This table requires activation of Time and Labor functional area. Provides information on repeating time period
Module: Time and Labor
REPEATING_TIME_PERIOD_ID
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 | 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, 2023, Oracle and/or its affiliates.