index back

Schedule Text

PeopleSoft Field NameField TypeColumn TypeDescription
SCHEDULENAMECharacter(30)VARCHAR2(30) NOT NULLSchedule Name
JOBNAMESRCCharacter(8)VARCHAR2(8) NOT NULLJob Name Source
ITEM_NODECharacter(36)VARCHAR2(36) NOT NULLItem Node
PARENT_ITEM_NODECharacter(36)VARCHAR2(36) NOT NULLParent Item Node
RQSTTEXTTYPECharacter(2)VARCHAR2(2) NOT NULLProcess 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
RQST_TEXTLong CharacterCLOBProcess 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.
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19