BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
REQ_IDDefault Value: NEXT
PV_RULEIDSTEPINSTANCEIDPV_WF_APPR_VW(SQL View) |
Index Back |
|---|---|
Requisition Approval |
| SELECT A.BUSINESS_UNIT ,A.REQ_ID ,A.PV_RULEID ,A.STEP ,A.INSTANCEID ,C.OPRID FROM PS_PV_WF_REQ_RTNG A , PS_PV_REQ_APPR_WL B , PSWORKLIST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.PV_RULEID = B.PV_RULEID AND A.STEP = B.STEP AND A.INSTANCEID = B.INSTANCEID AND B.EVENTNAME = C.EVENTNAME AND B.WORKLISTNAME = C.WORKLISTNAME AND B.INSTANCEID = C.INSTANCEID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 3 | PV_RULEID |
Character(12) | VARCHAR2(12) NOT NULL | Rule Id |
| 4 | STEP |
Number(2,0) | SMALLINT NOT NULL | Step |
| 5 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL | For a given worklist the unique number of rows in PSWORKLIST |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |