View: IGS_HE_ST_SPA

View Text

SELECT A.ROWID ROW_ID
, A.HESA_ST_SPA_ID
, A.COURSE_CD
, A.VERSION_NUMBER
, A.PERSON_ID
, A.FE_STUDENT_MARKER
, A.DOMICILE_CD
, A.INST_LAST_ATTENDED
, A.YEAR_LEFT_LAST_INST
, A.HIGHEST_QUAL_ON_ENTRY
, A.DATE_QUAL_ON_ENTRY_CALC
, A.A_LEVEL_POINT_SCORE
, A.HIGHERS_POINTS_SCORES
, A.OCCUPATION_CODE
, A.COMMENCEMENT_DT
, A.SPECIAL_STUDENT
, A.STUDENT_QUAL_AIM
, A.STUDENT_FE_QUAL_AIM
, A.TEACHER_TRAIN_PROG_ID
, A.ITT_PHASE
, A.BILINGUAL_ITT_MARKER
, A.TEACHING_QUAL_GAIN_SECTOR
, A.TEACHING_QUAL_GAIN_SUBJ1
, A.TEACHING_QUAL_GAIN_SUBJ2
, A.TEACHING_QUAL_GAIN_SUBJ3
, 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
, A.NHS_FUNDING_SOURCE
, A.UFI_PLACE
, A.POSTCODE
, A.SOCIAL_CLASS_IND
, A.DESTINATION
, A.OCCCODE
, A.TOTAL_UCAS_TARIFF
, A.NHS_EMPLOYER
, A.RETURN_TYPE
, 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
, A .QUAL_AIM_SUBJ2
, A.QUAL_AIM_SUBJ3
, A.QUAL_AIM_PROPORTION
, A.DEPENDANTS_CD
, A.IMPLIED_FUND_RATE
, A.GOV_INITIATIVES_CD
, A.UNITS_FOR_QUAL
, A.DISADV_UPLIFT_ELIG_CD
, A.FRANCH_PARTNER_CD
, A.UNITS_COMPLETED
, A.FRANCH_OUT_ARR_CD
, A.EMPLOYER_ROLE_CD
, A.DISADV_UPLIFT_FACTOR
, A.ENH_FUND_ELIG_CD
, A.EXCLUDE_FLAG
FROM IGS_HE_ST_SPA_ALL A
WHERE NVL (ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns