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