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]

VIEW: APPS.IGSBV_ST_UNIT_SET_ATT_HESA_DET

Object Details

Object Name:	IGSBV_ST_UNIT_SET_ATT_HESA_DET
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_ST_UNIT_SET_ATT_HESA_DET
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Base business view to allow queries on Student Unit Set Attempt HESA Details.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
HESA_EN_SUSA_ID	NUMBER	(6)	Yes	Sequence number uniquely identifying the HESA student unit set attempt records
PERSON_ID	NUMBER	(15)	Yes	Unique person identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique person number
PROGRAM_CODE	VARCHAR2	(6)	Yes	Unique identifier of program of study student enrolled on
UNIT_SET_CODE	VARCHAR2	(10)	Yes	Unique identifier for Year of Program Unit Set student enrolled on
UNIT_SET_VERSION_NUMBER	NUMBER	(3)	Yes	Version number of year of program unit set student enrolled on
SEQUENCE_NUMBER	NUMBER	(6)	Yes
NEW_HE_ENTRANT_CODE	VARCHAR2	(30)		New Entrant to HE Code.Returned as HESA ENTRYCDE
TERM_TIME_ACCOMMODATION	VARCHAR2	(30)		Term time accommodation indicator.Returned as HESA TTACCOM
DISABILITY_ALLOWANCE	VARCHAR2	(30)		Disabled student allowance.Returned as HESA DISALL
ADDITIONAL_SUP_BAND	VARCHAR2	(30)		Additional support band.Returned as HESA ADSPBAND
SLDD_DISCRETE_PROVISION	VARCHAR2	(30)		SLDD - Discrete provision.Returned as HESA ST13
LOCATION_OF_STUDY	VARCHAR2	(30)		Location of study.Student Unit Set Attempt override for HESA LOCSDY
MODE_OF_STUDY	VARCHAR2	(30)		Mode of Study.Student Unit Set Attempt override for HESA MODE
COMPLETION_STATUS	VARCHAR2	(30)		Completion status.Returned as HESA CSTAT
GOOD_STAND_MARKER	VARCHAR2	(30)		Good standing marker.Returned as HESA PROGRESS
COMPLETE_PYR_STUDY_CODE	VARCHAR2	(30)		Completion of Year of programme of study.Returned as HESA FUNDCOMP
FUNDABILITY_CODE	VARCHAR2	(30)		Fundability.Student Unit Set Attempt override for HESA FUNDCODE
FEE_BAND	VARCHAR2	(30)		Fee Band.Student Unit Set Attempt override for HESA FEEBAND
FEE_ELIGIBILITY	VARCHAR2	(30)		Fee Eligibility.Returned as HESA FEEELIG
MAJOR_SOURCE_TUITION_FEE	VARCHAR2	(30)		Major source of tuition fees.Returned as HESA MSTUFEE
NON_PAYMENT_REASON	VARCHAR2	(30)		Reason for partial or full non-payment of tuition fees.Returned as HESA NONPAY
FRANCHISING_ACTIVITY	VARCHAR2	(30)		Collaboration/Franchising activity. Student Unit Set Attempt override for HESA FRANACT
TYPE_PROGRAM_YEAR	VARCHAR2	(30)		Type of programme year.Student Unit Set Attempt override for HESA TYPEYR
YOP_CREDIT_VALUE_1	NUMBER	(3)		Credit value of year of programme 1.Student Unit Set Attempt override for HESA CREDIT1
LEVEL_CREDIT_1	VARCHAR2	(30)		Level of credit 1.Student Unit Set Attempt override for HESA LEVLCRD1
YOP_CREDIT_VALUE_2	NUMBER	(3)		Credit value of year of programme 2.Student Unit Set Attempt override for HESA CREDIT2
LEVEL_CREDIT_2	VARCHAR2	(30)		Level of credit 2.Student Unit Set Attempt override for HESA LEVLCRD2
CREDIT_PTS_ACHIEVED1	NUMBER	(3)		Credit points achieved 1.Returned as HESA CPOBTN1.
CREDIT_LEVEL_ACHIEVED1	VARCHAR2	(30)		Level of credit points achieved 1.Returned as LCPOBTN1.
CREDIT_PTS_ACHIEVED2	NUMBER	(3)		Credit points achieved 2.Returned as HESA CPOBTN2.
CREDIT_LEVEL_ACHIEVED2	VARCHAR2	(30)		Level of credit points achieved 2.Returned as LCPOBTN2.
OTHER_INST_PROV_TEACHING1	VARCHAR2	(30)		Other Institution providing teaching 1. Student Unit Set Attempt override for HESA TINST1
OTHER_INST_PROV_TEACHING2	VARCHAR2	(30)		Other Institution providing teaching 2. Student Unit Set Attempt override for HESA TINST2
PROP_NOT_TAUGHT_BY_THIS_INST	NUMBER	(5)		Proportion not taught by this institution.Student Unit Set Attempt override for HESA PCOLAB
FTE_PERC_OVERRIDE	NUMBER	(5)		Student Full Time Equivalent Override. Overrides the calculated value
FTE_INTENSITY	NUMBER	(5)		Student Unit Set Attempt Full Time Equivalent Intensity override
FTE_CALC_TYPE	VARCHAR2	(1)		Full Time Equivalent Calculation Type. Override for student year of program unit set attempt
CALCULATED_FTE	NUMBER	(5)		Calculated Student Full Time Equivalent for year of program unit set.Returned as HESA STULOAD
YEAR_OF_STUDENT_ON_PROGRAM	NUMBER			Year of student on this program.Student Unit Set Attempt override for HESA YEARSTU
YOP_CREDIT_VALUE_3	NUMBER			Credit value of year of programme 3. Student Unit Set Attempt override for HESA CREDIT3
LEVEL_CREDIT_3	VARCHAR2	(30)		Level of credit 3.Student Unit Set Attempt override for HESA LEVLCRD3
YOP_CREDIT_VALUE_4	NUMBER			Credit value of year of programme 4. Student Unit Set Attempt override for HESA CREDIT4
LEVEL_CREDIT_4	VARCHAR2	(30)		Level of credit 4.Student Unit Set Attempt override for HESA LEVLCRD4
CREDIT_PTS_ACHIEVED3	NUMBER			Credit points achieved 3.Returned as HESA CPOBTN3.
CREDIT_LEVEL_ACHIEVED3	VARCHAR2	(30)		Level of credit points achieved 3.Returned as LCPOBTN3.
CREDIT_PTS_ACHIEVED4	NUMBER			Credit points achieved 4.Returned as HESA CPOBTN4.
CREDIT_LEVEL_ACHIEVED4	VARCHAR2	(30)		Level of credit points achieved 4.Returned as LCPOBTN4.
ENHANCED_FUNDING_ELIG_CODE	VARCHAR2	(30)		Eligibility for Enhanced Funding.Returned as HESA ELIGENFD
ADDITIONAL_SUPPORT_COST	NUMBER			Additional support cost.Returned as HESA ADDSUPCT
DISADVANTAGE_UPLIFT_FACTOR	NUMBER			Disadvantage uplift factor.Returned as HESA DISUPFAC
CREATED_BY	DATE		Yes	Standard WHO column indicates who create this record
CREATION_DATE	NUMBER	(15)	Yes	Standard WHO column indicates when this record was created
LAST_UPDATED_BY	DATE		Yes	Standard WHO column indicates who updated this record last
LAST_UPDATE_DATE	NUMBER	(15)	Yes	Standard WHO column indicates when this record was last updated

