PTASDISTSETUP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PTSCHDL_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Partition Schedule |
| 2 | 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 |
| 3 | PTSCHDLTYPE |
Character(1) | VARCHAR2(1) NOT NULL | Type |
| 4 | PSRF_FOLDER_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Reporting Folder's Name
Prompt Table: PRCSDEFNFLDR_VW |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PT_RETENTIONDAYS | Number(4,0) | SMALLINT NOT NULL | Retention Days |
| 7 | EMAIL_LOG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Email With Log |
| 8 | 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 |
| 9 | 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. |
| 10 | PT_OVRDFROMEMAILID | Character(1) | VARCHAR2(1) NOT NULL |
Override From Email
0=Disable 1=Enable Default Value: 0 |