PCMP_PRODTYP_VW

(SQL View)
 Index Back

Prof Comp Prod Type view

Used in the Professional Compliance module. View of available Product Types for a company.

SELECT A.COMPANY ,A.DEFAULT_SETID ,B.PCMP_PROD_TYPE ,B.PCMP_PRODTYP_DESCR FROM PS_COMPANY_TBL A ,PS_PCMP_PROD_TYPE B WHERE A.DEFAULT_SETID=B.SETID

  • Related Language Record: PCMP_PRTYPVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default Set ID
    3 PCMP_PROD_TYPE Character(6) VARCHAR2(6) NOT NULL Used in the Professional ompliance module. Prodtuct Type category.

    Prompt Table: PCMP_PROD_TYPE

    4 PCMP_PRODTYP_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Product type description.