DW_EB_X_EBS_COMMON_W_INT_ORG_D

Internal Organization Dimension.

Details

Module: Common Tables (EBS_COMMON)

Business Name: Internal Organization Dimension

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.
ASSET_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an asset organization.
AUX1_CHANGED_ON_DT	TIMESTAMP		6		Oracle 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		Oracle 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		Oracle 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		Oracle 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.
BALANCING_ENTITY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a balancing entity.
BRANCH_FLG	VARCHAR2	1 CHAR			Indicates if the organization is a branch
BUSINESS_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP/JDE business area.
BUSINESS_GROUP_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an business group.
BU_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a business unit.
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_CODE	VARCHAR2	80 CHAR			City Code
CNTCT_REP_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a contact representative organization.
COLLECTIONS_BU_FLG	VARCHAR2	1 CHAR			Collections Business Unit Flag
COMPANY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a financial company.
CONTRACT_BU_FLG	VARCHAR2	1 CHAR			Contract Business Unit Flag
CONTROL_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP control area.
COST_ORG_FLG	VARCHAR2	1 CHAR			Cost Organization Flag
COUNTRY_REGION_CODE	VARCHAR2	80 CHAR			Country Region Code
COUNTY_CODE	VARCHAR2	120 CHAR			Country code
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 last modified 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.
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.
CUSTOMER_PAYMENTS_BU_FLG	VARCHAR2	1 CHAR			Customer Payments Business Unit Flag
C_CITY_CODE	VARCHAR2	120 CHAR			Customer City Code
C_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR			Customer Country Region Code
C_COUNTY_CODE	VARCHAR2	120 CHAR			Customer Country Code
C_STATE_PROV_CODE	VARCHAR2	120 CHAR			Customer State Province Code
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.
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.
DIVN_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a division or department.
EFFECTIVE_FROM_DT	TIMESTAMP		6		This column stores the date from which the dimension record is effective. A value is either assigned by Oracle BI 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 Oracle BI Applications or extracted from the source.
EMAIL_ADDRESS	VARCHAR2	255 CHAR			This is the email address.
ENTERPRISE_FLG	VARCHAR2	1 CHAR			Enterprise Flag
ETL_PROC_WID	NUMBER		38		This column is the unique identifier for the specific ETL process used to create or update this data.
EXPENDITURE_ORG_FLG	VARCHAR2	1 CHAR			Expenditure Organization Flag
EXPENSE_BU_FLG	VARCHAR2	1 CHAR			Expense Business Unit Flag
FAX_NUM	VARCHAR2	60 CHAR			This is the fax number.
FINANCIAL_BU_FLG	VARCHAR2	1 CHAR			Financial Business Unit Flag
FIN_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP financial area.
GOVT_REPT_ENTITY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a government reporting entity.
HR_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a human resource organization.
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.
INTERNAL_FLG	VARCHAR2	1 CHAR			Indicates whether organization is internal.
INT_ORG_ATTR10_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR10_CHAR
INT_ORG_ATTR10_DATE	TIMESTAMP		6		INT_ORG_ATTR10_DATE
INT_ORG_ATTR10_NUM	NUMBER				INT_ORG_ATTR10_NUM
INT_ORG_ATTR11_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR11_CHAR
INT_ORG_ATTR11_NUM	NUMBER				INT_ORG_ATTR11_NUM
INT_ORG_ATTR12_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR12_CHAR
INT_ORG_ATTR12_NUM	NUMBER				INT_ORG_ATTR12_NUM
INT_ORG_ATTR13_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR13_CHAR
INT_ORG_ATTR13_NUM	NUMBER				INT_ORG_ATTR13_NUM
INT_ORG_ATTR14_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR14_CHAR
INT_ORG_ATTR14_NUM	NUMBER				INT_ORG_ATTR14_NUM
INT_ORG_ATTR15_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR15_CHAR
INT_ORG_ATTR15_NUM	NUMBER				INT_ORG_ATTR15_NUM
INT_ORG_ATTR16_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR16_CHAR
INT_ORG_ATTR16_NUM	NUMBER				INT_ORG_ATTR16_NUM
INT_ORG_ATTR17_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR17_CHAR
INT_ORG_ATTR17_NUM	NUMBER				INT_ORG_ATTR17_NUM
INT_ORG_ATTR18_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR18_CHAR
INT_ORG_ATTR18_NUM	NUMBER				INT_ORG_ATTR18_NUM
INT_ORG_ATTR19_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR19_CHAR
INT_ORG_ATTR19_NUM	NUMBER				INT_ORG_ATTR19_NUM
INT_ORG_ATTR1_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR1_CHAR
INT_ORG_ATTR1_DATE	TIMESTAMP		6		INT_ORG_ATTR1_DATE
INT_ORG_ATTR1_NUM	NUMBER				INT_ORG_ATTR1_NUM
INT_ORG_ATTR20_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR20_CHAR
INT_ORG_ATTR20_NUM	NUMBER				INT_ORG_ATTR20_NUM
INT_ORG_ATTR21_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR21_CHAR
INT_ORG_ATTR22_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR22_CHAR
INT_ORG_ATTR23_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR23_CHAR
INT_ORG_ATTR24_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR24_CHAR
INT_ORG_ATTR25_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR25_CHAR
INT_ORG_ATTR26_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR26_CHAR
INT_ORG_ATTR27_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR27_CHAR
INT_ORG_ATTR28_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR28_CHAR
INT_ORG_ATTR29_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR29_CHAR
INT_ORG_ATTR2_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR2_CHAR
INT_ORG_ATTR2_DATE	TIMESTAMP		6		INT_ORG_ATTR2_DATE
INT_ORG_ATTR2_NUM	NUMBER				INT_ORG_ATTR2_NUM
INT_ORG_ATTR30_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR30_CHAR
INT_ORG_ATTR3_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR3_CHAR
INT_ORG_ATTR3_DATE	TIMESTAMP		6		INT_ORG_ATTR3_DATE
INT_ORG_ATTR3_NUM	NUMBER				INT_ORG_ATTR3_NUM
INT_ORG_ATTR4_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR4_CHAR
INT_ORG_ATTR4_DATE	TIMESTAMP		6		INT_ORG_ATTR4_DATE
INT_ORG_ATTR4_NUM	NUMBER				INT_ORG_ATTR4_NUM
INT_ORG_ATTR5_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR5_CHAR
INT_ORG_ATTR5_DATE	TIMESTAMP		6		INT_ORG_ATTR5_DATE
INT_ORG_ATTR5_NUM	NUMBER				INT_ORG_ATTR5_NUM
INT_ORG_ATTR6_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR6_CHAR
INT_ORG_ATTR6_DATE	TIMESTAMP		6		INT_ORG_ATTR6_DATE
INT_ORG_ATTR6_NUM	NUMBER				INT_ORG_ATTR6_NUM
INT_ORG_ATTR7_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR7_CHAR
INT_ORG_ATTR7_DATE	TIMESTAMP		6		INT_ORG_ATTR7_DATE
INT_ORG_ATTR7_NUM	NUMBER				INT_ORG_ATTR7_NUM
INT_ORG_ATTR8_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR8_CHAR
INT_ORG_ATTR8_DATE	TIMESTAMP		6		INT_ORG_ATTR8_DATE
INT_ORG_ATTR8_NUM	NUMBER				INT_ORG_ATTR8_NUM
INT_ORG_ATTR9_CHAR	VARCHAR2	255 CHAR			INT_ORG_ATTR9_CHAR
INT_ORG_ATTR9_DATE	TIMESTAMP		6		INT_ORG_ATTR9_DATE
INT_ORG_ATTR9_NUM	NUMBER				INT_ORG_ATTR9_NUM
INV_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an inventory organization.
LEGAL_ENTITY_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a legal entity.
LEGAL_ENTITY_ID	VARCHAR2	30 CHAR			Legal Entity Id
LEGAL_ENTITY_IDENTIFIER	VARCHAR2	30 CHAR
MARKETING_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a marketing organization.
MATERIALS_MANAGEMENT_BU_FLG	VARCHAR2	1 CHAR			Materials Management Business Unit Flag
MFG_DEPT_FLG	VARCHAR2	1 CHAR			Manufacturing Department Flag
MGR_NAME	VARCHAR2	255 CHAR			This is the name of the manager of the organization.
OPERATING_UNIT_FLG	VARCHAR2	1 CHAR			Indicates whether organization is an operating unit.
ORGANIZATION_CODE	VARCHAR2	80 CHAR			Organization Code
ORG_END_DATE	TIMESTAMP		6		Organization End Date
ORG_LOCATION_ID	VARCHAR2	30 CHAR			Organization Location Id
ORG_NUM	VARCHAR2	30 CHAR			Organization number or short name.
ORG_START_DATE	TIMESTAMP		6		Organization Start Date
ORG_STATUS_CODE	VARCHAR2	30 CHAR			Organization Status Code
ORG_TYPE_CODE	VARCHAR2	50 CHAR			Organization Type Code
PAYABLES_ORG_FLG	VARCHAR2	1 CHAR			Payables Organization Flag
PAYROLL_STATUTORY_UNIT_FLG	VARCHAR2	1 CHAR			Payroll Statutory Unit Flag
PHONE_NUM	VARCHAR2	60 CHAR			This is the phone number.
POSITION_DH_WID	NUMBER		38		Identifies the position hierarchy	DW_EB_X_EBS_COMMON_W_POSITION_DH
POSTAL_CODE	VARCHAR2	50 CHAR			This is the postal code of the customer location.
PRC_CONTRACT_MANAGEMENT_BU_FLG	VARCHAR2	1 CHAR			Contract Management Business Unit Flag
PRIMARY_LEDGER	VARCHAR2	30 CHAR			Primary Ledger
PROJECT_BU_FLG	VARCHAR2	1 CHAR			Project Business Unit Flag
PROJECT_EXP_ORG_FLG	VARCHAR2	1 CHAR			Indicates if the organization is a Project Expenditure Organization
PROJECT_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a project organization.
PROJECT_UNIT_FLG	VARCHAR2	1 CHAR			Project Unit Flag
PRTNRSHP_START_DT	TIMESTAMP		6		This is the partnership start date. This is used for partner organizations only.
PRTNR_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a partner.
PRTNR_SALES_RANK	NUMBER		28,10		This is the partner sales rank. This is used for partner organizations only.
PRTNR_TIER_CODE	VARCHAR2	50 CHAR			This code identifies the partner tier. This is used for partner organizations only.
PRTNR_TYPE_CODE	VARCHAR2	50 CHAR			This code identifies the partner type. This is used for partner organizations only.
PR_ORG_TRGT_MKT	VARCHAR2	50 CHAR			This is the primary organization target market
PR_PTSHP_MKTSEG	VARCHAR2	50 CHAR			This is the primary partnership marketing segment. This is used for partner organizations only.
PTSHP_END_DT	TIMESTAMP		6		This is the partnership end date. This is used for partner organizations only.
PTSHP_PRTNR_ACCNT	VARCHAR2	100 CHAR			This is the partnership partner account. This is used for partner organizations only.
PTSHP_RENEWAL_DT	TIMESTAMP		6		This is the partnership renewal date. This is used for partner organizations only.
PTSHP_SAT_INDEX	NUMBER		28,10		This is the partnership satisfaction index. This is used for partner organizations only.
PTSHP_STAGE_CODE	VARCHAR2	50 CHAR			Partner Stage Code
PURCH_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a purchasing organization.
QUALITY_ENABLED_FLG	VARCHAR2	1 CHAR			Quality Enabled Flag
RECEIVABLES_ORG_FLG	VARCHAR2	1 CHAR			Receivables Organization Flag
RECEIVING_BU_FLG	VARCHAR2	1 CHAR			Receiving Business Unit Flag
REGISTERED_NAME	VARCHAR2	255 CHAR
REGISTRATION_NUM	VARCHAR2	30 CHAR			Registration Number
REPORTING_EST_FLG	VARCHAR2	1 CHAR			Reporting Establishment Flag
REQUISITION_BU_FLG	VARCHAR2	1 CHAR			Requisition Business Unit Flag
RETAIL_FLG	VARCHAR2	1 CHAR			Retail Flag
SALES_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP sales area.
SALES_GROUP_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a sales group.
SALES_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a sales organization.
SCD1_WID	NUMBER		38		This is the new SCD1_WID
SERVICE_ORG_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a service organization.
SET_ID	VARCHAR2	30 CHAR			Peoplesoft Set Identifier
SIA_BU_FLG	VARCHAR2	1 CHAR			Student financial BU Flag
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)
STATE_PROV_CODE	VARCHAR2	120 CHAR			State Province Code
ST_ADDRESS1	VARCHAR2	255 CHAR			This is the first line of street address.
ST_ADDRESS2	VARCHAR2	1000 CHAR			This is the second line of street address.
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) model.
VALUATION_AREA_FLG	VARCHAR2	1 CHAR			Indicates whether organization is a SAP valuation area.
VIS_PRTNR_MGR_ID	VARCHAR2	80 CHAR			Visibility Partner Manager Id
VIS_PR_BU_ID	VARCHAR2	80 CHAR			This is the primary business unit id which has visibility of this organization.
VIS_PR_POS_ID	VARCHAR2	80 CHAR			This is the primary position id which has visibility to this organization.
WEB_ADDRESS	VARCHAR2	255 CHAR			This is the web address.
W_COUNTRY_CODE	VARCHAR2	60 CHAR			Warehouse Country code
W_CURR_CODE	VARCHAR2	50 CHAR			Warehouse Currency Code
W_PTSHP_STAGE_CODE	VARCHAR2	50 CHAR			Partnership Stage Code
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