ORACLE
EBS Data Intelligence Analytics
Table Documentation / DW_EB_X_EBS_COMMON_W_COST_CENTER_D

DW_EB_X_EBS_COMMON_W_COST_CENTER_D

This table Stores Cost Center Dimension Information. This supports type2 (out-of-the-box, no columns are marked for SCD behaviour)

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
NameDatatypeLengthPrecisionNot NullCommentsReferred Table
ROW_WIDNUMBER38TrueSurrogate key to uniquely identify a record.
ACTIVE_FLGVARCHAR21 CHARActive Flag
AUX1_CHANGED_ON_DTTIMESTAMP6Siebel 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_DTTIMESTAMP6Siebel 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_DTTIMESTAMP6Siebel 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_DTTIMESTAMP6Siebel 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.
CATEGORY_CODEVARCHAR280 CHARCategoryCode
CHANGED_BY_WIDNUMBER38This 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.DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DTTIMESTAMP6Identifies the date and time when the record was last modified in the source system.
CITY_CODEVARCHAR2120 CHARCityCode
CONTROL_AREA_NUMVARCHAR280 CHARControl Area Numbrer
COSTCNTR_ATTR10_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR10_DATETIMESTAMP6
COSTCNTR_ATTR10_NUMNUMBER
COSTCNTR_ATTR11_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR11_DATETIMESTAMP6
COSTCNTR_ATTR11_NUMNUMBER
COSTCNTR_ATTR12_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR12_DATETIMESTAMP6
COSTCNTR_ATTR12_NUMNUMBER
COSTCNTR_ATTR13_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR13_DATETIMESTAMP6
COSTCNTR_ATTR13_NUMNUMBER
COSTCNTR_ATTR14_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR14_DATETIMESTAMP6
COSTCNTR_ATTR14_NUMNUMBER
COSTCNTR_ATTR15_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR15_DATETIMESTAMP6
COSTCNTR_ATTR15_NUMNUMBER
COSTCNTR_ATTR16_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR16_DATETIMESTAMP6
COSTCNTR_ATTR16_NUMNUMBER
COSTCNTR_ATTR17_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR17_DATETIMESTAMP6
COSTCNTR_ATTR17_NUMNUMBER
COSTCNTR_ATTR18_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR18_DATETIMESTAMP6
COSTCNTR_ATTR18_NUMNUMBER
COSTCNTR_ATTR19_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR19_DATETIMESTAMP6
COSTCNTR_ATTR19_NUMNUMBER
COSTCNTR_ATTR1_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR1_DATETIMESTAMP6
COSTCNTR_ATTR1_NUMNUMBER
COSTCNTR_ATTR20_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR20_DATETIMESTAMP6
COSTCNTR_ATTR20_NUMNUMBER
COSTCNTR_ATTR21_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR21_NUMNUMBER
COSTCNTR_ATTR22_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR22_NUMNUMBER
COSTCNTR_ATTR23_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR23_NUMNUMBER
COSTCNTR_ATTR24_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR24_NUMNUMBER
COSTCNTR_ATTR25_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR25_NUMNUMBER
COSTCNTR_ATTR26_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR26_NUMNUMBER
COSTCNTR_ATTR27_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR27_NUMNUMBER
COSTCNTR_ATTR28_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR28_NUMNUMBER
COSTCNTR_ATTR29_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR29_NUMNUMBER
COSTCNTR_ATTR2_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR2_DATETIMESTAMP6
COSTCNTR_ATTR2_NUMNUMBER
COSTCNTR_ATTR30_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR30_NUMNUMBER
COSTCNTR_ATTR31_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR31_NUMNUMBER
COSTCNTR_ATTR32_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR32_NUMNUMBER
COSTCNTR_ATTR33_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR33_NUMNUMBER
COSTCNTR_ATTR34_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR34_NUMNUMBER
COSTCNTR_ATTR35_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR35_NUMNUMBER
COSTCNTR_ATTR36_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR36_NUMNUMBER
COSTCNTR_ATTR37_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR37_NUMNUMBER
COSTCNTR_ATTR38_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR38_NUMNUMBER
COSTCNTR_ATTR39_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR39_NUMNUMBER
COSTCNTR_ATTR3_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR3_DATETIMESTAMP6
COSTCNTR_ATTR3_NUMNUMBER
COSTCNTR_ATTR40_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR40_NUMNUMBER
COSTCNTR_ATTR41_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR42_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR43_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR44_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR45_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR46_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR47_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR48_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR49_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR4_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR4_DATETIMESTAMP6
COSTCNTR_ATTR4_NUMNUMBER
COSTCNTR_ATTR50_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR51_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR52_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR53_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR54_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR55_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR56_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR57_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR58_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR59_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR5_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR5_DATETIMESTAMP6
COSTCNTR_ATTR5_NUMNUMBER
COSTCNTR_ATTR60_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR6_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR6_DATETIMESTAMP6
COSTCNTR_ATTR6_NUMNUMBER
COSTCNTR_ATTR7_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR7_DATETIMESTAMP6
COSTCNTR_ATTR7_NUMNUMBER
COSTCNTR_ATTR8_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR8_DATETIMESTAMP6
COSTCNTR_ATTR8_NUMNUMBER
COSTCNTR_ATTR9_CHARVARCHAR21500 CHAR
COSTCNTR_ATTR9_DATETIMESTAMP6
COSTCNTR_ATTR9_NUMNUMBER
COST_CENTER_LOV_IDVARCHAR2100 CHARCostCenter List oF Values ID
COST_CENTER_VAL_CODEVARCHAR2150 CHARCostCenter Value Code
CREATED_BY_WIDNUMBER38This 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.DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DTTIMESTAMP6Identifies the date and time when the record was initially created in the source system.
CURRENCY_CODEVARCHAR280 CHARCurrencyCode
CURRENT_FLGVARCHAR21 CHARThis 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.
C_CITY_CODEVARCHAR2120 CHARCityCode
C_STATE_PROV_CODEVARCHAR2120 CHARStateCode
DATASOURCE_NUM_IDNUMBER10This 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.DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D
DELETE_FLGVARCHAR21 CHARThis 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_DTTIMESTAMP6This 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_DTTIMESTAMP6This 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.
ETL_PROC_WIDNUMBER38Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FAX_NUMVARCHAR250 CHARFaxNumber
INTEGRATION_IDVARCHAR2200 CHARThis column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D
LANGUAGE_CODEVARCHAR280 CHARLanguageCode
MANAGER_NAMEVARCHAR2255 CHARCost Center Manager Name
PHONE_NUMVARCHAR250 CHARPhone Number
POSTAL_CODEVARCHAR2120 CHARPostalcode
POST_OFFICE_BOXVARCHAR230 CHARPost Office Box
REGION_CODEVARCHAR2120 CHARRegionCode
SCD1_WIDNUMBER38SCD1 warehouse Id
SRC_EFF_FROM_DTTIMESTAMP6This 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_DTTIMESTAMP6This 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)
STATE_CODEVARCHAR2120 CHARStateCode
ST_ADDRESS1VARCHAR2255 CHARAdddress Line1
ST_ADDRESS2VARCHAR2255 CHARAdddress Line2
TENANT_IDVARCHAR280 CHARThis 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.
W_COUNTRY_CODEVARCHAR2120 CHARCountryCode
X_CUSTOMVARCHAR210 CHARThis column is used as a generic field for customer extensions.
W$_INSERT_DTTIMESTAMP6
W$_UPDATE_DTTIMESTAMP6