VIEW: APPS.IGSBV_ST_UNIT_SET_ATT_HESA_DET

Source

View Text - Preformatted

SELECT susa.HESA_EN_SUSA_ID HESA_EN_SUSA_ID, susa.PERSON_ID PERSON_ID, per.PARTY_NUMBER PERSON_NUMBER, susa.COURSE_CD PROGRAM_CODE, susa.UNIT_SET_CD UNIT_SET_CODE, susa.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER, susa.SEQUENCE_NUMBER SEQUENCE_NUMBER, susa.NEW_HE_ENTRANT_CD NEW_HE_ENTRANT_CODE, susa.TERM_TIME_ACCOM TERM_TIME_ACCOMMODATION, susa.DISABILITY_ALLOW DISABILITY_ALLOWANCE, susa.ADDITIONAL_SUP_BAND ADDITIONAL_SUP_BAND, susa.SLDD_DISCRETE_PROV SLDD_DISCRETE_PROVISION, susa.STUDY_LOCATION LOCATION_OF_STUDY, susa.STUDY_MODE MODE_OF_STUDY, susa.COMPLETION_STATUS COMPLETION_STATUS, susa.GOOD_STAND_MARKER GOOD_STAND_MARKER, susa.COMPLETE_PYR_STUDY_CD COMPLETE_PYR_STUDY_CODE, susa.FUNDABILITY_CODE FUNDABILITY_CODE, susa.FEE_BAND FEE_BAND, susa.FEE_ELIGIBILITY FEE_ELIGIBILITY, susa.STUDENT_FEE MAJOR_SOURCE_TUITION_FEE, susa.NON_PAYMENT_REASON NON_PAYMENT_REASON, susa.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY, susa.TYPE_OF_YEAR TYPE_PROGRAM_YEAR, susa.CREDIT_VALUE_YOP1 YOP_CREDIT_VALUE_1, susa.CREDIT_LEVEL1 LEVEL_CREDIT_1, susa.CREDIT_VALUE_YOP2 YOP_CREDIT_VALUE_2, susa.CREDIT_LEVEL2 LEVEL_CREDIT_2, susa.CREDIT_PT_ACHIEVED1 CREDIT_PTS_ACHIEVED1, susa.CREDIT_LEVEL_ACHIEVED1 CREDIT_LEVEL_ACHIEVED1, susa.CREDIT_PT_ACHIEVED2 CREDIT_PTS_ACHIEVED2, susa.CREDIT_LEVEL_ACHIEVED2 CREDIT_LEVEL_ACHIEVED2, susa.TEACHING_INST1 OTHER_INST_PROV_TEACHING1, susa.TEACHING_INST2 OTHER_INST_PROV_TEACHING2, susa.PRO_NOT_TAUGHT PROP_NOT_TAUGHT_BY_THIS_INST, susa.FTE_PERC_OVERRIDE FTE_PERC_OVERRIDE, susa.FTE_INTENSITY FTE_INTENSITY, susa.FTE_CALC_TYPE FTE_CALC_TYPE, susa.CALCULATED_FTE CALCULATED_FTE, susa.YEAR_STU YEAR_OF_STUDENT_ON_PROGRAM, susa.CREDIT_VALUE_YOP3 YOP_CREDIT_VALUE_3, susa.CREDIT_LEVEL3 LEVEL_CREDIT_3, susa.CREDIT_VALUE_YOP4 YOP_CREDIT_VALUE_4, susa.CREDIT_LEVEL4 LEVEL_CREDIT_4, susa.CREDIT_PT_ACHIEVED3 CREDIT_PTS_ACHIEVED3, susa.CREDIT_LEVEL_ACHIEVED3 CREDIT_LEVEL_ACHIEVED3, susa.CREDIT_PT_ACHIEVED4 CREDIT_PTS_ACHIEVED4, susa.CREDIT_LEVEL_ACHIEVED4 CREDIT_LEVEL_ACHIEVED4, susa.ENH_FUND_ELIG_CD ENHANCED_FUNDING_ELIG_CODE, susa.ADDITIONAL_SUP_COST ADDITIONAL_SUPPORT_COST, susa.DISADV_UPLIFT_FACTOR DISADVANTAGE_UPLIFT_FACTOR, susa.CREATION_DATE CREATION_DATE, susa.CREATED_BY CREATED_BY, susa.LAST_UPDATE_DATE LAST_UPDATE_DATE, susa.LAST_UPDATED_BY LAST_UPDATED_BY FROM IGS_HE_EN_SUSA susa, HZ_PARTIES per WHERE per.PARTY_ID = susa.PERSON_ID WITH READ ONLY

View Text - HTML Formatted

