DW_WRKFRC_SENIORITY_SETUP_D

Loads Seniority Date Rule Setup Data

Details

Module: Global Human Resources

Key Columns

SENIORITY_DATE_SETUP_ID

Columns

Columns
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 This column is for Oracle Internal use only. 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
TRIGGERING_FIELD VARCHAR2 32 Attribute or Triggering field
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