AV_PP_ACC_VW

(SQL View)
 Index Back

Pldg Schd Recog Vw

Displays Pledge Payments by recognition

SELECT B.INSTITUTION , A.SESSION_NO , A.GIFT_NO , A.EXPECT_DT , B.EMPLID , B.EXT_ORG_ID , B.RECOGNITION_TYPE , A.FISCAL_YEAR , A.RCVD_DT , %Round(%DecMult(%DecDiv(A.RCVD_AMT , 100) , B.RECOGNITION_PCT ),2) , A.NTFY_FLG , A.GIFT_REF_NO , %Round(%DecMult(%DecDiv(A.EXPECT_AMT , 100) , B.RECOGNITION_PCT ),2) , 'EXP-PP' , A.CURRENCY_CD FROM PS_AV_PLDG_SCHD A , PS_AV_RECOGNITION B , PS_AV_PLEDGE_DTL C , PS_AV_SESSION_TBL D WHERE A.SESSION_NO = B.SESSION_NO AND C.SESSION_NO = B.SESSION_NO AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.GIFT_NO = B.GIFT_NO AND C.GIFT_NO = B.GIFT_NO AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.SESSION_NO = D.SESSION_NO AND C.ADJUSTMENT_FLG = 'N' AND D.SESS_STATUS = 'P'

  • Parent record: AV_PLEDGE_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    4 GIFT_DT Date(10) DATE Gift Date
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    7 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
    8 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    9 RCVD_DT Date(10) DATE Received Date
    10 RCVD_AMT_CALC Number(21,7) DECIMAL(20,7) NOT NULL Received Amount
    11 NTFY_FLG Character(1) VARCHAR2(1) NOT NULL Notification Sent

    Y/N Table Edit

    12 GIFT_REF_NO Character(11) VARCHAR2(11) NOT NULL Gift Reference Number
    13 RCG_DES_AMT_CALC Number(21,7) DECIMAL(20,7) NOT NULL Amount
    14 GIFT_TYPE Character(6) VARCHAR2(6) NOT NULL Gift Type
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code