DW_SERVICE_PERIOD_D
This table stores the work relation ship details between person and their legal employer for the period of service
Details
Module: Global Human Resources
Key Columns
PERIOD_OF_SERVICE_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 | True | Perod of Service identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 32 | This column is for Oracle Internal use only. Source Record Identifier Consists of Period of Service Identifier | ||||
| PERSON_ID | NUMBER | 38 | 0 | Person Identifier | |||
| LEGISLATION_CODE | VARCHAR2 | 256 | Legislation Code | ||||
| DATE_START | DATE | Start date of the period of employment | |||||
| ACTUAL_TERMINATION_DATE | DATE | Actual date of termination of employment. | |||||
| NOTIFIED_TERMINATION_DATE | DATE | Date when the termination of employment was noted. | |||||
| PROJECTED_TERMINATION_DATE | DATE | Projected employment termination date. | |||||
| LAST_WORKING_DATE | DATE | Last Date Worked (for terminated workers). | |||||
| PRIMARY_FLAG | VARCHAR2 | 32 | If Yes, this employment period is considered the primary for the Legal Entity. | ||||
| ORIGINAL_DATE_OF_HIRE | DATE | Original date of hire. | |||||
| ADJUSTED_SERVICE_DATE | DATE | Adjusted Service Date |