PSPRCSRQSTTEXT2 (SQL Table)	Index Back
Process Request Text This contains email related info for bursted report

PSPRCSRQSTTEXT2

(SQL Table)

Process Request Text

This contains email related info for bursted report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID

3 RQSTTEXTTYPE Character(2) VARCHAR2(2) NOT NULL Process Request Text Type. This describes the different long text fields associated with a specific Process Reuqest
1=Email Address
2=Email Subject
3=Email Text
4=Email Address Expanded List
5=Distribution List
6=Original Extended Parameter
7=Extended Parameter

4 RQST_TEXT Long Character CLOB Process Request long text fields. This is used to hold values for any long text associated with a process request. For instance, this includes Email informationlike text, subject, or addresss.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTENTID	Number(15,0)	DECIMAL(15) NOT NULL	Report ID
3	RQSTTEXTTYPE	Character(2)	VARCHAR2(2) NOT NULL	Process Request Text Type. This describes the different long text fields associated with a specific Process Reuqest 1=Email Address 2=Email Subject 3=Email Text 4=Email Address Expanded List 5=Distribution List 6=Original Extended Parameter 7=Extended Parameter
4	RQST_TEXT	Long Character	CLOB	Process Request long text fields. This is used to hold values for any long text associated with a process request. For instance, this includes Email informationlike text, subject, or addresss.