# DW_PAY_ACTION_D

This table containsinformation of the payroll actions.

## Details

Module: Global Payroll

## Key Columns

PAYROLL_ACTION_ID

## Columns

Columns
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, 2026, Oracle and/or its affiliates.