SP_BU_SF_OPRVW

(SQL View)
 Index Back

Sec Vw - Bus Unit - Operator


select a.business_unit ,b.oprid ,a.descr ,c.access_cd from ps_bus_unit_tbl_sf a ,PSOPRDEFN b ,ps_sec_unitsf_opr c where c.access_cd = 'Y' and c.business_unit = a.business_unit and c.oprid = b.oprid

  • Related Language Record: SPBUSFOPRVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access