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    

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