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