PCMP_CMPRTVWLNG

(SQL View)
 Index Back

Prof Comp Company Products

Used in the Professional Compliance module. Related language view of all active Product Types that a Company sells.

SELECT B.EMPLID ,B.EMPL_RCD ,B.COMPANY ,A.PCMP_PROD_TYPE ,PT.LANGUAGE_CD ,PT.PCMP_PRODTYP_DESCR FROM PS_PCMP_COMPPRDEFF A ,PS_CURRENT_JOB_ALL B ,PS_PCMP_PRODTYPLNG PT WHERE A.COMPANY=B.COMPANY AND A.EFF_STATUS='A' AND A.EFFDT=( SELECT MAX(C.EFFDT) FROM PS_PCMP_COMPPRDEFF C WHERE C.COMPANY=A.COMPANY AND C.PCMP_PROD_TYPE=A.PCMP_PROD_TYPE AND C.PCMP_PRODUCT=A.PCMP_PRODUCT) AND PT.SETID=B.SETID_JOBCODE AND PT.PCMP_PROD_TYPE=A.PCMP_PROD_TYPE

  • Related Language Record for PCMP_COMPPRDTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    4 PCMP_PROD_TYPE Character(6) VARCHAR2(6) NOT NULL Used in the Professional ompliance module. Prodtuct Type category.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 PCMP_PRODTYP_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Product type description.