COMP_ITA_LNG

(SQL View)
 Index Back

Etablishment View LNG tbl

This view retrieves the establishments associated to a given company and the list of the company -Language Tbl

SELECT B.COMPANY , ' ' , D.LANGUAGE_CD , B.EFFDT , B.DESCR FROM PS_COMPANY_TBL B , PS_COMPNY_TBL_LANG D WHERE B.COMPANY = D.COMPANY AND B.EFFDT = D.EFFDT AND B.EFF_STATUS ='A'

  • Related Language Record for COMP_ITA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description