PCMP_COMP_VWLNG

(SQL View)
 Index Back

Prof Comp Company View

Used in the Professional Compliance module. Relate language view of Company Table to act as a search record and "virtual parent" for Professional Compliance Companies.

SELECT A.COMPANY ,C.LANGUAGE_CD ,C.DESCR ,A.DEFAULT_SETID FROM PS_COMPANY_TBL A ,PS_COMPNY_TBL_LANG C WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_COMPANY_TBL B WHERE B.EFFDT<=%CurrentDateIn AND B.COMPANY=A.COMPANY) AND A.COMPANY=C.COMPANY AND A.EFFDT=C.EFFDT

  • Related Language Record for PCMP_COMP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID