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_SIC_HIER_T

Object Details

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

FEM_SIC_HIER_T is an interface table for loading and updating Analytic Standard Industrial Classification hierarchies using the Dimension Hierarchy Loader. This table stores the individual relationship records for each parent and child combination in the hierarchy.
The HIERARCHY_OBJECT_NAME, HIERARCHY_OBJ_DEF_DISPLAY_NAME and LANGUAGE columns
identify the hierarchy version for loading. For each hierarchy version that you wish to load, populate the Parent and Child columns to designate the appropriate parent and child relationship records.
In addition, in order to load a hierarchy, you need to populate the interface tables that provide header information for the hierarchy. The header tables that you need to populate are based upon the type of hierarchy that is being loaded. The hierarchy header tables are: FEM_HIERARCHIES_T, FEM_HIER_DIM_GRPS_T, and FEM_HIER_VALUE_SETS_T.
Each distinct member is always identified by the non translatable alphanumeric identifier for the Channel. The PARENT_DISPLAY_CODE and CHILD_DISPLAY_CODE columns in the interface table stores this identifier.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Standard Industrial Classifications Hierarchy Detail
Category: BUSINESS_ENTITY FEM_XDIM_HIERARCHY

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_SIC_HIER_T_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	HIERARCHY_OBJECT_NAME HIERARCHY_OBJ_DEF_DISPLAY_NAME PARENT_DISPLAY_CODE CHILD_DISPLAY_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Hierarchy Object Name
HIERARCHY_OBJ_DEF_DISPLAY_NAME	VARCHAR2	(150)	Yes	Hierarchy Object Definition Name
PARENT_DISPLAY_CODE	VARCHAR2	(150)	Yes	Identifier of the parent dimension member
CHILD_DISPLAY_CODE	VARCHAR2	(150)	Yes	Identifier of the child dimension member
DISPLAY_ORDER_NUM	NUMBER		Yes	Display order number within the hierarchy for the parent child relationship
WEIGHTING_PCT	NUMBER	(3)		Weighting Percentage designating the relative weight assigned to the child from the parent
LANGUAGE	VARCHAR2	(4)	Yes	Language of the hierarchy object name and object definition name
STATUS	VARCHAR2	(30)	Yes	Designates the loading status of the row
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 HIERARCHY_OBJECT_NAME
,      HIERARCHY_OBJ_DEF_DISPLAY_NAME
,      PARENT_DISPLAY_CODE
,      CHILD_DISPLAY_CODE
,      DISPLAY_ORDER_NUM
,      WEIGHTING_PCT
,      LANGUAGE
,      STATUS
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_SIC_HIER_T;

Dependencies

[top of page]

FEM.FEM_SIC_HIER_T does not reference any database object

FEM.FEM_SIC_HIER_T is referenced by following:

APPS: FEM_SIC_HIER_T