DW_EB_X_EBS_COMMON_W_MCAL_CONFIG_G
Configuration table to specify type of week allocation
Details
Module: Common Tables (EBS_COMMON)
Business Name: Type of Week Allocation Table
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| CALENDAR_ID | VARCHAR2 | 80 CHAR | True | Identifies the calendar that is being configured | ||
| CALENDAR_CLASS | VARCHAR2 | 20 CHAR | Identifies the category of calendar. Valid values are 'Generated', ''File Sourced','OLTP Sourced' | |||
| CALENDAR_NAME | VARCHAR2 | 50 CHAR | Name of the calendar that is being configured | |||
| CAL_END_DT | TIMESTAMP | 6 | This is the date to which the calendar generation ends | |||
| CAL_OFFSET | NUMBER | 2 | This is the offset which identifies the start date of the calendar The valid values are:Week Start Day Offset value Monday 0 Tuesday 1 Wednesday 2 Thursday 3 Friday -3 Saturday -2 Sunday -1 | |||
| CAL_ST_DT | TIMESTAMP | 6 | This is the date from which the calendar generation begins | |||
| PERIOD_TYPE | VARCHAR2 | 50 CHAR | Type of the calendar period that is being configured e.g '4-4-5' | |||
| REFERENCE_DATE | VARCHAR2 | 4 CHAR | Reference Date | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multitenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS)" | |||
| WEEK_ALLOCATION_RULE | VARCHAR2 | 50 CHAR | This parameter determines how weeks are allocated in the calendar that is being configured. E.g. '4-4-5' or '-13 period','5-4-4','4-5-4' | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |