INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SSR_HE_CRSEID_PLANPrompt Table: SSR_HE_CRSLSTVW
SSR_HE_CROFRNBR_YRDefault Value: 1
Prompt Table: SSR_HE_CON_VW
SSR_HE_CRSE_VW(SQL View) |
Index Back |
|---|---|
Module HESA DataLists HESA data for courses. |
| SELECT institution , SSR_HE_CRSEID_PLAN ,SSR_HE_CROFRNBR_YR FROM %Table(ssr_he_crse) h WHERE EXISTS ( SELECT 'X' FROM %Table(crse_catalog) c WHERE c.crse_id=h.SSR_HE_CRSEID_PLAN AND c.eff_status='A') |
| # | 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_CRSEID_PLAN |
Character(10) | VARCHAR2(10) NOT NULL |
Course ID
Prompt Table: SSR_HE_CRSLSTVW |
| 3 | SSR_HE_CROFRNBR_YR |
Number(2,0) | SMALLINT NOT NULL |
Course Offering Nbr
Default Value: 1 Prompt Table: SSR_HE_CON_VW |