This table requires activation of Seniority Dates functional area. Assignment Level Seniority information
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. 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.