GPHK_MPFMN1_VW

(SQL View)
Index Back

Used in MPF MN1 Rules

View used in MPF MN1 calculation to fetch the orig calendar values of ER/EEMPFMN2_SEG accumulators from the RSLT_ACUM table

SELECT EMPLID ,EMPL_RCD ,GP_PAYGROUP ,CAL_RUN_ID ,CAL_ID ,RSLT_SEG_NUM ,PIN_NUM ,SLICE_BGN_DT ,SLICE_END_DT ,CALC_RSLT_VAL FROM PS_GP_RSLT_ACUM WHERE CAL_RUN_ID = ORIG_CAL_RUN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
8 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
9 SLICE_END_DT Date(10) DATE Element Slice End Date
10 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result