Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base View for UK Statistics Program Details |
Implementation/DBA Data: | Not implemented in this database |
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