DW_PAY_PERIOD_D (Preview)

This table requires activation of Payroll Balances functional area. This table contains the payroll calendar used as the basis for regular payroll processing

Details

Module: Global Payroll

Key Columns

TIME_PERIOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TIME_PERIOD_ID NUMBER 38 0 True Time Period Key
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier with Time period id
PAYROLL_ID NUMBER 38 0 Payroll Identifier DW_PAY_PAYROLL_D PAYROLL_ID
PERIOD_NAME VARCHAR2 128 Period Name
PERIOD_NUM NUMBER 38 0 Period Number
PERIOD_YEAR NUMBER 38 0 Period Year
DESCRIPTION VARCHAR2 256 Pay Period Description
PERIOD_TYPE VARCHAR2 32 Payroll Frequency
START_DATE DATE Pay Period Start Date
END_DATE DATE Pay Period End Date
PAYSLIP_VIEW_DATE DATE Payslip Availability Date
PROCESS_SUB_DATE DATE Planned Submission Date
REGULAR_EARN_DATE DATE Regular Earned Date
REGULAR_PROCESS_DATE DATE Regular Process Date
CUT_OFF_DATE DATE Payroll Cut Off Date
PERIOD_CATEGORY VARCHAR2 32 Pay Period Category