# DW_PAY_ELEMENT_TYPE_D (Preview)

This table requires activation of Payroll Balances functional area. Holds Pay Element Type Details

## Details

Module: Global Payroll

## Key Columns

EFFECTIVE_END_DATE, ELEMENT_TYPE_ID, EFFECTIVE_START_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ELEMENT_TYPE_ID | NUMBER | 38 | 0 | True | Element Type 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 |  |
INPUT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Input Currency Code |  |
OUTPUT_CURRENCY_CODE | VARCHAR2 | 32 |  |  | Output Currency Code |  |
PROCESSING_PRIORITY | NUMBER | 38 | 0 |  | Processing Priority |  |
PROCESS_MODE | VARCHAR2 | 32 |  |  | Indicates the Process Mode like Normal, Group etc. |  |
ONCE_EACH_PERIOD_FLAG | VARCHAR2 | 16 |  |  | Flag indicating Processing Once per Period |  |
ADJUSTMENT_ONLY_FLAG | VARCHAR2 | 32 |  |  | Flag indication element for Adjustments |  |
CLASSIFICATION_ID | NUMBER | 38 | 0 |  | Classification Identifier |  |
SECONDARY_CLASSIFICATION_ID | NUMBER | 38 | 0 |  | Secondary Classification Identifier |  |
LEGISLATIVE_DATA_GROUP_ID | NUMBER | 38 | 0 |  | Legislative Data Group Identifier |  |
LEGISLATION_CODE | VARCHAR2 | 32 |  |  | Legislation Code |  |
BASE_ELEMENT_NAME | VARCHAR2 | 128 |  |  | Base element name |  |

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