VIEW: HR.IRC_VAC_SUMMARY#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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