Load Seniority Date for Enterprise at Person Level
Module: Global Human Resources
EFFECTIVE_END_DATE, SENIORITY_DATE_ID, 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 | This column is for Oracle Internal use only. 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, 2025, Oracle and/or its affiliates.