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

VIEW: APPS.HRI_OBI_MB_WRKFC_EVT_V

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

[View Source]

Columns
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

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

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

Query Text

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
,      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
,      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
FROM APPS.HRI_OBI_MB_WRKFC_EVT_V;

Dependencies

[top of page]

APPS.HRI_OBI_MB_WRKFC_EVT_V references the following:

SchemaAPPS
SynonymHRI_MB_WRKFC_EVT_CT

APPS.HRI_OBI_MB_WRKFC_EVT_V is not referenced by any database object