View: IGS_HE_POOUS_DTLS_V

View Text

SELECT A.ROWID ROW_ID
, A.HESA_POOUS_ID HESA_POOUS_ID
, A.COURSE_CD COURSE_CD
, A.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, B.COURSE_STATUS COURSE_STATUS
, B.SHORT_TITLE SHORT_TITLE
, A.CAL_TYPE CAL_TYPE
, C.DESCRIPTION CAL_DESCRIPTION
, A.LOCATION_CD LOCATION_CD
, A.ATTENDANCE_MODE ATTENDANCE_MODE
, ATTENDANCE_TYPE ATTENDANCE_TYPE
, A.UNIT_SET_CD UNIT_SET_CD
, D.TITLE UNIT_SET_DESC
, A.US_VERSION_NUMBER US_VERSION_NUMBER
, A.LOCATION_OF_STUDY LOCATION_OF_STUDY
, E.VALUE_DESCRIPTION LOCATION_OF_STUDY_DESC
, A.MODE_OF_STUDY MODE_OF_STUDY
, F.VALUE_DESCRIPTION MODE_OF_STUDY_DESC
, A.UFI_PLACE UFI_PLACE
, G.VALUE_DESCRIPTION UFI_PLACE_DESC
, A.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, H.VALUE_DESCRIPTION FRANCHISING_ACTIVITY_DESC
, A.TYPE_OF_YEAR TYPE_OF_YEAR
, I.VALUE_DESCRIPTION TYPE_OF_YEAR_DESC
, A.LENG_CURRENT_YEAR LENG_CURRENT_YEAR
, A.CREDIT_VALUE_YOP1 CREDIT_VALUE_YOP1
, A.LEVEL_CREDIT1 LEVEL_CREDIT1
, J.DESCRIPTION LEVEL_CREDIT1_DESC
, A.CREDIT_VALUE_YOP2 CREDIT_VALUE_YOP2
, A.LEVEL_CREDIT2 LEVEL_CREDIT2
, K.DESCRIPTION LEVEL_CREDIT2_DESC
, A.FTE_INTENSITY FTE_INTENSITY
, A.FTE_CALC_TYPE FTE_CALC_TYPE
, R.MEANING FTE_CALC_TYPE_DESC
, A.TEACH_PERIOD_START_DT TEACH_PERIOD_START_DT
, A.TEACH_PERIOD_END_DT TEACH_PERIOD_END_DT
, A.OTHER_INSTIT_TEACH1 OTHER_INSTIT_TEACH1
, L.NAME OTHER_INSTIT_TEACH1_DESC
, A.OTHER_INSTIT_TEACH2 OTHER_INSTIT_TEACH2
, M.NAME OTHER_INSTIT_TEACH2_DESC
, A.PROP_NOT_TAUGHT PROP_NOT_TAUGHT
, A.FUNDABILITY_CD FUNDABILITY_CD
, N.VALUE_DESCRIPTION FUNDABILITY_DESC
, A.FEE_BAND FEE_BAND
, O.VALUE_DESCRIPTION FEE_BAND_DESC
, A.FUNDING_SOURCE FUNDING_SOURCE
, FUND.DESCRIPTION FUNDING_SOURCE_DESC
, A.LEVEL_APPLICABLE_TO_FUNDING LEVEL_APPLICABLE_TO_FUNDING
, P.VALUE_DESCRIPTION LEVEL_APPLICABLE_DESC
, A.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, A.GS_VERSION_NUMBER GS_VERSION_NUMBER
, Q.DESCRIPTION GRADING_SCHEMA_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.CREDIT_VALUE_YOP3 CREDIT_VALUE_YOP3
, A.LEVEL_CREDIT3 LEVEL_CREDIT3
, S.DESCRIPTION LEVEL_CREDIT3_DESC
, A.CREDIT_VALUE_YOP4 CREDIT_VALUE_YOP4
, A.LEVEL_CREDIT4 LEVEL_CREDIT4
, T.DESCRIPTION LEVEL_CREDIT4_DESC FROM IGS_HE_POOUS A
, IGS_PS_VER B
, IGS_CA_TYPE C
, IGS_EN_UNIT_SET 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_PS_UNIT_LEVEL J
, IGS_PS_UNIT_LEVEL K
, IGS_OR_INSTITUTION L
, IGS_OR_INSTITUTION M
, IGS_HE_CODE_VALUES N
, IGS_HE_CODE_VALUES O
, IGS_HE_CODE_VALUES P
, IGS_AS_GRD_SCHEMA Q
, IGS_LOOKUPS_VIEW R
, IGS_FI_FUND_SRC_ALL FUND
, IGS_PS_UNIT_LEVEL S
, IGS_PS_UNIT_LEVEL T
WHERE A.COURSE_CD = B.COURSE_CD
AND A.CRV_VERSION_NUMBER = B.VERSION_NUMBER AND A.CAL_TYPE = C.CAL_TYPE AND D.UNIT_SET_CD = A.UNIT_SET_CD
AND D.VERSION_NUMBER = A.US_VERSION_NUMBER AND E.CODE_TYPE (+) = 'OSS_LOCSDY' AND E.VALUE (+) = A.LOCATION_OF_STUDY AND F.CODE_TYPE (+) = 'OSS_MODE_TYPE' AND F.VALUE (+) = A.MODE_OF_STUDY AND G.CODE_TYPE (+) = 'OSS_UFI_PLACE' AND G.VALUE (+) = A.UFI_PLACE AND H.CODE_TYPE (+) = 'OSS_FRAN_ACT' AND H.VALUE (+) = A.FRANCHISING_ACTIVITY AND I.CODE_TYPE (+) = 'OSS_TYPEYR' AND I.VALUE (+) = A.TYPE_OF_YEAR AND J.UNIT_LEVEL (+) = A.LEVEL_CREDIT1 AND K.UNIT_LEVEL (+) = A.LEVEL_CREDIT2 AND L.INSTITUTION_CD (+) = A.OTHER_INSTIT_TEACH1 AND M. INSTITUTION_CD (+) = A.OTHER_INSTIT_TEACH2 AND N.CODE_TYPE (+) = 'OSS_FUND_CODE' AND N.VALUE (+) = A.FUNDABILITY_CD AND O.CODE_TYPE (+) = 'OSS_FEEBAND' AND O.VALUE (+) = A.FEE_BAND AND P.CODE_TYPE (+) = 'OSS_FUNDLEV' AND P.VALUE (+) = A.LEVEL_APPLICABLE_TO_FUNDING
AND Q.GRADING_SCHEMA_CD (+) = A.GRADING_SCHEMA_CD
AND Q.VERSION_NUMBER (+) = A.GS_VERSION_NUMBER
AND R.LOOKUP_CODE(+)= A.FTE_CALC_TYPE
AND R.LOOKUP_TYPE(+)= 'IGS_HE_FTE_CALC_TYPE'
AND A.FUNDING_SOURCE = FUND.FUNDING_SOURCE(+)
AND S.UNIT_LEVEL (+) = A.LEVEL_CREDIT3
AND T.UNIT_LEVEL (+) = A.LEVEL_CREDIT4

Columns