PCMP_MGR_SUPER_IDPrompt Table: PERSON
PCMP_MGR_SUPERM=Manager
S=Supervisor
Default Value: S
Default Value: %date
PCMP_MGR_SUPER(SQL Table) |
Index Back |
|---|---|
Prof Comp Mgr/SupervisorUsed in the Professional Compliance module. Defines the Managers/Supervisors that are used in the compliance process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PCMP_MGR_SUPER_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Professional Compliance Manager/Supervisor ID - Used in the Professional Compliance module.
Holds the EMPLID of the Manager/Supervisor.
Prompt Table: PERSON |
| 2 | PCMP_MGR_SUPER |
Character(1) | VARCHAR2(1) NOT NULL |
Professional Compliance Manager/Supervisor - Used within the Professional Compliance module.
Identifies whether the role is that of a Manager, or a Supervisor.
M=Manager S=Supervisor Default Value: S |
| 3 | PCMP_ASSIGNED_DT | Date(10) | DATE |
Professional Compliance Assigned Date - Used within the Professional Compliance module.
Contains the date that a Manager/Supervisor was assignd in the compliance process.
Default Value: %date |