View: IGS_HE_ST_PRG_DTLS_V

View Text

SELECT A.ROWID ROW_ID
, A.HESA_ST_PROG_ID
, A.COURSE_CD
, B.SHORT_TITLE
, A.VERSION_NUMBER
, A.TEACHER_TRAIN_PROG_ID
, C.VALUE_DESCRIPTION TEACHER_TRAIN_PROG_DESC
, A.ITT_PHASE
, D.VALUE_DESCRIPTION ITT_PHASE_DESC
, A.BILINGUAL_ITT_MARKER
, E.VALUE_DESCRIPTION BILINGUAL_ITT_MARKER_DESC
, A.TEACHING_QUAL_SOUGHT_SECTOR
, F.VALUE_DESCRIPTION TEACH_QUAL_SOUGHT_SECT_DESC
, A.TEACHING_QUAL_SOUGHT_SUBJ1
, G.VALUE_DESCRIPTION TEACH_QUAL_SOUGHT_SUBJ1_DESC
, A.TEACHING_QUAL_SOUGHT_SUBJ2
, H.VALUE_DESCRIPTION TEACH_QUAL_SOUGHT_SUBJ2_DESC
, A.TEACHING_QUAL_SOUGHT_SUBJ3
, I.VALUE_DESCRIPTION TEACH_QUAL_SOUGHT_SUBJ3_DESC
, A.LOCATION_OF_STUDY
, J.VALUE_DESCRIPTION LOCATION_OF_STUDY_DESC
, A.OTHER_INST_PROV_TEACHING1
, K.NAME OTHER_INST_PROV_TEACHING1_DESC
, A.OTHER_INST_PROV_TEACHING2
, L.NAME OTHER_INST_PROV_TEACHING2_DESC
, A.PROP_TEACHING_IN_WELSH
, A.PROP_NOT_TAUGHT
, A.CREDIT_TRANSFER_SCHEME
, M.VALUE_DESCRIPTION CREDIT_TRANSFER_SCHEME_DESC
, A.RETURN_TYPE
, S.MEANING RETURN_TYPE_DESC
, A.DEFAULT_AWARD
, A.PROGRAM_CALC
, A.LEVEL_APPLICABLE_TO_FUNDING
, N.VALUE_DESCRIPTION LEVEL_APPL_TO_FUNDING_DESC
, A.FRANCHISING_ACTIVITY
, O.VALUE_DESCRIPTION FRANCHISING_ACTIVITY_DESC
, A.NHS_FUNDING_SOURCE
, P.VALUE_DESCRIPTION NHS_FUNDING_SOURCE_DESC
, A.FE_PROGRAM_MARKER
, T.VALUE_DESCRIPTION FE_PROGRAM_MARKER_DESC
, A.FEE_BAND FEE_BAND
, Q.VALUE_DESCRIPTION FEE_BAND_DESC
, A.FUNDABILITY
, R.VALUE_DESCRIPTION FUNDABILITY_DESC
, A.FTE_INTENSITY
, A.TEACH_PERIOD_START_DT
, A.TEACH_PERIOD_END_DT
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.IMPLIED_FUND_RATE
, A.GOV_INITIATIVES_CD
, U.VALUE_DESCRIPTION GOV_INITIATIVES_DESC
, A.UNITS_FOR_QUAL
, A.DISADV_UPLIFT_ELIG_CD
, V.VALUE_DESCRIPTION DISADV_UPLIFT_ELIG_DESC
, A.FRANCH_PARTNER_CD
, W.VALUE_DESCRIPTION FRANCH_PARTNER_DESC
, A.FRANCH_OUT_ARR_CD
, X.VALUE_DESCRIPTION FRANCH_OUT_ARR_DESC
, A.EXCLUDE_FLAG FROM IGS_HE_ST_PROG A
, IGS_PS_VER B
, IGS_HE_CODE_VALUES C
, IGS_HE_CODE_VALUES D
, IGS_HE_CODE_VALUES E
, IGS_HE_CODE_VALUES F
, IGS_HE_CODE_VALUES G
, IGS_HE_CODE_VALUES H
, IGS_HE_CODE_VALUES I
, IGS_HE_CODE_VALUES J
, IGS_OR_INSTITUTION K
, IGS_OR_INSTITUTION 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_LOOKUPS_VIEW S
, IGS_HE_CODE_VALUES T
, IGS_HE_CODE_VALUES U
, IGS_HE_CODE_VALUES V
, IGS_HE_CODE_VALUES W
, IGS_HE_CODE_VALUES X
WHERE A.COURSE_CD = B.COURSE_CD
AND A.VERSION_NUMBER = B.VERSION_NUMBER AND C.CODE_TYPE (+) = 'OSS_TTCID'
AND C.VALUE (+) = A.TEACHER_TRAIN_PROG_ID AND D.CODE_TYPE (+) = 'OSS_ITTPHSC'
AND D.VALUE (+) = A.ITT_PHASE AND E.CODE_TYPE (+) = 'OSS_BITTM'
AND E.VALUE (+) = A.BILINGUAL_ITT_MARKER AND F.CODE_TYPE (+) = 'OSS_TQSEC'
AND F.VALUE (+) = A.TEACHING_QUAL_SOUGHT_SECTOR AND G.CODE_TYPE (+) = 'OSS_TQSUB123'
AND G.VALUE (+) = A.TEACHING_QUAL_SOUGHT_SUBJ1 AND H.CODE_TYPE (+) = 'OSS_TQSUB123'
AND H.VALUE (+) = A.TEACHING_QUAL_SOUGHT_SUBJ2 AND I.CODE_TYPE (+) = 'OSS_TQSUB123'
AND I.VALUE (+) = A.TEACHING_QUAL_SOUGHT_SUBJ3 AND J.CODE_TYPE (+) = 'OSS_LOCSDY'
AND J.VALUE (+) = A.LOCATION_OF_STUDY
AND K.INSTITUTION_CD (+) = A.OTHER_INST_PROV_TEACHING1 AND L.INSTITUTION_CD (+) = A.OTHER_INST_PROV_TEACHING2 AND M.CODE_TYPE (+) = 'OSS_CRDTSCM'
AND M.VALUE (+) = A.CREDIT_TRANSFER_SCHEME AND N.CODE_TYPE (+) = 'OSS_FUNDLEV'
AND N.VALUE (+) = A. LEVEL_APPLICABLE_TO_FUNDING AND O.CODE_TYPE (+) = 'OSS_FRAN_ACT' AND O.VALUE (+) = A.FRANCHISING_ACTIVITY AND P.CODE_TYPE (+) = 'OSS_NHS_FUSRC' AND P.VALUE (+) = A.NHS_FUNDING_SOURCE AND Q.CODE_TYPE (+) = 'OSS_FEEBAND' AND Q.VALUE (+) = A.FEE_BAND AND R.CODE_TYPE (+) = 'OSS_FUND_CODE' AND R.VALUE (+) = A.FUNDABILITY
AND S.LOOKUP_TYPE (+) = 'IGS_HE_RED_RTN'
AND S.LOOKUP_CODE (+) = A.RETURN_TYPE
AND T.CODE_TYPE(+)='OSS_FEPRMK'
AND T.VALUE(+)= A.FE_PROGRAM_MARKER
AND U.CODE_TYPE (+)='OSS_GOVINIT'
AND U.VALUE (+)= A.GOV_INITIATIVES_CD
AND V.CODE_TYPE (+)='OSS_ELIDISUP'
AND V.VALUE (+)= A. DISADV_UPLIFT_ELIG_CD
AND W.CODE_TYPE (+)='OSS_FRANPART'
AND W.VALUE (+)= A.FRANCH_PARTNER_CD
AND X.CODE_TYPE (+)='OSS_FROUTARR'
AND X.VALUE (+)= A. FRANCH_OUT_ARR_CD

Columns