OPRIDPRCSNAMEPRCSTYPE0=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
PTRCPRCSLST |
index back |
|---|---|
Processes accessible by User |
| SELECT DISTINCT U.OPRID , J.PRCSJOBNAME , J.PRCSTYPE , '9' ,J.PRCSJOBNAME , J.DESCR FROM PS_PRCSJOBDEFN J , PS_PRCSJOBPNL P , PS_PTRCUSERPAGESEC U WHERE J.PRCSJOBNAME = P.PRCSJOBNAME AND U.PNLGRPNAME = P.PNLGRPNAME UNION SELECT DISTINCT U1.OPRID , D.PRCSNAME , D.PRCSTYPE , T.GENPRCSTYPE , D.PRCSNAME , D.DESCR FROM PS_PRCSTYPEDEFN T , PS_PRCSDEFNPNL P , PS_PRCSDEFN D , PS_PTRCUSERPAGESEC U1 WHERE T.PRCSTYPE = D.PRCSTYPE AND D.PRCSTYPE = P.PRCSTYPE AND D.PRCSNAME = P.PRCSNAME AND T.PRCSTYPE = P.PRCSTYPE AND U1.PNLGRPNAME = P.PNLGRPNAME |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| PRCSNAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| PRCSTYPE |
Character(30) | VARCHAR2(30) NOT NULL | Process Type |
| 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 |
| PRCSJOBNAME | Character(8) | VARCHAR2(8) NOT NULL | Process Job Name |
| DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |