[Home] [Help]
[Dependency Information]
Object Name: | HRI_MB_REC_CAND_PIPLN_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MB_REC_CAND_PIPLN_CT_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() |
HRI_MB_REC_CAND_PIPLN_CT_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
HRI_MB_REC_CAND_PIPLN_CT_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_DAY_EVT_FK | DATE | |||
TIME_DAY_EVT_END_FK | DATE | |||
TIME_DAY_STG_EVT_EFF_END_FK | DATE | |||
PER_PERSON_CAND_FK | NUMBER | |||
PER_PERSON_MNGR_FK | NUMBER | |||
PER_PERSON_RCRT_FK | NUMBER | |||
PER_PERSON_RMGR_FK | NUMBER | |||
ORG_ORGANZTN_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) | ||
HEADCOUNT | NUMBER | |||
FTE | NUMBER | |||
POST_HIRE_NRMLSD_PERF_RTNG | NUMBER | |||
EVENT_SEQ | NUMBER | |||
APPL_IND | NUMBER | |||
APPL_NEW_IND | NUMBER | |||
APPL_EMP_IND | NUMBER | |||
APPL_CWK_IND | NUMBER | |||
APPL_STRT_EVNT_IND | NUMBER | |||
APPL_STRT_NEVNT_IND | NUMBER | |||
ASMT_STRT_EVNT_IND | NUMBER | |||
ASMT_STRT_NEVNT_IND | NUMBER | |||
ASMT_END_EVNT_IND | NUMBER | |||
ASMT_END_NEVNT_IND | NUMBER | |||
OFFR_EXTD_EVNT_IND | NUMBER | |||
OFFR_EXTD_NEVNT_IND | NUMBER | |||
OFFR_RJCT_EVNT_IND | NUMBER | |||
OFFR_RJCT_NEVNT_IND | NUMBER | |||
OFFR_ACPT_EVNT_IND | NUMBER | |||
OFFR_ACPT_NEVNT_IND | NUMBER | |||
APPL_TERM_EVNT_IND | NUMBER | |||
APPL_TERM_NEVNT_IND | NUMBER | |||
APPL_TERM_VOL_EVNT_IND | NUMBER | |||
APPL_TERM_VOL_NEVNT_IND | NUMBER | |||
APPL_TERM_INVOL_EVNT_IND | NUMBER | |||
APPL_TERM_INVOL_NEVNT_IND | NUMBER | |||
APPL_HIRE_EVNT_IND | NUMBER | |||
APPL_HIRE_NEVNT_IND | NUMBER | |||
HIRE_EVNT_IND | NUMBER | |||
HIRE_NEVNT_IND | NUMBER | |||
POST_HIRE_POW1_END_EVNT_IND | NUMBER | |||
POST_HIRE_POW1_END_NEVNT_IND | NUMBER | |||
POST_HIRE_PERF_EVNT_IND | NUMBER | |||
POST_HIRE_PERF_NEVNT_IND | NUMBER | |||
EMP_SPRTN_EVNT_IND | NUMBER | |||
EMP_SPRTN_NEVNT_IND | NUMBER | |||
HIRE_ORG_CHNG_IND | NUMBER | |||
HIRE_JOB_CHNG_IND | NUMBER | |||
HIRE_POS_CHNG_IND | NUMBER | |||
HIRE_GRD_CHNG_IND | NUMBER | |||
HIRE_LOC_CHNG_IND | NUMBER | |||
CURRENT_RECORD_IND | NUMBER | |||
CURRENT_STAGE_STRT_IND | NUMBER | |||
GEN_RECORD_IND | NUMBER | |||
APPL_STRT_TO_ASMT_STRT_DAYS | NUMBER | |||
APPL_STRT_TO_ASMT_END_DAYS | NUMBER | |||
APPL_STRT_TO_OFFR_EXTD_DAYS | NUMBER | |||
APPL_STRT_TO_OFFR_RJCT_DAYS | NUMBER | |||
APPL_STRT_TO_OFFR_ACPT_DAYS | NUMBER | |||
APPL_STRT_TO_HIRE_DAYS | NUMBER | |||
APPL_STRT_TO_TERM_DAYS | NUMBER | |||
APPL_STRT_DATE | DATE | |||
ASMT_STRT_DATE | DATE | |||
ASMT_END_DATE | DATE | |||
OFFR_EXTD_DATE | DATE | |||
OFFR_RJCT_DATE | DATE | |||
OFFR_ACPT_DATE | DATE | |||
APPL_TERM_DATE | DATE | |||
HIRE_DATE | DATE | |||
EMP_SPRTN_DATE | DATE | |||
EVENT_DATE | DATE | |||
ADT_ASSIGNMENT_ID | NUMBER | |||
ADT_ASG_EFFCTV_START_DATE | DATE | |||
ADT_ASG_EFFCTV_END_DATE | DATE | |||
ADT_APPLICATION_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
PER_PERSON_AUTH_FK | NUMBER | |||
PER_PERSON_MRGD_FK | NUMBER | |||
PER_PERSON_REFR_FK | NUMBER | |||
PER_PERSON_RSED_FK | NUMBER | |||
ORG_ORGANZTN_MRGD_FK | NUMBER | |||
ORG_ORGANZTN_RECR_FK | NUMBER | |||
STAGE_START_DATE | DATE | |||
INIT_APPL_STG_IND | NUMBER | |||
ASMT_STG_IND | NUMBER | |||
OFFR_EXTD_STG_IND | NUMBER | |||
STRT_PNDG_STG_IND | NUMBER | |||
HIRE_STG_IND | NUMBER |
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
, PER_PERSON_CAND_FK
, PER_PERSON_MNGR_FK
, PER_PERSON_RCRT_FK
, PER_PERSON_RMGR_FK
, ORG_ORGANZTN_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
, HEADCOUNT
, FTE
, POST_HIRE_NRMLSD_PERF_RTNG
, EVENT_SEQ
, APPL_IND
, APPL_NEW_IND
, APPL_EMP_IND
, APPL_CWK_IND
, APPL_STRT_EVNT_IND
, APPL_STRT_NEVNT_IND
, ASMT_STRT_EVNT_IND
, ASMT_STRT_NEVNT_IND
, ASMT_END_EVNT_IND
, ASMT_END_NEVNT_IND
, OFFR_EXTD_EVNT_IND
, OFFR_EXTD_NEVNT_IND
, OFFR_RJCT_EVNT_IND
, OFFR_RJCT_NEVNT_IND
, OFFR_ACPT_EVNT_IND
, OFFR_ACPT_NEVNT_IND
, APPL_TERM_EVNT_IND
, APPL_TERM_NEVNT_IND
, APPL_TERM_VOL_EVNT_IND
, APPL_TERM_VOL_NEVNT_IND
, APPL_TERM_INVOL_EVNT_IND
, APPL_TERM_INVOL_NEVNT_IND
, APPL_HIRE_EVNT_IND
, APPL_HIRE_NEVNT_IND
, HIRE_EVNT_IND
, HIRE_NEVNT_IND
, POST_HIRE_POW1_END_EVNT_IND
, POST_HIRE_POW1_END_NEVNT_IND
, POST_HIRE_PERF_EVNT_IND
, POST_HIRE_PERF_NEVNT_IND
, EMP_SPRTN_EVNT_IND
, EMP_SPRTN_NEVNT_IND
, HIRE_ORG_CHNG_IND
, HIRE_JOB_CHNG_IND
, HIRE_POS_CHNG_IND
, HIRE_GRD_CHNG_IND
, HIRE_LOC_CHNG_IND
, CURRENT_RECORD_IND
, CURRENT_STAGE_STRT_IND
, GEN_RECORD_IND
, APPL_STRT_TO_ASMT_STRT_DAYS
, APPL_STRT_TO_ASMT_END_DAYS
, APPL_STRT_TO_OFFR_EXTD_DAYS
, APPL_STRT_TO_OFFR_RJCT_DAYS
, APPL_STRT_TO_OFFR_ACPT_DAYS
, APPL_STRT_TO_HIRE_DAYS
, APPL_STRT_TO_TERM_DAYS
, APPL_STRT_DATE
, ASMT_STRT_DATE
, ASMT_END_DATE
, OFFR_EXTD_DATE
, OFFR_RJCT_DATE
, OFFR_ACPT_DATE
, APPL_TERM_DATE
, HIRE_DATE
, EMP_SPRTN_DATE
, EVENT_DATE
, ADT_ASSIGNMENT_ID
, ADT_ASG_EFFCTV_START_DATE
, ADT_ASG_EFFCTV_END_DATE
, ADT_APPLICATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PER_PERSON_AUTH_FK
, PER_PERSON_MRGD_FK
, PER_PERSON_REFR_FK
, PER_PERSON_RSED_FK
, ORG_ORGANZTN_MRGD_FK
, ORG_ORGANZTN_RECR_FK
, STAGE_START_DATE
, INIT_APPL_STG_IND
, ASMT_STG_IND
, OFFR_EXTD_STG_IND
, STRT_PNDG_STG_IND
, HIRE_STG_IND
FROM HRI.HRI_MB_REC_CAND_PIPLN_CT;
HRI.HRI_MB_REC_CAND_PIPLN_CT does not reference any database object
HRI.HRI_MB_REC_CAND_PIPLN_CT is referenced by following:
|
|
|