PTASDISTSETUP

index back

PeopleSoft Field Name Field Type Column Type Description
PTSCHDL_NAME Character(30) VARCHAR2(30) NOT NULL Partition Schedule
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
PTSCHDLTYPE Character(1) VARCHAR2(1) NOT NULL Type
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name

Prompt Table: PRCSDEFNFLDR_VW

DESCR Character(30) VARCHAR2(30) NOT NULL Description
PT_RETENTIONDAYS Number(4,0) SMALLINT NOT NULL Retention Days
EMAIL_LOG_FLAG Character(1) VARCHAR2(1) NOT NULL Email With Log
EMAIL_WEB_RPT Character(1) VARCHAR2(1) NOT NULL Email Web Report
0=Email report
1=Email report
N=Display report in browser
Y=Email report
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.
PT_OVRDFROMEMAILID Character(1) VARCHAR2(1) NOT NULL Override From Email
0=Disable
1=Enable

Default: 0

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20