AV_PLEDGE_VW2

(SQL View)
 Index Back

Pledge Detail View

Replica of AV_PLEDGE_DTL with no peoplecode. Used for new AV_ADJ_PLEDGE_SMRY panel. before 7.31.00 SELECT INSTITUTION, SESSION_NO, GIFT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, GIFT_AMT, CURRENCY_CD, PLDG_EFFDT, PLEDGE_DT, FULF_DT, PMT_SCHD, DATA_ENTRY_DT, PLEDGE_PMT_RCVD, LAST_PMT_DT, SEQ_NO, ADJUSTMENT_FLG, CP_PLEDGE_NO, FISCAL_YEAR, FEED_FLG, PMT_DTL_CHG, AV_PLDG_STATUS, PLEDGE_PG_TYPE, ACKN_FLG, DESCRLONG FROM PS_AV_PLEDGE_DTL

SELECT BUSINESS_UNIT, SESSION_NO, GIFT_NO, EMPLID, EXT_ORG_ID, SA_ID_TYPE, GIFT_AMT, CURRENCY_CD, PLDG_EFFDT, PLEDGE_DT, FULF_DT, PMT_SCHD, DATA_ENTRY_DT, PLEDGE_PMT_RCVD, LAST_PMT_DT, SEQ_NO, ADJUSTMENT_FLG, CP_PLEDGE_NO, FISCAL_YEAR, FEED_FLG, PMT_DTL_CHG, AV_PLDG_STATUS, PLEDGE_PG_TYPE, ACKN_FLG, INSTITUTION, DESCRLONG FROM PS_AV_PLEDGE_DTL

  • Related Language Record: AVPLEDGEVW2LNG

    • # 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
    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    6 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

    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 PLDG_EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    10 PLEDGE_DT Date(10) DATE First Payment Date
    11 FULF_DT Date(10) DATE Fulfillment 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
    14 PLEDGE_PMT_RCVD Number(16,2) DECIMAL(15,2) NOT NULL Payments Received
    15 LAST_PMT_DT Date(10) DATE Last Payment Date
    16 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    17 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    N=No
    Y=Yes
    18 CP_PLEDGE_NO Character(11) VARCHAR2(11) NOT NULL Conditional Pledge Nbr
    19 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    20 FEED_FLG Character(1) VARCHAR2(1) NOT NULL Feed Pledge
    N=No
    Y=Yes
    21 PMT_DTL_CHG Character(1) VARCHAR2(1) NOT NULL Payments Dtl Changed
    N=No
    Y=Yes
    22 AV_PLDG_STATUS Character(1) VARCHAR2(1) NOT NULL Pledge Status
    A=Active
    C=Closed
    W=Written Off
    23 PLEDGE_PG_TYPE Character(2) VARCHAR2(2) NOT NULL Planned Giving Type
    AT=Annuity Trust
    BQ=Bequest
    24 ACKN_FLG Character(1) VARCHAR2(1) NOT NULL Acknowledgement Flg
    25 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_SESSION_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    26 DESCRLONG Long Character CLOB Long Description