PCMP_RI_REG_VW3

(SQL View)
Index Back

Prof Comp RI View

Used in the Professional Compliance module. View of Regulated Individuals.

SELECT A.EMPLID , A.PCMP_REG_AUTH , A.PCMP_TYPE , A.EMPL_RCD , A.BUSINESS_UNIT FROM PS_PCMP_RI A

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