DW_PAY_ELEMENT_TYPE_D (Preview)

This table requires activation of Payroll Balances functional area. Holds Pay Element Type Details

Details

Module: Global Payroll

Key Columns

EFFECTIVE_END_DATE, ELEMENT_TYPE_ID, 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     This column is for Oracle Internal use only. Unique Source Record Identifier    
INPUT_CURRENCY_CODE VARCHAR2 32     Input Currency Code    
OUTPUT_CURRENCY_CODE VARCHAR2 32     Output Currency Code    
PROCESSING_PRIORITY NUMBER 38 0   Processing Priority    
PROCESS_MODE VARCHAR2 32     Indicates the Process Mode like Normal, Group etc.    
ONCE_EACH_PERIOD_FLAG VARCHAR2 16     Flag indicating Processing Once per Period    
ADJUSTMENT_ONLY_FLAG VARCHAR2 32     Flag indication element for Adjustments    
CLASSIFICATION_ID NUMBER 38 0   Classification Identifier    
SECONDARY_CLASSIFICATION_ID NUMBER 38 0   Secondary Classification Identifier    
LEGISLATIVE_DATA_GROUP_ID NUMBER 38 0   Legislative Data Group Identifier    
LEGISLATION_CODE VARCHAR2 32     Legislation Code    
BASE_ELEMENT_NAME VARCHAR2 128     Base element name    

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