DW_WRKFRC_SENIORITY_PER_ENT_D

Load Seniority Date for Enterprise at Person Level

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, SENIORITY_DATE_ID

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     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