VIEW: APPS.IGSBV_ST_PROG_ATT_HESA_DETAILS

Source

View Text - Preformatted

SELECT spa.HESA_ST_SPA_ID HESA_STATS_SPA_ID, spa.PERSON_ID PERSON_ID, per.PARTY_NUMBER PERSON_NUMBER, spa.COURSE_CD PROGRAM_CODE, spa.VERSION_NUMBER PROGRAM_VERSION_NUMBER, spa.STUDENT_INST_NUMBER STUDENT_INSTANCE_NUMBER, spa.RETURN_TYPE HESA_RETURN_TYPE, spa.FE_STUDENT_MARKER FE_STUDENT_MARKER, spa.HIGHEST_QUAL_ON_ENTRY HIGHEST_QUAL_ON_ENTRY, spa.DATE_QUAL_ON_ENTRY_CALC UCAS_TARIFF_CALC_LAST_RUN_DATE, spa.TOTAL_UCAS_TARIFF TOTAL_UCAS_TARIFF, spa.COMMENCEMENT_DT COMMENCEMENT_DATE, spa.SPECIAL_STUDENT SPECIAL_STUDENT_CODE, spa.STUDENT_QUAL_AIM STUDENT_QUAL_AIM_AWD, spa.QUAL_AIM_SUBJ1 QUAL_AIM_SUBJ1, spa.QUAL_AIM_SUBJ2 QUAL_AIM_SUBJ2, spa.QUAL_AIM_SUBJ3 QUAL_AIM_SUBJ3, spa.QUAL_AIM_PROPORTION QUAL_AIM_PROPORTION, spa.STUDENT_FE_QUAL_AIM STUDENT_FE_QUAL_AIM_AWD, spa.UFI_PLACE UFI_PLACE, spa.POSTCODE POSTCODE, spa.SOCIAL_CLASS_IND SOCIAL_CLASS_CODE, spa.OCCCODE PRE_2000_PARENTAL_OCCCODE, spa.OCCUPATION_CODE OCCUPATION_CODE, spa.DOMICILE_CD DOMICILE_CODE, spa.DESTINATION DESTINATION, spa.NHS_FUNDING_SOURCE SOURCE_OF_DH_FUNDING, spa.NHS_EMPLOYER NHS_EMPLOYER, spa.ASSOCIATE_UCAS_NUMBER ASSOCIATE_UCAS_NUMBER, spa.ASSOCIATE_SCOTT_CAND ASSOCIATE_SCOTT_CAND_NUMBER, spa.ASSOCIATE_TEACH_REF_NUM ASSOCIATE_TEACHER_REF_NUMBER, spa.ASSOCIATE_NHS_REG_NUM ASSOCIATE_REG_BODY_REF_NUMBER, spa.TEACHER_TRAIN_PROG_ID TEACHER_TRAINING_COURSE_ID, spa.ITT_PHASE ITT_PHASE_SCOPE, spa.BILINGUAL_ITT_MARKER BILINGUAL_ITT_MARKER, spa.TEACHING_QUAL_GAIN_SECTOR TEACHING_QUAL_GAIN_SECTOR, spa.TEACHING_QUAL_GAIN_SUBJ1 TEACHING_QUAL_GAIN_SUBJ1, spa.TEACHING_QUAL_GAIN_SUBJ2 TEACHING_QUAL_GAIN_SUBJ2, spa.TEACHING_QUAL_GAIN_SUBJ3 TEACHING_QUAL_GAIN_SUBJ3, spa.ITT_PROG_OUTCOME ITT_PROG_OUTCOME, spa.HESA_SUBMISSION_NAME HESA_SUBMISSION_NAME, spa.HESA_RETURN_NAME HESA_RETURN_NAME, spa.HESA_RETURN_ID HESA_RETURN_ID, spa.DEPENDANTS_CD DEPENDANTS_CODE, spa.IMPLIED_FUND_RATE IMPLIED_FUNDING_RATE, spa.GOV_INITIATIVES_CD GOVERNMENT_INITIATIVES_CODE, spa.UNITS_FOR_QUAL UNITS_TO_ACHIEVE_QUALIFICATION, spa.DISADV_UPLIFT_ELIG_CD DISADV_UPLIFT_ELIG_CODE, spa.FRANCH_PARTNER_CD FRANCHISE_PARTNER_CODE, spa.UNITS_COMPLETED UNITS_COMPLETED, spa.FRANCH_OUT_ARR_CD FRANCHISED_OUT_ARRANGMNTS_CODE, spa.EMPLOYER_ROLE_CD EMPLOYER_ROLE_CODE, spa.DISADV_UPLIFT_FACTOR DISADVANTAGE_UPLIFT_FACTOR, spa.ENH_FUND_ELIG_CD ENHANCED_FUNDING_ELIG_CODE, spa.EXCLUDE_FLAG EXCLUDE_FLAG, spa.CREATION_DATE CREATION_DATE, spa.CREATED_BY CREATED_BY, spa.LAST_UPDATE_DATE LAST_UPDATE_DATE, spa.LAST_UPDATED_BY LAST_UPDATED_BY FROM IGS_HE_ST_SPA_ALL spa, HZ_PARTIES per WHERE per.PARTY_ID = spa.PERSON_ID WITH READ ONLY

