Load Seniority Date for Enterprise at Person Level
Module: Global Human Resources
SENIORITY_DATE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
SENIORITY_DATE_ID | NUMBER | 38 | 0 | True | Transaction system generated primary key column | ||
EFFECTIVE_START_DATE | DATE | True | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||||
EFFECTIVE_END_DATE | DATE | True | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Unique Source Record Identifier This column contains JOB_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. | ||||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Group Identifier | |||
SENIORITY_DATE_CODE | VARCHAR2 | 32 | Seniority Date Code | ||||
PERSON_ID | NUMBER | 38 | 0 | Person Identifier | DW_PERSON_D | PERSON_ID | |
ENTRY_DATE | DATE | Entry Date | |||||
SENIORITY_DATE | DATE | Seniority Date | |||||
BASE_SENIORITY_DATE | DATE | Base Seniority Date | |||||
EXIT_DATE | DATE | Exit Date |
Copyright © 2019, 2023, Oracle and/or its affiliates.