VIEW: APPS.IGS_HE_ST_SPA

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)