CAL_RUN_IDPAY_ENTITYEMPLIDINSTANCEF=Finalized
M=Manually Paid
N=No Active Allocations
P=Prepared
T=Payment Transferred
V=Hold
W=Void
GPES_PAYMENT_VW(SQL View) |
Index Back |
|---|---|
Payment Processing ResultsResults table for Prepare Payment Process. Related Processing Setting of the GP_PAYMENT_STAT 1. After Prepare Payment set flag corresponding GP_PYE_PRC_STAT.GP_PAYMENT_STAT to 50 2. After Validate Payment set flag corresponding GP_PYE_PRC_STAT.GP_PAYMENT_STAT to 52 |
| SELECT A.CAL_RUN_ID ,A.PAY_ENTITY ,A.EMPLID ,A.INSTANCE ,B.ACCOUNT_NAME ,A.SEG_END_DT ,A.GP_PMT_AMT ,A.CURRENCY_CD ,A.PMT_STATUS FROM PS_GP_PAYMENT A , PS_PYE_BANKACCT B WHERE A.PAYMENT_MTHD = 'T' AND A.PMT_STATUS='F' AND A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 2 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | PAY_DT | Date(10) | DATE | Date of Pay |
| 7 | GP_PMT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount field on GP PAYMENT table |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 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 |