OUTDESTTYPE0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
8=Feed
9=IB Node
LANGUAGE_CDPSAERSOUTDSVWLG(SQL View) |
Index Back |
|---|
| SELECT DISTINCT O.OUTDESTTYPE , L.LANGUAGE_CD , %Substring (L.XLATLONGNAME , 1, 10) FROM PS_PRCSOUTPUTLIST O , PS_PRCSOUTDESTTYPE P , PSXLATITEMLANG L WHERE O.OUTDESTTYPE = L.FIELDVALUE AND L.FIELDNAME = 'OUTDESTTYPE' AND O.ACTIVE_FLAG = '1' AND O.GENPRCSTYPE = P.GENPRCSTYPE AND O.OUTDESTTYPE = P.OUTDESTTYPE AND O.GENPRCSTYPE = '5' AND O.OUTDESTTYPE IN ('2','4', '5', '6') |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | OUTDESTTYPEDESCR | Character(10) | VARCHAR2(10) NOT NULL | Process Scheduler Destination Type |