VIEW: HRI.HRI_MB_WRKFC_EVT_CT#

Source

View Text - Preformatted

select WEVT_EVTYPCMB_FK WEVT_EVTYPCMB_FK, ASG_ASSGNMNT_FK ASG_ASSGNMNT_FK, PER_PERSON_FK PER_PERSON_FK, PER_PERSON_MGR_FK PER_PERSON_MGR_FK, PER_PERSON_MGR_PRV_FK PER_PERSON_MGR_PRV_FK, MGR_MNGRSC_FK MGR_MNGRSC_FK, MGR_MNGRSC_PRV_FK MGR_MNGRSC_PRV_FK, ORG_ORGANZTN_FK ORG_ORGANZTN_FK, ORG_ORGANZTN_PRV_FK ORG_ORGANZTN_PRV_FK, JOB_JOB_FK JOB_JOB_FK, JOB_JOB_PRV_FK JOB_JOB_PRV_FK, GRD_GRADE_FK GRD_GRADE_FK, GRD_GRADE_PRV_FK GRD_GRADE_PRV_FK, POS_POSITION_FK POS_POSITION_FK, POS_POSITION_PRV_FK POS_POSITION_PRV_FK, GEO_LOCATION_FK GEO_LOCATION_FK, GEO_LOCATION_PRV_FK GEO_LOCATION_PRV_FK, ASGRSN_ASGRSN_FK ASGRSN_ASGRSN_FK, SPRN_SPRTNRSN_FK SPRN_SPRTNRSN_FK, SCAT_SPCATGRY_FK SCAT_SPCATGRY_FK, PTYP_PERTYP_FK PTYP_PERTYP_FK, PRFM_PERFBAND_FK PRFM_PERFBAND_FK, POW_POWBAND_FK POW_POWBAND_FK, TIME_DAY_EVT_FK TIME_DAY_EVT_FK, TIME_DAY_EVT_END_FK TIME_DAY_EVT_END_FK, CUR_CURRENCY_FK CUR_CURRENCY_FK, HEADCOUNT HEADCOUNT, HEADCOUNT_PRV HEADCOUNT_PRV, HEADCOUNT_HIRE HEADCOUNT_HIRE, HEADCOUNT_TERM HEADCOUNT_TERM, FTE FTE, FTE_PRV FTE_PRV, FTE_HIRE FTE_HIRE, FTE_TERM FTE_TERM, POW_DAYS_ON_EVENT_DATE POW_DAYS_ON_EVENT_DATE, POW_MONTHS_ON_EVENT_DATE POW_MONTHS_ON_EVENT_DATE, ANL_SLRY ANL_SLRY, ANL_SLRY_PRV ANL_SLRY_PRV, ASSIGNMENT_CHANGE_IND ASSIGNMENT_CHANGE_IND, HEADCOUNT_GAIN_IND HEADCOUNT_GAIN_IND, HEADCOUNT_LOSS_IND HEADCOUNT_LOSS_IND, FTE_GAIN_IND FTE_GAIN_IND, FTE_LOSS_IND FTE_LOSS_IND, CONTINGENT_IND CONTINGENT_IND, EMPLOYEE_IND EMPLOYEE_IND, GRADE_CHANGE_IND GRADE_CHANGE_IND, JOB_CHANGE_IND JOB_CHANGE_IND, POSITION_CHANGE_IND POSITION_CHANGE_IND, LOCATION_CHANGE_IND LOCATION_CHANGE_IND, ORGANIZATION_CHANGE_IND ORGANIZATION_CHANGE_IND, SUPERVISOR_CHANGE_IND SUPERVISOR_CHANGE_IND, HEADCOUNT_CHANGE_IND HEADCOUNT_CHANGE_IND, FTE_CHANGE_IND FTE_CHANGE_IND, WORKER_HIRE_IND WORKER_HIRE_IND, TERM_VOLUNTARY_IND TERM_VOLUNTARY_IND, TERM_INVOLUNTARY_IND TERM_INVOLUNTARY_IND, WORKER_TERM_IND WORKER_TERM_IND, START_ASG_SSPNSN_IND START_ASG_SSPNSN_IND, END_ASG_SSPNSN_IND END_ASG_SSPNSN_IND, POST_HIRE_ASGN_START_IND POST_HIRE_ASGN_START_IND, PRE_SPRTN_ASGN_END_IND PRE_SPRTN_ASGN_END_IND, PRSNTYP_CHANGE_IND PRSNTYP_CHANGE_IND, MGRH_NODE_CHANGE_IND MGRH_NODE_CHANGE_IND, HIRE_OR_START_IND HIRE_OR_START_IND, TERM_OR_END_IND TERM_OR_END_IND, ADT_EVENT_ID ADT_EVENT_ID, ADT_ASSIGNMENT_ID ADT_ASSIGNMENT_ID, ADT_ASG_EFFCTV_START_DATE ADT_ASG_EFFCTV_START_DATE, ADT_ASG_EFFCTV_END_DATE ADT_ASG_EFFCTV_END_DATE, ADT_PERF_REVIEW_ID ADT_PERF_REVIEW_ID, ADT_PERIOD_OF_SERVICE_ID ADT_PERIOD_OF_SERVICE_ID, ADT_PERIOD_OF_PLACEMENT_ID ADT_PERIOD_OF_PLACEMENT_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, ADT_BUSINESS_GROUP_ID ADT_BUSINESS_GROUP_ID, ADT_POW_BAND ADT_POW_BAND, PROMOTION_IND PROMOTION_IND, PRIMARY_IND PRIMARY_IND, DAYS_SINCE_LAST_PRMTN DAYS_SINCE_LAST_PRMTN, MONTHS_SINCE_LAST_PRMTN MONTHS_SINCE_LAST_PRMTN, WORKER_TERM_NXT_IND WORKER_TERM_NXT_IND, PRE_SPRTN_ASGN_END_NXT_IND PRE_SPRTN_ASGN_END_NXT_IND from "HRI"."HRI_MB_WRKFC_EVT_CT"

