[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_WRKFC_EVT_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MB_WRKFC_EVT_CT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ASG_ASSGNMNT_FK
TIME_DAY_EVT_END_FK TIME_DAY_EVT_FK |
HRI_MB_WRKFC_EVT_CT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
MGR_MNGRSC_FK
WORKER_TERM_IND TIME_DAY_EVT_FK TIME_DAY_EVT_END_FK |
HRI_MB_WRKFC_EVT_CT_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORG_ORGANZTN_FK
WORKER_TERM_IND TIME_DAY_EVT_FK TIME_DAY_EVT_END_FK |
HRI_MB_WRKFC_EVT_CT_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PER_PERSON_FK
TIME_DAY_EVT_FK TIME_DAY_EVT_END_FK |
HRI_MB_WRKFC_EVT_CT_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
MGR_MNGRSC_FK
WORKER_HIRE_IND TIME_DAY_EVT_FK TIME_DAY_EVT_END_FK |
HRI_MB_WRKFC_EVT_CT_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORG_ORGANZTN_FK
WORKER_HIRE_IND TIME_DAY_EVT_FK TIME_DAY_EVT_END_FK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WEVT_EVTYPCMB_FK | NUMBER | |||
ASG_ASSGNMNT_FK | NUMBER | |||
PER_PERSON_FK | NUMBER | |||
PER_PERSON_MGR_FK | NUMBER | |||
PER_PERSON_MGR_PRV_FK | NUMBER | |||
MGR_MNGRSC_FK | NUMBER | |||
MGR_MNGRSC_PRV_FK | NUMBER | |||
ORG_ORGANZTN_FK | NUMBER | |||
ORG_ORGANZTN_PRV_FK | NUMBER | |||
JOB_JOB_FK | NUMBER | |||
JOB_JOB_PRV_FK | NUMBER | |||
GRD_GRADE_FK | NUMBER | |||
GRD_GRADE_PRV_FK | NUMBER | |||
POS_POSITION_FK | NUMBER | |||
POS_POSITION_PRV_FK | NUMBER | |||
GEO_LOCATION_FK | NUMBER | |||
GEO_LOCATION_PRV_FK | NUMBER | |||
ASGRSN_ASGRSN_FK | VARCHAR2 | (30) | ||
SPRN_SPRTNRSN_FK | VARCHAR2 | (30) | ||
SCAT_SPCATGRY_FK | VARCHAR2 | (30) | ||
PTYP_PERTYP_FK | NUMBER | |||
PRFM_PERFBAND_FK | NUMBER | |||
POW_POWBAND_FK | NUMBER | |||
TIME_DAY_EVT_FK | DATE | |||
TIME_DAY_EVT_END_FK | DATE | |||
CUR_CURRENCY_FK | VARCHAR2 | (40) | ||
HEADCOUNT | NUMBER | |||
HEADCOUNT_PRV | NUMBER | |||
HEADCOUNT_HIRE | NUMBER | |||
HEADCOUNT_TERM | NUMBER | |||
FTE | NUMBER | |||
FTE_PRV | NUMBER | |||
FTE_HIRE | NUMBER | |||
FTE_TERM | NUMBER | |||
POW_DAYS_ON_EVENT_DATE | NUMBER | |||
POW_MONTHS_ON_EVENT_DATE | NUMBER | |||
ANL_SLRY | NUMBER | |||
ANL_SLRY_PRV | NUMBER | |||
ASSIGNMENT_CHANGE_IND | NUMBER | |||
HEADCOUNT_GAIN_IND | NUMBER | |||
HEADCOUNT_LOSS_IND | NUMBER | |||
FTE_GAIN_IND | NUMBER | |||
FTE_LOSS_IND | NUMBER | |||
CONTINGENT_IND | NUMBER | |||
EMPLOYEE_IND | NUMBER | |||
GRADE_CHANGE_IND | NUMBER | |||
JOB_CHANGE_IND | NUMBER | |||
POSITION_CHANGE_IND | NUMBER | |||
LOCATION_CHANGE_IND | NUMBER | |||
ORGANIZATION_CHANGE_IND | NUMBER | |||
SUPERVISOR_CHANGE_IND | NUMBER | |||
HEADCOUNT_CHANGE_IND | NUMBER | |||
FTE_CHANGE_IND | NUMBER | |||
WORKER_HIRE_IND | NUMBER | |||
TERM_VOLUNTARY_IND | NUMBER | |||
TERM_INVOLUNTARY_IND | NUMBER | |||
WORKER_TERM_IND | NUMBER | |||
START_ASG_SSPNSN_IND | NUMBER | |||
END_ASG_SSPNSN_IND | NUMBER | |||
POST_HIRE_ASGN_START_IND | NUMBER | |||
PRE_SPRTN_ASGN_END_IND | NUMBER | |||
PRSNTYP_CHANGE_IND | NUMBER | |||
MGRH_NODE_CHANGE_IND | NUMBER | |||
HIRE_OR_START_IND | NUMBER | |||
TERM_OR_END_IND | NUMBER | |||
ADT_EVENT_ID | NUMBER | |||
ADT_ASSIGNMENT_ID | NUMBER | |||
ADT_ASG_EFFCTV_START_DATE | DATE | |||
ADT_ASG_EFFCTV_END_DATE | DATE | |||
ADT_PERF_REVIEW_ID | NUMBER | |||
ADT_PERIOD_OF_SERVICE_ID | NUMBER | |||
ADT_PERIOD_OF_PLACEMENT_ID | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
ADT_BUSINESS_GROUP_ID | NUMBER | |||
ADT_POW_BAND | NUMBER | |||
PROMOTION_IND | NUMBER | |||
PRIMARY_IND | NUMBER | |||
DAYS_SINCE_LAST_PRMTN | NUMBER | |||
MONTHS_SINCE_LAST_PRMTN | NUMBER | |||
WORKER_TERM_NXT_IND | NUMBER | |||
PRE_SPRTN_ASGN_END_NXT_IND | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT WEVT_EVTYPCMB_FK
, ASG_ASSGNMNT_FK
, PER_PERSON_FK
, PER_PERSON_MGR_FK
, PER_PERSON_MGR_PRV_FK
, MGR_MNGRSC_FK
, MGR_MNGRSC_PRV_FK
, ORG_ORGANZTN_FK
, ORG_ORGANZTN_PRV_FK
, JOB_JOB_FK
, JOB_JOB_PRV_FK
, GRD_GRADE_FK
, GRD_GRADE_PRV_FK
, POS_POSITION_FK
, POS_POSITION_PRV_FK
, GEO_LOCATION_FK
, GEO_LOCATION_PRV_FK
, ASGRSN_ASGRSN_FK
, SPRN_SPRTNRSN_FK
, SCAT_SPCATGRY_FK
, PTYP_PERTYP_FK
, PRFM_PERFBAND_FK
, POW_POWBAND_FK
, TIME_DAY_EVT_FK
, TIME_DAY_EVT_END_FK
, CUR_CURRENCY_FK
, HEADCOUNT
, HEADCOUNT_PRV
, HEADCOUNT_HIRE
, HEADCOUNT_TERM
, FTE
, FTE_PRV
, FTE_HIRE
, FTE_TERM
, POW_DAYS_ON_EVENT_DATE
, POW_MONTHS_ON_EVENT_DATE
, ANL_SLRY
, ANL_SLRY_PRV
, ASSIGNMENT_CHANGE_IND
, HEADCOUNT_GAIN_IND
, HEADCOUNT_LOSS_IND
, FTE_GAIN_IND
, FTE_LOSS_IND
, CONTINGENT_IND
, EMPLOYEE_IND
, GRADE_CHANGE_IND
, JOB_CHANGE_IND
, POSITION_CHANGE_IND
, LOCATION_CHANGE_IND
, ORGANIZATION_CHANGE_IND
, SUPERVISOR_CHANGE_IND
, HEADCOUNT_CHANGE_IND
, FTE_CHANGE_IND
, WORKER_HIRE_IND
, TERM_VOLUNTARY_IND
, TERM_INVOLUNTARY_IND
, WORKER_TERM_IND
, START_ASG_SSPNSN_IND
, END_ASG_SSPNSN_IND
, POST_HIRE_ASGN_START_IND
, PRE_SPRTN_ASGN_END_IND
, PRSNTYP_CHANGE_IND
, MGRH_NODE_CHANGE_IND
, HIRE_OR_START_IND
, TERM_OR_END_IND
, ADT_EVENT_ID
, ADT_ASSIGNMENT_ID
, ADT_ASG_EFFCTV_START_DATE
, ADT_ASG_EFFCTV_END_DATE
, ADT_PERF_REVIEW_ID
, ADT_PERIOD_OF_SERVICE_ID
, ADT_PERIOD_OF_PLACEMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, ADT_BUSINESS_GROUP_ID
, ADT_POW_BAND
, PROMOTION_IND
, PRIMARY_IND
, DAYS_SINCE_LAST_PRMTN
, MONTHS_SINCE_LAST_PRMTN
, WORKER_TERM_NXT_IND
, PRE_SPRTN_ASGN_END_NXT_IND
FROM HRI.HRI_MB_WRKFC_EVT_CT;
HRI.HRI_MB_WRKFC_EVT_CT does not reference any database object
HRI.HRI_MB_WRKFC_EVT_CT is referenced by following:
|
|
|