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

VIEW: APPS.HRI_OBI_MD_REC_CAND_PIPLN_V

Object Details
Object Name: HRI_OBI_MD_REC_CAND_PIPLN_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_EVT_FK DATE

Event Start date
TIME_DAY_EVT_END_FK DATE

Event End date
TIME_DAY_STG_EVT_EFF_END_FK DATE

Effective End Date
TIME_DAY_VAC_STRT_FK DATE

Vacancy Start Date
TIME_DAY_VAC_END_FK DATE

Vacancy End Date
PER_PERSON_CAND_FK NUMBER

Person Candidate
PER_PERSON_MNGR_FK NUMBER

Person's Supervisor
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
PER_PERSON_AUTH_FK NUMBER

Person Authorization
PER_PERSON_REFR_FK NUMBER

Person Referred
ORG_ORGANZTN_FK NUMBER

Organization ID
ORG_ORGANZTN_MRGD_FK NUMBER

Organization ID
ORG_ORGANZTN_RECR_FK NUMBER

Organization Id
GEO_LOCATION_FK NUMBER

Location ID
JOB_JOB_FK NUMBER

Job ID
GRD_GRADE_FK NUMBER

Grade ID
POS_POSITION_FK NUMBER

Position ID
PRFM_PERFBAND_FK NUMBER

Performance Band
RVAC_VACNCY_FK NUMBER

Vacancy ID
RACT_RECACTVY_FK NUMBER

Recruitment Activity
REV_RECEVENT_FK VARCHAR2 (30)
Recruitement Event
TARN_TRMAPLRN_FK VARCHAR2 (30)
TARN_TRMAPLRN
RERN_RECEVTRN_FK VARCHAR2 (30)
RERN_RECEVTRN
VAC_OPEN_CNT NUMBER

Vacancy Open Count
INIT_APPL_STG_CNT NUMBER

Initial Application Stage Count
ASMT_STG_CNT NUMBER

Assessment Stage
OFFR_EXTD_STG_CNT NUMBER

Offer Extended Stage Count
STRT_PNDG_STG_CNT NUMBER

Start Pendings Stage Count
HIRE_PRE_POW1_CNT NUMBER

Hire Pre Pow1 Count
APPL_IN_PROGRESS_CNT NUMBER

Application in Progress Count
APPL_STRT_EVNT_CNT NUMBER

Application Start Event Count
APPL_TERM_INIT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_VOL_INIT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_INVOL_INIT_EVNT_CNT NUMBER

Application Termination Init Count
ASMT_STRT_EVNT_CNT NUMBER

Assessment Event Count
APPL_TERM_ASMT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_VOL_ASMT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_INVOL_ASMT_EVNT_CNT NUMBER

Application Termination Init Count
OFFR_EXTD_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_OFFR_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_VOL_OFFR_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_INVOL_OFFR_EVNT_CNT NUMBER

Application Termination Init Count
OFFR_ACPT_EVNT_CNT NUMBER

Offer Accepted Count
APPL_TERM_ACPT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_VOL_ACPT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_INVOL_ACPT_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_EVNT_CNT NUMBER

Application Termination Init Count
APPL_TERM_VOL_EVNT_CNT NUMBER

Application Termination Count
APPL_TERM_INVOL_EVNT_CNT NUMBER

Application Termination Count
HIRE_EVNT_CNT NUMBER

Hire Event Count
HIRE_APPL_EVNT_CNT NUMBER

Hired Application Count
HIRE_EMPL_EVNT_CNT NUMBER

Hired Into Employee Count
POST_HIRE_POW1_END_EVNT_CNT NUMBER

POST_HIRE_POW1_END Count
PRE_POW1_END_SPRTN_EVNT_CNT NUMBER

PRE_POW1_END_SPRTN Count
VAC_TO_APPL_STRT_EVNT_DAYS NUMBER

Vacancy to application start days
VAC_TO_ASMT_STRT_EVNT_DAYS NUMBER

Vacancy to assessment start days
VAC_TO_OFFR_EXTD_EVNT_DAYS NUMBER

Vacancy to offer Extended Days
VAC_TO_TERM_OFFR_EVNT_DAYS NUMBER

Vacancy to terminated Extended Days
VAC_TO_OFFR_ACPT_EVNT_DAYS NUMBER

Vacancy to offer accepted days
VAC_TO_APPL_HIRE_EVNT_DAYS NUMBER

Vacancy to application hired days
VAC_TO_APPL_TERM_EVNT_DAYS NUMBER

Vacancy to application terminated days
VAC_TO_FILL_EVNT_DAYS NUMBER

Vacancy to fill days
VAC_TO_EVENT_DAYS NUMBER

Vacancy to Event Days
APPL_TO_TERM_INIT_EVNT_DAYS NUMBER

Application to termination event days
APPL_TO_ASMT_STRT_EVNT_DAYS NUMBER

Application to assessment start event days
APPL_TO_TERM_ASMT_EVNT_DAYS NUMBER

Application to termination assessment event days
APPL_TO_OFFR_EXTD_EVNT_DAYS NUMBER

Application to offer extend event days
APPL_TO_TERM_OFFR_EVNT_DAYS NUMBER

Application to termination offer event days
APPL_TO_OFFR_ACPT_EVNT_DAYS NUMBER

Application to offer Accepted Days
APPL_TO_TERM_ACPT_EVNT_DAYS NUMBER

Application to Termination Accepted Days
APPL_TO_APPL_HIRE_EVNT_DAYS NUMBER

APPL_TO_APPL_HIRE_EVNT_DAYS
APPL_TO_APPL_TERM_EVNT_DAYS NUMBER

APPL_TO_APPL_TERM_EVNT_DAYS
APPL_TO_FILL_EVNT_DAYS NUMBER

APPL_TO_FILL_EVNT_DAYS
FILL_TO_APPL_HIRE_EVNT_DAYS NUMBER

FILL_TO_APPL_HIRE_EVNT_DAYS
APPL_TO_EVENT_DAYS NUMBER

APPL_TO_EVENT_DAYS
STAGE_STRT_TO_EVENT_DAYS NUMBER

STAGE_STRT_TO_EVENT_DAYS
ASMT_TO_TERM_EVNT_DAYS NUMBER

ASMT_TO_TERM_EVNT_DAYS
OFFR_TO_TERM_VOL_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS
OFFR_TO_TERM_INVOL_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS
OFFR_TO_ACPT_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS
ACPT_TO_HIRE_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS
ACPT_TO_TERM_VOL_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS
ACPT_TO_TERM_INVOL_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS
HEADCOUNT NUMBER

Headcount
FTE NUMBER

Full Time Employement
APPL_IND NUMBER

Applicatoin ID
APPL_NEW_IND NUMBER

New Application
APPL_EMP_IND NUMBER

Application Employee
APPL_CWK_IND NUMBER

Applied Contingent Worker
POST_HIRE_NRMLSD_PERF_RTNG NUMBER

POST_HIRE_NRMLSD_Performance Rating
EVENT_SEQ NUMBER

EVENT_SEQ
VAC_OPEN_DAYS NUMBER

vacancy Open Days
APPL_STRT_NEVNT_CNT NUMBER

Application Start Count
APPL_TERM_INIT_NEVNT_CNT NUMBER

APPL_TERM_INIT_NEVNT_CNT
APPL_TERM_VOL_INIT_NEVNT_CNT NUMBER

APPL_TERM_INIT_NEVNT_CNT
APPL_TERM_INVOL_INIT_NEVNT_CNT NUMBER

APPL_TERM_INVOL_INIT_NEVNT_CNT
ASMT_STRT_NEVNT_CNT NUMBER

ASMT_STRT_NEVNT_CNT
APPL_TERM_ASMT_NEVNT_CNT NUMBER

APPL_TERM_ASMT_NEVNT_CNT
APPL_TERM_VOL_ASMT_NEVNT_CNT NUMBER

APPL_TERM_VOL_ASMT_NEVNT_CNT
APPL_TERM_INVOL_ASMT_NEVNT_CNT NUMBER

APPL_TERM_INVOL_ASMT_NEVNT_CNT
OFFR_EXTD_NEVNT_CNT NUMBER

OFFR_EXTD_NEVNT_CNT
APPL_TERM_OFFR_NEVNT_CNT NUMBER

APPL_TERM_OFFR_NEVNT_CNT
APPL_TERM_VOL_OFFR_NEVNT_CNT NUMBER

