[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base View for Program Offering Option Unit Set HESA Details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT POO.HESA_POOUS_ID HESA_POOUS_ID
, POO.COURSE_CD PROGRAM_CODE
, POO.CRV_VERSION_NUMBER PROGRAM_VERSION_NUMBER
, POO.CAL_TYPE CALENDAR_TYPE
, POO.LOCATION_CD LOCATION_CODE
, POO.ATTENDANCE_MODE ATTENDANCE_MODE
, POO.ATTENDANCE_TYPE ATTENDANCE_TYPE
, POO.UNIT_SET_CD UNIT_SET_CODE
, POO.US_VERSION_NUMBER UNIT_SET_ABBREVIATION
, POO.LOCATION_OF_STUDY LOCATION_OF_STUDY
, POO.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APP_TO_FUNDING_COUNCIL
, POO.FUNDABILITY_CD FUNDABILITY_CODE
, POO.FEE_BAND FEE_BAND
, POO.FUNDING_SOURCE MAJOR_SOURCE_OF_FUNDING
, POO.MODE_OF_STUDY MODE_OF_STUDY
, POO.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, POO.TYPE_OF_YEAR TYPE_PROGRAM_YEAR
, POO.LENG_CURRENT_YEAR LENGTH_PROGRAM_YEAR
, POO.GRADING_SCHEMA_CD GRADING_SCHEMA_CODE
, POO.GS_VERSION_NUMBER GRADING_SCHEMA_VERSION
, POO.CREDIT_VALUE_YOP1 YOP_CREDIT_VALUE_1
, POO.LEVEL_CREDIT1 LEVEL_CREDIT_1
, POO.CREDIT_VALUE_YOP2 YOP_CREDIT_VALUE_2
, POO.LEVEL_CREDIT2 LEVEL_CREDIT_2
, POO.CREDIT_VALUE_YOP3 YOP_CREDIT_VALUE_3
, POO.LEVEL_CREDIT3 LEVEL_CREDIT_3
, POO.CREDIT_VALUE_YOP4 YOP_CREDIT_VALUE_4
, POO.LEVEL_CREDIT4 LEVEL_CREDIT_4
, POO.OTHER_INSTIT_TEACH1 OTHER_INST_PROV_TEACHING1
, POO.OTHER_INSTIT_TEACH2 OTHER_INST_PROV_TEACHING2
, POO.PROP_NOT_TAUGHT PROP_NOT_TAUGHT_BY_THIS_INST
, POO.UFI_PLACE UFI_PLACE
, POO.FTE_INTENSITY FTE_INTENSITY
, POO.FTE_CALC_TYPE FTE_CALC_TYPE
, POO.TEACH_PERIOD_START_DT TEACHING_PERIOD_START_DATE
, POO.TEACH_PERIOD_END_DT TEACHING_PERIOD_END_DATE
, POO.CREATED_BY CREATED_BY
, POO.CREATION_DATE CREATION_DATE
, POO.LAST_UPDATED_BY LAST_UPDATED_BY
, POO.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_POOUS_ALL POO WITH READ ONLY