DW_TNL_REPEATING_TIME_PERIOD_D (Preview)

This table requires activation of Time and Labor functional area. 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