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)

  • Related Language Record: PERSON_NAME_LNG

    • # 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 Record
    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