S360_RQSTR_VW

(SQL View)
 Index Back

Acitive Requestor View/OPRDESC

Active Requestor View with Requestor Name

SELECT A.REQUESTOR_ID , B.OPRDEFNDESC , A.REQ_STATUS , A.ORIGIN_PO_SETID , A.ORIGIN FROM PS_REQUESTOR_TBL A , PSOPRDEFN B WHERE A.ACTIVE_FLG = 'Y' AND A.REQUESTOR_ID = B.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

Prompt Table: ROLEXLATOPR_VW

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
3 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled
4 ORIGIN_PO_SETID Character(5) VARCHAR2(5) NOT NULL PO Origin Setid
5 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin