GPAU_PSLP_BK_VW(SQL View) |
Index Back |
|---|---|
GP AUS - Payslip BankingGP AUS - Payslip Banking view |
| SELECT B.EMPLID , B.EMPL_RCD , A.BRANCH_EC_CD , A.ACCOUNT_EC_ID , B.DISTRIB_AMT , C.BANK_NM FROM PS_GP_NET_DIST_DTL B , PS_PYE_BANKACCT A , PS_BANK_EC_TBL C WHERE A.EMPLID = B.EMPLID AND A.ACCOUNT_ID = B.ACCOUNT_ID AND B.EFFDT =( SELECT MAX(B1.EFFDT) FROM PS_GP_NET_DIST_DTL B1 WHERE B1.EMPLID = B.EMPLID AND B1.EMPL_RCD = B.EMPL_RCD AND B1.RUN_TYPE = B.RUN_TYPE AND B1.INSTANCE = B.INSTANCE) AND A.BANK_CD = C.BANK_CD AND A.COUNTRY_CD = C.COUNTRY_CD |
| # | 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 Rcd Nbr |
| 3 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL | Bank Branch ID |
| 4 | ACCOUNT_EC_ID | Character(35) | VARCHAR2(35) NOT NULL | Account Number used in banking. |
| 5 | DISTRIB_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Distribution Amount |
| 6 | BANK_NM | Character(40) | VARCHAR2(40) NOT NULL | Bank Name |