SSF_BU_CLSVW

(SQL View)
Index Back

Sec Vw - Bus Unit - Opr Class


SELECT DISTINCT b.oprid ,d.emplid ,a.business_unit ,b.oprclass FROM ps_bus_unit_tbl_sf a ,PSOPRDEFN b ,ps_sec_unitsf_cls c ,ps_account_sf d WHERE c.access_cd = 'Y' AND c.business_unit = a.business_unit AND c.oprclass = b.oprclass AND c.business_unit = d.business_unit

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class