PCMP_TYPE

(SQL Table)
 Index Back

Professional Compliance Type

Used in the Professional Compliance module. Identifies the different types of professional compliance.

  • Related Language Record: PCMP_TYPE_LANG

  • Parent Record Of PCMP_CLASS_LANG PCMP_CLSSCOMLNG

    • # 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.
    3 PCMP_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Professional Compliance Type Description - Used in the Professional Compliance module. Description of professional compliance type.
    4 PCMP_NOTIFY_HIR Character(1) VARCHAR2(1) NOT NULL Used in the Professional Compliance module. Checkbox to determine whether notifcation is required when employee hired.
    N=No
    Y=Yes
    5 PCMP_NOTIFY_MESS_H Character(80) VARCHAR2(80) NOT NULL Used in the Professional Compliance module. Notification message.
    6 PCMP_NOTIFY_ACTN_H Character(80) VARCHAR2(80) NOT NULL Used in the Professional Compliance module. Notification action message.
    7 PCMP_NOTIFY_TIME_H Number(3,0) SMALLINT NOT NULL Used in the Professional Compliance module. Time limit for notification action in days.