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 |