AV_PLDG_SEC_VW

(SQL View)
 Index Back

Pledge Detail VW

Used on the Open Pledge Register in Secured Mode

SELECT DISTINCT A.BUSINESS_UNIT , A.SESSION_NO , A.GIFT_NO , C.OPRID , A.EMPLID , A.EXT_ORG_ID , A.SA_ID_TYPE , A.GIFT_AMT , A.CURRENCY_CD , A.PLDG_EFFDT , A.PLEDGE_DT , A.FULF_DT , A.PMT_SCHD , A.DATA_ENTRY_DT , A.PLEDGE_PMT_RCVD , A.LAST_PMT_DT , A.SEQ_NO , A.ADJUSTMENT_FLG , A.CP_PLEDGE_NO , A.FISCAL_YEAR , A.FEED_FLG , A.PMT_DTL_CHG , A.AV_PLDG_STATUS , A.PLEDGE_PG_TYPE , A.ACKN_FLG , A.INSTITUTION FROM PS_AV_PLEDGE_DTL A , PS_AV_DESIGNATION B , PS_AV_SCRTY_BU_TBL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.AV_DES_BU = C.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND A.GIFT_NO = B.GIFT_NO

  • 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

    Prompt Table: AV_INST_BU_VW

    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

    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: AV_EXT_ORG_SRCH

    7 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

    8 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Gift Amount
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 PLDG_EFFDT Date(10) DATE Effective Date
    11 PLEDGE_DT Date(10) DATE NOT NULL First Payment Date

    Default Value: %date

    12 FULF_DT Date(10) DATE NOT NULL Fulfillment Date

    Default Value: %date

    13 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
    14 DATA_ENTRY_DT Date(10) DATE NOT NULL Data Entry Date

    Default Value: %date

    15 PLEDGE_PMT_RCVD Number(16,2) DECIMAL(15,2) NOT NULL Payments Received
    16 LAST_PMT_DT Date(10) DATE Last Payment Date
    17 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    18 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    N=No
    Y=Yes
    19 CP_PLEDGE_NO Character(11) VARCHAR2(11) NOT NULL Conditional Pledge Nbr
    20 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    21 FEED_FLG Character(1) VARCHAR2(1) NOT NULL Feed Pledge
    N=No
    Y=Yes
    22 PMT_DTL_CHG Character(1) VARCHAR2(1) NOT NULL Payments Dtl Changed
    N=No
    Y=Yes
    23 AV_PLDG_STATUS Character(1) VARCHAR2(1) NOT NULL Pledge Status
    A=Active
    C=Closed
    W=Written Off
    24 PLEDGE_PG_TYPE Character(2) VARCHAR2(2) NOT NULL Planned Giving Type
    AT=Annuity Trust
    BQ=Bequest
    25 ACKN_FLG Character(1) VARCHAR2(1) NOT NULL Acknowledgement Flg

    Y/N Table Edit

    Default Value: N

    26 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution