View: IGS_HE_EN_SUSA_V

View Text

SELECT A.ROWID ROW_ID
, A.HESA_EN_SUSA_ID HESA_EN_SUSA_ID
, A.PERSON_ID PERSON_ID
, A.COURSE_CD COURSE_CD
, A.UNIT_SET_CD UNIT_SET_CD
, A.US_VERSION_NUMBER US_VERSION_NUMBER
, A.SEQUENCE_NUMBER SEQUENCE_NUMBER
, A.TERM_TIME_ACCOM TERM_TIME_ACCOM
, B.VALUE_DESCRIPTION TERM_TIME_ACCOM_DESC
, A.DISABILITY_ALLOW DISABILITY_ALLOW
, C.VALUE_DESCRIPTION DISABILITY_ALLOW_DESC
, A.ADDITIONAL_SUP_BAND ADDITIONAL_SUP_BAND
, D.VALUE_DESCRIPTION ADDITIONAL_SUP_BAND_DESC
, A.SLDD_DISCRETE_PROV SLDD_DISCRETE_PROV
, E.VALUE_DESCRIPTION SLDD_DISCRETE_PROV_DESC
, A.STUDY_MODE STUDY_MODE
, F.VALUE_DESCRIPTION STUDY_MODE_DESC
, A.STUDY_LOCATION STUDY_LOCATION
, G.VALUE_DESCRIPTION STUDY_LOCATION_DESC
, A. FTE_PERC_OVERRIDE FTE_PERC_OVERRIDE
, A.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, H.VALUE_DESCRIPTION FRANCHISING_ACTIVITY_DESC
, A.COMPLETION_STATUS COMPLETION_STATUS
, I.VALUE_DESCRIPTION COMPLETION_STATUS_DESC
, A.GOOD_STAND_MARKER GOOD_STAND_MARKER
, J.VALUE_DESCRIPTION GOOD_STAND_MARKER_DESC
, A.COMPLETE_PYR_STUDY_CD COMPLETE_PYR_STUDY_CD
, K.VALUE_DESCRIPTION COMPLETE_PYR_STUDY_DESC
, A. NEW_HE_ENTRANT_CD NEW_ENTRANT_CD
, L.VALUE_DESCRIPTION NEW_ENTRANT_DESC
, A.TEACHING_INST1 TEACHING_INST1
, M.NAME TEACHING_INST1_DESC
, A. TEACHING_INST2 TEACHING_INST2
, N. NAME TEACHING_INST2_DESC
, A.PRO_NOT_TAUGHT PRO_NOT_TAUGHT
, A.FUNDABILITY_CODE FUNDABILITY_CODE
, O.VALUE_DESCRIPTION FUNDABILITY_CODE_DESC
, A.FEE_ELIGIBILITY FEE_ELIGIBILITY
, P.VALUE_DESCRIPTION FEE_ELIGIBILITY_DESC
, A.FEE_BAND FEE_BAND
, Q.VALUE_DESCRIPTION FEE_BAND_DESC
, A.NON_PAYMENT_REASON NON_PAYMENT_REASON
, R.VALUE_DESCRIPTION NON_PAYMENT_REASON_DESC
, A.STUDENT_FEE STUDENT_FEE
, S.VALUE_DESCRIPTION STUDENT_FEE_DESC
, A.CREDIT_PT_ACHIEVED1 CREDIT_PT_ACHIEVED1
, A.CREDIT_PT_ACHIEVED2 CREDIT_PT_ACHIEVED2
, A.CREDIT_LEVEL1 CREDIT_LEVEL1
, T.DESCRIPTION CREDIT_LEVEL1_DESC
, A.CREDIT_LEVEL2 CREDIT_LEVEL2
, U.DESCRIPTION CREDIT_LEVEL2_DESC
, A.CREDIT_VALUE_YOP1 CREDIT_VALUE_YOP1
, A.CREDIT_VALUE_YOP2 CREDIT_VALUE_YOP2
, A.CREDIT_LEVEL_ACHIEVED1 CREDIT_LEVEL_ACHIEVED1
, V.DESCRIPTION CREDIT_LEVEL_ACHIEVED1_DESC
, A.CREDIT_LEVEL_ACHIEVED2 CREDIT_LEVEL_ACHIEVED2
, W.DESCRIPTION CREDIT_LEVEL_ACHIEVED2_DESC
, A.GRAD_SCH_GRADE GRAD_SCH_GRADE
, A.MARK MARK
, A.FTE_INTENSITY FTE_INTENSITY
, A.CALCULATED_FTE CALCULATED_FTE
, A.FTE_CALC_TYPE FTE_CALC_TYPE
, Z.MEANING FTE_CALC_TYPE_DESC
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.TYPE_OF_YEAR
, TY.VALUE_DESCRIPTION TYPE_OF_YEAR_DESC
, A.YEAR_STU YEAR_STU
, A.CREDIT_VALUE_YOP3 CREDIT_VALUE_YOP3
, A.CREDIT_LEVEL3 CREDIT_LEVEL3
, CL3.DESCRIPTION CREDIT_LEVEL3_DESC
, A.CREDIT_VALUE_YOP4 CREDIT_VALUE_YOP4
, A.CREDIT_LEVEL4 CREDIT_LEVEL4
, CL4.DESCRIPTION CREDIT_LEVEL4_DESC
, A.CREDIT_PT_ACHIEVED3 CREDIT_PT_ACHIEVED3
, A.CREDIT_PT_ACHIEVED4 CREDIT_PT_ACHIEVED4
, A.CREDIT_LEVEL_ACHIEVED3 CREDIT_LEVEL_ACHIEVED3
, CLA3.DESCRIPTION CREDIT_LEVEL_ACHIEVED3_DESC
, A.CREDIT_LEVEL_ACHIEVED4 CREDIT_LEVEL_ACHIEVED4
, CLA4.DESCRIPTION CREDIT_LEVEL_ACHIEVED4_DESC
, A.ENH_FUND_ELIG_CD ENH_FUND_ELIG_CD
, FE.VALUE_DESCRIPTION ENH_FUND_ELIG_DESC
, A.ADDITIONAL_SUP_COST ADDITIONAL_SUP_COST
, A.DISADV_UPLIFT_FACTOR DISADV_UPLIFT_FACTOR
FROM IGS_HE_EN_SUSA A
, IGS_HE_CODE_VALUES 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_HE_CODE_VALUES K
, IGS_HE_CODE_VALUES L
, IGS_OR_INSTITUTION M
, IGS_OR_INSTITUTION 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_PS_UNIT_LEVEL T
, IGS_PS_UNIT_LEVEL U
, IGS_PS_UNIT_LEVEL V
, IGS_PS_UNIT_LEVEL W
, IGS_LOOKUPS_VIEW Z
, IGS_HE_CODE_VALUES TY
, IGS_PS_UNIT_LEVEL CL3
, IGS_PS_UNIT_LEVEL CL4
, IGS_PS_UNIT_LEVEL CLA3
, IGS_PS_UNIT_LEVEL CLA4
, IGS_HE_CODE_VALUES FE
WHERE B.CODE_TYPE (+) = 'OSS_TTA'
AND B.VALUE(+) = A.TERM_TIME_ACCOM
AND C.CODE_TYPE (+)= 'OSS_DIS_ALLOW'
AND C.VALUE (+)= A.DISABILITY_ALLOW
AND D.CODE_TYPE (+)= 'OSS_SUP_BAND'
AND D.VALUE (+)= A.ADDITIONAL_SUP_BAND
AND E.CODE_TYPE (+)= 'OSS_ST13'
AND E.VALUE (+)= A.SLDD_DISCRETE_PROV
AND F.CODE_TYPE(+) ='OSS_MODE_TYPE'
AND F.VALUE(+) = A.STUDY_MODE
AND G.CODE_TYPE (+)= 'OSS_LOCSDY'
AND G.VALUE(+) = A.STUDY_LOCATION
AND H.CODE_TYPE (+)= 'OSS_FRAN_ACT'
AND H.VALUE(+) = A.FRANCHISING_ACTIVITY
AND I.CODE_TYPE(+) = 'OSS_CSTAT'
AND I.VALUE (+)= A.COMPLETION_STATUS
AND J.CODE_TYPE (+)= 'OSS_PROGRESS'
AND J.VALUE (+)= A.GOOD_STAND_MARKER
AND K.CODE_TYPE (+)= 'OSS_FUNDCOMP'
AND K.VALUE(+) = A.COMPLETE_PYR_STUDY_CD
AND L.CODE_TYPE(+) = 'OSS_HEENT'
AND L.VALUE(+) = A.NEW_HE_ENTRANT_CD
AND M.INSTITUTION_CD(+) = A.TEACHING_INST1
AND N.INSTITUTION_CD(+) = A.TEACHING_INST2
AND O.CODE_TYPE (+)= 'OSS_FUND_CODE'
AND O.VALUE(+) = A.FUNDABILITY_CODE
AND P.CODE_TYPE(+) = 'OSS_FEEELIG'
AND P.VALUE (+)= A.FEE_ELIGIBILITY
AND Q.CODE_TYPE (+)= 'OSS_FEEBAND'
AND Q.VALUE (+)= A.FEE_BAND
AND R.CODE_TYPE(+)= 'OSS_NONPAY'
AND R.VALUE(+) = A.NON_PAYMENT_REASON
AND S.CODE_TYPE (+)= 'OSS_MSTUFEE'
AND S.VALUE (+)= A.STUDENT_FEE
AND T.UNIT_LEVEL (+) =A.CREDIT_LEVEL1
AND T.CLOSED_IND (+) = 'N'
AND U.UNIT_LEVEL (+) = A.CREDIT_LEVEL2
AND U.CLOSED_IND (+) = 'N'
AND V.UNIT_LEVEL (+)=A.CREDIT_LEVEL_ACHIEVED1
AND V.CLOSED_IND (+) ='N'
AND W.UNIT_LEVEL (+) = A.CREDIT_LEVEL_ACHIEVED2
AND W.CLOSED_IND (+) = 'N'
AND Z.LOOKUP_CODE(+)= A.FTE_CALC_TYPE
AND Z.LOOKUP_TYPE(+)='IGS_HE_FTE_CALC_TYPE'
AND TY.CODE_TYPE(+) = 'OSS_TYPEYR'
AND TY.VALUE(+) = A.TYPE_OF_YEAR
AND CL3.UNIT_LEVEL (+) = A.CREDIT_LEVEL3
AND CL4.UNIT_LEVEL (+) = A.CREDIT_LEVEL4
AND CLA3.UNIT_LEVEL (+) = A.CREDIT_LEVEL_ACHIEVED3
AND CLA4.UNIT_LEVEL (+) = A.CREDIT_LEVEL_ACHIEVED4
AND FE.CODE_TYPE (+) = 'OSS_ELIGENFD'
AND FE.VALUE(+) = A.ENH_FUND_ELIG_CD

Columns