PCMP_MGR_SUPER_IDPCMP_MGR_SUPERM=Manager
S=Supervisor
EMPLIDPrompt Table: %RECNAME_EDIT
EMPL_RCDPCMP_TYPEPCMP_REG_AUTHPrompt Table: PCMP_RI_REG_VW
Default Value: %date
A=Active
I=Inactive
Default Value: A
PCMP_MGRSUPRIVW(SQL View) |
Index Back |
|---|---|
Prof Comp Mgr/Super RIUsed in the Professional Compliance module. Contains a list of regulated individuals assigned to a manager/supervisor. |
| SELECT PCMP_MGR_SUPER_ID , PCMP_MGR_SUPER , EMPLID , EMPL_RCD , PCMP_TYPE , PCMP_REG_AUTH , PCMP_ASSIGNED_DT , PCMP_RI_STATUS , BUSINESS_UNIT FROM PS_PCMP_MGRSUP_RI A WHERE PCMP_ASSIGNED_DT = ( SELECT MAX(PCMP_ASSIGNED_DT) FROM PS_PCMP_MGRSUP_RI B WHERE A.PCMP_MGR_SUPER_ID = B.PCMP_MGR_SUPER_ID AND A.PCMP_MGR_SUPER = B.PCMP_MGR_SUPER AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.PCMP_TYPE = B.PCMP_TYPE AND A.PCMP_REG_AUTH = B.PCMP_REG_AUTH) |
| # | 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. |
| 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 |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %RECNAME_EDIT |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 5 | 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. |
| 6 | 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_VW |
| 7 | 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 |
| 8 | PCMP_RI_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Professional Compliance Regulated Individual Status - Used in the Professional Compliance module.
Defines whether the individual is active/inactive within the compliance process.
A=Active I=Inactive Default Value: A |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |