PCMP_CMPPRVWLNG

(SQL View)
 Index Back

Prof Comp Company Products

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

SELECT B.EMPLID ,B.EMPL_RCD ,B.COMPANY ,A.PCMP_PROD_TYPE ,A.PCMP_PRODUCT ,P.LANGUAGE_CD ,P.PCMP_PRODUCT_DESCR FROM PS_PCMP_COMPPRDEFF A ,PS_CURRENT_JOB_ALL B ,PS_PCMP_PROD_LNG P 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 P.SETID=B.SETID_JOBCODE AND P.PCMP_PROD_TYPE=A.PCMP_PROD_TYPE AND P.PCMP_PRODUCT=A.PCMP_PRODUCT

  • Related Language Record for PCMP_COMPPRODVW

    • # 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 Rcd Nbr
    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 PCMP_PRODUCT Character(6) VARCHAR2(6) NOT NULL Used in the Professional Compliance module. Product that a Company sells.
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 PCMP_PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Product description.