# DW_WRKFRC_SENIORITY_ASG_D

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 |  |  | 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 |  |
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, 2025, Oracle and/or its affiliates.