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: HRI.EDW_HR_AGE_BAND_M

Object Details

Object Name:	EDW_HR_AGE_BAND_M
Object Type:	TABLE
Owner:	HRI
FND Design Data:	HRI.EDW_HR_AGE_BAND_M
Subobject Name:
Status:	VALID

This is the Age Band dimension table. This is a denormalized star table and contains records for the lowest level of the dimension and every level above.
The Age dimension delivers a number of age bands that enable you to group people of a similar age. Age bands are measured in years and months and are configurable. The Age dimension is referenced by several facts, usually to record the age of a person at the time of a transaction.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_HR_AGE_BAND_M_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	AGBD_AGE_BAND_PK AGBD_AGE_BAND_PK_KEY
EDW_HR_AGE_BAND_M_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	AGBD_AGE_BAND_PK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
AGBD_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
AGBD_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
ALL_NAME	VARCHAR2	(80)		Name for the All Level
AGBD_AGE_BAND_PK_KEY	NUMBER		Yes	Unique Warehouse Identifier for the Age Band Level
ALL_ALL_PK	VARCHAR2	(40)		Textual Unique Identifier for the All Ages Level
ALL_ALL_PK_KEY	NUMBER			Unique Warehouse Identifier for the All Ages Level
AGBD_AGE_BAND_PK	VARCHAR2	(400)		Textual Unique Identifier for the Age Band level
AGBD_AGE_BAND_DP	VARCHAR2	(240)		Reserved for future use
AGBD_NAME	VARCHAR2	(240)		Age Band Name for the Age Band level
AGBD_AGE_MAX	NUMBER			The Maximum age of the Age Band in months
AGBD_AGE_MIN	NUMBER			The Minimum age of the Age Band in months
AGBD_LAST_UPDATE_DATE	DATE			Internal use only
AGBD_CREATION_DATE	DATE			Internal use only
AGBD_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
AGBD_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
AGBD_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
AGBD_INSTANCE	VARCHAR2	(400)		Identity of Data Source
CREATION_DATE	DATE			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
AGBD_AGE_MIN_MONTHS	NUMBER			Together with minimum age (years), provides the minimum age for the band in years and months
AGBD_AGE_MAX_MONTHS	NUMBER			Together with maximum age (years), provides the maximum age for the band in years and months
AGBD_AGE_MIN_YEARS	NUMBER			Together with minimum age (months), provides the minimum age for the band in years and months
AGBD_AGE_MAX_YEARS	NUMBER			Together with maximum age (months), provides the maximum age for the band in years and months

Query Text

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


SELECT AGBD_USER_ATTRIBUTE4
,      AGBD_USER_ATTRIBUTE5
,      ALL_NAME
,      AGBD_AGE_BAND_PK_KEY
,      ALL_ALL_PK
,      ALL_ALL_PK_KEY
,      AGBD_AGE_BAND_PK
,      AGBD_AGE_BAND_DP
,      AGBD_NAME
,      AGBD_AGE_MAX
,      AGBD_AGE_MIN
,      AGBD_LAST_UPDATE_DATE
,      AGBD_CREATION_DATE
,      AGBD_USER_ATTRIBUTE1
,      AGBD_USER_ATTRIBUTE2
,      AGBD_USER_ATTRIBUTE3
,      AGBD_INSTANCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      AGBD_AGE_MIN_MONTHS
,      AGBD_AGE_MAX_MONTHS
,      AGBD_AGE_MIN_YEARS
,      AGBD_AGE_MAX_YEARS
FROM HRI.EDW_HR_AGE_BAND_M;

Dependencies

[top of page]

HRI.EDW_HR_AGE_BAND_M does not reference any database object

HRI.EDW_HR_AGE_BAND_M is referenced by following:

APPS: EDW_HR_AGE_BAND_M