DW_WRKFRC_SENIORITY_ASG_D (Preview)

This table requires activation of Seniority Dates functional area. Assignment Level Seniority information

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, SENIORITY_DATE_ID, 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. Seniority Date Identifier    
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 is the combination of SENIORITY_DATE_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    
ASSIGNMENT_ID NUMBER 38 0   Assignment Identifier    
PERSON_ID NUMBER 38 0   Person Identifier DW_PERSON_D PERSON_ID
ENTRY_DATE DATE       Entry Date    
SENIORITY_DATE DATE       Seniority Date    
EXIT_DATE DATE       Exit Date    
LEVEL_CODE VARCHAR2 32     Level Code DW_WRKFRC_SENIORITY_LEVEL_D_TL SENIORITY_LEVEL_CODE
SENIORITY_FIELD VARCHAR2 32     Seniority Field DW_WRKFRC_SENIORITY_FIELD_D_TL SENIORITY_FIELD_CODE
SENIORITY_FIELD_VALUE_CODE VARCHAR2 256     Seniority Field Value    
SENIORITY_JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
SENIORITY_LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
SENIORITY_BUSINESS_GROUP_ID NUMBER 38 0   Business Group Identifier    
SENIORITY_POSITION_ID NUMBER 38 0   Position Identifier DW_POSITION_D POSITION_ID
SENIORITY_DEPARTMENT_ID NUMBER 38 0   Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID
SENIORITY_LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Employer Identifier DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
SENIORITY_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
SENIORITY_GRADE_ID NUMBER 38 0   Grade Identifier DW_PAY_GRADE_D GRADE_ID
SENIORITY_COUNTRY VARCHAR2 256     Country DW_COUNTRY_D_TL COUNTRY
SENIORITY_BARGAINING_UNIT_CODE VARCHAR2 256     Bargaining Unit Code DW_BARGAINING_UNIT_D_TL BARGAINING_UNIT_CODE
SENIORITY_ASSIGNMENT_CATEGORY VARCHAR2 256     Assignment Category DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
MANUAL_ADJUSTMENT_DAYS NUMBER       Manual Adjustment Days    
TOTAL_MANUAL_ADJUSTMENT_DAYS NUMBER       Total Manual Adjustment Days    
AUTO_ADJUSTMENT_DAYS NUMBER       Auto Adjustment Days    
TOTAL_AUTO_ADJUSTMENT_DAYS NUMBER       Total Auto Adjustment Days    
TOTAL_ADJUSTMENT_DAYS NUMBER       Total Adjustment Days    
MANUAL_ADJUSTMENT_HOURS NUMBER       Manual Adjustment Hours    
TOTAL_MANUAL_ADJUSTMENT_HOURS NUMBER       Total Manual Adjustment Hours    
AUTO_ADJUSTMENT_HOURS NUMBER       Auto Adjustment Hours    
TOTAL_AUTO_ADJUSTMENT_HOURS NUMBER       Total Auto Adjustment Hours    
TOTAL_ADJUSTMENT_HOURS NUMBER       Total Adjustment Hours    
MANUAL_ADJUSTMENT_COMMENTS VARCHAR2 512     Manual Adjustment Comments    
AUTO_ADJUSTMENT_COMMENTS VARCHAR2 512     Auto Adjustment Comments    
SENIORITY_HOURS NUMBER       Seniority Hours    
TOTAL_SENIORITY_HOURS NUMBER       Total Seniority Hours    
SENIORITY_HOURS_LOS VARCHAR2 128     Seniority or Length of Service in Hours    
SENIORITY_LOS_YEARS NUMBER       Seniority or Length of Service in Years    
SENIORITY_LOS_MONTHS NUMBER       Seniority or Length of Service in Months    
SENIORITY_LOS_DAYS NUMBER       Seniority or Length of Service in Days    
SENIORITY_LOS_TOTAL_DAYS NUMBER       Total Seniority or Total Length of Service in Days    
LAST_SENIORITY_HRS_RUN_DATE DATE       Last Seniority Hours Run Date    
LAST_ESS_RUN_DATE TIMESTAMP       Last ESS Job Run Date    

Copyright © 2019, 2022, Oracle and/or its affiliates.