[Home] [Help] [Dependency Information]
Object Name: | IRC_VAC_SUMMARY# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|