SP_CMPNY_OPRVW

(SQL View)
Index Back

Sec Vw - Company - Operator


select a.company ,b.oprid ,a.descr ,c.access_cd from ps_company_tbl a ,PSOPRDEFN b ,ps_sec_company_opr c where a.effdt = (select max(d.effdt) from ps_company_tbl d where d.company = a.company and d.effdt <= %currentdatein and d.eff_status = 'A') and c.access_cd = 'Y' and c.company = a.company and c.oprid = b.oprid

  • Related Language Record: SPCMPNYOPRVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    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