View Text - HTML Formatted

SELECT WEVT_EVTYPCMB_FK WEVT_EVTYPCMB_FK
, ASG_ASSGNMNT_FK ASG_ASSGNMNT_FK
, PER_PERSON_FK PER_PERSON_FK
, PER_PERSON_MGR_FK PER_PERSON_MGR_FK
, PER_PERSON_MGR_PRV_FK PER_PERSON_MGR_PRV_FK
, MGR_MNGRSC_FK MGR_MNGRSC_FK
, MGR_MNGRSC_PRV_FK MGR_MNGRSC_PRV_FK
, ORG_ORGANZTN_FK ORG_ORGANZTN_FK
, ORG_ORGANZTN_PRV_FK ORG_ORGANZTN_PRV_FK
, JOB_JOB_FK JOB_JOB_FK
, JOB_JOB_PRV_FK JOB_JOB_PRV_FK
, GRD_GRADE_FK GRD_GRADE_FK
, GRD_GRADE_PRV_FK GRD_GRADE_PRV_FK
, POS_POSITION_FK POS_POSITION_FK
, POS_POSITION_PRV_FK POS_POSITION_PRV_FK
, GEO_LOCATION_FK GEO_LOCATION_FK
, GEO_LOCATION_PRV_FK GEO_LOCATION_PRV_FK
, ASGRSN_ASGRSN_FK ASGRSN_ASGRSN_FK
, SPRN_SPRTNRSN_FK SPRN_SPRTNRSN_FK
, SCAT_SPCATGRY_FK SCAT_SPCATGRY_FK
, PTYP_PERTYP_FK PTYP_PERTYP_FK
, PRFM_PERFBAND_FK PRFM_PERFBAND_FK
, POW_POWBAND_FK POW_POWBAND_FK
, TIME_DAY_EVT_FK TIME_DAY_EVT_FK
, TIME_DAY_EVT_END_FK TIME_DAY_EVT_END_FK
, CUR_CURRENCY_FK CUR_CURRENCY_FK
, HEADCOUNT HEADCOUNT
, HEADCOUNT_PRV HEADCOUNT_PRV
, HEADCOUNT_HIRE HEADCOUNT_HIRE
, HEADCOUNT_TERM HEADCOUNT_TERM
, FTE FTE
, FTE_PRV FTE_PRV
, FTE_HIRE FTE_HIRE
, FTE_TERM FTE_TERM
, POW_DAYS_ON_EVENT_DATE POW_DAYS_ON_EVENT_DATE
, POW_MONTHS_ON_EVENT_DATE POW_MONTHS_ON_EVENT_DATE
, ANL_SLRY ANL_SLRY
, ANL_SLRY_PRV ANL_SLRY_PRV
, ASSIGNMENT_CHANGE_IND ASSIGNMENT_CHANGE_IND
, HEADCOUNT_GAIN_IND HEADCOUNT_GAIN_IND
, HEADCOUNT_LOSS_IND HEADCOUNT_LOSS_IND
, FTE_GAIN_IND FTE_GAIN_IND
, FTE_LOSS_IND FTE_LOSS_IND
, CONTINGENT_IND CONTINGENT_IND
, EMPLOYEE_IND EMPLOYEE_IND
, GRADE_CHANGE_IND GRADE_CHANGE_IND
, JOB_CHANGE_IND JOB_CHANGE_IND
, POSITION_CHANGE_IND POSITION_CHANGE_IND
, LOCATION_CHANGE_IND LOCATION_CHANGE_IND
, ORGANIZATION_CHANGE_IND ORGANIZATION_CHANGE_IND
, SUPERVISOR_CHANGE_IND SUPERVISOR_CHANGE_IND
, HEADCOUNT_CHANGE_IND HEADCOUNT_CHANGE_IND
, FTE_CHANGE_IND FTE_CHANGE_IND
, WORKER_HIRE_IND WORKER_HIRE_IND
, TERM_VOLUNTARY_IND TERM_VOLUNTARY_IND
, TERM_INVOLUNTARY_IND TERM_INVOLUNTARY_IND
, WORKER_TERM_IND WORKER_TERM_IND
, START_ASG_SSPNSN_IND START_ASG_SSPNSN_IND
, END_ASG_SSPNSN_IND END_ASG_SSPNSN_IND
, POST_HIRE_ASGN_START_IND POST_HIRE_ASGN_START_IND
, PRE_SPRTN_ASGN_END_IND PRE_SPRTN_ASGN_END_IND
, PRSNTYP_CHANGE_IND PRSNTYP_CHANGE_IND
, MGRH_NODE_CHANGE_IND MGRH_NODE_CHANGE_IND
, HIRE_OR_START_IND HIRE_OR_START_IND
, TERM_OR_END_IND TERM_OR_END_IND
, ADT_EVENT_ID ADT_EVENT_ID
, ADT_ASSIGNMENT_ID ADT_ASSIGNMENT_ID
, ADT_ASG_EFFCTV_START_DATE ADT_ASG_EFFCTV_START_DATE
, ADT_ASG_EFFCTV_END_DATE ADT_ASG_EFFCTV_END_DATE
, ADT_PERF_REVIEW_ID ADT_PERF_REVIEW_ID
, ADT_PERIOD_OF_SERVICE_ID ADT_PERIOD_OF_SERVICE_ID
, ADT_PERIOD_OF_PLACEMENT_ID ADT_PERIOD_OF_PLACEMENT_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADT_BUSINESS_GROUP_ID ADT_BUSINESS_GROUP_ID
, ADT_POW_BAND ADT_POW_BAND
, PROMOTION_IND PROMOTION_IND
, PRIMARY_IND PRIMARY_IND
, DAYS_SINCE_LAST_PRMTN DAYS_SINCE_LAST_PRMTN
, MONTHS_SINCE_LAST_PRMTN MONTHS_SINCE_LAST_PRMTN
, WORKER_TERM_NXT_IND WORKER_TERM_NXT_IND
, PRE_SPRTN_ASGN_END_NXT_IND PRE_SPRTN_ASGN_END_NXT_IND
FROM "HRI"."HRI_MB_WRKFC_EVT_CT"