OUTDESTTYPE0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
OUTDESTSRC0=(None)
1=Process Type Definition
2=Process Definition
3=User Specified
OUTDESTSRC(SQL View) |
Index Back |
|---|
| SELECT DISTINCT %Substring(O.OUTDESTTYPE , 1,3) , %Substring(O.OUTDESTSRC , 1,1) , %Substring(X.XLATLONGNAME , 1, 25) FROM PS_PRCSOUTDESTLIST O , PSXLATITEM X WHERE O.OUTDESTSRC = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTSRC' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OUTDESTTYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default 8=Feed 9=IB Node |
| 2 | OUTDESTSRC |
Character(1) | VARCHAR2(1) NOT NULL |
Process Request output destination source
0=(None) 1=Process Type Definition 2=Process Definition 3=User Specified |
| 3 | OUTDESTSRCDESCR | Character(25) | VARCHAR2(25) NOT NULL | Output Format |