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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.