AV_PLDG3_SRCH

(SQL View)
 Index Back

Pledge Detail VW

Search view of AV_PLEDGE_DTL with emplid as a key. 7.27.00: SELECT INSTITUTION, EXT_ORG_ID, SESSION_NO, GIFT_NO FROM PS_AV_PLEDGE_DTL

SELECT INSTITUTION , BUSINESS_UNIT , EXT_ORG_ID , SESSION_NO , GIFT_NO FROM PS_AV_PLEDGE_DTL WHERE ADJUSTMENT_FLG = 'N'

  • 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
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT

    Prompt Table: AV_INST_BU_VW

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

    Prompt Table: AV_EXT_ORG_SRCH

    4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESSION_TBL

    5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr