FLD_REQUEST_IDFLD_REQ_APPV_VW(SQL View) |
Index Back |
|---|---|
Field Request Approvers ViewField Request Approvers View to allow those approvers who have approved the request to perform the 'Update Blank Value' action |
| SELECT X.FLD_REQUEST_ID , U.OPRID FROM PS_FLD_REQ_AF_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE X.EOAWTHREAD_ID=S.EOAWTHREAD_ID AND X.EOAWPRCS_ID=S.EOAWPRCS_ID AND X.EOAWDEFN_ID=S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE=U.EOAWSTEP_INSTANCE AND U.EOAWSTEP_STATUS='A' AND X.EOAWTHREAD_ID=( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_FLD_REQ_AF_XREF X1 WHERE X1.FLD_REQUEST_ID=X.FLD_REQUEST_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FLD_REQUEST_ID |
Character(30) | VARCHAR2(30) NOT NULL | Field Request ID |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |