PCMP_COMPPRODVW

(SQL View)
 Index Back

Prof Comp Company Products

Used in the Professional Compliance module. View of all active Products that a Company sells.

SELECT DISTINCT B.EMPLID ,B.EMPL_RCD ,B.COMPANY ,A.PCMP_PROD_TYPE ,A.PCMP_PRODUCT ,P.PCMP_PRODUCT_DESCR FROM PS_PCMP_COMPPRDEFF A ,PS_CURRENT_JOB_ALL B ,PS_PCMP_PRODUCT 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.EFFDT<= %CurrentDateIn AND 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: PCMP_CMPPRVWLNG

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