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 | This column is for Oracle Internal use only. 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, 2024, Oracle and/or its affiliates.