# DW_PAY_ELE_CLASSIFICATION_H

Helper Table to Resolve Primary and Secondary Classification for an Element Type

## Details

Module: Global Payroll

## Key Columns

ELEMENT_TYPE_ID, EFFECTIVE_END_DATE, 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 |  |
PRIMARY_CLASSIFICATION_ID | NUMBER | 38 | 0 |  | Holds the Resolved Primary Classification Identifier |  |
SECONDARY_CLASSIFICATION_ID | NUMBER | 38 | 0 |  | Holds the Resolved Secondary Classification Identifier |  |

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