GENPRCSTYPE0=Other
1=SQR
2=PeopleSoft COBOL
3=Crystal Report
4=Winword Macro
5=Application Engine
6=Cube Builder
7=nVision
8=Data Mover
9=PSJob (inactive)
OUTDESTTYPE0=Any
1=(None)
2=File
3=Printer
4=Window
5=Email
6=Web
7=Default
OUTDESTTYPE2 | |
View: PS_OUTDESTTYPE2 |
| Platform | View Text |
|---|---|
| Default | SELECT DISTINCT O.GENPRCSTYPE , O.OUTDESTTYPE , %Substring(X.XLATLONGNAME , 1, 10) FROM PS_PRCSOUTPUTLIST O , PS_PRCSOUTDESTTYPE P , PSXLATITEM X WHERE O.OUTDESTTYPE = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTTYPE' AND O.ACTIVE_FLAG = '1' AND O.GENPRCSTYPE = P.GENPRCSTYPE AND O.OUTDESTTYPE = P.OUTDESTTYPE AND P.ACTIVE_FLAG = '1' AND O.OUTDESTTYPE <> '4' |
| PeopleSoft Field Name | Description |
|---|---|
| GENPRCSTYPE | Generic Process Type 0=Other 1=SQR 2=PeopleSoft COBOL 3=Crystal Report 4=Winword Macro 5=Application Engine 6=Cube Builder 7=nVision 8=Data Mover 9=PSJob (inactive) |
| OUTDESTTYPE | Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default |
| OUTDESTTYPEDESCR | Process Scheduler Destination Type |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |