AV_PLEDGE_VW5

(SQL View)
 Index Back

Update Pledge Adjustment


SELECT B.OPRID ,A.BUSINESS_UNIT ,A.INSTITUTION ,A.SESSION_NO ,A.GIFT_NO ,A.EMPLID ,A.EXT_ORG_ID 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 AND B.AV_SESS_TYPE = 'AP' AND B.SESS_STATUS = 'O'

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

5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID