PCMP_COMPAUTHVW

(SQL View)
 Index Back

Prof Comp Company Regulation

Used in the Professional Compliance module. View of all Regulation Authorities for a Company.

SELECT DISTINCT B.EMPLID ,B.EMPL_RCD ,B.COMPANY ,A.PCMP_TYPE ,A.PCMP_REG_AUTH ,T.PCMP_REG_AUTH_DESC FROM PS_PCMP_COMP_REG A ,PS_CURRENT_JOB_ALL B ,PS_PCMP_REG_AUTH T WHERE A.COMPANY=B.COMPANY AND T.SETID=B.SETID_JOBCODE AND T.PCMP_TYPE=A.PCMP_TYPE AND T.PCMP_REG_AUTH=A.PCMP_REG_AUTH

  • Related Language Record: PCMP_CMAUTVWLNG

    • # 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    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 PCMP_REG_AUTH_DESC Character(40) VARCHAR2(40) NOT NULL Used in the Professional Compliance module. Regulatory Authority description.