This table requires activation of Payroll Balances functional area. Stores the Pay Input Value Details
Module: Global Payroll
EFFECTIVE_END_DATE, INPUT_VALUE_ID, EFFECTIVE_START_DATE
| 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, 2025, Oracle and/or its affiliates.