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 |