PCMP_MGR_SUPER_IDPrompt Table: PERSON
PCMP_MGR_SUPERM=Manager
S=Supervisor
Default Value: S
PCMP_MGRSUP_SRC(SQL View) |
Index Back |
|---|---|
Prof Comp Mgr/SupervisorUsed in the Professional Compliance module. Search record for Managers/Supervisors that are used in the compliance process. |
| SELECT A.PCMP_MGR_SUPER_ID ,A.PCMP_MGR_SUPER ,B.NAME FROM PS_PCMP_MGR_SUPER A ,PS_PERSON_NAME B WHERE B.EMPLID=A.PCMP_MGR_SUPER_ID |
| # | 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |