This table stores the work relation ship details between person and their legal employer for the period of service
Module: Global Human Resources
PERIOD_OF_SERVICE_ID
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 | 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. |