View Text - HTML Formatted

SELECT SPA.HESA_ST_SPA_ID HESA_STATS_SPA_ID
, SPA.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, SPA.COURSE_CD PROGRAM_CODE
, SPA.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, SPA.STUDENT_INST_NUMBER STUDENT_INSTANCE_NUMBER
, SPA.RETURN_TYPE HESA_RETURN_TYPE
, SPA.FE_STUDENT_MARKER FE_STUDENT_MARKER
, SPA.HIGHEST_QUAL_ON_ENTRY HIGHEST_QUAL_ON_ENTRY
, SPA.DATE_QUAL_ON_ENTRY_CALC UCAS_TARIFF_CALC_LAST_RUN_DATE
, SPA.TOTAL_UCAS_TARIFF TOTAL_UCAS_TARIFF
, SPA.COMMENCEMENT_DT COMMENCEMENT_DATE
, SPA.SPECIAL_STUDENT SPECIAL_STUDENT_CODE
, SPA.STUDENT_QUAL_AIM STUDENT_QUAL_AIM_AWD
, SPA.QUAL_AIM_SUBJ1 QUAL_AIM_SUBJ1
, SPA.QUAL_AIM_SUBJ2 QUAL_AIM_SUBJ2
, SPA.QUAL_AIM_SUBJ3 QUAL_AIM_SUBJ3
, SPA.QUAL_AIM_PROPORTION QUAL_AIM_PROPORTION
, SPA.STUDENT_FE_QUAL_AIM STUDENT_FE_QUAL_AIM_AWD
, SPA.UFI_PLACE UFI_PLACE
, SPA.POSTCODE POSTCODE
, SPA.SOCIAL_CLASS_IND SOCIAL_CLASS_CODE
, SPA.OCCCODE PRE_2000_PARENTAL_OCCCODE
, SPA.OCCUPATION_CODE OCCUPATION_CODE
, SPA.DOMICILE_CD DOMICILE_CODE
, SPA.DESTINATION DESTINATION
, SPA.NHS_FUNDING_SOURCE SOURCE_OF_DH_FUNDING
, SPA.NHS_EMPLOYER NHS_EMPLOYER
, SPA.ASSOCIATE_UCAS_NUMBER ASSOCIATE_UCAS_NUMBER
, SPA.ASSOCIATE_SCOTT_CAND ASSOCIATE_SCOTT_CAND_NUMBER
, SPA.ASSOCIATE_TEACH_REF_NUM ASSOCIATE_TEACHER_REF_NUMBER
, SPA.ASSOCIATE_NHS_REG_NUM ASSOCIATE_REG_BODY_REF_NUMBER
, SPA.TEACHER_TRAIN_PROG_ID TEACHER_TRAINING_COURSE_ID
, SPA.ITT_PHASE ITT_PHASE_SCOPE
, SPA.BILINGUAL_ITT_MARKER BILINGUAL_ITT_MARKER
, SPA.TEACHING_QUAL_GAIN_SECTOR TEACHING_QUAL_GAIN_SECTOR
, SPA.TEACHING_QUAL_GAIN_SUBJ1 TEACHING_QUAL_GAIN_SUBJ1
, SPA.TEACHING_QUAL_GAIN_SUBJ2 TEACHING_QUAL_GAIN_SUBJ2
, SPA.TEACHING_QUAL_GAIN_SUBJ3 TEACHING_QUAL_GAIN_SUBJ3
, SPA.ITT_PROG_OUTCOME ITT_PROG_OUTCOME
, SPA.HESA_SUBMISSION_NAME HESA_SUBMISSION_NAME
, SPA.HESA_RETURN_NAME HESA_RETURN_NAME
, SPA.HESA_RETURN_ID HESA_RETURN_ID
, SPA.DEPENDANTS_CD DEPENDANTS_CODE
, SPA.IMPLIED_FUND_RATE IMPLIED_FUNDING_RATE
, SPA.GOV_INITIATIVES_CD GOVERNMENT_INITIATIVES_CODE
, SPA.UNITS_FOR_QUAL UNITS_TO_ACHIEVE_QUALIFICATION
, SPA.DISADV_UPLIFT_ELIG_CD DISADV_UPLIFT_ELIG_CODE
, SPA.FRANCH_PARTNER_CD FRANCHISE_PARTNER_CODE
, SPA.UNITS_COMPLETED UNITS_COMPLETED
, SPA.FRANCH_OUT_ARR_CD FRANCHISED_OUT_ARRANGMNTS_CODE
, SPA.EMPLOYER_ROLE_CD EMPLOYER_ROLE_CODE
, SPA.DISADV_UPLIFT_FACTOR DISADVANTAGE_UPLIFT_FACTOR
, SPA.ENH_FUND_ELIG_CD ENHANCED_FUNDING_ELIG_CODE
, SPA.EXCLUDE_FLAG EXCLUDE_FLAG
, SPA.CREATION_DATE CREATION_DATE
, SPA.CREATED_BY CREATED_BY
, SPA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SPA.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_HE_ST_SPA_ALL SPA
, HZ_PARTIES PER
WHERE PER.PARTY_ID = SPA.PERSON_ID WITH READ ONLY