AV_GIFT_DTL_VW4(SQL View) |
Index Back |
---|---|
Add Gift Entry |
SELECT A.BUSINESS_UNIT , A.INSTITUTION , A.SESSION_NO , A.GIFT_NO FROM PS_AV_GIFT_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 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT Prompt Table: AV_BUS_UNIT_TBL |
|
2 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_BUS_UNIT_TBL.INSTITUTION |
|
3 | Character(11) | VARCHAR2(11) NOT NULL |
Session Nbr
Prompt Table: AV_SESS_OG_VW |
|
4 | Character(11) | VARCHAR2(11) NOT NULL |
Gift Nbr
Default Value: NEW |