SELECT SUSA.HESA_EN_SUSA_ID HESA_EN_SUSA_ID
, SUSA.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, SUSA.COURSE_CD PROGRAM_CODE
, SUSA.UNIT_SET_CD UNIT_SET_CODE
, SUSA.US_VERSION_NUMBER UNIT_SET_VERSION_NUMBER
, SUSA.SEQUENCE_NUMBER SEQUENCE_NUMBER
, SUSA.NEW_HE_ENTRANT_CD NEW_HE_ENTRANT_CODE
, SUSA.TERM_TIME_ACCOM TERM_TIME_ACCOMMODATION
, SUSA.DISABILITY_ALLOW DISABILITY_ALLOWANCE
, SUSA.ADDITIONAL_SUP_BAND ADDITIONAL_SUP_BAND
, SUSA.SLDD_DISCRETE_PROV SLDD_DISCRETE_PROVISION
, SUSA.STUDY_LOCATION LOCATION_OF_STUDY
, SUSA.STUDY_MODE MODE_OF_STUDY
, SUSA.COMPLETION_STATUS COMPLETION_STATUS
, SUSA.GOOD_STAND_MARKER GOOD_STAND_MARKER
, SUSA.COMPLETE_PYR_STUDY_CD COMPLETE_PYR_STUDY_CODE
, SUSA.FUNDABILITY_CODE FUNDABILITY_CODE
, SUSA.FEE_BAND FEE_BAND
, SUSA.FEE_ELIGIBILITY FEE_ELIGIBILITY
, SUSA.STUDENT_FEE MAJOR_SOURCE_TUITION_FEE
, SUSA.NON_PAYMENT_REASON NON_PAYMENT_REASON
, SUSA.FRANCHISING_ACTIVITY FRANCHISING_ACTIVITY
, SUSA.TYPE_OF_YEAR TYPE_PROGRAM_YEAR
, SUSA.CREDIT_VALUE_YOP1 YOP_CREDIT_VALUE_1
, SUSA.CREDIT_LEVEL1 LEVEL_CREDIT_1
, SUSA.CREDIT_VALUE_YOP2 YOP_CREDIT_VALUE_2
, SUSA.CREDIT_LEVEL2 LEVEL_CREDIT_2
, SUSA.CREDIT_PT_ACHIEVED1 CREDIT_PTS_ACHIEVED1
, SUSA.CREDIT_LEVEL_ACHIEVED1 CREDIT_LEVEL_ACHIEVED1
, SUSA.CREDIT_PT_ACHIEVED2 CREDIT_PTS_ACHIEVED2
, SUSA.CREDIT_LEVEL_ACHIEVED2 CREDIT_LEVEL_ACHIEVED2
, SUSA.TEACHING_INST1 OTHER_INST_PROV_TEACHING1
, SUSA.TEACHING_INST2 OTHER_INST_PROV_TEACHING2
, SUSA.PRO_NOT_TAUGHT PROP_NOT_TAUGHT_BY_THIS_INST
, SUSA.FTE_PERC_OVERRIDE FTE_PERC_OVERRIDE
, SUSA.FTE_INTENSITY FTE_INTENSITY
, SUSA.FTE_CALC_TYPE FTE_CALC_TYPE
, SUSA.CALCULATED_FTE CALCULATED_FTE
, SUSA.YEAR_STU YEAR_OF_STUDENT_ON_PROGRAM
, SUSA.CREDIT_VALUE_YOP3 YOP_CREDIT_VALUE_3
, SUSA.CREDIT_LEVEL3 LEVEL_CREDIT_3
, SUSA.CREDIT_VALUE_YOP4 YOP_CREDIT_VALUE_4
, SUSA.CREDIT_LEVEL4 LEVEL_CREDIT_4
, SUSA.CREDIT_PT_ACHIEVED3 CREDIT_PTS_ACHIEVED3
, SUSA.CREDIT_LEVEL_ACHIEVED3 CREDIT_LEVEL_ACHIEVED3
, SUSA.CREDIT_PT_ACHIEVED4 CREDIT_PTS_ACHIEVED4
, SUSA.CREDIT_LEVEL_ACHIEVED4 CREDIT_LEVEL_ACHIEVED4
, SUSA.ENH_FUND_ELIG_CD ENHANCED_FUNDING_ELIG_CODE
, SUSA.ADDITIONAL_SUP_COST ADDITIONAL_SUPPORT_COST
, SUSA.DISADV_UPLIFT_FACTOR DISADVANTAGE_UPLIFT_FACTOR
, SUSA.CREATION_DATE CREATION_DATE
, SUSA.CREATED_BY CREATED_BY
, SUSA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SUSA.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_HE_EN_SUSA SUSA
, HZ_PARTIES PER
WHERE PER.PARTY_ID = SUSA.PERSON_ID WITH READ ONLY