VIEW: HRI.HRI_MB_ASGN_EVENTS_CT#

Source

View Text - Preformatted

select EVENT_ID EVENT_ID, EFFECTIVE_CHANGE_DATE EFFECTIVE_CHANGE_DATE, EFFECTIVE_CHANGE_END_DATE EFFECTIVE_CHANGE_END_DATE, ASSIGNMENT_ID ASSIGNMENT_ID, PERSON_ID PERSON_ID, GRADE_ID GRADE_ID, GRADE_PRV_ID GRADE_PRV_ID, JOB_ID JOB_ID, JOB_PRV_ID JOB_PRV_ID, LOCATION_ID LOCATION_ID, LOCATION_PRV_ID LOCATION_PRV_ID, ORGANIZATION_ID ORGANIZATION_ID, ORGANIZATION_PRV_ID ORGANIZATION_PRV_ID, SUPERVISOR_ID SUPERVISOR_ID, SUPERVISOR_PRV_ID SUPERVISOR_PRV_ID, POSITION_ID POSITION_ID, POSITION_PRV_ID POSITION_PRV_ID, PRIMARY_FLAG PRIMARY_FLAG, PRIMARY_FLAG_PRV PRIMARY_FLAG_PRV, CHANGE_REASON_CODE CHANGE_REASON_CODE, LEAVING_REASON_CODE LEAVING_REASON_CODE, FTE FTE, FTE_PRV FTE_PRV, HEADCOUNT HEADCOUNT, HEADCOUNT_PRV HEADCOUNT_PRV, ANL_SLRY ANL_SLRY, ANL_SLRY_PRV ANL_SLRY_PRV, ANL_SLRY_CURRENCY ANL_SLRY_CURRENCY, ANL_SLRY_CURRENCY_PRV ANL_SLRY_CURRENCY_PRV, PAY_PROPOSAL_ID PAY_PROPOSAL_ID, ASG_RTRSPCTV_STRT_EVENT_IND ASG_RTRSPCTV_STRT_EVENT_IND, ASSIGNMENT_CHANGE_IND ASSIGNMENT_CHANGE_IND, SALARY_CHANGE_IND SALARY_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, SUPERVISOR_CHANGE_NXT_IND SUPERVISOR_CHANGE_NXT_IND, WORKER_HIRE_IND WORKER_HIRE_IND, TERM_VOLUNTARY_IND TERM_VOLUNTARY_IND, TERM_VOLUNTARY_NXT_IND TERM_VOLUNTARY_NXT_IND, TERM_INVOLUNTARY_IND TERM_INVOLUNTARY_IND, TERM_INVOLUNTARY_NXT_IND TERM_INVOLUNTARY_NXT_IND, WORKER_TERM_IND WORKER_TERM_IND, WORKER_TERM_NXT_IND WORKER_TERM_NXT_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, PRE_SPRTN_ASGN_END_NXT_IND PRE_SPRTN_ASGN_END_NXT_IND, POW_DAYS_ON_EVENT_DATE POW_DAYS_ON_EVENT_DATE, EFFECTIVE_CHANGE_DATE_PRV EFFECTIVE_CHANGE_DATE_PRV, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, SEPARATION_CATEGORY SEPARATION_CATEGORY, SEPARATION_CATEGORY_NXT SEPARATION_CATEGORY_NXT, POW_MONTHS_ON_EVENT_DATE POW_MONTHS_ON_EVENT_DATE, POW_START_DATE POW_START_DATE, POW_BAND POW_BAND, POW_BAND_PRV POW_BAND_PRV, POW_BAND_CHANGE_IND POW_BAND_CHANGE_IND, POW_BAND1_IND POW_BAND1_IND, POW_BAND2_IND POW_BAND2_IND, POW_BAND3_IND POW_BAND3_IND, POW_BAND4_IND POW_BAND4_IND, POW_BAND5_IND POW_BAND5_IND, PERF_NRMLSD_RATING PERF_NRMLSD_RATING, PERF_NRMLSD_RATING_PRV PERF_NRMLSD_RATING_PRV, PERFORMANCE_REVIEW_ID PERFORMANCE_REVIEW_ID, PERF_REVIEW_TYPE_CD PERF_REVIEW_TYPE_CD, PERFORMANCE_RATING_CD PERFORMANCE_RATING_CD, PERF_BAND PERF_BAND, PERF_BAND_PRV PERF_BAND_PRV, PERF_RATING_CHANGE_IND PERF_RATING_CHANGE_IND, PERF_BAND_CHANGE_IND PERF_BAND_CHANGE_IND, PERF_BAND1_IND PERF_BAND1_IND, PERF_BAND2_IND PERF_BAND2_IND, PERF_BAND3_IND PERF_BAND3_IND, PERF_BANDNA_IND PERF_BANDNA_IND, PERSON_TYPE_ID PERSON_TYPE_ID, USED_FOR_SUMMARIZATION USED_FOR_SUMMARIZATION, POW_START_DATE_ADJ POW_START_DATE_ADJ, POW_BAND_SK_FK POW_BAND_SK_FK, POW_BAND_PRV_SK_FK POW_BAND_PRV_SK_FK, PRSNTYP_SK_FK PRSNTYP_SK_FK, SUMMARIZATION_RQD_IND SUMMARIZATION_RQD_IND, SUMMARIZATION_RQD_CHNG_IND SUMMARIZATION_RQD_CHNG_IND, SUMMARIZATION_RQD_CHNG_NXT_IND SUMMARIZATION_RQD_CHNG_NXT_IND, POW_EXTN_STRT_DT POW_EXTN_STRT_DT, B B, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ASG_TYPE_CODE ASG_TYPE_CODE, PROMOTION_IND PROMOTION_IND, DAYS_SINCE_LAST_PRMTN DAYS_SINCE_LAST_PRMTN, MONTHS_SINCE_LAST_PRMTN MONTHS_SINCE_LAST_PRMTN from "HRI"."HRI_MB_ASGN_EVENTS_CT"

View Text - HTML Formatted

SELECT EVENT_ID EVENT_ID
, EFFECTIVE_CHANGE_DATE EFFECTIVE_CHANGE_DATE
, EFFECTIVE_CHANGE_END_DATE EFFECTIVE_CHANGE_END_DATE
, ASSIGNMENT_ID ASSIGNMENT_ID
, PERSON_ID PERSON_ID
, GRADE_ID GRADE_ID
, GRADE_PRV_ID GRADE_PRV_ID
, JOB_ID JOB_ID
, JOB_PRV_ID JOB_PRV_ID
, LOCATION_ID LOCATION_ID
, LOCATION_PRV_ID LOCATION_PRV_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_PRV_ID ORGANIZATION_PRV_ID
, SUPERVISOR_ID SUPERVISOR_ID
, SUPERVISOR_PRV_ID SUPERVISOR_PRV_ID
, POSITION_ID POSITION_ID
, POSITION_PRV_ID POSITION_PRV_ID
, PRIMARY_FLAG PRIMARY_FLAG
, PRIMARY_FLAG_PRV PRIMARY_FLAG_PRV
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, LEAVING_REASON_CODE LEAVING_REASON_CODE
, FTE FTE
, FTE_PRV FTE_PRV
, HEADCOUNT HEADCOUNT
, HEADCOUNT_PRV HEADCOUNT_PRV
, ANL_SLRY ANL_SLRY
, ANL_SLRY_PRV ANL_SLRY_PRV
, ANL_SLRY_CURRENCY ANL_SLRY_CURRENCY
, ANL_SLRY_CURRENCY_PRV ANL_SLRY_CURRENCY_PRV
, PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, ASG_RTRSPCTV_STRT_EVENT_IND ASG_RTRSPCTV_STRT_EVENT_IND
, ASSIGNMENT_CHANGE_IND ASSIGNMENT_CHANGE_IND
, SALARY_CHANGE_IND SALARY_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
, SUPERVISOR_CHANGE_NXT_IND SUPERVISOR_CHANGE_NXT_IND
, WORKER_HIRE_IND WORKER_HIRE_IND
, TERM_VOLUNTARY_IND TERM_VOLUNTARY_IND
, TERM_VOLUNTARY_NXT_IND TERM_VOLUNTARY_NXT_IND
, TERM_INVOLUNTARY_IND TERM_INVOLUNTARY_IND
, TERM_INVOLUNTARY_NXT_IND TERM_INVOLUNTARY_NXT_IND
, WORKER_TERM_IND WORKER_TERM_IND
, WORKER_TERM_NXT_IND WORKER_TERM_NXT_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
, PRE_SPRTN_ASGN_END_NXT_IND PRE_SPRTN_ASGN_END_NXT_IND
, POW_DAYS_ON_EVENT_DATE POW_DAYS_ON_EVENT_DATE
, EFFECTIVE_CHANGE_DATE_PRV EFFECTIVE_CHANGE_DATE_PRV
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, SEPARATION_CATEGORY SEPARATION_CATEGORY
, SEPARATION_CATEGORY_NXT SEPARATION_CATEGORY_NXT
, POW_MONTHS_ON_EVENT_DATE POW_MONTHS_ON_EVENT_DATE
, POW_START_DATE POW_START_DATE
, POW_BAND POW_BAND
, POW_BAND_PRV POW_BAND_PRV
, POW_BAND_CHANGE_IND POW_BAND_CHANGE_IND
, POW_BAND1_IND POW_BAND1_IND
, POW_BAND2_IND POW_BAND2_IND
, POW_BAND3_IND POW_BAND3_IND
, POW_BAND4_IND POW_BAND4_IND
, POW_BAND5_IND POW_BAND5_IND
, PERF_NRMLSD_RATING PERF_NRMLSD_RATING
, PERF_NRMLSD_RATING_PRV PERF_NRMLSD_RATING_PRV
, PERFORMANCE_REVIEW_ID PERFORMANCE_REVIEW_ID
, PERF_REVIEW_TYPE_CD PERF_REVIEW_TYPE_CD
, PERFORMANCE_RATING_CD PERFORMANCE_RATING_CD
, PERF_BAND PERF_BAND
, PERF_BAND_PRV PERF_BAND_PRV
, PERF_RATING_CHANGE_IND PERF_RATING_CHANGE_IND
, PERF_BAND_CHANGE_IND PERF_BAND_CHANGE_IND
, PERF_BAND1_IND PERF_BAND1_IND
, PERF_BAND2_IND PERF_BAND2_IND
, PERF_BAND3_IND PERF_BAND3_IND
, PERF_BANDNA_IND PERF_BANDNA_IND
, PERSON_TYPE_ID PERSON_TYPE_ID
, USED_FOR_SUMMARIZATION USED_FOR_SUMMARIZATION
, POW_START_DATE_ADJ POW_START_DATE_ADJ
, POW_BAND_SK_FK POW_BAND_SK_FK
, POW_BAND_PRV_SK_FK POW_BAND_PRV_SK_FK
, PRSNTYP_SK_FK PRSNTYP_SK_FK
, SUMMARIZATION_RQD_IND SUMMARIZATION_RQD_IND
, SUMMARIZATION_RQD_CHNG_IND SUMMARIZATION_RQD_CHNG_IND
, SUMMARIZATION_RQD_CHNG_NXT_IND SUMMARIZATION_RQD_CHNG_NXT_IND
, POW_EXTN_STRT_DT POW_EXTN_STRT_DT
, B B
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ASG_TYPE_CODE ASG_TYPE_CODE
, PROMOTION_IND PROMOTION_IND
, DAYS_SINCE_LAST_PRMTN DAYS_SINCE_LAST_PRMTN
, MONTHS_SINCE_LAST_PRMTN MONTHS_SINCE_LAST_PRMTN
FROM "HRI"."HRI_MB_ASGN_EVENTS_CT"