SP_CMPNY_CLSVW

(SQL View)
 Index Back

Sec Vw - Company - Opr Class


select distinct a.company ,b.oprclass ,a.descr ,c.access_cd from ps_company_tbl a ,PSOPRDEFN b ,ps_sec_company_cls 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.oprclass = b.oprclass

  • Related Language Record: SPCMPNYCLSVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    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