PCMP_CMPPLNLVW2

(SQL View)
 Index Back

Prof Comp Compliance Plan

Used in the Professional Compliance module. Company compliance plan.

SELECT A.COMPANY ,A.PCMP_CMP_PLANYR ,A.LANGUAGE_CD ,A.PCMP_CMP_PLANDESC FROM PS_PCMP_CMPPLANLNG A

  • Related Language Record for PCMP_CMPPLANVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 PCMP_CMP_PLANYR Number(4,0) SMALLINT NOT NULL Used in the Professional Compliance module. Contains the year for the company compliance plan.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PCMP_CMP_PLANDESC Character(40) VARCHAR2(40) NOT NULL Used in the Professional Compliance module. Description of company compliance plan.