APPL_TERM_VOL_OFFR_NEVNT_CNT
APPL_TERM_INVOL_OFFR_NEVNT_CNT NUMBER

APPL_TERM_INVOL_OFFR_NEVNT_CNT
OFFR_ACPT_NEVNT_CNT NUMBER

OFFR_ACPT_NEVNT_CNT
APPL_TERM_ACPT_NEVNT_CNT NUMBER

APPL_TERM_ACPT_NEVNT_CNT
APPL_TERM_VOL_ACPT_NEVNT_CNT NUMBER

APPL_TERM_VOL_ACPT_NEVNT_CNT
APPL_TERM_INVOL_ACPT_NEVNT_CNT NUMBER

APPL_TERM_INVOL_ACPT_NEVNT_CNT
APPL_TERM_NEVNT_CNT NUMBER

APPL_TERM_NEVNT_CNT
APPL_TERM_VOL_NEVNT_CNT NUMBER

APPL_TERM_VOL_NEVNT_CNT
APPL_TERM_INVOL_NEVNT_CNT NUMBER

APPL_TERM_INVOL_NEVNT_CNT
HIRE_NEVNT_CNT NUMBER

HIRE_NEVNT_CNT
HIRE_APPL_NEVNT_CNT NUMBER

HIRE_APPL_NEVNT_CNT
HIRE_EMPL_NEVNT_CNT NUMBER

HIRE_EMPL_NEVNT_CNT
POST_HIRE_POW1_END_NEVNT_CNT NUMBER

POST_HIRE_POW1_END_NEVNT_CNT
PRE_POW1_END_SPRTN_NEVNT_CNT NUMBER

PRE_POW1_END_SPRTN_NEVNT_CNT
VAC_TO_APPL_STRT_NEVNT_DAYS NUMBER

VAC_TO_APPL_STRT_NEVNT_DAYS
VAC_TO_ASMT_STRT_NEVNT_DAYS NUMBER

VAC_TO_ASMT_STRT_NEVNT_DAYS
VAC_TO_OFFR_EXTD_NEVNT_DAYS NUMBER

VAC_TO_OFFR_EXTD_NEVNT_DAYS
VAC_TO_TERM_OFFR_NEVNT_DAYS NUMBER

VAC_TO_TERM_OFFR_NEVNT_DAYS
VAC_TO_OFFR_ACPT_NEVNT_DAYS NUMBER

VAC_TO_OFFR_ACPT_NEVNT_DAYS
VAC_TO_APPL_HIRE_NEVNT_DAYS NUMBER

VAC_TO_APPL_HIRE_NEVNT_DAYS
VAC_TO_APPL_TERM_NEVNT_DAYS NUMBER

VAC_TO_APPL_TERM_NEVNT_DAYS
APPL_TO_TERM_INIT_NEVNT_DAYS NUMBER

APPL_TO_TERM_INIT_NEVNT_DAYS
APPL_TO_ASMT_STRT_NEVNT_DAYS NUMBER

APPL_TO_ASMT_STRT_NEVNT_DAYS
APPL_TO_TERM_ASMT_NEVNT_DAYS NUMBER

APPL_TO_TERM_ASMT_NEVNT_DAYS
APPL_TO_OFFR_EXTD_NEVNT_DAYS NUMBER

APPL_TO_OFFR_EXTD_NEVNT_DAYS
APPL_TO_TERM_OFFR_NEVNT_DAYS NUMBER

APPL_TO_TERM_OFFR_NEVNT_DAYS
APPL_TO_OFFR_ACPT_NEVNT_DAYS NUMBER

APPL_TO_OFFR_ACPT_NEVNT_DAYS
APPL_TO_TERM_ACPT_NEVNT_DAYS NUMBER

APPL_TO_TERM_ACPT_NEVNT_DAYS
APPL_TO_APPL_HIRE_NEVNT_DAYS NUMBER

APPL_TO_APPL_HIRE_NEVNT_DAYS
APPL_TO_APPL_TERM_NEVNT_DAYS NUMBER

APPL_TO_APPL_TERM_NEVNT_DAYS
ASMT_TO_TERM_NEVNT_DAYS NUMBER

