[Home] [Help] [Dependency Information]
Object Name: | IRCFV_VACANCIES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows vacancies entered via HRMS or iRecruitment, with iRecruitment extra information fields also shown for iRecruitment vacancies, and null columns where the vacancy was entered via HRMS.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
VACANCY_NAME | VARCHAR2 | (30) | Yes | |
DESCRIPTION | VARCHAR2 | (80) | ||
VACANCY_STATUS | VARCHAR2 | (4000) | ||
NUMBER_OF_OPENINGS | NUMBER | (5) | ||
BUDGET_MEASUREMENT_TYPE | VARCHAR2 | (4000) | ||
BUDGET_MEASUREMENT_VALUE | NUMBER | (22) | ||
VACANCY_START_DATE | DATE | Yes | ||
VACANCY_END_DATE | DATE | |||
VACANCY_END_DATE_NN | DATE | |||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
JOB_NAME | VARCHAR2 | (700) | ||
POSITION_NAME | VARCHAR2 | (240) | ||
GRADE_NAME | VARCHAR2 | (240) | ||
PEOPLE_GROUP | VARCHAR2 | (240) | ||
LOCATION_NAME | VARCHAR2 | (60) | ||
REQUISITION_NAME | VARCHAR2 | (30) | Yes | |
REQUISITION_START_DATE | DATE | Yes | ||
REQUISITION_END_DATE | DATE | |||
REQUISITION_END_DATE_NN | DATE | |||
RAISED_BY | VARCHAR2 | (240) | ||
RECRUITER_NAME | VARCHAR2 | (240) | ||
MANAGER_NAME | VARCHAR2 | (240) | ||
SUITABLE_FOR_EMPLOYEE | VARCHAR2 | (4000) | ||
SUITABLE_FOR_CONTRACTOR | VARCHAR2 | (4000) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
KEYWORDS | VARCHAR2 | (240) | ||
TRAVEL_PERCENTAGE | VARCHAR2 | (4000) | ||
MIN_SALARY | NUMBER | |||
MAX_SALARY | NUMBER | |||
SALARY_CORRENCY | VARCHAR2 | (80) | ||
SALARY_PERIOD | VARCHAR2 | (4000) | ||
PROFESSIONAL_AREA | VARCHAR2 | (4000) | ||
WORK_AT_HOME | VARCHAR2 | (4000) | ||
MINIMUM_QUALIFICATION_LEVEL | VARCHAR2 | (150) | ||
MAXIMUM_QUALIFICATION_LEVEL | VARCHAR2 | (150) | ||
_DF:VAC | CHAR | (25) | ||
_DF:REQ | CHAR | (28) | ||
_DF:SRC1 | CHAR | (31) | ||
_DF:SRC2 | CHAR | (35) | ||
BUDGET_MEASUREMENT_TYPE_CODE | VARCHAR2 | (30) | ||
SUITABLE_FOR_EMPLOYEE_CODE | VARCHAR2 | (30) | ||
SUITABLE_FORCONTRACTOR_CODE | VARCHAR2 | (30) | ||
EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | ||
PROFESSIONAL_AREA_CODE | VARCHAR2 | (30) | ||
WORK_AT_HOME_CODE | VARCHAR2 | (30) | ||
TRAVEL_PERCENTAGE_CODE | NUMBER | |||
SALARY_PERIOD_CODE | VARCHAR2 | (30) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
MANAGER_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
RAISER_ID | NUMBER | (10) | ||
RECRUITER_ID | NUMBER | (10) | ||
REQUISITION_ID | NUMBER | (15) | Yes | |
VACANCY_ID | NUMBER | (15) | Yes | |
SEARCH_CRITERIA_ID | NUMBER | (15) | ||
MIN_QUALIFICATION_TYPE_ID | NUMBER | (9) | ||
MAX_QUALIFICATION_TYPE_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, VACANCY_NAME
, DESCRIPTION
, VACANCY_STATUS
, NUMBER_OF_OPENINGS
, BUDGET_MEASUREMENT_TYPE
, BUDGET_MEASUREMENT_VALUE
, VACANCY_START_DATE
, VACANCY_END_DATE
, VACANCY_END_DATE_NN
, ORGANIZATION_NAME
, JOB_NAME
, POSITION_NAME
, GRADE_NAME
, PEOPLE_GROUP
, LOCATION_NAME
, REQUISITION_NAME
, REQUISITION_START_DATE
, REQUISITION_END_DATE
, REQUISITION_END_DATE_NN
, RAISED_BY
, RECRUITER_NAME
, MANAGER_NAME
, SUITABLE_FOR_EMPLOYEE
, SUITABLE_FOR_CONTRACTOR
, EMPLOYMENT_CATEGORY
, KEYWORDS
, TRAVEL_PERCENTAGE
, MIN_SALARY
, MAX_SALARY
, SALARY_CORRENCY
, SALARY_PERIOD
, PROFESSIONAL_AREA
, WORK_AT_HOME
, MINIMUM_QUALIFICATION_LEVEL
, MAXIMUM_QUALIFICATION_LEVEL
, _DF:VAC
, _DF:REQ
, _DF:SRC1
, _DF:SRC2
, BUDGET_MEASUREMENT_TYPE_CODE
, SUITABLE_FOR_EMPLOYEE_CODE
, SUITABLE_FORCONTRACTOR_CODE
, EMPLOYMENT_CATEGORY_CODE
, PROFESSIONAL_AREA_CODE
, WORK_AT_HOME_CODE
, TRAVEL_PERCENTAGE_CODE
, SALARY_PERIOD_CODE
, BUSINESS_GROUP_ID
, GRADE_ID
, JOB_ID
, LOCATION_ID
, MANAGER_ID
, ORGANIZATION_ID
, PEOPLE_GROUP_ID
, POSITION_ID
, RAISER_ID
, RECRUITER_ID
, REQUISITION_ID
, VACANCY_ID
, SEARCH_CRITERIA_ID
, MIN_QUALIFICATION_TYPE_ID
, MAX_QUALIFICATION_TYPE_ID
FROM APPS.IRCFV_VACANCIES;
APPS.IRCFV_VACANCIES is not referenced by any database object
|
|
|