SETIDDESIGNATIONEFFDTAV_ACCT_PLDG_VW(SQL View) |
Index Back |
|---|---|
View of AV_ACCOUNT_TBLThis view is used to get the related display field, AV_DES_NAME, for the Open Pledge Summary panel. |
| SELECT A.SETID, A.DESIGNATION, A.EFFDT, A.AV_DES_NAME FROM PS_AV_ACCOUNT_TBL A, PS_AV_DESIGNATION B, PS_AV_PLEDGE_DTL C WHERE C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.SESSION_NO = B.SESSION_NO AND C.GIFT_NO = B.GIFT_NO AND A.DESIGNATION = B.DESIGNATION AND A.EFFDT = (SELECT MAX(A1.EFFDT) FROM PS_AV_ACCOUNT_TBL A1 WHERE A1.SETID = A.SETID AND A1.DESIGNATION = A.DESIGNATION AND A1.EFFDT<= C.DATA_ENTRY_DT) |
| # | 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 |