PCMP_OBMODVWLNG

(SQL View)
 Index Back

Prof Comp Observation Model Vw

Used in the Professional Compliance module. Related language observation model view.

SELECT A.SETID ,A.PCMP_OBS_MODEL ,B.LANGUAGE_CD ,B.PCMP_OBSMODEL_DESC FROM PS_PCMP_OBS_MODEL A , PS_PCMP_OBSMOD_LNG B WHERE A.EFFDT<=%CurrentDateIn AND A.EFF_STATUS='A' AND A.SETID=B.SETID AND A.PCMP_OBS_MODEL=B.PCMP_OBS_MODEL

  • Related Language Record for PCMP_OBS_MOD_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PCMP_OBSMODEL_DESC Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Observation model description.