PA_SP_MSG_LOG (SQL Table)	Index Back
Service Purchase Message Log Service Purchase Message Log Details

PA_SP_MSG_LOG

(SQL Table)

Service Purchase Message Log

Service Purchase Message Log Details

# 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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

8 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL AR Entry Types for Service Purchase.

9 ENTRY_REASON Character(5) VARCHAR2(5) NOT NULL AR Entry Reasons for Service Purchase.

10 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

11 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

12 ERR_MSG_NBR Number(5,0) INTEGER NOT NULL Service Purchase Error Message Numbers, passed on integration message with AR.

13 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.

14 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

#	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	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	AR Entry Types for Service Purchase.
9	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	AR Entry Reasons for Service Purchase.
10	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
11	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
12	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Message Numbers, passed on integration message with AR.
13	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.
14	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code