RUN_CNTL_PCMP2

(SQL Table)
Index Back

Prof Comp Compliance Plan

Used in the Professional Compliance module. Run control record for Company compliance plan report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
O=Specified Language
R=Recipient's Language
5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: PCMP_CMP_PLANVW

6 PCMP_CMP_PLANYR Number(4,0) SMALLINT NOT NULL Used in the Professional Compliance module. Contains the year for the company compliance plan.

Prompt Table: PCMP_CMPPLANVW2