DW_EB_X_EBS_COMMON_W_DATE_RANGE_G
No table description is available in the supplied metadata.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Date Range
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | |||
| DAY_DT | TIMESTAMP | 6 | ||||
| DAY_OF_MONTH | NUMBER | 2 | ||||
| DAY_OF_WEEK | NUMBER | 1 | ||||
| DAY_OF_YEAR | NUMBER | 3 | ||||
| IS_VALID_DATE | VARCHAR2 | 1 CHAR | ||||
| JULIAN_DAY_NUM | NUMBER | 10 | ||||
| LAST_VALID_ROW_WID | NUMBER | 38 | ||||
| MONTH | NUMBER | 2 | ||||
| YEAR | NUMBER | 4 | ||||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |