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 | 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.