RUN_CNTL_PCMP1

(SQL Table)
Index Back

Prof Comp Reassignment

Used in the Professional Compliance module. Run control record for the reassignment application engine programs.

# 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 PCMP_REASS_SEL Character(1) VARCHAR2(1) NOT NULL Used in the Professional Compliance module. Determines which reassignment selection is required - either reassigning regulated individuals or reassigning compliance supervisors.
R=Regulated Individuals
S=Compliance Supervisors

Default Value: R

4 PCMP_REASS_OPT Character(1) VARCHAR2(1) NOT NULL Used in the Professional Compliance module. Option flag indicating whether a single regulated individual is being reassigned, or all regulated individuals reporting to the given Emplid.
A=All Individuals
S=Single Individual

Default Value: S

5 PCMP_REASS_EMPLID Character(11) VARCHAR2(11) NOT NULL Used in the Professional Compliance module. Holds the EMPLID of the regulated individual or Manager/Supervisor that needs to be reassigned for the reassign application engine programs.

Prompt Table: %RECNAME_EDIT

6 PCMP_REASS_EMPREC Number(3,0) SMALLINT NOT NULL Used in the Professional Compliance module. Holds the employee record number for reassigning regulated individuals.
7 PCMP_TARGET_EMPLID Character(11) VARCHAR2(11) NOT NULL Used in the Professional Compliance module. Holds the EMPLID of the target Manager/Supervisor for the reassign application engine programs.

Prompt Table: %RECNAME_EDIT2

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.

Prompt Table: PCMP_RI_REG_VW2