VIEW: APPS.IGSBV_UK_PRG_OFR_OPT_UNIT_SETS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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