PV_OPR_RQSTR_VW

(SQL View)
 Index Back

Requestors Opr Authorized For

/OPRDESC This view shows Requestors which are both active and operator authorized.

SELECT A.OPRID , A.REQUESTOR_ID , C.OPRDEFNDESC , A.ADD_AUTH , A.UPDATE_AUTH , A.CLOSE_AUTH FROM PS_OPR_PO_RQSTR A , PS_REQUESTOR_TBL B , PSOPRDEFN C WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND B.ACTIVE_FLG ='Y' AND A.REQUESTOR_ID = C.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: REQUESTOR_VW

3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
4 ADD_AUTH Character(1) VARCHAR2(1) NOT NULL Add Authority

Y/N Table Edit

Default Value: Y

5 UPDATE_AUTH Character(1) VARCHAR2(1) NOT NULL Update Authority

Y/N Table Edit

Default Value: Y

6 CLOSE_AUTH Character(1) VARCHAR2(1) NOT NULL Cancel Authority

Y/N Table Edit

Default Value: Y