RUN_CNTL_PCMP3

(SQL Table)
 Index Back

Prof Comp RI Observation

Used in the Professional Compliance module. Contains details of a regulated individual observation within the compliance process.

  • Parent record: PCMP_RI_CLASS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
    O=Specified Language
    R=Recipient's Language
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PCMP_RI_OBS_VW

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    7 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.
    8 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.
    9 PCMP_OBS_DT Date(10) DATE Used in the Professional Compliance module. Observation date.

    Prompt Table: PCMP_RI_OBS_VW2

    10 PCMP_OBS_MODEL Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Observation model name.