OPRIDDefault Value: VED_REQUEST_HDR.OPRID
RUN_CNTL_IDDefault Value: VED_REQUEST_HDR.RUN_CNTL_ID
Default Value: VED_REQUEST_HDR.PROCESS_INSTANCE
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
VED_RQ_PROC_VW(SQL View) |
Index Back |
|---|---|
Vchr Edit Rqst Proc Info View |
| SELECT OPRID , RUN_CNTL_ID , PROCESS_INSTANCE , AE_PROCESS_STATUS FROM PS_AEREQUESTTBL WHERE AE_APPLID = 'AP_VCHRBLD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: VED_REQUEST_HDR.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: VED_REQUEST_HDR.RUN_CNTL_ID |
| 3 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: VED_REQUEST_HDR.PROCESS_INSTANCE |
| 4 | AE_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now |