INSTITUTIONINTV_CDY/N Table Edit
AV_INTV_RSRC_VW(SQL View) |
Index Back |
|---|---|
Initiative Resouces DefinedThis table will determine if there have been any Initiatives Resources defined for the given Initiative. It will return a 'Y' if records exist. |
| SELECT INSTITUTION, INTV_CD, 'Y' FROM PS_AV_INTV_TBL WHERE INTV_CD IN (SELECT A.INTV_CD FROM PS_AV_INTV_MANAGER A WHERE A.INSTITUTION = INSTITUTION AND A.INTV_CD = INTV_CD) OR INTV_CD IN (SELECT B.INTV_CD FROM PS_AV_INTV_STAFF B WHERE B.INSTITUTION = INSTITUTION AND B.INTV_CD = INTV_CD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | INTV_CD |
Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
| 3 | RESOURCES_DEFINED | Character(1) | VARCHAR2(1) NOT NULL |
Resources Defined
Y/N Table Edit |