PSPRCSRQSTTEXT (SQL Table)	Index Back
Process Request Text This contains all long text fields affiliated with a Process Request

PSPRCSRQSTTEXT

(SQL Table)

Process Request Text

This contains all long text fields affiliated with a Process Request

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

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