AV_PLDG_SESS_VW

(SQL View)
 Index Back

Pledge session view

View of all data elements for a pledge session from the av_pledge_dtl and av_session_tbl tables. 28 Mar 2000 - Added CURRENCY_CD to this view from PLEDGE_DTL

SELECT A.INSTITUTION , A.SESSION_NO , A.GIFT_NO , 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 , B.AV_SESS_TYPE , B.OPRID , B.SESS_STATUS , B.BAL_DT , B.AV_POST_DT , B.ACTL_TTL_AMT , B.ACTL_TTL_CNT , B.ORIG_OPRID , B.LAST_MOD_DT , B.AV_OPEN_DT , A.DESCRLONG FROM PS_AV_PLEDGE_DTL A , PS_AV_SESSION_TBL B WHERE A.INSTITUTION=B.INSTITUTION AND A.SESSION_NO=B.SESSION_NO AND B.AV_SESS_TYPE IN ('PL' ,'AP') AND A.ADJUSTMENT_FLG='N'

  • Related Language Record: AVPLDGSESSVWLNG

    • # 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 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

    Prompt Table: AV_PLEDGE_P_VW

    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

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

    Prompt Table: AV_EXT_ORG_SRCH

    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
    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

    Default Value: %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

    Default Value: 1

    17 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Adjusted Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    18 CP_PLEDGE_NO Character(11) VARCHAR2(11) NOT NULL Conditional Pledge Nbr

    Prompt Table: AV_CP_PLDG_VW2

    19 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    20 AV_SESS_TYPE Character(2) VARCHAR2(2) NOT NULL Session Type
    AG=Gift Adjustment
    AM=Adjust Membership
    AP=Pledge Adjustment
    G=Gift
    M=Membership
    PL=Pledge
    21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    22 SESS_STATUS Character(1) VARCHAR2(1) NOT NULL Session Status
    B=Balanced
    O=Open
    P=Posted
    Q=Queued
    S=Suspense
    23 BAL_DT Date(10) DATE Balance Date
    24 AV_POST_DT Date(10) DATE Post Date
    25 ACTL_TTL_AMT Number(16,2) DECIMAL(15,2) NOT NULL Actual Total Amount
    26 ACTL_TTL_CNT Number(5,0) INTEGER NOT NULL Actual Total Count
    27 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    28 LAST_MOD_DT Date(10) DATE Last Modification Date
    29 AV_OPEN_DT Date(10) DATE Date Opened
    30 DESCRLONG Long Character CLOB Long Description