This table requires activation of Payroll Balances functional area. Holds Pay Element Type Details
Module: Global Payroll
EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ELEMENT_TYPE_ID
| 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, 2024, Oracle and/or its affiliates.