VIEW: APPS.IGSBV_PROGRAM_UK_STATISTICS

Source

View Text - Preformatted

SELECT prg.HESA_ST_PROG_ID HESA_STATS_PROGRAM_ID, prg.COURSE_CD PROGRAM_CODE, prg.VERSION_NUMBER PROGRAM_VERSION_NUMBER, prg.FE_PROGRAM_MARKER FE_PROGRAM_MARKER, prg.RETURN_TYPE HESA_RETURN_TYPE, prg.LOCATION_OF_STUDY LOCATION_OF_STUDY, prg.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME, prg.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APP_TO_FUNDING_COUNCIL, prg.FUNDABILITY FUNDABILITY_CODE, prg.FEE_BAND FEE_BAND, prg.NHS_FUNDING_SOURCE SOURCE_OF_DEPT_HEALTH_FUNDING, prg.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY, prg.OTHER_INST_PROV_TEACHING1 OTHER_INST_PROV_TEACHING1, prg.OTHER_INST_PROV_TEACHING2 OTHER_INST_PROV_TEACHING2, prg.PROP_NOT_TAUGHT PROP_NOT_TAUGHT_BY_THIS_INST, prg.PROP_TEACHING_IN_WELSH PROP_TAUGHT_IN_WELSH, prg.PROGRAM_CALC USE_PROGRAM_LEVEL_FOR_CALC, prg.FTE_INTENSITY FTE_INTENSITY, prg.TEACH_PERIOD_START_DT TEACHING_PERIOD_START_DATE, prg.TEACH_PERIOD_END_DT TEACHING_PERIOD_END_DATE, prg.TEACHER_TRAIN_PROG_ID TEACHER_TRAINING_PROGRAM_ID, prg.ITT_PHASE ITT_PHASE_SCOPE, prg.BILINGUAL_ITT_MARKER BILINGUAL_ITT_MARKER, prg.TEACHING_QUAL_SOUGHT_SECTOR TEACH_QUAL_SOUGHT_SECTOR, prg.TEACHING_QUAL_SOUGHT_SUBJ1 TEACH_QUAL_SOUGHT_SUBJ1, prg.TEACHING_QUAL_SOUGHT_SUBJ2 TEACH_QUAL_SOUGHT_SUBJ2, prg.TEACHING_QUAL_SOUGHT_SUBJ3 TEACH_QUAL_SOUGHT_SUBJ3, prg.IMPLIED_FUND_RATE IMPLIED_FUNDING_RATE, prg.GOV_INITIATIVES_CD GOVERNMENT_INITIATIVES_CODE, prg.UNITS_FOR_QUAL UNITS_TO_ACHIEVE_QUALIFICATION, prg.DISADV_UPLIFT_ELIG_CD DISADVANTAGE_UPLIFT_ELIG_CODE, prg.FRANCH_PARTNER_CD FRANCHISE_PARTNER_CODE, prg.FRANCH_OUT_ARR_CD FRANCHISE_OUT_ARRANGMNTS_CODE, prg.EXCLUDE_FLAG EXCLUDE_FLAG, prg.CREATED_BY CREATED_BY, prg.CREATION_DATE CREATION_DATE, prg.LAST_UPDATED_BY LAST_UPDATED_BY, prg.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_HE_ST_PROG_ALL prg WITH READ ONLY

View Text - HTML Formatted

SELECT PRG.HESA_ST_PROG_ID HESA_STATS_PROGRAM_ID
, PRG.COURSE_CD PROGRAM_CODE
, PRG.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, PRG.FE_PROGRAM_MARKER FE_PROGRAM_MARKER
, PRG.RETURN_TYPE HESA_RETURN_TYPE
, PRG.LOCATION_OF_STUDY LOCATION_OF_STUDY
, PRG.CREDIT_TRANSFER_SCHEME CREDIT_TRANSFER_SCHEME
, PRG.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APP_TO_FUNDING_COUNCIL
, PRG.FUNDABILITY FUNDABILITY_CODE
, PRG.FEE_BAND FEE_BAND
, PRG.NHS_FUNDING_SOURCE SOURCE_OF_DEPT_HEALTH_FUNDING
, PRG.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, PRG.OTHER_INST_PROV_TEACHING1 OTHER_INST_PROV_TEACHING1
, PRG.OTHER_INST_PROV_TEACHING2 OTHER_INST_PROV_TEACHING2
, PRG.PROP_NOT_TAUGHT PROP_NOT_TAUGHT_BY_THIS_INST
, PRG.PROP_TEACHING_IN_WELSH PROP_TAUGHT_IN_WELSH
, PRG.PROGRAM_CALC USE_PROGRAM_LEVEL_FOR_CALC
, PRG.FTE_INTENSITY FTE_INTENSITY
, PRG.TEACH_PERIOD_START_DT TEACHING_PERIOD_START_DATE
, PRG.TEACH_PERIOD_END_DT TEACHING_PERIOD_END_DATE
, PRG.TEACHER_TRAIN_PROG_ID TEACHER_TRAINING_PROGRAM_ID
, PRG.ITT_PHASE ITT_PHASE_SCOPE
, PRG.BILINGUAL_ITT_MARKER BILINGUAL_ITT_MARKER
, PRG.TEACHING_QUAL_SOUGHT_SECTOR TEACH_QUAL_SOUGHT_SECTOR
, PRG.TEACHING_QUAL_SOUGHT_SUBJ1 TEACH_QUAL_SOUGHT_SUBJ1
, PRG.TEACHING_QUAL_SOUGHT_SUBJ2 TEACH_QUAL_SOUGHT_SUBJ2
, PRG.TEACHING_QUAL_SOUGHT_SUBJ3 TEACH_QUAL_SOUGHT_SUBJ3
, PRG.IMPLIED_FUND_RATE IMPLIED_FUNDING_RATE
, PRG.GOV_INITIATIVES_CD GOVERNMENT_INITIATIVES_CODE
, PRG.UNITS_FOR_QUAL UNITS_TO_ACHIEVE_QUALIFICATION
, PRG.DISADV_UPLIFT_ELIG_CD DISADVANTAGE_UPLIFT_ELIG_CODE
, PRG.FRANCH_PARTNER_CD FRANCHISE_PARTNER_CODE
, PRG.FRANCH_OUT_ARR_CD FRANCHISE_OUT_ARRANGMNTS_CODE
, PRG.EXCLUDE_FLAG EXCLUDE_FLAG
, PRG.CREATED_BY CREATED_BY
, PRG.CREATION_DATE CREATION_DATE
, PRG.LAST_UPDATED_BY LAST_UPDATED_BY
, PRG.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_HE_ST_PROG_ALL PRG WITH READ ONLY