This table requires activation of Payroll Balances functional area. This table contains the payroll calendar used as the basis for regular payroll processing
Module: Global Payroll
TIME_PERIOD_ID
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, 2022, Oracle and/or its affiliates.