PA_SP_MSGLOG_VW(SQL View) |
Index Back |
|---|---|
Service Purchase Int. MessagesService Purchase Integration Message Log Header. This stores the message data that was sent and received by AR and Pensions. |
| SELECT H.EMPLID , H.BENEFIT_PLAN , H.SP_ID , H.MSG_NBR , L.MESSAGESEQ , H.INSTALL_NBR , H.DUE_DT , H.SP_AMT , H.CURRENCY_CD , H.ACCOUNTING_DT , H.EACCT_TRAN_TYPE , H.SP_MSG_CD , L.CUST_ID , L.BUSINESS_UNIT , L.ENTRY_TYPE , L.ENTRY_REASON , L.SP_SYSTEM_SOURCE , L.SP_MSG_RESP , L.DTTM_STAMP , L.ACCT_CD FROM PS_PA_SP_MSG_HDR H , PS_PA_SP_MSG_LOG L WHERE H.EMPLID = L.EMPLID AND H.BENEFIT_PLAN = L.BENEFIT_PLAN AND H.SP_ID = L.SP_ID AND H.MSG_NBR = L.MSG_NBR |
| # | 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 | MSG_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 5 | MESSAGESEQ |
Number(5,0) | INTEGER NOT NULL | Message Sequence |
| 6 | INSTALL_NBR | Number(2,0) | SMALLINT NOT NULL | Installation Number for Service Purchase Installment Payments. |
| 7 | DUE_DT | Date(10) | DATE | Expected Birth Date |
| 8 | 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. |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | ACCOUNTING_DT | Date(10) | DATE | Accounting Date |
| 11 | EACCT_TRAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Tax Type of Pension amounts.
O=Post-Tax R=Pre-Tax |
| 12 | SP_MSG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Service Purchase Message Codes to indicate purpose of integration message.
CNL=Cancel Item CRT=Create Open Item GBA=Goal Balance Attained PAY=Pay an Item REV=Reversal of Payment RFD=Refund Item |
| 13 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 15 | ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL | AR Entry Types for Service Purchase. |
| 16 | ENTRY_REASON | Character(5) | VARCHAR2(5) NOT NULL | AR Entry Reasons for Service Purchase. |
| 17 | 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 |
| 18 | SP_MSG_RESP | Character(2) | VARCHAR2(2) NOT NULL |
Service Purchase Response code. This code indicates if the integration message from Pensions to AR was successful in its objective, or resulted in an error.
01=Request 02=Success-Pendiing 03=Success-Item 04=Error 05=Resend 06=Applied |
| 19 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 20 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |