PCMP_CMPRGVWLNG

(SQL View)
 Index Back

Prof Comp Reg Auth view

Used in the Professional Compliance module. Relate language view of regulatory authorities for a company.

SELECT A.COMPANY ,A.DEFAULT_SETID ,B.PCMP_TYPE ,B.PCMP_REG_AUTH ,B.LANGUAGE_CD ,B.PCMP_REG_AUTH_DESC FROM PS_COMPANY_TBL A ,PS_PCMP_RGAUTH_LNG B WHERE A.DEFAULT_SETID=B.SETID

  • Related Language Record for PCMP_COMPREG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default Set ID
    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 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.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 PCMP_REG_AUTH_DESC Character(40) VARCHAR2(40) NOT NULL Used in the Professional Compliance module. Regulatory Authority description.