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_RQN_VCNCY_M

Object Details

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

This is the Requisition Vacancy dimension table. This is a denormalized star table and contains records for the lowest level of the dimension and every level above.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_HR_RQN_VCNCY_M_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	VNCY_VACANCY_PK VNCY_VACANCY_PK_KEY
EDW_HR_RQN_VCNCY_M_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	VNCY_VACANCY_PK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
ALL_ALL_PK	VARCHAR2	(40)		Textual Unique Identifier for the All Vacancies Level
RQSN_REQUISITION_PK_KEY	NUMBER			Unique Warehouse Identifier for the Requisition Level
VNCY_VACANCY_PK_KEY	NUMBER		Yes	Unique Warehouse Identifier for the Vacancy Level
VNCY_VACANCY_PK	VARCHAR2	(400)		Textual Unique Identifier for the Vacancy Level
VNCY_INSTANCE	VARCHAR2	(40)		Identity of Data Source
VNCY_VACANCY_STATUS_CODE	VARCHAR2	(30)		Hidden Code for the Vacancy Status from the data source
VNCY_VACANCY_STATUS	VARCHAR2	(80)		The status of the vacancy
VNCY_NUMBER_OF_OPENINGS	NUMBER			Number of people who can be hired for this vacancy
VNCY_NAME	VARCHAR2	(360)		Vacancy Name for the Vacancy Level
VNCY_VACANCY_DP	VARCHAR2	(360)		Reserved for future use
VNCY_BUSINESS_GROUP_ID	NUMBER			Hidden Identifier for the Business Group from the data source
VNCY_REQUISITION_ID	NUMBER			Hidden Identifier for the Requisition from the data source
VNCY_VACANCY_ID	NUMBER			Hidden Identifier for the Vacancy from the data source
VNCY_VACANCY_START_DATE	DATE			Start date of the Vacancy
VNCY_VACANCY_END_DATE	DATE			End date of the Vacancy
VNCY_LAST_UPDATE_DATE	DATE			Internal use only
VNCY_CREATION_DATE	DATE			Internal use only
VNCY_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
VNCY_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
VNCY_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
VNCY_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
VNCY_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
RQSN_REQUISITION_PK	VARCHAR2	(400)		Textual Unique Identifier for the Requisition Level
RQSN_INSTANCE	VARCHAR2	(40)		Identity of Data Source
RQSN_NAME	VARCHAR2	(360)		Requisition Name for the Requisition Level
RQSN_REQUISITION_DP	VARCHAR2	(360)		Reserved for future use
RQSN_BUSINESS_GROUP_ID	NUMBER			Hidden Identifier for the Business Group from the data source
RQSN_REQUISITION_ID	NUMBER			Hidden Identifier for the Requisition from the data source
RQSN_START_DATE	DATE			Start date of the Requisition
RQSN_END_DATE	DATE			End date of the Requisition
RQSN_LAST_UPDATE_DATE	DATE			Internal use only
RQSN_CREATION_DATE	DATE			Internal use only
RQSN_USER_ATTRIBUTE1	VARCHAR2	(240)		User Defined Attribute
RQSN_USER_ATTRIBUTE2	VARCHAR2	(240)		User Defined Attribute
RQSN_USER_ATTRIBUTE3	VARCHAR2	(240)		User Defined Attribute
RQSN_USER_ATTRIBUTE4	VARCHAR2	(240)		User Defined Attribute
RQSN_USER_ATTRIBUTE5	VARCHAR2	(240)		User Defined Attribute
ALL_ALL_PK_KEY	NUMBER			Unique Warehouse Identifier for the All Vacancies Level
ALL_NAME	VARCHAR2	(80)		Name for the All Level
VNCY_BUDGET_MSRMNT_TYPE	VARCHAR2	(80)		Budget Measurement Type (e.g. Full Time Equivalent)
VNCY_BUDGET_MSRMNT_VALUE	NUMBER			Budget Measurement Value for vacancy
VNCY_BUDGET_MSRMNT_TYPE_CODE	VARCHAR2	(30)		Hidden Code for the Budget Measurement Type from the data source
CREATION_DATE	DATE			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column

Query Text

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


SELECT ALL_ALL_PK
,      RQSN_REQUISITION_PK_KEY
,      VNCY_VACANCY_PK_KEY
,      VNCY_VACANCY_PK
,      VNCY_INSTANCE
,      VNCY_VACANCY_STATUS_CODE
,      VNCY_VACANCY_STATUS
,      VNCY_NUMBER_OF_OPENINGS
,      VNCY_NAME
,      VNCY_VACANCY_DP
,      VNCY_BUSINESS_GROUP_ID
,      VNCY_REQUISITION_ID
,      VNCY_VACANCY_ID
,      VNCY_VACANCY_START_DATE
,      VNCY_VACANCY_END_DATE
,      VNCY_LAST_UPDATE_DATE
,      VNCY_CREATION_DATE
,      VNCY_USER_ATTRIBUTE1
,      VNCY_USER_ATTRIBUTE2
,      VNCY_USER_ATTRIBUTE3
,      VNCY_USER_ATTRIBUTE4
,      VNCY_USER_ATTRIBUTE5
,      RQSN_REQUISITION_PK
,      RQSN_INSTANCE
,      RQSN_NAME
,      RQSN_REQUISITION_DP
,      RQSN_BUSINESS_GROUP_ID
,      RQSN_REQUISITION_ID
,      RQSN_START_DATE
,      RQSN_END_DATE
,      RQSN_LAST_UPDATE_DATE
,      RQSN_CREATION_DATE
,      RQSN_USER_ATTRIBUTE1
,      RQSN_USER_ATTRIBUTE2
,      RQSN_USER_ATTRIBUTE3
,      RQSN_USER_ATTRIBUTE4
,      RQSN_USER_ATTRIBUTE5
,      ALL_ALL_PK_KEY
,      ALL_NAME
,      VNCY_BUDGET_MSRMNT_TYPE
,      VNCY_BUDGET_MSRMNT_VALUE
,      VNCY_BUDGET_MSRMNT_TYPE_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM HRI.EDW_HR_RQN_VCNCY_M;

Dependencies

[top of page]

HRI.EDW_HR_RQN_VCNCY_M does not reference any database object

HRI.EDW_HR_RQN_VCNCY_M is referenced by following:

APPS: EDW_HR_RQN_VCNCY_M