eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_HE_EN_SUSA

Object Details

Object Name:	IGS_HE_EN_SUSA
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_HE_EN_SUSA
Subobject Name:
Status:	VALID

table stores HESA information acquired during enrolment of a student on to a program unit set attempt

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_HE_EN_SUSA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HESA_EN_SUSA_ID
IGS_HE_EN_SUSA_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UNIT_SET_CD SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
HESA_EN_SUSA_ID	NUMBER	(6)	Yes	Sequence generated identifier for each record
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
COURSE_CD	VARCHAR2	(6)	Yes	Program code
UNIT_SET_CD	VARCHAR2	(10)	Yes	Unit Set Code
US_VERSION_NUMBER	NUMBER	(3)	Yes	Used to uniquely identify each version of a unit set
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the Sequence Number for Student Unit Set Attempt
NEW_HE_ENTRANT_CD	VARCHAR2	(30)		New higher education entrant code
TERM_TIME_ACCOM	VARCHAR2	(30)		HESA related Term Time Accommodation
DISABILITY_ALLOW	VARCHAR2	(30)		HESA related Disability Allowance
ADDITIONAL_SUP_BAND	VARCHAR2	(30)		HESA related Additional Support Band
SLDD_DISCRETE_PROV	VARCHAR2	(30)		HESA related SLDD Discrete Provision
STUDY_MODE	VARCHAR2	(30)		HESA Mode of Study
STUDY_LOCATION	VARCHAR2	(30)		HESA Location of Study
FTE_PERC_OVERRIDE	NUMBER	(5)		Full time equivalent study percentage override
FRANCHISING_ACTIVITY	VARCHAR2	(30)		HESA Franchising Activity
COMPLETION_STATUS	VARCHAR2	(30)		HESA Completion Status
GOOD_STAND_MARKER	VARCHAR2	(30)		HESA Good Standing Marker
COMPLETE_PYR_STUDY_CD	VARCHAR2	(30)		HESA Completion of Year of Program of Study
CREDIT_VALUE_YOP1	NUMBER	(3)		HESA Credit Value of Year of Program 1
CREDIT_VALUE_YOP2	NUMBER	(3)		HESA Credit Value of Year of Program 2
CREDIT_LEVEL_ACHIEVED1	VARCHAR2	(30)		HESA Level of Credit Points Obtained 1
CREDIT_LEVEL_ACHIEVED2	VARCHAR2	(30)		HESA Level of Credit Points Obtained 2
CREDIT_PT_ACHIEVED1	NUMBER	(3)		HESA Number of Credit Points Obtained 1
CREDIT_PT_ACHIEVED2	NUMBER	(3)		HESA Number of Credit Points Obtained 2
CREDIT_LEVEL1	VARCHAR2	(30)		HESA Level of Credit 1
CREDIT_LEVEL2	VARCHAR2	(30)		HESA Level of Credit 2
GRAD_SCH_GRADE	VARCHAR2	(10)		Grade
MARK	NUMBER	(6)		Mark obtained
TEACHING_INST1	VARCHAR2	(30)		HESA Code of Other Institutions providing Teaching 1
TEACHING_INST2	VARCHAR2	(30)		HESA Code of Other Institutions providing Teaching 2
PRO_NOT_TAUGHT	NUMBER	(5)		Proportion not taught by this institution
FUNDABILITY_CODE	VARCHAR2	(30)		HESA related Fundability Code
FEE_ELIGIBILITY	VARCHAR2	(30)		HESA related Fee Eligibility
FEE_BAND	VARCHAR2	(30)		HESA related Fee Band
NON_PAYMENT_REASON	VARCHAR2	(30)		HESA related reason for Partial or Full non-payment of tuition fees
STUDENT_FEE	VARCHAR2	(30)		HESA related Student Fee
FTE_INTENSITY	NUMBER	(5)		Full time equivalent study intensity
CALCULATED_FTE	NUMBER	(5)		Calculated Full time equivalent study
FTE_CALC_TYPE	VARCHAR2	(1)		Full time equivalent study calculation type flag.Can take values I,B and U
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
TYPE_OF_YEAR	VARCHAR2	(30)		The code that identifies the type of program year as applies to the student
YEAR_STU	NUMBER			Year of student on this programme
CREDIT_VALUE_YOP3	NUMBER			Credit value of year of programme 3
CREDIT_LEVEL3	VARCHAR2	(30)		Level of credit 3
CREDIT_VALUE_YOP4	NUMBER			Credit value of year of programme 4
CREDIT_LEVEL4	VARCHAR2	(30)		Level of credit 4
CREDIT_PT_ACHIEVED3	NUMBER			Number of credit points obtained 3
CREDIT_PT_ACHIEVED4	NUMBER			Number of credit points obtained 4
CREDIT_LEVEL_ACHIEVED3	VARCHAR2	(30)		Level of credit points obtained 3
CREDIT_LEVEL_ACHIEVED4	VARCHAR2	(30)		Level of credit points obtained 4
ENH_FUND_ELIG_CD	VARCHAR2	(30)		Eligibility for enhanced funding code
ADDITIONAL_SUP_COST	NUMBER			Additional support cost
DISADV_UPLIFT_FACTOR	NUMBER			Disadvantage uplift factor

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HESA_EN_SUSA_ID
,      PERSON_ID
,      COURSE_CD
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      SEQUENCE_NUMBER
,      NEW_HE_ENTRANT_CD
,      TERM_TIME_ACCOM
,      DISABILITY_ALLOW
,      ADDITIONAL_SUP_BAND
,      SLDD_DISCRETE_PROV
,      STUDY_MODE
,      STUDY_LOCATION
,      FTE_PERC_OVERRIDE
,      FRANCHISING_ACTIVITY
,      COMPLETION_STATUS
,      GOOD_STAND_MARKER
,      COMPLETE_PYR_STUDY_CD
,      CREDIT_VALUE_YOP1
,      CREDIT_VALUE_YOP2
,      CREDIT_LEVEL_ACHIEVED1
,      CREDIT_LEVEL_ACHIEVED2
,      CREDIT_PT_ACHIEVED1
,      CREDIT_PT_ACHIEVED2
,      CREDIT_LEVEL1
,      CREDIT_LEVEL2
,      GRAD_SCH_GRADE
,      MARK
,      TEACHING_INST1
,      TEACHING_INST2
,      PRO_NOT_TAUGHT
,      FUNDABILITY_CODE
,      FEE_ELIGIBILITY
,      FEE_BAND
,      NON_PAYMENT_REASON
,      STUDENT_FEE
,      FTE_INTENSITY
,      CALCULATED_FTE
,      FTE_CALC_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TYPE_OF_YEAR
,      YEAR_STU
,      CREDIT_VALUE_YOP3
,      CREDIT_LEVEL3
,      CREDIT_VALUE_YOP4
,      CREDIT_LEVEL4
,      CREDIT_PT_ACHIEVED3
,      CREDIT_PT_ACHIEVED4
,      CREDIT_LEVEL_ACHIEVED3
,      CREDIT_LEVEL_ACHIEVED4
,      ENH_FUND_ELIG_CD
,      ADDITIONAL_SUP_COST
,      DISADV_UPLIFT_FACTOR
FROM IGS.IGS_HE_EN_SUSA;

Dependencies

[top of page]

IGS.IGS_HE_EN_SUSA does not reference any database object

IGS.IGS_HE_EN_SUSA is referenced by following:

APPS: IGS_HE_EN_SUSA