GP_MPSLP_PD_VW(SQL View) |
Index Back |
|---|---|
Mobile EpayMobile Epay |
| SELECT C.EMPLID ,C.EMPL_RCD , B.CAL_RUN_ID ,E.BANK_NM , 'xxxx'%Concat %Substring(D.ACCOUNT_EC_ID,%SQL(FUNCLIB_GP_GETCHARLENGTH,D.ACCOUNT_EC_ID)-3,%SQL(FUNCLIB_GP_GETCHARLENGTH,D.ACCOUNT_EC_ID)) ,F.FIELDVALUE /* F.XLATSHORTNAME */ ,F.FIELDVALUE /* F.XLATSHORTNAME */ ,B.GP_PMT_AMT ,B.GP_PMT_AMT , B.PYMT_NBR ,B.PAYMENT_MTHD ,%Sql(FUNCLIB_HR_CONVERT_TO_STRING,B.GP_PMT_AMT,18)%Concat ' ' %Concat b.currencY_cd2 ,%Sql(FUNCLIB_HR_CONVERT_TO_STRING,B.GP_PMT_AMT,18)%Concat ' ' %Concat b.currencY_cd2 ,B.SEG_END_DT ,B.CURRENCY_CD2 FROM PS_GP_PAYMENT B ,PS_GP_NET_DIST_DTL C , PS_PYE_BANKACCT D , PS_BANK_EC_TBL E , PSXLATITEM F WHERE B.EMPLID= C.EMPLID AND B.EMPL_RCD=C.EMPL_RCD AND B.PMT_TYPE = '01' AND B.RUN_TYPE=C.RUN_TYPE AND C.EFFDT=( SELECT MAX(CH.EFFDT) FROM PS_GP_NET_DIST_DTL CH WHERE CH.EMPLID=C.EMPLID AND CH.EMPL_RCD=C.EMPL_RCD AND CH.RUN_TYPE=C.RUN_TYPE AND CH.INSTANCE = C.INSTANCE AND ch.effdt <=b.DEBIT_DT) AND C.EMPLID=D.EMPLID AND C.ACCOUNT_ID=D.ACCOUNT_ID AND D.EFF_STATUS='A' AND D.BANK_CD=E.BANK_CD AND E.EFF_STATUS='A' AND D.COUNTRY_CD=E.COUNTRY_CD AND B.EMPLID=D.EMPLID AND B.ACCOUNT_ID=D.ACCOUNT_ID AND D.ACCOUNT_TYPE_PYE = F.FIELDVALUE AND F.FIELDNAME = 'ACCOUNT_TYPE_PYE' |
| # | 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 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |
| 5 | GP_BANK_ACCT_NUM | Character(17) | VARCHAR2(17) NOT NULL | Mobile Epay |
| 6 | GP_MPSL_BANK_NM | Character(60) | VARCHAR2(60) NOT NULL | Mobile Epay |
| 7 | GP_MPSL_BANK_NM2 | Character(60) | VARCHAR2(60) NOT NULL | Mobile Epay |
| 8 | GP_PMT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount field on GP PAYMENT table |
| 9 | GP_MPSLP_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Mobile Epay |
| 10 | GP_PYMT_NBR | Number(18,0) | DECIMAL(18) NOT NULL | Mobile Epay |
| 11 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer |
| 12 | GP_AMT_CUR | Character(20) | VARCHAR2(20) NOT NULL | Mobile Epay |
| 13 | GP_AMT_CUR2 | Character(20) | VARCHAR2(20) NOT NULL | Mobile Epay |
| 14 | SEG_END_DT | Date(10) | DATE | Payee Process Segment's End Date |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |