EMPLIDCAL_RUN_IDEMPL_RCDGP_PSLP_IDGP_MPSLP_CHT_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 ,A.PIN_NUM , CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END ,SUM(A.CALC_RSLT_VAL) + SUM(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 ,A.PIN_NUM , 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 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 7 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 8 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |