PTASDISTSETUP

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTSCHDL_NAMECharacter(30)VARCHAR2(30) NOT NULLPartition Schedule
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
PTSCHDLTYPECharacter(1)VARCHAR2(1) NOT NULLType
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW

DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
PT_RETENTIONDAYSNumber(4,0)SMALLINT NOT NULLRetention Days
EMAIL_LOG_FLAGCharacter(1)VARCHAR2(1) NOT NULLEmail With Log
EMAIL_WEB_RPTCharacter(1)VARCHAR2(1) NOT NULLEmail Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
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, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19