GP_PMT_NPS_VW(SQL View) |
Index Back |
|---|---|
Net Pay Summary ViewNet Pay summarised. |
| SELECT A.CAL_RUN_ID ,A.EMPLID ,A.EMPL_RCD ,SUM(A.GP_PMT_AMT) ,A.CURRENCY_CD ,A.CAL_PRD_ID ,A.PAYMENT_MTHD ,A.SRC_BANK_ID ,A.PMT_STATUS FROM PS_GP_PAYMENT A WHERE A.PMT_TYPE = '01' GROUP BY A.CAL_RUN_ID ,A.EMPLID ,A.EMPL_RCD, A.CAL_PRD_ID, A.CURRENCY_CD , A.SRC_BANK_ID, A.PAYMENT_MTHD, A.PMT_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | GP_PMT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount field on GP PAYMENT table |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 7 | 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 |
| 8 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 9 | PMT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status field for a generated payment transaction
F=Finalized M=Manually Paid N=No Active Allocations P=Prepared T=Payment Transferred V=Hold W=Void |