OPR_PO_RQSTR_VW

(SQL View)
 Index Back

Requestors Opr Authorized For

12/29/1998, Qi Xie 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 , A.DELETE_AUTH FROM PS_OPR_PO_RQSTR A , PS_REQUESTOR_TBL B ,PSOPRDEFN C WHERE A.REQUESTOR_ID = B.REQUESTOR_ID AND A.REQUESTOR_ID = C.OPRID AND B.REQUESTOR_ID = C.OPRID AND B.ACTIVE_FLG ='Y'

# 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

7 DELETE_AUTH Character(1) VARCHAR2(1) NOT NULL Delete Authority

Y/N Table Edit

Default Value: N