PY_COMPANY_VW

(SQL View)
 Index Back

Company table view

The view will list all the active companies.

SELECT a.company , a.descr FROM PS_COMPANY_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_COMPANY_TBL b WHERE b.company = a.company AND b.effdt <= %CurrentDateIn) AND a.eff_status = 'A'

  • Related Language Record: PY_COMP_VW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description