DW_PAY_PERIOD_D

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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.