Query Text

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


SELECT HESA_EN_SUSA_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PROGRAM_CODE
,      UNIT_SET_CODE
,      UNIT_SET_VERSION_NUMBER
,      SEQUENCE_NUMBER
,      NEW_HE_ENTRANT_CODE
,      TERM_TIME_ACCOMMODATION
,      DISABILITY_ALLOWANCE
,      ADDITIONAL_SUP_BAND
,      SLDD_DISCRETE_PROVISION
,      LOCATION_OF_STUDY
,      MODE_OF_STUDY
,      COMPLETION_STATUS
,      GOOD_STAND_MARKER
,      COMPLETE_PYR_STUDY_CODE
,      FUNDABILITY_CODE
,      FEE_BAND
,      FEE_ELIGIBILITY
,      MAJOR_SOURCE_TUITION_FEE
,      NON_PAYMENT_REASON
,      FRANCHISING_ACTIVITY
,      TYPE_PROGRAM_YEAR
,      YOP_CREDIT_VALUE_1
,      LEVEL_CREDIT_1
,      YOP_CREDIT_VALUE_2
,      LEVEL_CREDIT_2
,      CREDIT_PTS_ACHIEVED1
,      CREDIT_LEVEL_ACHIEVED1
,      CREDIT_PTS_ACHIEVED2
,      CREDIT_LEVEL_ACHIEVED2
,      OTHER_INST_PROV_TEACHING1
,      OTHER_INST_PROV_TEACHING2
,      PROP_NOT_TAUGHT_BY_THIS_INST
,      FTE_PERC_OVERRIDE
,      FTE_INTENSITY
,      FTE_CALC_TYPE
,      CALCULATED_FTE
,      YEAR_OF_STUDENT_ON_PROGRAM
,      YOP_CREDIT_VALUE_3
,      LEVEL_CREDIT_3
,      YOP_CREDIT_VALUE_4
,      LEVEL_CREDIT_4
,      CREDIT_PTS_ACHIEVED3
,      CREDIT_LEVEL_ACHIEVED3
,      CREDIT_PTS_ACHIEVED4
,      CREDIT_LEVEL_ACHIEVED4
,      ENHANCED_FUNDING_ELIG_CODE
,      ADDITIONAL_SUPPORT_COST
,      DISADVANTAGE_UPLIFT_FACTOR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_ST_UNIT_SET_ATT_HESA_DET;

Dependencies

[top of page]

APPS.IGSBV_ST_UNIT_SET_ATT_HESA_DET references the following:

APPS: HZ_PARTIES; IGS_HE_EN_SUSA

APPS.IGSBV_ST_UNIT_SET_ATT_HESA_DET is not referenced by any database object