EMPLIDBENEFIT_PLANSP_IDPYMT_DTTMACCOUNTING_DTPYMT_TYPEPAY=Payment
REV=Reversal of Payment
RFD=Refund
INSTALL_NBREACCT_TRAN_TYPEO=Post-Tax
R=Pre-Tax
AR=Receivables
PA=Pensions
PY=Payroll
PA_SP_PAYMENTS(SQL Table) |
Index Back |
|---|---|
Service Purchase PaymentsService Purchase Payments Log. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 3 | SP_ID |
Number(11,0) | DECIMAL(11) NOT NULL | Service Purchase ID |
| 4 | PYMT_DTTM |
DateTime(26) | TIMESTAMP | Payment Date Time |
| 5 | ACCOUNTING_DT |
Date(10) | DATE | Accounting Date |
| 6 | PYMT_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Payment Type
PAY=Payment REV=Reversal of Payment RFD=Refund |
| 7 | INSTALL_NBR |
Number(2,0) | SMALLINT NOT NULL | Installation Number for Service Purchase Installment Payments. |
| 8 | EACCT_TRAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Type of Pension amounts.
O=Post-Tax R=Pre-Tax |
| 9 | DUE_DT | Date(10) | DATE | Expected Birth Date |
| 10 | SP_AMT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Amount sent to AR for Service Purchase processing to create open items in AR. |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | SP_SYSTEM_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
This field identifies the source of the messages between AR and Pensions for Service Purchase functionality.
AR=Receivables PA=Pensions PY=Payroll |
| 13 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |