# DW_TNL_REPEATING_TIME_PERIOD_D

Provides information on repeating time period

## Details

Module: Time and Labor

## Key Columns

REPEATING_TIME_PERIOD_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
REPEATING_TIME_PERIOD_ID | NUMBER | 38 | 0 | True | Repeating Time period identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Identifier Source Record ID |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise Identifier |  |
ACCRUAL_USAGE | VARCHAR2 | 32 |  |  | Accrual Usage indicator |  |
TIME_ENTRY_USAGE | VARCHAR2 | 32 |  |  | Time_Entry Usage indicator |  |
APPROVAL_USAGE | VARCHAR2 | 32 |  |  | Approval Usage indicator |  |
RULE_USAGE | VARCHAR2 | 32 |  |  | Rule Usage indicator |  |
BALANCE_USAGE | VARCHAR2 | 32 |  |  | Balance Usage indicator |  |
OVERTIME_USAGE | VARCHAR2 | 32 |  |  | Overtime Usage indicator |  |
PERIOD_CODE | VARCHAR2 | 128 |  |  | Period Code |  |
PERIOD_CLASS | VARCHAR2 | 64 |  |  | Period Class |  |
PERIOD_LENGTH | NUMBER |  |  |  | Period Length |  |
PERIOD_TYPE | VARCHAR2 | 64 |  |  | Period Type |  |
WEEK_TYPE | VARCHAR2 | 64 |  |  | Week Type |  |
MONTH_TYPE | VARCHAR2 | 64 |  |  | Month Type |  |
ONE_OR_MANY | VARCHAR2 | 64 |  |  | One Or Many |  |
MULTIPLE | NUMBER |  |  |  | Multiple |  |
PERIOD_START_DATE | DATE |  |  |  | Period Start Date |  |
REFERENCE_DATE | DATE |  |  |  | Reference Date |  |

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