ASMT_TO_TERM_NEVNT_DAYS
OFFR_TO_TERM_VOL_NEVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_NEVNT_DAYS
OFFR_TO_TERM_INVOL_NEVNT_DAYS NUMBER

OFFR_TO_TERM_INVOL_NEVNT_DAYS
OFFR_TO_ACPT_NEVNT_DAYS NUMBER

OFFR_TO_ACPT_NEVNT_DAYS
ACPT_TO_HIRE_NEVNT_DAYS NUMBER

ACPT_TO_HIRE_NEVNT_DAYS
ACPT_TO_TERM_VOL_NEVNT_DAYS NUMBER

ACPT_TO_TERM_VOL_NEVNT_DAYS
ACPT_TO_TERM_INVOL_NEVNT_DAYS NUMBER

ACPT_TO_TERM_INVOL_NEVNT_DAYS
TOTAL_OPENINGS NUMBER

TOTAL_OPENINGS
FILLED_OPENINGS NUMBER

FILLED_OPENINGS
TOTAL_HEADCOUNT NUMBER

FILLED_OPENINGS
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
BUDGET_MEASUREMENT_VALUE NUMBER

BUDGET_MEASUREMENT_VALUE
ADT_ASSIGNMENT_ID NUMBER

ADT_ASSIGNMENT_ID
Query Text

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


SELECT TIME_DAY_EVT_FK
,      TIME_DAY_EVT_END_FK
,      TIME_DAY_STG_EVT_EFF_END_FK
,      TIME_DAY_VAC_STRT_FK
,      TIME_DAY_VAC_END_FK
,      PER_PERSON_CAND_FK
,      PER_PERSON_MNGR_FK
,      PER_PERSON_RCRT_FK
,      PER_PERSON_RMGR_FK
,      PER_PERSON_RSED_FK
,      PER_PERSON_MRGD_FK
,      PER_PERSON_AUTH_FK
,      PER_PERSON_REFR_FK
,      ORG_ORGANZTN_FK
,      ORG_ORGANZTN_MRGD_FK
,      ORG_ORGANZTN_RECR_FK
,      GEO_LOCATION_FK
,      JOB_JOB_FK
,      GRD_GRADE_FK
,      POS_POSITION_FK
,      PRFM_PERFBAND_FK
,      RVAC_VACNCY_FK
,      RACT_RECACTVY_FK
,      REV_RECEVENT_FK
,      TARN_TRMAPLRN_FK
,      RERN_RECEVTRN_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_EVNT_CNT
,      HIRE_APPL_EVNT_CNT
,      HIRE_EMPL_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_TERM_OFFR_EVNT_DAYS
,      VAC_TO_OFFR_ACPT_EVNT_DAYS
,      VAC_TO_APPL_HIRE_EVNT_DAYS
,      VAC_TO_APPL_TERM_EVNT_DAYS
,      VAC_TO_FILL_EVNT_DAYS
,      VAC_TO_EVENT_DAYS
,      APPL_TO_TERM_INIT_EVNT_DAYS
,      APPL_TO_ASMT_STRT_EVNT_DAYS
,      APPL_TO_TERM_ASMT_EVNT_DAYS
,      APPL_TO_OFFR_EXTD_EVNT_DAYS
,      APPL_TO_TERM_OFFR_EVNT_DAYS
,      APPL_TO_OFFR_ACPT_EVNT_DAYS
,      APPL_TO_TERM_ACPT_EVNT_DAYS
,      APPL_TO_APPL_HIRE_EVNT_DAYS
,      APPL_TO_APPL_TERM_EVNT_DAYS
,      APPL_TO_FILL_EVNT_DAYS
,      FILL_TO_APPL_HIRE_EVNT_DAYS
,      APPL_TO_EVENT_DAYS
,      STAGE_STRT_TO_EVENT_DAYS
,      ASMT_TO_TERM_EVNT_DAYS
,      OFFR_TO_TERM_VOL_EVNT_DAYS
,      OFFR_TO_TERM_INVOL_EVNT_DAYS
,      OFFR_TO_ACPT_EVNT_DAYS
,      ACPT_TO_HIRE_EVNT_DAYS
,      ACPT_TO_TERM_VOL_EVNT_DAYS
,      ACPT_TO_TERM_INVOL_EVNT_DAYS
,      HEADCOUNT
,      FTE
,      APPL_IND
,      APPL_NEW_IND
,      APPL_EMP_IND
,      APPL_CWK_IND
,      POST_HIRE_NRMLSD_PERF_RTNG
,      EVENT_SEQ
,      VAC_OPEN_DAYS
,      APPL_STRT_NEVNT_CNT
,      APPL_TERM_INIT_NEVNT_CNT
,      APPL_TERM_VOL_INIT_NEVNT_CNT
,      APPL_TERM_INVOL_INIT_NEVNT_CNT
,      ASMT_STRT_NEVNT_CNT
,      APPL_TERM_ASMT_NEVNT_CNT
,      APPL_TERM_VOL_ASMT_NEVNT_CNT
,      APPL_TERM_INVOL_ASMT_NEVNT_CNT
,      OFFR_EXTD_NEVNT_CNT
,      APPL_TERM_OFFR_NEVNT_CNT
,      APPL_TERM_VOL_OFFR_NEVNT_CNT
,      APPL_TERM_INVOL_OFFR_NEVNT_CNT
,      OFFR_ACPT_NEVNT_CNT
,      APPL_TERM_ACPT_NEVNT_CNT
,      APPL_TERM_VOL_ACPT_NEVNT_CNT
,      APPL_TERM_INVOL_ACPT_NEVNT_CNT
,      APPL_TERM_NEVNT_CNT
,      APPL_TERM_VOL_NEVNT_CNT
,      APPL_TERM_INVOL_NEVNT_CNT
,      HIRE_NEVNT_CNT
,      HIRE_APPL_NEVNT_CNT
,      HIRE_EMPL_NEVNT_CNT
,      POST_HIRE_POW1_END_NEVNT_CNT
,      PRE_POW1_END_SPRTN_NEVNT_CNT
,      VAC_TO_APPL_STRT_NEVNT_DAYS
,      VAC_TO_ASMT_STRT_NEVNT_DAYS
,      VAC_TO_OFFR_EXTD_NEVNT_DAYS
,      VAC_TO_TERM_OFFR_NEVNT_DAYS
,      VAC_TO_OFFR_ACPT_NEVNT_DAYS
,      VAC_TO_APPL_HIRE_NEVNT_DAYS
,      VAC_TO_APPL_TERM_NEVNT_DAYS
,      APPL_TO_TERM_INIT_NEVNT_DAYS
,      APPL_TO_ASMT_STRT_NEVNT_DAYS
,      APPL_TO_TERM_ASMT_NEVNT_DAYS
,      APPL_TO_OFFR_EXTD_NEVNT_DAYS
,      APPL_TO_TERM_OFFR_NEVNT_DAYS
,      APPL_TO_OFFR_ACPT_NEVNT_DAYS
,      APPL_TO_TERM_ACPT_NEVNT_DAYS
,      APPL_TO_APPL_HIRE_NEVNT_DAYS
,      APPL_TO_APPL_TERM_NEVNT_DAYS
,      ASMT_TO_TERM_NEVNT_DAYS
,      OFFR_TO_TERM_VOL_NEVNT_DAYS
,      OFFR_TO_TERM_INVOL_NEVNT_DAYS
,      OFFR_TO_ACPT_NEVNT_DAYS
,      ACPT_TO_HIRE_NEVNT_DAYS
,      ACPT_TO_TERM_VOL_NEVNT_DAYS
,      ACPT_TO_TERM_INVOL_NEVNT_DAYS
,      TOTAL_OPENINGS
,      FILLED_OPENINGS
,      TOTAL_HEADCOUNT
,      FILLED_HEADCOUNT
,      TOTAL_FTE
,      FILLED_FTE
,      TOTAL_MONEY
,      FILLED_MONEY
,      BUDGET_MEASUREMENT_VALUE
,      ADT_ASSIGNMENT_ID
FROM APPS.HRI_OBI_MD_REC_CAND_PIPLN_V;

Dependencies

[top of page]

APPS.HRI_OBI_MD_REC_CAND_PIPLN_V references the following:

SchemaAPPS
SynonymHRI_MB_REC_CAND_PIPLN_CT
SynonymHRI_MB_REC_VACANCY_CT

APPS.HRI_OBI_MD_REC_CAND_PIPLN_V is not referenced by any database object