PCMP_REGAUTH_VW

(SQL View)
Index Back

Prof Comp Reg Auth View

Used in the Professional Compliance module. View of regulatory authorities without Business Unit as the set control field.

SELECT A.SETID ,A.PCMP_TYPE ,A.PCMP_REG_AUTH ,A.PCMP_REG_AUTH_DESC FROM PS_PCMP_REG_AUTH A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 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.
3 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.
4 PCMP_REG_AUTH_DESC Character(40) VARCHAR2(40) NOT NULL Used in the Professional Compliance module. Regulatory Authority description.