AV_INVLV_CT_VW

(SQL View)
 Index Back

Involvement Category View

Involvement Category View

SELECT A.INVLV_TYPE_CD ,H.INVLV_CTGY_CD , B.INVLV_CD , B.DESCR FROM PS_AV_INVLV_CT_TBL A , PS_AV_INVLV_CD_TBL B ,PS_AV_INVLV_CC_TBL H WHERE A.INVLV_CD = B.INVLV_CD AND H.INVLV_CD=B.INVLV_CD AND A.INVLV_CD=H.INVLV_CD AND A.EFFDT=B.EFFDT AND H.EFFDT=B.EFFDT AND A.EFFDT=H.EFFDT AND B.EFFDT=( SELECT MAX(C.EFFDT) FROM PS_AV_INVLV_CD_TBL C WHERE B.INVLV_CD=C.INVLV_CD AND C.EFFDT <=%CurrentDateIn) AND B.EFF_STATUS <>'I'

  • Related Language Record: AV_INVLVCTVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INVLV_TYPE_CD Character(6) VARCHAR2(6) NOT NULL Involvement Type
    2 INVLV_CTGY_CD Character(6) VARCHAR2(6) NOT NULL Involvement Category
    3 INVLV_CD Character(6) VARCHAR2(6) NOT NULL Involvement Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description