PCMP_RGAUTHCLNG

(SQL Table)
Index Back

Prof Comp Reg Auth Comments

Used in the Professional Compliance module. Related language record for PCMP_RGAUTH_COM

  • Related Language Record for PCMP_RGAUTH_COM
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    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.

    Prompt Table: PCMP_TYPE

    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PCMP_REG_AUTH_COMM Long Character CLOB Used in the Professional Compliance module. Comments for the Regulated Authority