SSR_HE_INTN_VW(SQL View) |
Index Back |
---|---|
HESA Institution DataHESA Institution Data View |
SELECT i.institution , descr FROM %Table(Ssr_he_intn) i , %Table(institution_tbl) t WHERE i.institution = t.institution |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |