DW_EB_X_EBS_COMMON_W_ENT_PERIOD_D
Dimension table for storing Enterprise Periods
Details
Module: Common Tables (EBS_COMMON)
Business Name: Enterprise Period 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 an Enterprise Period record. This key is formed by appending Enterprise Period to Enterprise Year. | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | |
| ADJUSTMENT_PERIOD_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is an adjustment period for the enterprise year | |||
| 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_MNTH_NUM | NUMBER | 10 | Cumulative Month Number getting added up through the years. | |||
| ENT_DIM_QTR_NUM | NUMBER | 10 | Cumulative Quarter Number getting added up through the years. | |||
| ENT_DIM_WEEK_NUM | NUMBER | 10 | Cumulative Week Number getting added up through the years. | |||
| ENT_DIM_YEAR_NUM | NUMBER | 10 | Cumulative Year Number getting added up through the years. | |||
| ENT_HALF | NUMBER | 2 | Identifies the half of Enterprise Year that this period belongs. Possible values are 1 or 2. | |||
| ENT_PERIOD | NUMBER | 4 | Accounting Period Number | |||
| ENT_PERIOD_AGO_WID | NUMBER | 38 | ROW_WID of the same period in the previous year | |||
| ENT_PERIOD_END_DAY_WID | NUMBER | 38 | ROW_WID of the last day of this period | |||
| ENT_PERIOD_END_DT | TIMESTAMP | 6 | Identifies the Last Date of the Enterprise Period. | |||
| ENT_PERIOD_END_DT_WID | NUMBER | 38 | Identifies the Last Date of the Enterprise Period. | |||
| ENT_PERIOD_NAME | VARCHAR2 | 240 CHAR | Name of the enterprise period | |||
| ENT_PERIOD_OF_QTR | NUMBER | 10 | Identifies the enterprise period in the enterprise quarter | |||
| ENT_PERIOD_OF_YEAR | NUMBER | 10 | Identifies the enterprise period in the enterprise year | |||
| ENT_PERIOD_START_DAY_WID | NUMBER | 38 | ROW_WID of the first day of this period | |||
| ENT_PERIOD_START_DT | TIMESTAMP | 6 | Identifies the First Date of the Enterprise Period. | |||
| ENT_PERIOD_START_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD of the first day of the Eneterprise Period | |||
| ENT_PERIOD_TOTAL_DAYS | NUMBER | 10 | Total number of days in the enterprise period | |||
| ENT_PERIOD_TOTAL_WEEKS | NUMBER | 10 | Total number of weeks in the Enterprise period | |||
| ENT_PERIOD_TYPE | VARCHAR2 | 50 CHAR | Identifies the accounting period type | |||
| ENT_PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies the enterprise Half year Period Name. For example, 1980 Half1, 1980 Half2, etc. | |||
| ENT_PER_NAME_PERIOD | VARCHAR2 | 50 CHAR | Month Period Name in YYYY/MM format. For example, "1980 / 01", "1980 / 10", etc. | |||
| ENT_PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the enterprise Quarter Period Name. For example, "1980Q1". | |||
| ENT_PER_NAME_TER | VARCHAR2 | 50 CHAR | Identifies the enterprise Trimester Period Name. For example, "1980T1". | |||
| ENT_PER_NAME_WEEK | VARCHAR2 | 50 CHAR | Identifies the enterprise Week Period Name. For example, "1980Week01". | |||
| ENT_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the enterprise Year Period Name in YYYY format. For example, "1980". | |||
| ENT_PRIOR_PERIOD_WID | NUMBER | 38 | ROW_WID of the previous period | |||
| ENT_PRIOR_QTR_WID | NUMBER | 38 | The ROW_WID of the previous enterprise quarter | |||
| ENT_PRIOR_YEAR_WID | NUMBER | 38 | The ROW_WID of the previous enterprise year | |||
| ENT_QTR | NUMBER | 2 | Identifies which Enterprise Quarter this period belongs to like 1,2..4. | |||
| ENT_QTR_AGO_WID | NUMBER | 38 | The ROW_WID of the same quarter in the previous year, e.g. the Q1 2007 prior period is Q1 2006 | |||
| ENT_QTR_END_DAY_WID | NUMBER | 38 | ROW_WID of the last day of this quarter | |||
| ENT_QTR_END_DT | TIMESTAMP | 6 | Identifies the End Date of the enterprise Quarter. | |||
| ENT_QTR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the Enterprise Quarter | |||
| ENT_QTR_START_DAY_WID | NUMBER | 38 | ROW_WID of the first day of this quarter | |||
| ENT_QTR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the enterprise Quarter. | |||
| ENT_QTR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the Enterprise Quarter | |||
| ENT_QTR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_ENT_QTR_D | |||
| ENT_TRIMESTER | NUMBER | 2 | Identifies the Enterprise trimester this period belongs to. Possible values are 1, 2 and 3. | |||
| ENT_YEAR | NUMBER | 4 | Identifies the enterprise year in YYYY Format. | |||
| ENT_YEAR_END_DAY_WID | NUMBER | 38 | ROW_WID of the last day of this year | |||
| ENT_YEAR_END_DT | TIMESTAMP | 6 | Identifies the End Date of the enterprise Year. | |||
| ENT_YEAR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the Enterprise Year | |||
| ENT_YEAR_START_DAY_WID | NUMBER | 38 | ROW_WID of the first day of this year | |||
| ENT_YEAR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the enterprise Year. | |||
| ENT_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the Enterprise Year | |||
| ENT_YEAR_START_PERIOD_WID | NUMBER | 38 | ROW_WID of the first day of this period | |||
| 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 | |||
| ENT_YEAR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_ENT_YEAR_D | |||
| FST_PERIOD_ENT_QTR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the first period of the enterprise quarter. | |||
| FST_PERIOD_ENT_YEAR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the first period of the enterprise year | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Identifier used for integration with external systems | |||
| LAST_PERIOD_ENT_QTR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the last period of the enterprise quarter. | |||
| LAST_PERIOD_ENT_YEAR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the last period of the 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_MONTH_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous month depending on whether the period is previous , current or next month with respect to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_ENT_PERIOD_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous period depending on whether the period is previous , current or next period with respect to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_ENT_QTR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous quarter depending on whether the period is previous , current or next quarter with respect to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_ENT_YEAR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous year depending on whether the period is previous , current or next year with respect 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 |