GP_MPSLP_SUBSECTNEMPLIDEMPL_RCDCAL_RUN_IDGP_MPSLP_SUBSECTN2GP_MPSLP2_VIEW(SQL View) |
Index Back |
|---|---|
Mobile EpayMobile Epay |
| SELECT DISTINCT 'ALL' , A.EMPLID ,A.EMPL_RCD , A.CAL_RUN_ID ,'ALL' ,'DD' ,'20' FROM PS_GP_MPSLP_STGED A , PS_GP_PIN B WHERE A.PIN_NUM=B.PIN_NUM UNION SELECT DISTINCT CASE A.GP_MPSLP_SUBSECTN WHEN ' ' THEN 'ALL' ELSE A.GP_MPSLP_SUBSECTN END ,A.EMPLID ,A.EMPL_RCD , A.CAL_RUN_ID , CASE A.GP_MPSLP_SUBSECTN WHEN ' ' THEN 'ALL' ELSE A.GP_MPSLP_SUBSECTN END ,B.PIN_TYPE ,'20' FROM PS_GP_MPSLP_STGED A , PS_GP_PIN B WHERE A.PIN_NUM=B.PIN_NUM AND A.GP_MPSLP_SECTION='20' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_MPSLP_SUBSECTN |
Character(30) | VARCHAR2(30) NOT NULL | Mobile Epay |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | GP_MPSLP_SUBSECTN2 |
Character(30) | VARCHAR2(30) NOT NULL | Mobile Epay |
| 6 | PIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Element Type |
| 7 | GP_MPSLP_SECTION | Character(30) | VARCHAR2(30) NOT NULL | Mobile Epay |