PCMP_CMP_PLANA

(SQL Table)
Index Back

Prof Comp Compliance Plan Area

Used in the Professional Compliance module. Company compliance plan area.

  • Related Language Record: PCMP_CMPPLNALNG
  • # 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 PCMP_CMP_PLANSEQ Number(3,0) SMALLINT NOT NULL Used in the Professional Compliance module. Sequence number of compliance plan area.
    4 PCMP_CMP_PLANAREA Character(40) VARCHAR2(40) NOT NULL Used in the Professional Compliance module. Plan area for company compliance plan.
    5 PCMP_CMP_PLANNOTES Long Character CLOB Used in the Professional Compliance module. Notes relevant to a compliance plan area.