PCMP_RI_VW

(SQL View)
 Index Back

Prof Comp RI View

Used in the Professional Compliance module. View of Regulated Individuals not yet assigned to a compliance supervisor.

SELECT A.EMPLID ,A.EMPL_RCD ,B.NAME ,A.PCMP_TYPE ,A.PCMP_REG_AUTH ,A.BUSINESS_UNIT FROM PS_PCMP_RI A ,PS_PERSON_NAME B WHERE B.EMPLID=A.EMPLID AND NOT EXISTS ( SELECT PCMP_MGR_SUPER_ID FROM PS_PCMP_MGR_SUPER WHERE PCMP_MGR_SUPER_ID = A.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 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.
5 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.
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit