DW_PERSON_SERVICE_PERIOD_TYPE_D
This table stores the enterprise hire date per person and period type for period of service
Details
Module: Global Human Resources
Key Columns
PERIOD_TYPE, PERSON_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PERSON_ID | NUMBER | 38 | 0 | True | Person Identifier | ||
| PERIOD_TYPE | VARCHAR2 | 32 | True | Determines whether it is a period of service for an Employee, or Contingent worker: E, C, or N: non-worker. | |||
| SOURCE_RECORD_ID | VARCHAR2 | 32 | This column is for Oracle Internal use only. Source Record Identifier Consists of Period of Service Identifier | ||||
| ENTERPRISE_HIRE_DATE | DATE | Minimum start date of the period of employment |