This table requires activation of Payroll Balances functional area. This table containsinformation of the payroll actions.
Module: Global Payroll
PAYROLL_ACTION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PAYROLL_ACTION_ID | NUMBER | 38 | 0 | True | Payroll Action Identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Unique Source Record Identifier with Payroll action id | ||||
PAYROLL_ID | NUMBER | 38 | 0 | Payroll Identifier | DW_PAY_PAYROLL_D | PAYROLL_ID | |
EFFECTIVE_DATE | DATE | Effective Date | |||||
ACTION_TYPE | VARCHAR2 | 32 | Action Type | ||||
ACTION_STATUS | VARCHAR2 | 16 | Action Status | ||||
START_DATE | DATE | Start Date | |||||
END_DATE | DATE | End Date | |||||
DATE_EARNED | DATE | Date Earned | |||||
DEDN_TIME_PERIOD_ID | NUMBER | 38 | 0 | Deduction Time Period Id | DW_PAY_PERIOD_D | TIME_PERIOD_ID | |
EARN_TIME_PERIOD_ID | NUMBER | 38 | 0 | Earn Time Period Id | DW_PAY_PERIOD_D | TIME_PERIOD_ID | |
CONSOLIDATION_SET_ID | NUMBER | 38 | 0 | Consolidation Set Id | DW_PAY_CONSOLIDATION_SETS_D | CONSOLIDATION_SET_ID | |
PAY_REQUEST_ID | NUMBER | 38 | 0 | Pay Request Id | |||
OVERRIDING_DD_DATE | DATE | Overriding direct deposit date parameter for magnetic tape process. | |||||
ACTION_SEQUENCE | NUMBER | 38 | 0 | Action Sequence | |||
START_CHEQUE_NUMBER | NUMBER | 38 | 0 | Start number for the cheque/check writer process. | |||
END_CHEQUE_NUMBER | NUMBER | 38 | 0 | Optional end of cheque/check number range to be used by the cheque/check writer process. | |||
CHEQUE_PROCEDURE | VARCHAR2 | 32 | Lookup code for report run to print out cheques/checks. | ||||
CURRENT_CHUNK_NUMBER | NUMBER | 38 | 0 | Current chunk to process. | |||
CURRENT_TASK | VARCHAR2 | 32 | Indicates if payroll action is currently executing. | ||||
LEGISLATIVE_DATA_GROUP_ID | NUMBER | 38 | 0 | Legsilative Data Group Identifier | DW_LEGISLATIVE_DATA_GROUP_D | LEGISLATIVE_DATA_GROUP_ID | |
LEGISLATIVE_PARAMETERS | VARCHAR2 | 999 | process and legislation-dependent parameters are held |
Copyright © 2019, 2022, Oracle and/or its affiliates.