DW_WRKFRC_SENIORITY_WR_D

Workrelationship Level Seniority information

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. 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 This column is for Oracle Internal use only. 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
PERIOD_OF_SERVICE_ID NUMBER 38 0 Period of Service Identifier DW_SERVICE_PERIOD_D PERIOD_OF_SERVICE_ID
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