BUSINESS_UNITSESSION_NOGIFT_NOTRIBUTE_NOEMPLIDAV_TRIB_NTFY_VW(SQL View) |
Index Back |
|---|---|
Tribute Notify View |
| SELECT BUSINESS_UNIT ,SESSION_NO ,GIFT_NO ,TRIBUTE_NO ,EMPLID ,ADDRESS_TYPE ,INSTITUTION FROM PS_AV_TRIBUTE_NTFY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SESSION_NO |
Character(11) | VARCHAR2(11) NOT NULL | Session Nbr |
| 3 | GIFT_NO |
Character(11) | VARCHAR2(11) NOT NULL | Gift Nbr |
| 4 | TRIBUTE_NO |
Character(11) | VARCHAR2(11) NOT NULL | Tribute Nbr |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 7 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |