DESCR0=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
PRCSLIST_VW(SQL View) |
Index Back |
|---|---|
Process Definition ListThis view is used to list all valid process and jobs to be run from a given panel group. |
| SELECT DISTINCT D.DESCR , D.PRCSNAME , D.PRCSTYPE , T.GENPRCSTYPE , P.PNLGRPNAME FROM PS_PRCSDEFN D , PS_PRCSTYPEDEFN T , PS_PRCSDEFNPNL P WHERE D.PRCSTYPE = T.PRCSTYPE AND D.PRCSTYPE = P.PRCSTYPE AND D.PRCSNAME = P.PRCSNAME AND T.PRCSTYPE = P.PRCSTYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 2 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 3 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 4 | 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 |
| 5 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |