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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_DAY_EVT_FK DATE

TIME_DAY_EVT_END_FK DATE

TIME_DAY_STG_EVT_EFF_END_FK DATE

TIME_DAY_VAC_STRT_FK DATE

TIME_DAY_VAC_END_FK DATE

PER_PERSON_CAND_FK NUMBER

PER_PERSON_MNGR_FK NUMBER

PER_PERSON_RCRT_FK NUMBER

PER_PERSON_RMGR_FK NUMBER

PER_PERSON_RSED_FK NUMBER

PER_PERSON_MRGD_FK NUMBER

PER_PERSON_AUTH_FK NUMBER

PER_PERSON_REFR_FK NUMBER

ORG_ORGANZTN_FK NUMBER

ORG_ORGANZTN_MRGD_FK NUMBER

ORG_ORGANZTN_RECR_FK NUMBER

GEO_LOCATION_FK NUMBER

JOB_JOB_FK NUMBER

GRD_GRADE_FK NUMBER

POS_POSITION_FK NUMBER

PRFM_PERFBAND_FK NUMBER

RVAC_VACNCY_FK NUMBER

RACT_RECACTVY_FK NUMBER

REV_RECEVENT_FK VARCHAR2 (30)
TARN_TRMAPLRN_FK VARCHAR2 (30)
RERN_RECEVTRN_FK VARCHAR2 (30)
VAC_OPEN_CNT NUMBER

INIT_APPL_STG_CNT NUMBER

ASMT_STG_CNT NUMBER

OFFR_EXTD_STG_CNT NUMBER

STRT_PNDG_STG_CNT NUMBER

HIRE_PRE_POW1_CNT NUMBER

APPL_IN_PROGRESS_CNT NUMBER

APPL_STRT_EVNT_CNT NUMBER

APPL_TERM_INIT_EVNT_CNT NUMBER

APPL_TERM_VOL_INIT_EVNT_CNT NUMBER

APPL_TERM_INVOL_INIT_EVNT_CNT NUMBER

ASMT_STRT_EVNT_CNT NUMBER

APPL_TERM_ASMT_EVNT_CNT NUMBER

APPL_TERM_VOL_ASMT_EVNT_CNT NUMBER

APPL_TERM_INVOL_ASMT_EVNT_CNT NUMBER

OFFR_EXTD_EVNT_CNT NUMBER

APPL_TERM_OFFR_EVNT_CNT NUMBER

APPL_TERM_VOL_OFFR_EVNT_CNT NUMBER

APPL_TERM_INVOL_OFFR_EVNT_CNT NUMBER

OFFR_ACPT_EVNT_CNT NUMBER

APPL_TERM_ACPT_EVNT_CNT NUMBER

APPL_TERM_VOL_ACPT_EVNT_CNT NUMBER

APPL_TERM_INVOL_ACPT_EVNT_CNT NUMBER

APPL_TERM_EVNT_CNT NUMBER

APPL_TERM_VOL_EVNT_CNT NUMBER

APPL_TERM_INVOL_EVNT_CNT NUMBER

HIRE_EVNT_CNT NUMBER

HIRE_APPL_EVNT_CNT NUMBER

HIRE_EMPL_EVNT_CNT NUMBER

POST_HIRE_POW1_END_EVNT_CNT NUMBER

PRE_POW1_END_SPRTN_EVNT_CNT NUMBER

VAC_TO_APPL_STRT_EVNT_DAYS NUMBER

VAC_TO_ASMT_STRT_EVNT_DAYS NUMBER

VAC_TO_OFFR_EXTD_EVNT_DAYS NUMBER

VAC_TO_TERM_OFFR_EVNT_DAYS NUMBER

VAC_TO_OFFR_ACPT_EVNT_DAYS NUMBER

VAC_TO_APPL_HIRE_EVNT_DAYS NUMBER

VAC_TO_APPL_TERM_EVNT_DAYS NUMBER

VAC_TO_FILL_EVNT_DAYS NUMBER

VAC_TO_EVENT_DAYS NUMBER

APPL_TO_TERM_INIT_EVNT_DAYS NUMBER

APPL_TO_ASMT_STRT_EVNT_DAYS NUMBER

APPL_TO_TERM_ASMT_EVNT_DAYS NUMBER

APPL_TO_OFFR_EXTD_EVNT_DAYS NUMBER

APPL_TO_TERM_OFFR_EVNT_DAYS NUMBER

APPL_TO_OFFR_ACPT_EVNT_DAYS NUMBER

APPL_TO_TERM_ACPT_EVNT_DAYS NUMBER

APPL_TO_APPL_HIRE_EVNT_DAYS NUMBER

APPL_TO_APPL_TERM_EVNT_DAYS NUMBER

APPL_TO_FILL_EVNT_DAYS NUMBER

FILL_TO_APPL_HIRE_EVNT_DAYS NUMBER

APPL_TO_EVENT_DAYS NUMBER

STAGE_STRT_TO_EVENT_DAYS NUMBER

ASMT_TO_TERM_EVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_EVNT_DAYS NUMBER

OFFR_TO_TERM_INVOL_EVNT_DAYS NUMBER

OFFR_TO_ACPT_EVNT_DAYS NUMBER

ACPT_TO_HIRE_EVNT_DAYS NUMBER

ACPT_TO_TERM_VOL_EVNT_DAYS NUMBER

ACPT_TO_TERM_INVOL_EVNT_DAYS NUMBER

HEADCOUNT NUMBER

FTE NUMBER

APPL_IND NUMBER

APPL_NEW_IND NUMBER

APPL_EMP_IND NUMBER

APPL_CWK_IND NUMBER

POST_HIRE_NRMLSD_PERF_RTNG NUMBER

EVENT_SEQ NUMBER

VAC_OPEN_DAYS NUMBER

APPL_STRT_NEVNT_CNT NUMBER

APPL_TERM_INIT_NEVNT_CNT NUMBER

APPL_TERM_VOL_INIT_NEVNT_CNT NUMBER

APPL_TERM_INVOL_INIT_NEVNT_CNT NUMBER

ASMT_STRT_NEVNT_CNT NUMBER

APPL_TERM_ASMT_NEVNT_CNT NUMBER

APPL_TERM_VOL_ASMT_NEVNT_CNT NUMBER

APPL_TERM_INVOL_ASMT_NEVNT_CNT NUMBER

OFFR_EXTD_NEVNT_CNT NUMBER

APPL_TERM_OFFR_NEVNT_CNT NUMBER

APPL_TERM_VOL_OFFR_NEVNT_CNT NUMBER

APPL_TERM_INVOL_OFFR_NEVNT_CNT NUMBER

OFFR_ACPT_NEVNT_CNT NUMBER

APPL_TERM_ACPT_NEVNT_CNT NUMBER

APPL_TERM_VOL_ACPT_NEVNT_CNT NUMBER

APPL_TERM_INVOL_ACPT_NEVNT_CNT NUMBER

APPL_TERM_NEVNT_CNT NUMBER

APPL_TERM_VOL_NEVNT_CNT NUMBER

APPL_TERM_INVOL_NEVNT_CNT NUMBER

HIRE_NEVNT_CNT NUMBER

HIRE_APPL_NEVNT_CNT NUMBER

HIRE_EMPL_NEVNT_CNT NUMBER

POST_HIRE_POW1_END_NEVNT_CNT NUMBER

PRE_POW1_END_SPRTN_NEVNT_CNT NUMBER

VAC_TO_APPL_STRT_NEVNT_DAYS NUMBER

VAC_TO_ASMT_STRT_NEVNT_DAYS NUMBER

VAC_TO_OFFR_EXTD_NEVNT_DAYS NUMBER

VAC_TO_TERM_OFFR_NEVNT_DAYS NUMBER

VAC_TO_OFFR_ACPT_NEVNT_DAYS NUMBER

VAC_TO_APPL_HIRE_NEVNT_DAYS NUMBER

VAC_TO_APPL_TERM_NEVNT_DAYS NUMBER

APPL_TO_TERM_INIT_NEVNT_DAYS NUMBER

APPL_TO_ASMT_STRT_NEVNT_DAYS NUMBER

APPL_TO_TERM_ASMT_NEVNT_DAYS NUMBER

APPL_TO_OFFR_EXTD_NEVNT_DAYS NUMBER

APPL_TO_TERM_OFFR_NEVNT_DAYS NUMBER

APPL_TO_OFFR_ACPT_NEVNT_DAYS NUMBER

APPL_TO_TERM_ACPT_NEVNT_DAYS NUMBER

APPL_TO_APPL_HIRE_NEVNT_DAYS NUMBER

APPL_TO_APPL_TERM_NEVNT_DAYS NUMBER

ASMT_TO_TERM_NEVNT_DAYS NUMBER

OFFR_TO_TERM_VOL_NEVNT_DAYS NUMBER

OFFR_TO_TERM_INVOL_NEVNT_DAYS NUMBER

OFFR_TO_ACPT_NEVNT_DAYS NUMBER

ACPT_TO_HIRE_NEVNT_DAYS NUMBER

ACPT_TO_TERM_VOL_NEVNT_DAYS NUMBER

ACPT_TO_TERM_INVOL_NEVNT_DAYS NUMBER

TOTAL_OPENINGS NUMBER

FILLED_OPENINGS NUMBER

TOTAL_HEADCOUNT NUMBER

FILLED_HEADCOUNT NUMBER

TOTAL_FTE NUMBER

FILLED_FTE NUMBER

TOTAL_MONEY NUMBER

FILLED_MONEY NUMBER

BUDGET_MEASUREMENT_VALUE NUMBER

ADT_ASSIGNMENT_ID NUMBER

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