AV_ACCT_VW(SQL View) |
Index Back |
|---|---|
View of AV_ACCOUNT_TBLUsed as prompt table for designation field in ps_av_designation because we want to make this table dependent on the av_des_bu (the business unit that we make the designation to) that is chosen. ======================================================== Modified by JPM on 02/2001. I added two fields to this view AV_CASE_TYPE and AV_CASE_PRPS. These fields are needed for RCG_DES build process. ======================================================== |
| SELECT A.SETID , A.DESIGNATION , A.EFFDT , A.EFF_STATUS , A.AV_DES_NAME , A.AV_CASE_TYPE , A.AV_CASE_PRPS , A.AV_INST_TYPE 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | AV_DES_NAME | Character(30) | VARCHAR2(30) NOT NULL | Designation Name |
| 6 | AV_CASE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
CASE Type
C=Current Unrestricted E=Endowment & Similar L=Loan Funds N=Non-Gift P=Plant Funds R=Current Restricted |
| 7 | AV_CASE_PRPS | Character(4) | VARCHAR2(4) NOT NULL |
CASE Purpose
A=Financial Aid B=Land & Buildings C=Chairs E=Equipment F=Faculty/Staff Compen J=Student Projects L=Library M=Academic Divisions N=Non-Gift O=Other Restricted Purposes P=Prizes R=Research S=Special Programs T=Athletics U=Unrestricted X=Public Service & Ext |
| 8 | AV_INST_TYPE | Character(6) | VARCHAR2(6) NOT NULL | Designation Type |