DW_PAY_ELE_CLASSIFICATION_H (Preview)

This table requires activation of Payroll Costing functional area. Helper Table to Resolve Primary and Secondary Classification for an Element Type

Details

Module: Global Payroll

Key Columns

ELEMENT_TYPE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ELEMENT_TYPE_ID NUMBER 38 0 True Element Type 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    
PRIMARY_CLASSIFICATION_ID NUMBER 38 0   Holds the Resolved Primary Classification Identifier    
SECONDARY_CLASSIFICATION_ID NUMBER 38 0   Holds the Resolved Secondary Classification Identifier    

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