DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D

A profit center is a unit of a company that generates revenue in excess of its expenses. It is expected that, through the sale of goods or services, the unit will turn a profit. This is in contrast to a cost center, which is a unit inside a company that generates expenses with no responsibility for creating revenue. Examples of profit centers would be the manufacturing units that produce products for sale to consumers or other businesses. Profit Center Dimension. Master data information on Profit Centers including Name and Description. It can be used for browsing, establishing limits on fact table queries, and providing descriptive information about Profit Centers.

Details

Module: Common Tables (EBS_COMMON)

Business Name: Profit Center

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments	Referred Table
ROW_WID	NUMBER		38	True	Surrogate key to uniquely identify a record.
ACTIVE_FLG	VARCHAR2	1 CHAR
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.	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was last modified in the source system.
CITY_NAME	VARCHAR2	80 CHAR			City Name
COMPANY_CODE	VARCHAR2	50 CHAR			Company Code
COMPANY_NAME	VARCHAR2	80 CHAR			Company Name
CONTACT_NAME	VARCHAR2	80 CHAR			Contact Name
COUNTRY_CODE	VARCHAR2	50 CHAR			Country Code
COUNTRY_NAME	VARCHAR2	80 CHAR			Country Name
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.	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was initially created in the source system.
CTRL_AREA_CODE	VARCHAR2	50 CHAR			Controlling Area Number
CTRL_AREA_DESC	VARCHAR2	255 CHAR			Controlling Area Description
CTRL_AREA_NAME	VARCHAR2	80 CHAR			Controlling Area Name
CURRENCY_CODE	VARCHAR2	50 CHAR			Currency Code
CURRENCY_NAME	VARCHAR2	80 CHAR			Currency Name
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.
DEPARTMENT	VARCHAR2	30 CHAR			Department
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.
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.
FAX_NUM	VARCHAR2	30 CHAR			Fax Number
INTEGRATION_ID	VARCHAR2	80 CHAR			This 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.
MANAGER_NAME	VARCHAR2	80 CHAR			Profit Center Manager
PHONE_NUM	VARCHAR2	30 CHAR			Phone Number
POSTAL_CODE	VARCHAR2	50 CHAR			Postal Code
POST_OFFICE_BOX	VARCHAR2	30 CHAR			Post Office Box
PRCN_HIER1_CODE	VARCHAR2	50 CHAR			Hierarchy Code
PRCN_HIER1_NAME	VARCHAR2	80 CHAR			Hierarchy Name
PRCN_HIER2_CODE	VARCHAR2	50 CHAR			Hierarchy Code
PRCN_HIER2_NAME	VARCHAR2	80 CHAR			Hierarchy Name
PRCN_HIER3_CODE	VARCHAR2	50 CHAR			Hierarchy Code
PRCN_HIER3_NAME	VARCHAR2	80 CHAR			Hierarchy Name
PRCN_HIER4_CODE	VARCHAR2	50 CHAR			Hierarchy Code
PRCN_HIER4_NAME	VARCHAR2	80 CHAR			Hierarchy Name
PRCN_HIER5_CODE	VARCHAR2	50 CHAR			Hierarchy Code
PRCN_HIER5_NAME	VARCHAR2	80 CHAR			Hierarchy Name
PRCN_HIER6_CODE	VARCHAR2	50 CHAR			Hierarchy Code
PRCN_HIER6_NAME	VARCHAR2	80 CHAR			Hierarchy Name
PROFITCTR_GRP_CODE	VARCHAR2	50 CHAR			Profit Center Group Code
PROFITCTR_GRP_NAME	VARCHAR2	80 CHAR			Profit Center Group Name
PROFIT_CENTER_DESC	VARCHAR2	255 CHAR			Profit Center Description
PROFIT_CENTER_NAME	VARCHAR2	80 CHAR			Profit Center Name
PROFIT_CENTER_NUM	VARCHAR2	50 CHAR			Profit Center Number
REGION_CODE	VARCHAR2	50 CHAR			Region Code
REGION_NAME	VARCHAR2	80 CHAR			Region Name
SEARCH_TERM	VARCHAR2	255 CHAR			Search Term
SET_ID	VARCHAR2	30 CHAR			This column represents a unique identifier often used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
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)
ST_ADDRESS1	VARCHAR2	255 CHAR			Street Address
ST_ADDRESS2	VARCHAR2	255 CHAR			Street Address
SUCC_PROFIT_CENTER	VARCHAR2	50 CHAR			Successor Profit Center
TAX_CAT_CODE	VARCHAR2	50 CHAR			Tax Category Code
TAX_CAT_NAME	VARCHAR2	80 CHAR			Tax Category Name
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.
TITLE_NAME	VARCHAR2	80 CHAR			Title
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