DW_WRKFRC_SENIORITY_PER_ENT_D

Load Seniority Date for Enterprise at Person Level

Details

Module: Global Human Resources

Key Columns

SENIORITY_DATE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
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