This table requires activation of Seniority Dates functional area. Person Level Seniority Date Rule Setup Data
Module: Global Human Resources
SENIORITY_DATE_SETUP_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
SENIORITY_DATE_SETUP_ID | NUMBER | 38 | 0 | True | Transaction system generated primary key column | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Unique Source Record Identifier This column contains JOB_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. | ||||
SENIORITY_DATE_CODE | VARCHAR2 | 32 | Seniority Date Code | ||||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Group Identifier | |||
LEVEL_CODE | VARCHAR2 | 32 | Level Code | DW_WRKFRC_SENIORITY_LEVEL_D_TL | SENIORITY_LEVEL_CODE | ||
TRIGGERING_FIELD | VARCHAR2 | 32 | Attribute or Triggering field | DW_WRKFRC_SENIORITY_FIELD_D_TL | SENIORITY_FIELD_CODE | ||
ACTIVE_FLAG | VARCHAR2 | 16 | Indicates if the Rule is Active | ||||
CUMULATIVE_FLAG | VARCHAR2 | 32 | Cumulative Flag | ||||
SENIORITY_VERSION | VARCHAR2 | 32 | Indicates the Seniority Version | ||||
SENIORITY_BASIS | VARCHAR2 | 32 | Indicates if the Seniority Basis is Days or Hours | ||||
SELECT_COLL_AGREEMENT_NAME | VARCHAR2 | 999 | Stores the filtered values (if any) for Collective Agreement | ||||
SELECT_LEGAL_EMPLOYER_NAME | VARCHAR2 | 999 | Stores the filtered values (if any) for Legal Employer | ||||
SELECT_LEGISLATION_CODE | VARCHAR2 | 512 | Stores the filtered values (if any) for Legislation Code | ||||
SELECT_UNION_NAME | VARCHAR2 | 999 | Stores the filtered values (if any) for Union | ||||
SELECT_WORKER_TYPE | VARCHAR2 | 512 | Stores the filtered values (if any) for Worker Type | ||||
LABOUR_UNION_MEMBER_FLAG | VARCHAR2 | 32 | Labour Union Member Flag |
Copyright © 2019, 2023, Oracle and/or its affiliates.