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: HR.IRC_VAC_SUMMARY

Object Details

Object Name:	IRC_VAC_SUMMARY
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IRC_VAC_SUMMARY_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VACANCY_ID
IRC_VAC_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MANAGER_ID
IRC_VAC_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECRUITER_ID
IRC_VAC_SUMMARY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory
VACANCY_ID	NUMBER	(15)	Yes
MANAGER_ID	NUMBER	(15)
RECRUITER_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
BUDGET_MEASUREMENT_TYPE	VARCHAR2	(30)
BUDGET_MEASUREMENT_VALUE	NUMBER	(22)
NUMBER_OF_OPENINGS	NUMBER	(5)
TOTAL_APPLICATIONS	NUMBER	(15)
ACTIVE_APPLICATIONS	NUMBER	(15)
FILLED_APPLICATIONS	NUMBER	(15)
TO_BE_PROCESSED_APPLICATIONS	NUMBER	(15)
IN_PROGRESS_APPLICATIONS	NUMBER	(15)
REJECTED_APPLICATIONS	NUMBER	(15)
PENDING_FOR_APPROVAL_OFFERS	NUMBER	(15)
APPROVED_OFFERS	NUMBER	(15)
EXTENDED_OFFERS	NUMBER	(15)
ACCEPTED_OFFERS	NUMBER	(15)
REJECTED_OFFERS	NUMBER	(15)
ON_HOLD_OFFERS	NUMBER	(15)
WITHDRAWN_OFFERS	NUMBER	(15)
PROCESSED_STATUS	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE

Query Text

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


SELECT VACANCY_ID
,      MANAGER_ID
,      RECRUITER_ID
,      ORGANIZATION_ID
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_VALUE
,      NUMBER_OF_OPENINGS
,      TOTAL_APPLICATIONS
,      ACTIVE_APPLICATIONS
,      FILLED_APPLICATIONS
,      TO_BE_PROCESSED_APPLICATIONS
,      IN_PROGRESS_APPLICATIONS
,      REJECTED_APPLICATIONS
,      PENDING_FOR_APPROVAL_OFFERS
,      APPROVED_OFFERS
,      EXTENDED_OFFERS
,      ACCEPTED_OFFERS
,      REJECTED_OFFERS
,      ON_HOLD_OFFERS
,      WITHDRAWN_OFFERS
,      PROCESSED_STATUS
,      LAST_UPDATE_DATE
FROM HR.IRC_VAC_SUMMARY;

Dependencies

[top of page]

HR.IRC_VAC_SUMMARY does not reference any database object

HR.IRC_VAC_SUMMARY is referenced by following:

HR: IRC_VAC_SUMMARY#