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