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_CAL_PERIODS_HIER_T

Object Details

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

FEM_CAL_PERIODS_HIER_T is an interface table for loading and updating Analytic Calendar Period 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 and FEM_HIER_DIM_GRPS_T.
Each distinct parent and child Calendar Period member is always identified by the following:
Calendar (in the CALENDAR_DISPLAY_CODE column)
Level (in the PARENT_DIM_GRP_DISPLAY_CODE and CHILD_DIM_GRP_DISPLAY_CODE columns)
End Date (in the PARENT_CAL_PERIOD_END_DATE and CHILD_CAL_PERIOD_END_DATE columns)
Period Number (in the PARENT_CAL_PERIOD_NUMBER and CHILD_CAL_PERIOD_NUMBER columns)
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Calendar Period Hierarchy Detail
Category: BUSINESS_ENTITY FEM_XDIM_HIERARCHY

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_CAL_PERIODS_HIER_T_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	HIERARCHY_OBJECT_NAME HIERARCHY_OBJ_DEF_DISPLAY_NAME PARENT_DIM_GRP_DISPLAY_CODE PARENT_CAL_PERIOD_END_DATE PARENT_CAL_PERIOD_NUMBER CHILD_DIM_GRP_DISPLAY_CODE CHILD_CAL_PERIOD_END_DATE CHILD_CAL_PERIOD_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
HIERARCHY_OBJECT_NAME	VARCHAR2	(150)	Yes	Object name of the hierarchy
HIERARCHY_OBJ_DEF_DISPLAY_NAME	VARCHAR2	(150)	Yes	Display name of the object definition of the hierarchy
PARENT_CAL_PERIOD_END_DATE	DATE		Yes	The end date of the parent node
PARENT_CAL_PERIOD_NUMBER	NUMBER	(15)	Yes	The relative number of the parent period within a given year
CHILD_CAL_PERIOD_END_DATE	DATE		Yes	The end date of the child node
CHILD_CAL_PERIOD_NUMBER	NUMBER	(15)	Yes	The relative number of the child period within a given year
LANGUAGE	VARCHAR2	(4)	Yes	Designates the language of the Hierarchy Object and Hierarchy Object Definition for the relationship record
DISPLAY_ORDER_NUM	NUMBER		Yes	Sequence number that designates the order in which hierarchy relationships are displayed on the screen
WEIGHTING_PCT	NUMBER	(3)		Weighting Percentage designating the relative weight assigned to the child from the parent
STATUS	VARCHAR2	(30)	Yes	Load status of the record
CALENDAR_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric code identifying the Calendar
PARENT_DIM_GRP_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the level
CHILD_DIM_GRP_DISPLAY_CODE	VARCHAR2	(150)	Yes	Non translatable alphanumeric identifier of the level
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_CAL_PERIOD_END_DATE
,      PARENT_CAL_PERIOD_NUMBER
,      CHILD_CAL_PERIOD_END_DATE
,      CHILD_CAL_PERIOD_NUMBER
,      LANGUAGE
,      DISPLAY_ORDER_NUM
,      WEIGHTING_PCT
,      STATUS
,      CALENDAR_DISPLAY_CODE
,      PARENT_DIM_GRP_DISPLAY_CODE
,      CHILD_DIM_GRP_DISPLAY_CODE
,      CREATED_BY_DIM_MIGRATION_FLAG
FROM FEM.FEM_CAL_PERIODS_HIER_T;

Dependencies

[top of page]

FEM.FEM_CAL_PERIODS_HIER_T does not reference any database object

FEM.FEM_CAL_PERIODS_HIER_T is referenced by following:

APPS: FEM_CAL_PERIODS_HIER_T