INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SSR_HE_QUAL_TYPEPrompt Table: SSR_HE_QTDESCVW
SSR_HE_QOEMAPVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT b.institution ,b.ssr_he_qual_type ,a.descr ,a.ssr_he_descr254 ,b.ssr_he_active ,a.ssr_he_imported FROM ps_ssr_he_codes a , PS_SSR_HE_QOE_MAP b WHERE a.ssr_he_field='QUALTYPE' AND a.ssr_he_active='Y' AND a.ssr_he_code = b.ssr_he_qual_type |
| # | 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 | SSR_HE_QUAL_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Qualification Type
Prompt Table: SSR_HE_QTDESCVW |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SSR_HE_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 5 | SSR_HE_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL | Active |
| 6 | SSR_HE_IMPORTED | Character(1) | VARCHAR2(1) NOT NULL | Imported |