AV_CP_PLDG_DTL

(SQL Table)
 Index Back

Pledge Detail

Contains all pledges in the system

  • Parent record: AV_SESSION_TBL

    • # 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    4 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Prompt Table: AV_PLEDGES_P_VW

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

    Default Value: AV_INSTALL_INST.BASE_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    7 PLDG_EFFDT Date(10) DATE Effective Date

    Default Value: %date

    8 PLEDGE_DT Date(10) DATE NOT NULL First Payment Date

    Default Value: %date

    9 FULF_DT Date(10) DATE NOT NULL Fulfillment Date
    10 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
    11 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    12 DESCRLONG Long Character CLOB Long Description