GP_PMT_DEDS_VW(SQL View) |
Index Back |
|---|---|
Payment; Summed DeductionsView of GP_PAYMENT selecting rows with Payment Type of '02' or '03' (General and Individual Recipient Deductions). Sums deduction by Element/Recipient/Debit Dt and Source Account |
| SELECT A.CAL_RUN_ID ,A.RECIPIENT_ID ,A.RECIPIENT_NAME ,A.PIN_NUM ,SUM(A.GP_PMT_AMT) ,A.CURRENCY_CD ,A.DEBIT_DT ,A.SRC_BANK_ID ,A.PAYMENT_MTHD ,A.PMT_STATUS ,A.PMT_TYPE ,' ' ,0 ,' ' ,' ' ,0 ,0 FROM PS_GP_PAYMENT A WHERE A.PMT_TYPE IN('02','03') GROUP BY A.CAL_RUN_ID ,A.RECIPIENT_ID ,A.RECIPIENT_NAME, A.PIN_NUM ,A.CURRENCY_CD ,A.DEBIT_DT, A.SRC_BANK_ID, A.PAYMENT_MTHD, A.PMT_STATUS, A.PMT_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | RECIPIENT_ID |
Character(8) | VARCHAR2(8) NOT NULL | Payment recipient ID |
| 3 | RECIPIENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Recipient Name |
| 4 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 5 | GP_PMT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount field on GP PAYMENT table |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | DEBIT_DT | Date(10) | DATE | Debit Date |
| 8 | SRC_BANK_ID | Character(8) | VARCHAR2(8) NOT NULL | Source Bank ID |
| 9 | 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 |
| 10 | 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 |
| 11 | PMT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Payment Type
01=Net Pay Distribution 02=General Recipient Deduction 03=Individual Recipient Deduction |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Rcd# |
| 14 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 15 | CAL_ID | Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 16 | RSLT_SEG_NUM | Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 17 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |