PCMP_OBS_MOD_VW

(SQL View)
 Index Back

Prof Comp Observation Model Vw

Used in the Professional Compliance module. Observation model view.

SELECT A.SETID ,A.PCMP_OBS_MODEL ,A.PCMP_OBSMODEL_DESC ,A.EFFDT FROM PS_PCMP_OBS_MODEL A WHERE A.EFF_STATUS='A' AND A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_PCMP_OBS_MODEL B WHERE B.SETID=A.SETID AND B.PCMP_OBS_MODEL=A.PCMP_OBS_MODEL AND B.EFFDT<=%CurrentDateIn)

  • Related Language Record: PCMP_OBMODVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PCMP_OBS_MODEL Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Observation model name.
    3 PCMP_OBSMODEL_DESC Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Observation model description.
    4 EFFDT Date(10) DATE Effective Date