SCHEDULENAMEJOBNAMESRCITEM_NODEPARENT_ITEM_NODERQSTTEXTTYPE1=Email Address
2=Email Subject
3=Email Text
4=Email Address Expanded List
5=Distribution List
6=Original Extended Parameter
7=Extended Parameter
SCHDLTEXT |
index back |
|---|---|
Schedule Text |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| SCHEDULENAME |
Character(30) | VARCHAR2(30) NOT NULL | Schedule Name |
| JOBNAMESRC |
Character(8) | VARCHAR2(8) NOT NULL | Job Name Source |
| ITEM_NODE |
Character(36) | VARCHAR2(36) NOT NULL | Item Node |
| PARENT_ITEM_NODE |
Character(36) | VARCHAR2(36) NOT NULL | Parent Item Node |
| 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 |
| 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. |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |