AV_INVLVCTVWLNG

(SQL View)
 Index Back

Involvement Category View

Involvement Category View

SELECT A.INVLV_TYPE_CD ,H.INVLV_CTGY_CD , B.INVLV_CD ,B.LANGUAGE_CD , B.DESCR FROM PS_AV_INVLV_CT_TBL A ,PS_AV_INVLV_CC_TBL H , PS_AV_INVLV_CD_LNG B 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_LNG C WHERE B.INVLV_CD = C.INVLV_CD AND C.EFFDT <= %CurrentDateIn)

  • Related Language Record for AV_INVLV_CT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description