VIEW: APPS.IGS_HE_POOUS_DTLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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