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
PTNONUNPRCSVIEW(SQL View) |
Index Back |
|---|---|
Non unqiue process view |
| SELECT DISTINCT A.GENPRCSTYPE , B.PTNONUNPRCSNAME FROM PS_PRCSTYPEDEFN A , PS_PRCSNONUNIQUE B WHERE A.PRCSTYPE=B.PRCSTYPE |
| # | 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 | PTNONUNPRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |