# DW_PAY_INPUT_VALUE_D

Stores the Pay Input Value Details

## Details

Module: Global Payroll

## Key Columns

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

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