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
LANGUAGE_CDOUTDESTSRCLANG(SQL View) |
Index Back |
|---|
| SELECT DISTINCT %Substring(O.OUTDESTTYPE , 1, 3) , %Substring(O.OUTDESTSRC ,1,1) , X.LANGUAGE_CD , %Substring(X.XLATLONGNAME ,1,25) FROM PS_PRCSOUTDESTLIST O , PSXLATITEMLANG 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | OUTDESTSRCDESCR | Character(25) | VARCHAR2(25) NOT NULL | Output Format |