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

VIEW: APPS.HRI_OBI_MD_REC_VACANCY_V

Object Details
Object Name: HRI_OBI_MD_REC_VACANCY_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_DAY_VAC_STRT_FK DATE

Vacancy Start day
TIME_DAY_VAC_END_FK DATE

Vacancy End date
PER_PERSON_RCRT_FK NUMBER

Person RCRT
PER_PERSON_RMGR_FK NUMBER

Person RMGR
PER_PERSON_RSED_FK NUMBER

Person RSED
PER_PERSON_MRGD_FK NUMBER

Person MRGD
ORG_ORGANZTN_FK NUMBER

Oraganization id
ORG_ORGANZTN_MRGD_FK NUMBER

Organization MRGD
GEO_LOCATION_FK NUMBER

Geography Location ID
JOB_JOB_FK NUMBER

Job ID
GRD_GRADE_FK NUMBER

Grade ID
POS_POSITION_FK NUMBER

Position ID
RVAC_VACNCY_FK NUMBER

Vacancy ID
VAC_OPEN_CNT NUMBER

Vacancy Open Count
INIT_APPL_STG_CNT NUMBER

Initial Application Stage Count
ASMT_STG_CNT NUMBER

ASMT STG Count
OFFR_EXTD_STG_CNT NUMBER

Offer Extend Stage Count
STRT_PNDG_STG_CNT NUMBER

Start Pending Stage Count
HIRE_PRE_POW1_CNT NUMBER

Hire Count
APPL_IN_PROGRESS_CNT NUMBER

Application in Progress Count
APPL_STRT_EVNT_CNT NUMBER

Application Start even Count
APPL_TERM_INIT_EVNT_CNT NUMBER

Application Terminated Count
APPL_TERM_VOL_INIT_EVNT_CNT NUMBER

Application Terminated Volume count
APPL_TERM_INVOL_INIT_EVNT_CNT NUMBER

Application Terminated InVolume count
ASMT_STRT_EVNT_CNT NUMBER

Assessment Start Event Count
APPL_TERM_ASMT_EVNT_CNT NUMBER

Assessment Termination Event Count
APPL_TERM_VOL_ASMT_EVNT_CNT NUMBER

Assessment Termination Event Count
APPL_TERM_INVOL_ASMT_EVNT_CNT NUMBER

Assessment Termination Event Count
OFFR_EXTD_EVNT_CNT NUMBER

Offer Count
APPL_TERM_OFFR_EVNT_CNT NUMBER

Application Termination Offer count
APPL_TERM_VOL_OFFR_EVNT_CNT NUMBER

Application Termination Offer Volume count
APPL_TERM_INVOL_OFFR_EVNT_CNT NUMBER

Application Termination Offer InVolume count
OFFR_ACPT_EVNT_CNT NUMBER

Offer Accept Event Count
APPL_TERM_ACPT_EVNT_CNT NUMBER

Application Termination Accepted Count
APPL_TERM_VOL_ACPT_EVNT_CNT NUMBER

Application Termination Accepted Count
APPL_TERM_INVOL_ACPT_EVNT_CNT NUMBER

Application Termination Accepted Count
APPL_TERM_EVNT_CNT NUMBER

Application Terminated Count
APPL_TERM_VOL_EVNT_CNT NUMBER

Application Terminated Count
APPL_TERM_INVOL_EVNT_CNT NUMBER

Application Terminated Count
HIRE_APPL_EVNT_CNT NUMBER

Hire Application Event Count
POST_HIRE_POW1_END_EVNT_CNT NUMBER

Hire Application Event Count
PRE_POW1_END_SPRTN_EVNT_CNT NUMBER

Hire Application Event Count
VAC_TO_APPL_STRT_EVNT_DAYS NUMBER

Vacancy To Application Start Days
VAC_TO_ASMT_STRT_EVNT_DAYS NUMBER

Vacancy to Assessment Start Event Days
VAC_TO_OFFR_EXTD_EVNT_DAYS NUMBER

Vacancy to Offer Extended Event Days
VAC_TO_OFFR_ACPT_EVNT_DAYS NUMBER

Vacancy to Offer Accepted Event Days
VAC_TO_FILL_EVNT_DAYS NUMBER

Vacancy to Fill Event Days
VAC_TO_APPL_HIRE_EVNT_DAYS NUMBER

Vacancy to Application Hire Event Days
FILL_TO_APPL_HIRE_EVNT_DAYS NUMBER

Fill TO Application Hire Event Days
VAC_TO_TERM_OFFR_EVNT_DAYS NUMBER

Vacancy to Terminated Offer Event Days
VAC_TO_APPL_TERM_EVNT_DAYS NUMBER

Vacancy to Application Termination Event Days
APPL_TO_ASMT_STRT_EVNT_DAYS NUMBER

Application to Assessment Start Event Days
APPL_TO_OFFR_EXTD_EVNT_DAYS NUMBER

Application to Offer Extended Event Days
APPL_TO_OFFR_ACPT_EVNT_DAYS NUMBER

Application to Offer Accepted Event Days
APPL_TO_FILL_EVNT_DAYS NUMBER

Accept to Fill Event Days
APPL_TO_APPL_HIRE_EVNT_DAYS NUMBER

Application to Application Hire Event Days
APPL_TO_TERM_OFFR_EVNT_DAYS NUMBER

Application To Termination Offer Event Days
APPL_TO_APPL_TERM_EVNT_DAYS NUMBER

Application To Application Termination Event Days
OFFR_TO_TERM_VOL_EVNT_DAYS NUMBER

Offer to Termination Event Days
OFFR_TO_TERM_INVOL_EVNT_DAYS NUMBER

Offer to Termination InVol Event Days
OFFR_TO_ACPT_EVNT_DAYS NUMBER

Offer to Accept Event Days
ACPT_TO_TERM_VOL_EVNT_DAYS NUMBER

Accept to Termination Vol Event Days
ACPT_TO_TERM_INVOL_EVNT_DAYS NUMBER

Accept to Termination InVol Event Days
TOTAL_OPENINGS NUMBER

Total Openings
FILLED_OPENINGS NUMBER

Filled Openings
TOTAL_HEADCOUNT NUMBER

Total Headcount
FILLED_HEADCOUNT NUMBER

Filled Headcount
TOTAL_FTE NUMBER

Total FTE
FILLED_FTE NUMBER

Filled FTE
TOTAL_MONEY NUMBER

Total Money
FILLED_MONEY NUMBER

Filled Money
VAC_FILLED_IND NUMBER

Vacnacy Filled
Query Text

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


SELECT TIME_DAY_VAC_STRT_FK
,      TIME_DAY_VAC_END_FK
,      PER_PERSON_RCRT_FK
,      PER_PERSON_RMGR_FK
,      PER_PERSON_RSED_FK
,      PER_PERSON_MRGD_FK
,      ORG_ORGANZTN_FK
,      ORG_ORGANZTN_MRGD_FK
,      GEO_LOCATION_FK
,      JOB_JOB_FK
,      GRD_GRADE_FK
,      POS_POSITION_FK
,      RVAC_VACNCY_FK
,      VAC_OPEN_CNT
,      INIT_APPL_STG_CNT
,      ASMT_STG_CNT
,      OFFR_EXTD_STG_CNT
,      STRT_PNDG_STG_CNT
,      HIRE_PRE_POW1_CNT
,      APPL_IN_PROGRESS_CNT
,      APPL_STRT_EVNT_CNT
,      APPL_TERM_INIT_EVNT_CNT
,      APPL_TERM_VOL_INIT_EVNT_CNT
,      APPL_TERM_INVOL_INIT_EVNT_CNT
,      ASMT_STRT_EVNT_CNT
,      APPL_TERM_ASMT_EVNT_CNT
,      APPL_TERM_VOL_ASMT_EVNT_CNT
,      APPL_TERM_INVOL_ASMT_EVNT_CNT
,      OFFR_EXTD_EVNT_CNT
,      APPL_TERM_OFFR_EVNT_CNT
,      APPL_TERM_VOL_OFFR_EVNT_CNT
,      APPL_TERM_INVOL_OFFR_EVNT_CNT
,      OFFR_ACPT_EVNT_CNT
,      APPL_TERM_ACPT_EVNT_CNT
,      APPL_TERM_VOL_ACPT_EVNT_CNT
,      APPL_TERM_INVOL_ACPT_EVNT_CNT
,      APPL_TERM_EVNT_CNT
,      APPL_TERM_VOL_EVNT_CNT
,      APPL_TERM_INVOL_EVNT_CNT
,      HIRE_APPL_EVNT_CNT
,      POST_HIRE_POW1_END_EVNT_CNT
,      PRE_POW1_END_SPRTN_EVNT_CNT
,      VAC_TO_APPL_STRT_EVNT_DAYS
,      VAC_TO_ASMT_STRT_EVNT_DAYS
,      VAC_TO_OFFR_EXTD_EVNT_DAYS
,      VAC_TO_OFFR_ACPT_EVNT_DAYS
,      VAC_TO_FILL_EVNT_DAYS
,      VAC_TO_APPL_HIRE_EVNT_DAYS
,      FILL_TO_APPL_HIRE_EVNT_DAYS
,      VAC_TO_TERM_OFFR_EVNT_DAYS
,      VAC_TO_APPL_TERM_EVNT_DAYS
,      APPL_TO_ASMT_STRT_EVNT_DAYS
,      APPL_TO_OFFR_EXTD_EVNT_DAYS
,      APPL_TO_OFFR_ACPT_EVNT_DAYS
,      APPL_TO_FILL_EVNT_DAYS
,      APPL_TO_APPL_HIRE_EVNT_DAYS
,      APPL_TO_TERM_OFFR_EVNT_DAYS
,      APPL_TO_APPL_TERM_EVNT_DAYS
,      OFFR_TO_TERM_VOL_EVNT_DAYS
,      OFFR_TO_TERM_INVOL_EVNT_DAYS
,      OFFR_TO_ACPT_EVNT_DAYS
,      ACPT_TO_TERM_VOL_EVNT_DAYS
,      ACPT_TO_TERM_INVOL_EVNT_DAYS
,      TOTAL_OPENINGS
,      FILLED_OPENINGS
,      TOTAL_HEADCOUNT
,      FILLED_HEADCOUNT
,      TOTAL_FTE
,      FILLED_FTE
,      TOTAL_MONEY
,      FILLED_MONEY
,      VAC_FILLED_IND
FROM APPS.HRI_OBI_MD_REC_VACANCY_V;

Dependencies

[top of page]

APPS.HRI_OBI_MD_REC_VACANCY_V references the following:

SchemaAPPS
SynonymHRI_MB_REC_CAND_PIPLN_CT
SynonymHRI_MB_REC_VACANCY_CT

APPS.HRI_OBI_MD_REC_VACANCY_V is not referenced by any database object