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, INPUT_VALUE_ID, EFFECTIVE_START_DATE

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.