RUN_CNTL_PCMP1(SQL Table) |
Index Back |
---|---|
Prof Comp ReassignmentUsed 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 |