[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base business view to allow queries on Student Unit Set Attempt HESA Details. |
| Implementation/DBA Data: | Not implemented in this database |
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