AV_PLEDGE_VW4

(SQL View)
Index Back

Add Pledge Entry


SELECT B.OPRID , A.BUSINESS_UNIT , A.INSTITUTION , A.SESSION_NO , A.GIFT_NO FROM PS_AV_PLEDGE_DTL A ,PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT

Prompt Table: AV_BUS_UNIT_TBL

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: AV_BUS_UNIT_TBL.INSTITUTION

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

Prompt Table: AV_SESS_P_O_VW

5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number

Default Value: NEW