DW_EB_X_EBS_COMMON_W_ENT_YEAR_D
Dimension table for storing Enterprise years
Details
Module: Common Tables (EBS_COMMON)
Business Name: Enterprise Year Dimension
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 | Surrogate key to uniquely identify a record. This keyholds the value of each Enterprise year in YYYY format. | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances | |||
| ENT_CAL_CLASS | VARCHAR2 | 20 CHAR | Identifies the category of calendar. Valid values are 'Generated', ''File Sourced','OLTP Sourced' | |||
| ENT_CAL_ID | VARCHAR2 | 80 CHAR | Identifies the accounting calendar | |||
| ENT_CAL_NAME | VARCHAR2 | 30 CHAR | Identifies the name of the accounting calendar | |||
| ENT_CAL_WID | NUMBER | 38 | ID assigned within the warehouse to uniquely identify a calendar | |||
| ENT_DIM_YEAR_NUM | NUMBER | 10 | Year in number format. | |||
| ENT_PERIOD_TYPE | VARCHAR2 | 50 CHAR | Enterprise accounting period type | |||
| ENT_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the Enterprise Year period name in string format. for example 1980. | |||
| ENT_PRIOR_YEAR_WID | NUMBER | 38 | The ROW_WID of the previous enterprise year | |||
| ENT_YEAR | NUMBER | 4 | Identifies the year in YYYY Format | |||
| ENT_YEAR_END_DAY_WID | NUMBER | 38 | Identifies the end date Surrogate key (Date in YYYYMMDD) of the Enterprise Year. | |||
| ENT_YEAR_END_DT | TIMESTAMP | 6 | Enterprise year end dateIdentifies the End Date of the Enterprise Year. | |||
| ENT_YEAR_END_DT_KEY | NUMBER | 10 | Identifies the End Date of the Enterprise Year in Julian. | |||
| ENT_YEAR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key (Date in YYYYMMDD) of the Enterprise Year. | |||
| ENT_YEAR_KEY | NUMBER | 10 | Julian??? | |||
| ENT_YEAR_LAST_DAY_OF_YEAR | NUMBER | 10 | Identifies the Last Day of the Enterprise Year. | |||
| ENT_YEAR_START_DAY_WID | NUMBER | 38 | Identifies the start Date Surrogate key (Date in YYYYMMDD) of the Enterprise Year. | |||
| ENT_YEAR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the Enterprise Year. | |||
| ENT_YEAR_START_DT_KEY | NUMBER | 10 | Identifies the Start Date of the Enterprise Year in Julian. | |||
| ENT_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key (Date in YYYYMMDD) of the enterprise year. | |||
| ENT_YEAR_TOTAL_DAYS | NUMBER | 10 | Total number of days in this Enterprise year | |||
| ENT_YEAR_TOTAL_WEEKS | NUMBER | 10 | Total number of weeks in this Enterprise year | |||
| 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)" | |||
| W_CURRENT_ENT_YEAR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous year depending on whether it is current or next or previous year w.r.t to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| 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 |