EMPLIDCAL_RUN_IDEMPL_RCDGP_PSLP_IDGP_MPSLP_CHN_VW(SQL View) |
Index Back |
|---|---|
Mobile EpayMobile Epay |
| SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PSLP_ID , CASE WHEN A.GP_MPSLP_SECTION ='10' THEN 'ER' ELSE 'DD' END , CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END , SUM(%Abs(A.CALC_RSLT_VAL)) +SUM(%Abs(A.CALC_DELTA_VAL)) FROM PS_GP_MPSLP_STGED A , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM AND A.GP_MPSLP_ADD_TOTAL = 'Y' GROUP BY A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PSLP_ID ,CASE WHEN A.GP_MPSLP_SECTION ='10' THEN 'ER' ELSE 'DD' END ,CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GP_PSLP_ID |
Character(40) | VARCHAR2(40) NOT NULL | Payslip Identifier |
| 5 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 6 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 7 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |