View: IGS_HE_ST_SPA_DTLS_V

View Text

SELECT A.ROWID ROW_ID
, A.HESA_ST_SPA_ID
, A.COURSE_CD
, A.VERSION_NUMBER
, A.PERSON_ID
, B.PERSON_NUMBER
, B.PERSON_NAME
, A.FE_STUDENT_MARKER
, W.VALUE_DESCRIPTION FE_STUDENT_MARKER_DESC
, A.DOMICILE_CD
, C.VALUE_DESCRIPTION
, A.INST_LAST_ATTENDED
, A.YEAR_LEFT_LAST_INST
, A.A_LEVEL_POINT_SCORE
, A.HIGHERS_POINTS_SCORES
, A.OCCUPATION_CODE
, D.VALUE_DESCRIPTION
, A.OCCCODE
, A.COMMENCEMENT_DT
, A.SPECIAL_STUDENT
, E.VALUE_DESCRIPTION
, A.STUDENT_QUAL_AIM
, F.AWARD_TITLE
, A.STUDENT_FE_QUAL_AIM
, G.AWARD_TITLE
, A.TEACHER_TRAIN_PROG_ID
, H.VALUE_DESCRIPTION
, A.ITT_PHASE
, I.VALUE_DESCRIPTION
, A.BILINGUAL_ITT_MARKER
, J.VALUE_DESCRIPTION
, A.TEACHING_QUAL_GAIN_SECTOR
, K.VALUE_DESCRIPTION
, A.TEACHING_QUAL_GAIN_SUBJ1
, L.VALUE_DESCRIPTION
, A.TEACHING_QUAL_GAIN_SUBJ2
, M.VALUE_DESCRIPTION
, A.TEACHING_QUAL_GAIN_SUBJ3
, N.VALUE_DESCRIPTION
, A.STUDENT_INST_NUMBER
, A.HESA_RETURN_NAME
, A.HESA_RETURN_ID
, A.HESA_SUBMISSION_NAME
, A.ASSOCIATE_UCAS_NUMBER
, A.ASSOCIATE_SCOTT_CAND
, A.ASSOCIATE_TEACH_REF_NUM
, A.ASSOCIATE_NHS_REG_NUM
, A.ITT_PROG_OUTCOME
, O.VALUE_DESCRIPTION
, A.NHS_FUNDING_SOURCE
, P.VALUE_DESCRIPTION NHS_FUNDING_SOURCE_DESC
, A.UFI_PLACE
, Q.VALUE_DESCRIPTION
, A.POSTCODE
, A.SOCIAL_CLASS_IND
, R.VALUE_DESCRIPTION
, A.DESTINATION
, S.VALUE_DESCRIPTION
, A.HIGHEST_QUAL_ON_ENTRY
, X.FULL_GRADE_NAME
, A.DATE_QUAL_ON_ENTRY_CALC
, A.TOTAL_UCAS_TARIFF
, A.NHS_EMPLOYER
, U.VALUE_DESCRIPTION
, A.RETURN_TYPE
, V.MEANING
, A.CALCULATED_FTE
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.QUAL_AIM_SUBJ1
, SUB1.DESCRIPTION QUAL_AIM_SUBJ1_DESC
, A.QUAL_AIM_SUBJ2
, SUB2.DESCRIPTION QUAL_AIM_SUBJ2_DESC
, A.QUAL_AIM_SUBJ3
, SUB3.DESCRIPTION QUAL_AIM_SUBJ3_DESC
, A.QUAL_AIM_PROPORTION
, Y.VALUE_DESCRIPTION QUAL_AIM_PROPORTION_DESC
, A.DEPENDANTS_CD
, HC1.VALUE_DESCRIPTION DEPENDANTS_DESC
, A.IMPLIED_FUND_RATE
, A.GOV_INITIATIVES_CD
, HC2.VALUE_DESCRIPTION GOV_INITIATIVES_DESC
, A.UNITS_FOR_QUAL
, A.DISADV_UPLIFT_ELIG_CD
, HC3.VALUE_DESCRIPTION DISADV_UPLIFT_ELIG_DESC
, A.FRANCH_PARTNER_CD
, HC4.VALUE_DESCRIPTION FRANCH_PARTNER_DESC
, A.UNITS_COMPLETED
, A.FRANCH_OUT_ARR_CD
, HC5.VALUE_DESCRIPTION FRANCH_OUT_ARR_DESC
, A.EMPLOYER_ROLE_CD
, HC6.VALUE_DESCRIPTION EMPLOYER_ROLE_DESC
, A.DISADV_UPLIFT_FACTOR
, A.ENH_FUND_ELIG_CD
, HC7.VALUE_DESCRIPTION ENH_FUND_ELIG_DESC
, A.EXCLUDE_FLAG
FROM IGS_HE_ST_SPA A
, IGS_PE_PERSON B
, IGS_HE_CODE_VALUES C
, IGS_HE_CODE_VALUES D
, IGS_HE_CODE_VALUES E
, IGS_PS_AWD F
, IGS_PS_AWD G
, IGS_HE_CODE_VALUES H
, IGS_HE_CODE_VALUES I
, IGS_HE_CODE_VALUES J
, IGS_HE_CODE_VALUES K
, IGS_HE_CODE_VALUES L
, IGS_HE_CODE_VALUES M
, IGS_HE_CODE_VALUES N
, IGS_HE_CODE_VALUES O
, IGS_HE_CODE_VALUES P
, IGS_HE_CODE_VALUES Q
, IGS_HE_CODE_VALUES R
, IGS_HE_CODE_VALUES S
, IGS_HE_CODE_VALUES T
, IGS_HE_CODE_VALUES U
, IGS_LOOKUPS_VIEW V
, IGS_HE_CODE_VALUES W
, IGS_AS_GRD_SCH_GRADE_V X
, IGS_HE_CODE_VALUES Y
, IGS_PS_FLD_OF_STUDY SUB1
, IGS_PS_FLD_OF_STUDY SUB2
, IGS_PS_FLD_OF_STUDY SUB3
, IGS_HE_CODE_VALUES HC1
, IGS_HE_CODE_VALUES HC2
, IGS_HE_CODE_VALUES HC3
, IGS_HE_CODE_VALUES HC4
, IGS_HE_CODE_VALUES HC5
, IGS_HE_CODE_VALUES HC6
, IGS_HE_CODE_VALUES HC7
WHERE A.PERSON_ID = B.PERSON_ID AND C.CODE_TYPE (+) = 'OSS_DOM' AND C.VALUE (+) = A.DOMICILE_CD AND D.CODE_TYPE (+) = 'OSS_OCC'
AND D.VALUE (+) = A.OCCUPATION_CODE AND E.CODE_TYPE (+) = 'OSS_SPEC_STUD'
AND E.VALUE (+) = A.SPECIAL_STUDENT AND F.AWARD_CD (+) = A.STUDENT_QUAL_AIM AND G.AWARD_CD (+) = A.STUDENT_FE_QUAL_AIM AND H.CODE_TYPE (+) = 'OSS_TTCID'
AND H.VALUE (+) = A.TEACHER_TRAIN_PROG_ID AND I.CODE_TYPE (+) = 'OSS_ITTPHSC'
AND I.VALUE (+) = A.ITT_PHASE AND J.CODE_TYPE (+) = 'OSS_BITTM'
AND J.VALUE (+) = A.BILINGUAL_ITT_MARKER AND K.CODE_TYPE (+) = 'OSS_TQSEC'
AND K.VALUE (+) = A.TEACHING_QUAL_GAIN_SECTOR AND L.CODE_TYPE (+) = 'OSS_TQSUB123'
AND L.VALUE (+) = A.TEACHING_QUAL_GAIN_SUBJ1 AND M.CODE_TYPE (+) = 'OSS_TQSUB123'
AND M.VALUE (+) = A.TEACHING_QUAL_GAIN_SUBJ2 AND N.CODE_TYPE (+) = 'OSS_TQSUB123'
AND N.VALUE (+) = A.TEACHING_QUAL_GAIN_SUBJ3 AND O.CODE_TYPE (+) = 'OSS_OUTCOME'
AND O.VALUE (+) = A.ITT_PROG_OUTCOME AND P.CODE_TYPE (+) = 'OSS_NHS_FUSRC'
AND P.VALUE (+) = A.NHS_FUNDING_SOURCE AND Q.CODE_TYPE (+) = 'OSS_UFI_PLACE'
AND Q.VALUE (+) = A.UFI_PLACE AND R.CODE_TYPE (+) = 'OSS_SOC'
AND R.VALUE (+) = A.SOCIAL_CLASS_IND AND S.CODE_TYPE (+) = 'OSS_DEST'
AND S.VALUE (+) = A.DESTINATION
AND X.GRADE (+) = A.HIGHEST_QUAL_ON_ENTRY AND T.CODE_TYPE (+) = 'HESA_HIGH_QUAL_ON_ENT'
AND T.VALUE (+) = X.GRADING_SCHEMA_CD
AND U.VALUE(+) = A.NHS_EMPLOYER
AND U.CODE_TYPE(+)='OSS_NHS_EMPLOYER'
AND V.LOOKUP_TYPE(+)='IGS_HE_RED_RTN'
AND V.LOOKUP_CODE(+)=A.RETURN_TYPE AND W.VALUE(+)= A.FE_STUDENT_MARKER
AND W.CODE_TYPE(+)='OSS_FESTUMK'
AND SUB1.FIELD_OF_STUDY(+) = A.QUAL_AIM_SUBJ1
AND SUB2.FIELD_OF_STUDY(+) = A.QUAL_AIM_SUBJ2
AND SUB3.FIELD_OF_STUDY(+) = A.QUAL_AIM_SUBJ3
AND Y.CODE_TYPE(+) = 'OSS_PROPORTION'
AND Y.VALUE(+) = A.QUAL_AIM_PROPORTION
AND HC1.CODE_TYPE (+) = 'OSS_DEPEND'
AND HC1.VALUE (+) = A.DEPENDANTS_CD
AND HC2.CODE_TYPE (+) = 'OSS_GOVINIT'
AND HC2.VALUE (+) = A.GOV_INITIATIVES_CD
AND HC3.CODE_TYPE (+) = 'OSS_ELIDISUP'
AND HC3.VALUE (+) = A.DISADV_UPLIFT_ELIG_CD
AND HC4.CODE_TYPE (+) = 'OSS_FRANPART'
AND HC4.VALUE (+) = A.FRANCH_PARTNER_CD
AND HC5.CODE_TYPE (+) = 'OSS_FROUTARR'
AND HC5.VALUE (+) = A.FRANCH_OUT_ARR_CD
AND HC6.CODE_TYPE (+) = 'OSS_EMPROLE'
AND HC6.VALUE (+) = A.EMPLOYER_ROLE_CD
AND HC7.CODE_TYPE (+) = 'OSS_ELIGENFD'
AND HC7.VALUE (+) = A.ENH_FUND_ELIG_CD

Columns