# DW_PAY_PERIOD_D

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

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