BUSINESS_UNITSESSION_NOAV_EP_GSLOG_VW(SQL View) |
Index Back |
|---|---|
EPay Gift Sessn Trans Log ViewThis view will select from all Posted Gift / Adj Gift Sessions available on the AV_EP_TRANS_LOG record. |
| SELECT DISTINCT A.BUSINESS_UNIT ,A.SESSION_NO ,B.LAST_MOD_DT ,A.INSTITUTION FROM PS_AV_EP_TRANS_LOG 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 IN ('G','AG') |
| # | 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 | LAST_MOD_DT | Date(10) | DATE | Last Modification Date |
| 4 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |