SCHDLTEXT (SQL Table)	Index Back
Schedule Text

SCHDLTEXT

(SQL Table)

Schedule Text

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCHEDULENAME Character(30) VARCHAR2(30) NOT NULL Schedule Name

2 JOBNAMESRC Character(8) VARCHAR2(8) NOT NULL Job Name Source

3 ITEM_NODE Character(36) VARCHAR2(36) NOT NULL Item Node

4 PARENT_ITEM_NODE Character(36) VARCHAR2(36) NOT NULL Parent Item Node

5 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

6 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	SCHEDULENAME	Character(30)	VARCHAR2(30) NOT NULL	Schedule Name
2	JOBNAMESRC	Character(8)	VARCHAR2(8) NOT NULL	Job Name Source
3	ITEM_NODE	Character(36)	VARCHAR2(36) NOT NULL	Item Node
4	PARENT_ITEM_NODE	Character(36)	VARCHAR2(36) NOT NULL	Parent Item Node
5	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
6	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.