PV_REQ_OPR_VW

(SQL View)
 Index Back

Req Operator View

Req Operator View

SELECT B.OPRID ,B.REQUESTOR_ID FROM PS_OPR_DEF_TBL_PM B WHERE B.REQUESTOR_ID <>' ' UNION SELECT A.OPRID_ENTERED_BY ,A.REQUESTOR_ID FROM PS_REQ_HDR A

# 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 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: PV_REQ_OPR_VW