PCMP_SSRIOBS_VW

(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.EMPL_RCD ,A.PCMP_TYPE ,A.PCMP_REG_AUTH ,A.PCMP_OBS_DT ,A.PCMP_OBS_MODEL ,A.PCMP_OBS_STATUS ,B.BUSINESS_UNIT FROM PS_PCMP_RI_OBS A , PS_PCMP_RI B WHERE A.PCMP_OBS_DT IS NOT NULL AND B.EMPLID=A.EMPLID AND B.EMPL_RCD=A.EMPL_RCD AND B.PCMP_TYPE=A.PCMP_TYPE AND B.PCMP_REG_AUTH=A.PCMP_REG_AUTH

  • 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    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 PCMP_OBS_DT Date(10) DATE NOT NULL Used in the Professional Compliance module. Observation date.
    6 PCMP_OBS_MODEL Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Observation model name.
    7 PCMP_OBS_STATUS Character(1) VARCHAR2(1) NOT NULL Used in the Professional Compliance module. Observation status.
    F=Fail
    P=Pass
    8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit