SETIDDESIGNATIONEFFDTAV_ACCT_HIST_VW(SQL View) |
Index Back |
|---|---|
View of AV_ACCOUNT_TBLA simple view of AV_ACCOUNT_TBL, using AV_DES_BU as the set control field (rather than BUSINESS_UNIT, which is what AV_ACCOUNT_TBL is defined to use). This view is used to get designation names based on gift/pledge dates, rather than the current effective row for a designation. |
| SELECT A.SETID, A.DESIGNATION, A.EFFDT, A.AV_DES_NAME FROM PS_AV_ACCOUNT_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DESIGNATION |
Character(11) | VARCHAR2(11) NOT NULL | Designation |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | AV_DES_NAME | Character(30) | VARCHAR2(30) NOT NULL | Designation Name |