PCMP_RI_OBS_VW2

(SQL View)
 Index Back

Prof Comp RI Observation

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

SELECT A.EMPLID ,A.PCMP_OBS_DT ,A.EMPL_RCD ,A.PCMP_TYPE ,A.PCMP_REG_AUTH ,A.PCMP_OBS_MODEL FROM PS_PCMP_RI_OBS A

  • Parent record: PCMP_RI_CLASS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PCMP_OBS_DT Date(10) DATE NOT NULL Used in the Professional Compliance module. Observation date.
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    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_OBS_MODEL Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Observation model name.