eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: FEM.FEM_SHARED_ATTR_T

Object Details

Object Name:	FEM_SHARED_ATTR_T
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

FEM_SHARED_ATTR_T is an interface table for loading and updating attribute assignments for members of any Analytic Auxiliary dimension using the Dimension Member Loader. In constrast to Analytic Foundation dimensions, Analytic Auxiliary dimensions are those dimensions that are not normally considered critical for business calculations and processes.
Foundation dimensions each have their own set of interface tables, while Auxiliary dimensions share the FEM_SIMPLE_DIMS_B_T, FEM_SIMPLE_DIMS_TL_T and FEM_SHARED_ATTR_T interface tables for loading members. The following list of dimensions is the list of specifically designated Foundation dimensions with their own individual interface tables. All other dimensions are considered Auxiliary:
Budget
Calendar Period
Channel
Company Cost Center Organization
Company
Cost Center
Customer
Dataset
Entity
Financial Element
Geography
Ledger
Line Item
Natural Account
Product
Project
Standard Industrial Classification
Task
User Dimensions 1 through 10
Since members from Auxiliary dimensions are loaded from a set of shared interface tables, you need to designate the dimension to which the member belongs in the DIMENSION_VARCHAR_LABEL column. You only need to populate the FEM_SHARED_ATTR_T table when you are either:
1) Loading new members of an Auxiliary dimension that has required attributes or optional attributes that you wish to assign
2) Updating attribute assignments for members of an Auxiliary dimension
When you are creating new members of an (attributed) Auxiliary dimension, you also need to populate the FEM_SIMPLE_DIMS_B_T and FEM_SIMPLE_DIMS_TL_T tables.
Populate the FEM_SHARED_ATTR_T table with one row for each distinct attribute assignment per member. The columns in the FEM_SHARED_ATTR_T table are:
DIMENSION_VARCHAR_LABEL - This column identifies the Auxiliary dimension ATTRIBUTE_VARCHAR_LABEL - This column identifies the attribute
MEMBER_CODE - This column identifies the dimension member
VERSION_DISPLAY_CODE - This column identifies the attribute version to which the assignment applies
ATTR_ASSIGN_VS_DISPLAY_CODE - Normally this column should be null. It is only populated if the attribute being assigned uses a Value Set dimension as the list of values for assignments. In which case, you populate this column with the Display Code that identifies the Value Set of that list of values dimension.
STATUS - This column designates the loading status for the record. You will initially populate it as 'LOAD', thereby indicating that the Dimension Member loader should try to load the record into the Enterprise Performance Foundation database. If there is a problem with the record or the member being loaded, the loader will update this column with an error code that specifies the problem encountered.
CREATED_BY_DIM_MIGRATION_FLAG - Always leave this column as null for your loads. Enterprise Performance Foundation uses this column for Dimension Migration loads.
The 4 CALPATTR columns are columns that should normally remain null. Only populate these columns if the attribute uses the Calendar Period dimension as the list of values for assignments. In which case, you populate these columns with the 4 (external) identifying components of a Calendar Period member.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Auxiliary Dimension Member Attribute Assignments
Category: BUSINESS_ENTITY FEM_XDIM_AUXILIARY

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_SHARED_ATTR_T_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DIMENSION_VARCHAR_LABEL MEMBER_CODE ATTRIBUTE_VARCHAR_LABEL VERSION_DISPLAY_CODE ATTRIBUTE_ASSIGN_VALUE ATTR_ASSIGN_VS_DISPLAY_CODE CALPATTR_CAL_DISPLAY_CODE CALPATTR_DIMGRP_DISPLAY_CODE CALPATTR_END_DATE CALPATTR_PERIOD_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_VARCHAR_LABEL	VARCHAR2	(30)	Yes	Non translatable alphanumeric identifier for the dimension
MEMBER_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier for the dimension member
ATTRIBUTE_VARCHAR_LABEL	VARCHAR2	(30)	Yes	Non translatable alphanumeric identifier for the attribute
VERSION_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier for the attribute version
ATTRIBUTE_ASSIGN_VALUE	VARCHAR2	(1000)		Designates the actual assignment for the attribute
ATTR_ASSIGN_VS_DISPLAY_CODE	VARCHAR2	(150)		Identifies the value set of the attribute assignment if the attribute references a value set dimension as the list of values
STATUS	VARCHAR2	(30)	Yes	Designates the load status of the record
CALPATTR_CAL_DISPLAY_CODE	VARCHAR2	(150)		Non translatable alpahnumeric identifier of the Calendar that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values
CALPATTR_DIMGRP_DISPLAY_CODE	VARCHAR2	(150)		Non translatable alpahnumeric identifier of the Dimension Group that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values
CALPATTR_END_DATE	DATE			End Date of the Calendar Period that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values
CALPATTR_PERIOD_NUM	NUMBER			Period Number of the Calendar Period that is a component of the attribute assignment when the attribute references the Calendar Period dimension as a list of values
CREATED_BY_DIM_MIGRATION_FLAG	VARCHAR2	(1)		Oracle applications uses this column to identify data created by internal processes. Do not populate this column for user created rows - leave as null.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DIMENSION_VARCHAR_LABEL
,      MEMBER_CODE
,      ATTRIBUTE_VARCHAR_LABEL
,      VERSION_DISPLAY_CODE
,      ATTRIBUTE_ASSIGN_VALUE
,      ATTR_ASSIGN_VS_DISPLAY_CODE
,      STATUS
,      CALPATTR_CAL_DISPLAY_CODE
,      CALPATTR_DIMGRP_DISPLAY_CODE
,      CALPATTR_END_DATE
,      CALPATTR_PERIOD_NUM
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_SHARED_ATTR_T;

Dependencies

[top of page]

FEM.FEM_SHARED_ATTR_T does not reference any database object

FEM.FEM_SHARED_ATTR_T is referenced by following:

APPS: FEM_SHARED_ATTR_T; FEM_SHARED_ATTR_T_TI1