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

***** 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
WEVT_EVTYPCMB_FK NUMBER

Event types
ASG_ASSGNMNT_FK NUMBER

Assignment id
PER_PERSON_FK NUMBER

Person id
PER_PERSON_MGR_FK NUMBER

Person's manager
PER_PERSON_MGR_PRV_FK NUMBER

Person's supervisor privileges
MGR_MNGRSC_FK NUMBER

Manager id
MGR_MNGRSC_PRV_FK NUMBER

Manager privileges
ORG_ORGANZTN_FK NUMBER

Organization Id
ORG_ORGANZTN_PRV_FK NUMBER

Organization Prv
JOB_JOB_FK NUMBER

Job Id
JOB_JOB_PRV_FK NUMBER

Job Id PRv
GRD_GRADE_FK NUMBER

Grade Id
GRD_GRADE_PRV_FK NUMBER

Grade prv
POS_POSITION_FK NUMBER

Position Id
POS_POSITION_PRV_FK NUMBER

Position PRV
GEO_LOCATION_FK NUMBER

Location id
GEO_LOCATION_PRV_FK NUMBER

Location PRV
ASGRSN_ASGRSN_FK VARCHAR2 (30)
Assignment Id
SPRN_SPRTNRSN_FK VARCHAR2 (30)
SPRTNRSN
SCAT_SPCATGRY_FK VARCHAR2 (30)
SP Category
PTYP_PERTYP_FK NUMBER

Person Type Id
PRFM_PERFBAND_FK NUMBER

Performance Band
POW_POWBAND_FK NUMBER

POW Band
TIME_DAY_EVT_FK DATE

Time Day Event start
TIME_DAY_EVT_END_FK DATE

Time Day Event end
CUR_CURRENCY_FK VARCHAR2 (40)
Currency id
HEADCOUNT NUMBER

Headcount number
HEADCOUNT_PRV NUMBER

Headcount prv
HEADCOUNT_HIRE NUMBER

Headcount hired
HEADCOUNT_TERM NUMBER

Headcount terminated
FTE NUMBER

Full time employement
FTE_PRV NUMBER

Full time employement prv
FTE_HIRE NUMBER

Full time employment hired
FTE_TERM NUMBER

Full time employment terminated
POW_DAYS_ON_EVENT_DATE NUMBER

number of days on event
POW_MONTHS_ON_EVENT_DATE NUMBER

number of month on event
ANL_SLRY NUMBER

Annual salary
ANL_SLRY_PRV NUMBER

Previous annual salary
ASSIGNMENT_CHANGE_IND NUMBER

Change in assignment
HEADCOUNT_GAIN_IND NUMBER

Headcount gain
HEADCOUNT_LOSS_IND NUMBER

Headcount loss
FTE_GAIN_IND NUMBER

Full Time Employement Gained
FTE_LOSS_IND NUMBER

Full Time Employement Lost
CONTINGENT_IND NUMBER

Contingent worker id
EMPLOYEE_IND NUMBER

Employee number
GRADE_CHANGE_IND NUMBER

Change in grade
JOB_CHANGE_IND NUMBER

Change in job
POSITION_CHANGE_IND NUMBER

Change in position
LOCATION_CHANGE_IND NUMBER

Change in locaiton
ORGANIZATION_CHANGE_IND NUMBER

Change in organization
SUPERVISOR_CHANGE_IND NUMBER

Change in supervisor
WORKER_HIRE_IND NUMBER

worker hired
TERM_VOLUNTARY_IND NUMBER

Voluntary termination
TERM_INVOLUNTARY_IND NUMBER

Involuntary termination
WORKER_TERM_IND NUMBER

Terminated worker
START_ASG_SSPNSN_IND NUMBER

Start Assignment
END_ASG_SSPNSN_IND NUMBER

End Assignment
POST_HIRE_ASGN_START_IND NUMBER

Post Hire Assignment Start Date
PRE_SPRTN_ASGN_END_IND NUMBER

Pre Assignment End
PRSNTYP_CHANGE_IND NUMBER

Person Type Change
MGRH_NODE_CHANGE_IND NUMBER

Manager Hierarchy node change
ADT_EVENT_ID NUMBER

Event ID
ADT_ASSIGNMENT_ID NUMBER

Assignment Id
ADT_ASG_EFFCTV_START_DATE DATE

Assignment Effective Start date
ADT_ASG_EFFCTV_END_DATE DATE

Assignment Effective End date
ADT_PERF_REVIEW_ID NUMBER

Performance review id
ADT_PERIOD_OF_SERVICE_ID NUMBER

Period of service id
ADT_PERIOD_OF_PLACEMENT_ID NUMBER

Period of placement id
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