AVPLDGSESSVWLNG

(SQL View)
 Index Back

Pledge session view

View of all data elements for a pledge session from the av_pledge_dtl and av_session_tbl tables. 28 Mar 2000 - Added CURRENCY_CD to this view from PLEDGE_DTL

SELECT D.INSTITUTION , A.SESSION_NO , A.GIFT_NO , A.LANGUAGE_CD , A.DESCRLONG FROM PS_AVPLEDGEDTLLNG A ,PS_AV_PLEDGE_DTL D , PS_AV_SESSION_TBL B WHERE D.INSTITUTION=B.INSTITUTION AND A.SESSION_NO=B.SESSION_NO AND B.AV_SESS_TYPE IN ('PL' ,'AP') AND D.ADJUSTMENT_FLG='N' AND A.BUSINESS_UNIT=D.BUSINESS_UNIT AND A.SESSION_NO=D.SESSION_NO AND A.GIFT_NO=D.GIFT_NO

  • Related Language Record for AV_PLDG_SESS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESSION_TBL

    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Default Value: NEW

    Prompt Table: AV_PLEDGE_P_VW

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRLONG Long Character CLOB Long Description