DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.IRC_VAC_SUMMARY#

Object Details
Object Name: IRC_VAC_SUMMARY#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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# references the following:

SchemaHR
TableIRC_VAC_SUMMARY
HR.IRC_VAC_SUMMARY# is referenced by following:

SchemaAPPS
SynonymIRC_VAC_SUMMARY