OUTDESTTYPE2_LG(SQL View) |
Index Back |
---|
SELECT DISTINCT O.GENPRCSTYPE , O.OUTDESTTYPE , X.LANGUAGE_CD , %Substring(X.XLATLONGNAME, 1, 10) FROM PS_PRCSOUTPUTLIST O , PSXLATITEMLANG X WHERE O.OUTDESTTYPE = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTTYPE' AND O.ACTIVE_FLAG = '1' AND O.OUTDESTTYPE <> '4' AND O.PTNONUNPRCSNAME = '-' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GENPRCSTYPE | Character(2) | VARCHAR2(2) NOT NULL |
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 |
2 | 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 |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | OUTDESTTYPEDESCR | Character(10) | VARCHAR2(10) NOT NULL | Process Scheduler Destination Type |