VIEW: APPS.IGS_HE_ST_PRG_DTLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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