DW_EB_X_EBS_COMMON_W_COST_CENTER_DH
This table Stores Cost Center Hierarchy Information
Details
Module: Common Tables (EBS_COMMON)
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. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | |||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| COST_CENTER_WID | NUMBER | 38 | CostCenter Warehouse Id | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | |||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous. | |||
| 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, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source. | |||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source. | |||
| ENABLED_FLG | VARCHAR2 | 1 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| FIXED_HIER_LEVEL | NUMBER | 10 | Fixed Hierarchy Level | |||
| HIERARCHY_ID | VARCHAR2 | 150 CHAR | Hierarchy Id | |||
| HIERARCHY_LOV_ID | VARCHAR2 | 100 CHAR | Hierarchy List of Values Id | |||
| HIERARCHY_VERSION | VARCHAR2 | 100 CHAR | Hierarchy Version | |||
| HIERARCHY_VERSION_NAME | VARCHAR2 | 100 CHAR | ||||
| INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 0 Integration Id | |||
| LEVEL0_CODE | VARCHAR2 | 250 CHAR | ||||
| LEVEL0_INTEGRATION_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL0_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL10_CODE | VARCHAR2 | 250 CHAR | Level 10 Code | |||
| LEVEL10_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 10 Integration Id | |||
| LEVEL10_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL11_CODE | VARCHAR2 | 250 CHAR | Level 11 Code | |||
| LEVEL11_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 11 Integration Id | |||
| LEVEL11_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL12_CODE | VARCHAR2 | 250 CHAR | Level 12 Code | |||
| LEVEL12_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 12 Integration Id | |||
| LEVEL12_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL13_CODE | VARCHAR2 | 250 CHAR | Level 13 Code | |||
| LEVEL13_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 13 Integration Id | |||
| LEVEL13_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL14_CODE | VARCHAR2 | 250 CHAR | Level 14 Code | |||
| LEVEL14_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 14 Integration Id | |||
| LEVEL14_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL15_CODE | VARCHAR2 | 250 CHAR | Level 15 Code | |||
| LEVEL15_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 15 Integration Id | |||
| LEVEL15_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL16_CODE | VARCHAR2 | 250 CHAR | Level 16 Code | |||
| LEVEL16_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 16 Integration Id | |||
| LEVEL16_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL17_CODE | VARCHAR2 | 250 CHAR | Level 17 Code | |||
| LEVEL17_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 17 Integration Id | |||
| LEVEL17_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL18_CODE | VARCHAR2 | 250 CHAR | Level 18 Code | |||
| LEVEL18_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 18 Integration Id | |||
| LEVEL18_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL19_CODE | VARCHAR2 | 250 CHAR | Level 19 Code | |||
| LEVEL19_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 19 Integration Id | |||
| LEVEL19_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL1_CODE | VARCHAR2 | 250 CHAR | Level 1 Code | |||
| LEVEL1_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 1 Integration Id | |||
| LEVEL1_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL20_CODE | VARCHAR2 | 250 CHAR | Level 20 Code | |||
| LEVEL20_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 20 Integration Id | |||
| LEVEL20_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL21_CODE | VARCHAR2 | 250 CHAR | Level 21Code | |||
| LEVEL21_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 21 Integration Id | |||
| LEVEL21_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL22_CODE | VARCHAR2 | 250 CHAR | Level 22 Code | |||
| LEVEL22_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 22 Integration Id | |||
| LEVEL22_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL23_CODE | VARCHAR2 | 250 CHAR | Level 23 Code | |||
| LEVEL23_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 23 Integration Id | |||
| LEVEL23_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL24_CODE | VARCHAR2 | 250 CHAR | Level 24 Code | |||
| LEVEL24_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 24 Integration Id | |||
| LEVEL24_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL25_CODE | VARCHAR2 | 250 CHAR | Level 25 Code | |||
| LEVEL25_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 25 Integration Id | |||
| LEVEL25_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL26_CODE | VARCHAR2 | 250 CHAR | Level 26 Code | |||
| LEVEL26_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 26 Integration Id | |||
| LEVEL26_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL27_CODE | VARCHAR2 | 250 CHAR | Level 27 Code | |||
| LEVEL27_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 27 Integration Id | |||
| LEVEL27_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL28_CODE | VARCHAR2 | 250 CHAR | Level 82 Code | |||
| LEVEL28_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 28 Integration Id | |||
| LEVEL28_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL29_CODE | VARCHAR2 | 250 CHAR | Level 29 Code | |||
| LEVEL29_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 29 Integration Id | |||
| LEVEL29_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL2_CODE | VARCHAR2 | 250 CHAR | Level 2 Code | |||
| LEVEL2_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 2 Integration Id | |||
| LEVEL2_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL30_CODE | VARCHAR2 | 250 CHAR | Level 30 Code | |||
| LEVEL30_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 30 Integration Id | |||
| LEVEL30_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL31_CODE | VARCHAR2 | 250 CHAR | Level 31 Code | |||
| LEVEL31_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 31 Integration Id | |||
| LEVEL31_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL3_CODE | VARCHAR2 | 250 CHAR | Level 3 Code | |||
| LEVEL3_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 3 Integration Id | |||
| LEVEL3_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL4_CODE | VARCHAR2 | 250 CHAR | Level 4 Code | |||
| LEVEL4_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 4 Integration Id | |||
| LEVEL4_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL5_CODE | VARCHAR2 | 250 CHAR | Level 5 Code | |||
| LEVEL5_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 5 Integration Id | |||
| LEVEL5_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL6_CODE | VARCHAR2 | 250 CHAR | Level 6 Code | |||
| LEVEL6_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 6 Integration Id | |||
| LEVEL6_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL7_CODE | VARCHAR2 | 250 CHAR | Level 7 Code | |||
| LEVEL7_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 7 Integration Id | |||
| LEVEL7_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL8_CODE | VARCHAR2 | 250 CHAR | Level 8 Code | |||
| LEVEL8_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 8 Integration Id | |||
| LEVEL8_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| LEVEL9_CODE | VARCHAR2 | 250 CHAR | Level 9 Code | |||
| LEVEL9_INTEGRATION_ID | VARCHAR2 | 400 CHAR | Level 9 Integration Id | |||
| LEVEL9_SECURITY_ID | VARCHAR2 | 400 CHAR | ||||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available) | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available) | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| 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 |