INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTION_TBL
AV_AUDIENCEAV_AUDIENCE_VW1(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.INSTITUTION , A.AV_AUDIENCE , A.DESCR60 FROM PS_AV_AUDIENCE_TBL A , PS_AV_INITIATIVE B WHERE A.INSTITUTION = B.INSTITUTION AND A.AV_MBR_CRIT_TYP = 'P' AND A.AV_AUDIENCE = B.AV_AUDIENCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AV_AUDIENCE |
Character(10) | VARCHAR2(10) NOT NULL | Audience Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |