DW_PAY_INPUT_VALUE_D (Preview)

This table requires activation of Payroll Balances functional area. Stores the Pay Input Value Details

Details

Module: Global Payroll

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, INPUT_VALUE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INPUT_VALUE_ID NUMBER 38 0 True Input Value 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    
ELEMENT_TYPE_ID NUMBER 38 0   Element Type Identifier DW_PAY_ELEMENT_TYPE_D ELEMENT_TYPE_ID
UOM VARCHAR2 32     Unit of Measure    
DISPLAY_SEQUENCE NUMBER 38 0   Display Sequence    
DEFAULT_VALUE VARCHAR2 64     Default for the input value on entry. Value may be overridden    
HOT_DEFAULT_FLAG VARCHAR2 32     Indicates whether the default value is a HOT default.    
RESERVED_INPUT_VALUE VARCHAR2 32     Reserved Input Value    
MANDATORY_FLAG VARCHAR2 16     Indicates whether the input value is required for an entry.    

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