OPRIDPRCSINSTANCERUNCNTLID0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
AR_PRCS_VW(SQL View) |
Index Back |
|---|
| SELECT A.OPRID , A.PRCSINSTANCE , A.RUNCNTLID , A.DBNAME , A.DBTYPE FROM PSPRCSRQST A , PS_AE_REQUEST B WHERE B.OPRID = A.OPRID AND B.PROCESS_INSTANCE = A.PRCSINSTANCE AND B.RUN_CNTL_ID = A.RUNCNTLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | RUNCNTLID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 5 | DBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Database Type
0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/UNIX 5=AllBase 6=Sybase 7=Microsoft 8=DB2/400 |