AV_PLEDGE_P_VW

(SQL View)
 Index Back

Posted Pledge Detail

Returns all non adjustment pledges that have been posted. Used as a prompt for Pledge No on AV_ADJ_PLEDGE before 7.31.00 SELECT A.INSTITUTION, A.GIFT_NO, A.EMPLID, A.EXT_ORG_ID, A.PLDG_EFFDT, A.GIFT_AMT, A.CURRENCY_CD, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT, A.FULF_DT, A.PMT_SCHD, A.DATA_ENTRY_DT FROM PS_AV_PLEDGE_DTL A, PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P' AND A.ADJUSTMENT_FLG = 'N'

SELECT A.BUSINESS_UNIT, A.GIFT_NO, A.EMPLID, A.EXT_ORG_ID, A.INSTITUTION, A.PLDG_EFFDT, A.GIFT_AMT, A.CURRENCY_CD, A.PLEDGE_PMT_RCVD, A.LAST_PMT_DT, A.FULF_DT, A.PMT_SCHD, A.DATA_ENTRY_DT FROM PS_AV_PLEDGE_DTL A, PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P' AND A.ADJUSTMENT_FLG = 'N'

  • Parent record: AV_SESSION_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PLEDGE_GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    6 PLDG_EFFDT Date(10) DATE Effective Date
    7 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Gift Amount
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    9 PLEDGE_PMT_RCVD Number(16,2) DECIMAL(15,2) NOT NULL Payments Received
    10 LAST_PMT_DT Date(10) DATE Last Payment Date
    11 FULF_DT Date(10) DATE NOT NULL Fulfillment Date

    Default Value: %date

    12 PMT_SCHD Character(2) VARCHAR2(2) NOT NULL Payment Schedule
    A=Annual
    BM=Bi-Monthly
    I=Irregular
    M=Monthly
    Q=Quarterly
    SA=Semi-Annually
    W=Weekly
    13 DATA_ENTRY_DT Date(10) DATE NOT NULL Data Entry Date

    Default Value: %date