RUN_CNTL_PCMP4

(SQL Table)
Index Back

Prof Comp Dev Review

Used in the Professional Compliance module. Run control record for RI Development Review.

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PCMP_RIDEVRECVW

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 PCMP_TYPE Character(3) VARCHAR2(3) NOT NULL Professiona Compliance Type - Used in the Professional Compliance module. Identifies the different types of professional complianc within a company.
8 PCMP_REG_AUTH Character(10) VARCHAR2(10) NOT NULL Professional Compliance Regulatory Authority - Used within the Professional Compliance module. Identifies the body or organization that defines the rules/regulations that a company must apply to its individuals in order for them to become compliant/qualified in that particular field.
9 PCMP_CREATION_DT Date(10) DATE Used in the Professional Compliance module. Creation Date

Prompt Table: PCMP_RIDVRECVW2