DW_PAY_ACTION_D (Preview)

This table requires activation of Payroll Balances functional area. 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