PV_OS_RQSTR_VW

(SQL View)
Index Back

Requester view


SELECT A.BUSINESS_UNIT_GL , A.REQUESTOR_ID , B.OPRDEFNDESC , A.ACTIVE_FLG FROM PS_REQUESTOR_TBL A , PSOPRDEFN B WHERE A.REQUESTOR_ID = B.OPRID AND A.BUSINESS_UNIT_GL <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
3 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
4 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Y/N Table Edit

Default Value: Y