EMPLIDEMPL_RCDCAL_RUN_IDGP_MPSLP_SUBSECTNGP_MPSLP3_VIEW(SQL View) |
Index Back |
|---|---|
Mobile EpayMobile Epay |
| SELECT DISTINCT A.EMPLID ,A.EMPL_RCD , A.CAL_RUN_ID ,'ALL' ,'ALL' ,'AC' ,'40' FROM PS_GP_MPSLP_STGACM A , PS_GP_PIN B WHERE A.PIN_NUM=B.PIN_NUM UNION SELECT DISTINCT A.EMPLID ,A.EMPL_RCD , A.CAL_RUN_ID , CASE A.GP_MPSLP_SUBSECTN WHEN ' ' THEN 'ALL' ELSE A.GP_MPSLP_SUBSECTN END , CASE A.GP_MPSLP_SUBSECTN WHEN ' ' THEN 'ALL' ELSE A.GP_MPSLP_SUBSECTN END , B.PIN_TYPE ,'40' FROM PS_GP_MPSLP_STGACM A , PS_GP_PIN B WHERE A.PIN_NUM=B.PIN_NUM AND A.GP_MPSLP_SECTION='40' |
| # | 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 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 4 | GP_MPSLP_SUBSECTN |
Character(30) | VARCHAR2(30) NOT NULL | Mobile Epay |
| 5 | GP_MPSLP_SUBSECTN3 | 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 |