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

VIEW: APPS.IGSFV_ST_UNIT_SET_ATT_HESA_DET

Object Details
Object Name: IGSFV_ST_UNIT_SET_ATT_HESA_DET
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_ST_UNIT_SET_ATT_HESA_DET
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Full 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
PERSON_SURNAME VARCHAR2 (150)
Surname
PERSON_GIVEN_NAMES VARCHAR2 (150)
Given names
PERSON_FULL_NAME VARCHAR2 (450)
Full name
PROGRAM_CODE VARCHAR2 (6) Yes Unique identifier of program of study student enrolled on
PROGRAM_TITLE VARCHAR2 (90) Yes Program of study Title
PROGRAM_SHORT_TITLE VARCHAR2 (40) Yes Program of study Short Name
PROGRAM_ABBREVIATION VARCHAR2 (20) Yes Program of study Abbreviation
UNIT_SET_CODE VARCHAR2 (10) Yes Unique identifier for Year of Program Unit Set student enrolled on
UNIT_SET_TITLE VARCHAR2 (90) Yes Year of program unit set Title
UNIT_SET_SHORT_TITLE VARCHAR2 (40) Yes Year of program short unit set Title
UNIT_SET_ABBREVIATION VARCHAR2 (20) Yes Year of program abbreviation unit set Title
UNIT_SET_VERSION_NUMBER NUMBER (3) Yes Version number of year of program unit set student enrolled on
SEQUENCE_NUMBER NUMBER (6) Yes SEQUENCE_NUMBER
NEW_HE_ENTRANT_CODE VARCHAR2 (30)
New Entrant to HE Code.Returned as HESA ENTRYCDE
NEW_HE_ENTRANT_DESC VARCHAR2 (240)
New Entrant to HE description
TERM_TIME_ACCOMMODATION VARCHAR2 (30)
Term time accommodation indicator.Returned as HESA TTACCOM
TERM_TIME_ACCOMMODATION_DESC VARCHAR2 (240)
Term time accommodation description
DISABILITY_ALLOWANCE VARCHAR2 (30)
Disabled student allowance.Returned as HESA DISALL
DISABILITY_ALLOWANCE_DESC VARCHAR2 (240)
Disabled student allowance description
ADDITIONAL_SUP_BAND VARCHAR2 (30)
Additional support band.Returned as HESA ADSPBAND
ADDITIONAL_SUP_BAND_DESC VARCHAR2 (240)
Additional support band description
SLDD_DISCRETE_PROVISION VARCHAR2 (30)
SLDD - Discrete provision.Returned as HESA ST13
SLDD_DISCRETE_PROVISION_DESC VARCHAR2 (240)
SLDD - Discrete provision description
LOCATION_OF_STUDY VARCHAR2 (30)
Location of study.Student Unit Set Attempt override for HESA LOCSDY
LOCATION_OF_STUDY_DESC VARCHAR2 (240)
Location of study description
MODE_OF_STUDY VARCHAR2 (30)
Mode of Study.Student Unit Set Attempt override for HESA MODE
MODE_OF_STUDY_DESC VARCHAR2 (240)
Mode of study description
COMPLETION_STATUS VARCHAR2 (30)
Completion status.Returned as HESA CSTAT
COMPLETION_STATUS_DESC VARCHAR2 (240)
Completion status description
GOOD_STAND_MARKER VARCHAR2 (30)
Good standing marker.Returned as HESA PROGRESS
GOOD_STAND_MARKER_DESC VARCHAR2 (240)
Good standing marker description
COMPLETE_PYR_STUDY_CODE VARCHAR2 (30)
Completion of Year of programme of study.Returned as HESA FUNDCOMP
COMPLETE_PYR_STUDY_DESC VARCHAR2 (240)
Completion of Year of programme of study description
FUNDABILITY_CODE VARCHAR2 (30)
Fundability.Student Unit Set Attempt override for HESA FUNDCODE
FUNDABILITY_DESC VARCHAR2 (240)
Fundability description
FEE_BAND VARCHAR2 (30)
Fee Band.Student Unit Set Attempt override for HESA FEEBAND
FEE_BAND_DESC VARCHAR2 (240)
Fee Band Description
FEE_ELIGIBILITY VARCHAR2 (30)
Fee Eligibility.Returned as HESA FEEELIG
FEE_ELIGIBILITY_DESC VARCHAR2 (240)
Fee Eligibility description
MAJOR_SOURCE_TUITION_FEE VARCHAR2 (30)
Major source of tuition fees override to calculated value.Returned as HESA MSTUFEE
MAJOR_SOURCE_TUITION_FEE_DESC VARCHAR2 (240)
Major source of tuition fees description
NON_PAYMENT_REASON VARCHAR2 (30)
Reason for partial or full non-payment of tuition fees.Returned as HESA NONPAY
NON_PAYMENT_REASON_DESC VARCHAR2 (240)
Reason for partial or full non-payment of tuition fees description
FRANCHISING_ACTIVITY VARCHAR2 (30)
Collaboration/Franchising activity Student Unit Set Attempt override for HESA FRANACT
FRANCHISING_ACTIVITY_DESC VARCHAR2 (240)
Collaboration/Franchising activity description
TYPE_PROGRAM_YEAR VARCHAR2 (30)
Type of programme year.Student Unit Set Attempt override for HESA TYPEYR
TYPE_PROGRAM_YEAR_DESC VARCHAR2 (240)
Type of program year description
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
LEVEL_CREDIT_1_DESC VARCHAR2 (60)
Level of credit 1 description
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
LEVEL_CREDIT_2_DESC VARCHAR2 (60)
Level of credit 2 description
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_LEVEL_ACHIEVED1_DESC VARCHAR2 (60)
Level of credit 2 description
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.
CREDIT_LEVEL_ACHIEVED2_DESC VARCHAR2 (60)
Level of credit 2 description
OTHER_INST_PROV_TEACHING1 VARCHAR2 (30)
Other Institution providing teaching 1 Student Unit Set Attempt override for HESA TINST1
OTHER_INST_PROV_TEACHING1_DESC VARCHAR2 (360)
Other Institution providing teaching 1 Name
OTHER_INST_PROV_TEACHING2 VARCHAR2 (30)
Other Institution providing teaching 2 Student Unit Set Attempt override for HESA TINST2
OTHER_INST_PROV_TEACHING2_DESC VARCHAR2 (360)
Other Institution providing teaching 2 Name
PROP_NOT_TAUGHT_BY_THIS_INST NUMBER (5)
Proportion not taught by this institutionStudent 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 Year of Program 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
_LA:FTE_CALC_TYPE_DESC CHAR (69)
Full Time Equivalent Calculation Type description
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
LEVEL_CREDIT_3_DESC VARCHAR2 (60)
Level of credit3 description
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
LEVEL_CREDIT_4_DESC VARCHAR2 (60)
Level of credit 4 description
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_LEVEL_ACHIEVED3_DESC VARCHAR2 (60)
Level of credit 3 description
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.
CREDIT_LEVEL_ACHIEVED4_DESC VARCHAR2 (60)
Level of credit 4 description
ENHANCED_FUNDING_ELIG_CODE VARCHAR2 (30)
Eligibility for Enhanced Funding.Returned as HESA ELIGENFD
ENHANCED_FUNDING_ELIG_DESC VARCHAR2 (240)
Eligibility for enhanced funding description.
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
,      PERSON_SURNAME
,      PERSON_GIVEN_NAMES
,      PERSON_FULL_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      PROGRAM_SHORT_TITLE
,      PROGRAM_ABBREVIATION
,      UNIT_SET_CODE
,      UNIT_SET_TITLE
,      UNIT_SET_SHORT_TITLE
,      UNIT_SET_ABBREVIATION
,      UNIT_SET_VERSION_NUMBER
,      SEQUENCE_NUMBER
,      NEW_HE_ENTRANT_CODE
,      NEW_HE_ENTRANT_DESC
,      TERM_TIME_ACCOMMODATION
,      TERM_TIME_ACCOMMODATION_DESC
,      DISABILITY_ALLOWANCE
,      DISABILITY_ALLOWANCE_DESC
,      ADDITIONAL_SUP_BAND
,      ADDITIONAL_SUP_BAND_DESC
,      SLDD_DISCRETE_PROVISION
,      SLDD_DISCRETE_PROVISION_DESC
,      LOCATION_OF_STUDY
,      LOCATION_OF_STUDY_DESC
,      MODE_OF_STUDY
,      MODE_OF_STUDY_DESC
,      COMPLETION_STATUS
,      COMPLETION_STATUS_DESC
,      GOOD_STAND_MARKER
,      GOOD_STAND_MARKER_DESC
,      COMPLETE_PYR_STUDY_CODE
,      COMPLETE_PYR_STUDY_DESC
,      FUNDABILITY_CODE
,      FUNDABILITY_DESC
,      FEE_BAND
,      FEE_BAND_DESC
,      FEE_ELIGIBILITY
,      FEE_ELIGIBILITY_DESC
,      MAJOR_SOURCE_TUITION_FEE
,      MAJOR_SOURCE_TUITION_FEE_DESC
,      NON_PAYMENT_REASON
,      NON_PAYMENT_REASON_DESC
,      FRANCHISING_ACTIVITY
,      FRANCHISING_ACTIVITY_DESC
,      TYPE_PROGRAM_YEAR
,      TYPE_PROGRAM_YEAR_DESC
,      YOP_CREDIT_VALUE_1
,      LEVEL_CREDIT_1
,      LEVEL_CREDIT_1_DESC
,      YOP_CREDIT_VALUE_2
,      LEVEL_CREDIT_2
,      LEVEL_CREDIT_2_DESC
,      CREDIT_PTS_ACHIEVED1
,      CREDIT_LEVEL_ACHIEVED1
,      CREDIT_LEVEL_ACHIEVED1_DESC
,      CREDIT_PTS_ACHIEVED2
,      CREDIT_LEVEL_ACHIEVED2
,      CREDIT_LEVEL_ACHIEVED2_DESC
,      OTHER_INST_PROV_TEACHING1
,      OTHER_INST_PROV_TEACHING1_DESC
,      OTHER_INST_PROV_TEACHING2
,      OTHER_INST_PROV_TEACHING2_DESC
,      PROP_NOT_TAUGHT_BY_THIS_INST
,      FTE_PERC_OVERRIDE
,      FTE_INTENSITY
,      FTE_CALC_TYPE
,      _LA:FTE_CALC_TYPE_DESC
,      CALCULATED_FTE
,      YEAR_OF_STUDENT_ON_PROGRAM
,      YOP_CREDIT_VALUE_3
,      LEVEL_CREDIT_3
,      LEVEL_CREDIT_3_DESC
,      YOP_CREDIT_VALUE_4
,      LEVEL_CREDIT_4
,      LEVEL_CREDIT_4_DESC
,      CREDIT_PTS_ACHIEVED3
,      CREDIT_LEVEL_ACHIEVED3
,      CREDIT_LEVEL_ACHIEVED3_DESC
,      CREDIT_PTS_ACHIEVED4
,      CREDIT_LEVEL_ACHIEVED4
,      CREDIT_LEVEL_ACHIEVED4_DESC
,      ENHANCED_FUNDING_ELIG_CODE
,      ENHANCED_FUNDING_ELIG_DESC
,      ADDITIONAL_SUPPORT_COST
,      DISADVANTAGE_UPLIFT_FACTOR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ST_UNIT_SET_ATT_HESA_DET;

Dependencies

[top of page]

APPS.IGSFV_ST_UNIT_SET_ATT_HESA_DET references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES
SynonymIGS_EN_STDNT_PS_ATT_ALL
SynonymIGS_EN_UNIT_SET_ALL
SynonymIGS_HE_CODE_VALUES
SynonymIGS_HE_EN_SUSA
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PS_UNIT_LEVEL_ALL
SynonymIGS_PS_VER_ALL

APPS.IGSFV_ST_UNIT_SET_ATT_HESA_DET is not referenced by any database object