AV_PLDG2_SRCH

(SQL View)
 Index Back

Pledge Detail VW

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

SELECT INSTITUTION , BUSINESS_UNIT , EMPLID , 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

    4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr