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

VIEW: APPS.IGSFV_ST_PROG_ATT_HESA_DETAILS

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

View Type

A Business Intelligence System view


Full View for Student Program Attempt HESA Details


[View Source]

Columns
Name Datatype Length Mandatory Comments
HESA_STATS_SPA_ID NUMBER (6) Yes Sequence number uniquely identifying the HESA statistics student program 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 for 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
PROGRAM_VERSION_NUMBER NUMBER (3) Yes Version number of program student enrolled on
HUSID VARCHAR2 (20)
Student HUSID
STUDENT_INSTANCE_NUMBER VARCHAR2 (20)
Student instance number.Returned as HESA NUMHUS
HESA_RETURN_TYPE VARCHAR2 (3)
Type of HESA reduce return produced for this student
_LA:HESA_RETURN_TYPE_DESC CHAR (60)
Return type description
FE_STUDENT_MARKER VARCHAR2 (30)
FE student marker.Returned as HESA FESTUMK.
FE_STUDENT_MARKER_DESC VARCHAR2 (240)
FE Student marker description
HIGHEST_QUAL_ON_ENTRY VARCHAR2 (30)
Highest Qualification on Entry.Returned as HESA QUALENT2
HIGHEST_QUAL_ON_ENTRY_DESC VARCHAR2 (60)
Highest Qualification on entry description
UCAS_TARIFF_CALC_LAST_RUN_DATE DATE

Date UCAS tariff Calculation last run for HESA reporting purposes
TOTAL_UCAS_TARIFF NUMBER (5)
Total UCAS tariff. Returned as HESA TOTALTS.
COMMENCEMENT_DATE DATE

Date of commencement of programme.Returned as HESA COMDATE.Overrides student program attempt start date.
SPECIAL_STUDENT_CODE VARCHAR2 (30)
Special Student indicator.Returned as HESA SPCSTU.
SPECIAL_STUDENT_DESC VARCHAR2 (240)
Special Student description
STUDENT_QUAL_AIM_AWD VARCHAR2 (30)
General qualification aim of student.Returned as HESA QUALAIM.Overrides value derived from student program attempt award aim
STUDENT_QUAL_AIM_AWD_TITLE VARCHAR2 (90)
Student General qualification aim award title
QUAL_AIM_SUBJ1 VARCHAR2 (10)
Subject(s) of qualification aim 1.Returned as HESA SBJQA1.Overrides values derived from program field of study
QUAL_AIM_SUBJ1_DESC VARCHAR2 (80)
Subject of qualification aim description 1
QUAL_AIM_SUBJ2 VARCHAR2 (10)
Subject(s) of qualification aim 2.Returned as HESA SBJQA2.Overrides values derived from program field of study
QUAL_AIM_SUBJ2_DESC VARCHAR2 (80)
Subject of qualification aim description 2
QUAL_AIM_SUBJ3 VARCHAR2 (10)
Subject(s) of qualification aim 3.Returned as HESA SBJQA3.Overrides values derived from program field of study.
QUAL_AIM_SUBJ3_DESC VARCHAR2 (80)
Subject of qualification aim description 3
QUAL_AIM_PROPORTION VARCHAR2 (30)
Proportion indicator.Returned as HESA SBJBID
QUAL_AIM_PROPORTION_DESC VARCHAR2 (240)
Subject proportion indicator description
STUDENT_FE_QUAL_AIM_AWD VARCHAR2 (30)
FE general qualification aim of student.Returned as HESA FEQAIM
STUDENT_FE_QUAL_AIM_AWD_TITLE VARCHAR2 (90)
Student FE general qualification aim award title
UFI_PLACE VARCHAR2 (30)
University for Industry Place.Returned as HESA UFIPLACE
UFI_PLACE_DESC VARCHAR2 (240)
University for Industry Place Description
POSTCODE VARCHAR2 (30)
Postcode on Entry.Returned as HESA POSTCODE
SOCIAL_CLASS_CODE VARCHAR2 (30)
Socio-economic classification on entry.Returned as HESA SEC
SOCIAL_CLASS_DESC VARCHAR2 (240)
Socio-economic classification description
PRE_2000_PARENTAL_OCCCODE VARCHAR2 (30)
Pre-2000 parental occupation code.Returned as HESA OCCCODE
OCCUPATION_CODE VARCHAR2 (30)
Post-2000 parental occupation code. Returned as HESA SOC2000
OCCUPATION_DESC VARCHAR2 (240)
Post-2000 parental occupation code description
DOMICILE_CODE VARCHAR2 (30)
Domicile on entry.Returned as HESA DOMICILE
DOMCILE_DESC VARCHAR2 (240)
Domicile description
DESTINATION VARCHAR2 (30)
Destination of student.Returned as HESA DESTIN
DESTINATION_DESC VARCHAR2 (240)
Fundability description
SOURCE_OF_DH_FUNDING VARCHAR2 (30)
Source of Department of Health funding.Program attempt override for HESA DHFUND
SOURCE_OF_DH_FUNDING_DESC VARCHAR2 (240)
Source of Department of Health funding description
NHS_EMPLOYER VARCHAR2 (30)
National Health Service employer code. Returned as HESA NHSEMP
NHS_EMPLOYER_DESC VARCHAR2 (240)
National Health Service employer description
ASSOCIATE_UCAS_NUMBER VARCHAR2 (1)
If Y then UCASNUM returned to HESA for student
UCAS_NUMBER VARCHAR2 (20)
UCAS application Number
GTTR_NUMBER VARCHAR2 (20)
GTTR application Number
SWAS_NUMBER VARCHAR2 (20)
SWAS application Number
NMAS_NUMBER VARCHAR2 (20)
NMAS application Number
ASSOCIATE_SCOTT_CAND_NUMBER VARCHAR2 (1)
If Y then SCOTVEC number returned to HESA for Student
SCOTT_CAND_NUMBER VARCHAR2 (20)
Scottish Candidate Number
ASSOCIATE_TEACHER_REF_NUMBER VARCHAR2 (1)
If Y then TREFNO returned to HESA for student
TEACHER_TRAINING_REF_NUMBER VARCHAR2 (20)
Teacher training reference number
ASSOCIATE_REG_BODY_REF_NUMBER VARCHAR2 (1)
If Y then DHREGREF number returned to HESA for Student
REG_BODY_REF_NUMBER VARCHAR2 (20)
Regulatory body reference number
TEACHER_TRAINING_COURSE_ID VARCHAR2 (30)
Teacher training course identifier.Program attempt override for HESA TTCID
TEACHER_TRAINING_COURSE_DESC VARCHAR2 (240)
Teacher training course identifier description
ITT_PHASE_SCOPE VARCHAR2 (30)
Initial Teacher Training Phase/Scope.Program attempt override for HESA ITTPHSC Field
ITT_PHASE_SCOPE_DESC VARCHAR2 (240)
Initial Teacher Training Phase/Scope description
BILINGUAL_ITT_MARKER VARCHAR2 (30)
Bilingual Initial Teacher Training marker.Program attempt override for HESA BITTM Field
BILINGUAL_ITT_MARKER_DESC VARCHAR2 (240)
Bilingual Initial Teacher Training marker description
TEACHING_QUAL_GAIN_SECTOR VARCHAR2 (30)
Teaching qualification gained sector. Program override for HESA TQGSEC
TEACHING_QUAL_GAIN_SECTOR_DESC VARCHAR2 (240)
Teaching qualification gained sector description
TEACHING_QUAL_GAIN_SUBJ1 VARCHAR2 (30)
Teaching qualification gained subject 1.Returned as HESA TQGSUB1.
TEACHING_QUAL_GAIN_SUBJ1_DESC VARCHAR2 (240)
Teaching qualification gain subject 1 description
TEACHING_QUAL_GAIN_SUBJ2 VARCHAR2 (30)
Teaching qualification gained subject 2.Returned as HESA TQGSUB2.
TEACHING_QUAL_GAIN_SUBJ2_DESC VARCHAR2 (240)
Teaching qualification gain subject 2 description
TEACHING_QUAL_GAIN_SUBJ3 VARCHAR2 (30)
Teaching qualification gained subject 3.Returned as HESA TQGSUB3.
TEACHING_QUAL_GAIN_SUBJ3_DESC VARCHAR2 (240)
Teaching qualification gain subject 3 description
ITT_PROG_OUTCOME VARCHAR2 (30)
Outcome of Initial Teacher Training programme.Returned as HESA OUTCOME
ITT_PROG_OUTCOME_DESC VARCHAR2 (240)
Outcome of Initial Teacher Training programme description
HESA_SUBMISSION_NAME VARCHAR2 (50)
HESA submission name of last HESA return submitted for the student program attempt
HESA_SUBMISSION_DESC VARCHAR2 (200)
HESA submission description of last HESA return submitted for the student program attempt
HESA_RETURN_NAME VARCHAR2 (50)
HESA return name of last HESA return submitted for the student program attempt
HESA_USER_RETURN_SUBCLASS VARCHAR2 (50)
HESA return sub-class of the last HESA return submitted for the student program attempt
HESA_USER_RETURN_SUBCLASS_DESC VARCHAR2 (200)
The HESA return user sub-class description of the last HESA return submitted for the student program attempt
HESA_RETURN_ID NUMBER (15)
HESA return id uniquely identifying the last HESA return submitted for the student program attempt
DEPENDANTS_CODE VARCHAR2 (30)
Dependants. Returned as HESA DEPEND
DEPENDANTS_DESC VARCHAR2 (240)
Description
IMPLIED_FUNDING_RATE NUMBER

Implied Rate of Council Partial Funding. Program attempt override for HESA IMPRATE
GOVERNMENT_INITIATIVES_CODE VARCHAR2 (30)
Government Initiative. Program attempt override for HESA GOVINIT
GOVERNMENT_INITIATIVES_DESC VARCHAR2 (240)
Description
UNITS_TO_ACHIEVE_QUALIFICATION NUMBER

Number of Units to Achieve Full Qualification.Program attempt override for HESA NOUNTACH Number of Units to Achieve Full Qualification.Program attempt override for HESA NOUNTACH
DISADVANTAGE_UPLIFT_ELIG_CODE VARCHAR2 (30)
Eligibility for Disadvantage Uplift.Program attempt override for HESA ELIDISUP
DISADVANTAGE_UPLIFT_ELIG_DESC VARCHAR2 (240)
Description
FRANCHISE_PARTNER_CODE VARCHAR2 (30)
Franchise Partner.Program attempt override for HESA FRANPART
FRANCHISE_PARTNER_DESC VARCHAR2 (240)
Description
UNITS_COMPLETED NUMBER

Number of Units Completed.Returned as HESA NUMUNITS
FRANCHISED_OUT_ARRANGMNTS_CODE VARCHAR2 (30)
Franchised Out Arrangements.Program attempt override for HESA FROUTARR
FRANCHISED_OUT_ARRANGMNTS_DESC VARCHAR2 (240)
Description
EMPLOYER_ROLE_CODE VARCHAR2 (30)
Employer Role.Returned as HESA EMPROLE
EMPLOYER_ROLE_DESC VARCHAR2 (240)
Description
DISADVANTAGE_UPLIFT_FACTOR NUMBER

Disadvantage Uplift Factor.Returned as HESA DISUPFAC
ENHANCED_FUNDING_ELIG_CODE VARCHAR2 (30)
Eligibility for Enhanced Funding.Returned as HESA ELIGENFD
ENHANCED_FUNDING_ELIG_DESC VARCHAR2 (240)
Description
EXCLUDE_FLAG VARCHAR2 (1)
Flag to identify record for exclusion from HESA extract
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_STATS_SPA_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PERSON_SURNAME
,      PERSON_GIVEN_NAMES
,      PERSON_FULL_NAME
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      PROGRAM_SHORT_TITLE
,      PROGRAM_ABBREVIATION
,      PROGRAM_VERSION_NUMBER
,      HUSID
,      STUDENT_INSTANCE_NUMBER
,      HESA_RETURN_TYPE
,      _LA:HESA_RETURN_TYPE_DESC
,      FE_STUDENT_MARKER
,      FE_STUDENT_MARKER_DESC
,      HIGHEST_QUAL_ON_ENTRY
,      HIGHEST_QUAL_ON_ENTRY_DESC
,      UCAS_TARIFF_CALC_LAST_RUN_DATE
,      TOTAL_UCAS_TARIFF
,      COMMENCEMENT_DATE
,      SPECIAL_STUDENT_CODE
,      SPECIAL_STUDENT_DESC
,      STUDENT_QUAL_AIM_AWD
,      STUDENT_QUAL_AIM_AWD_TITLE
,      QUAL_AIM_SUBJ1
,      QUAL_AIM_SUBJ1_DESC
,      QUAL_AIM_SUBJ2
,      QUAL_AIM_SUBJ2_DESC
,      QUAL_AIM_SUBJ3
,      QUAL_AIM_SUBJ3_DESC
,      QUAL_AIM_PROPORTION
,      QUAL_AIM_PROPORTION_DESC
,      STUDENT_FE_QUAL_AIM_AWD
,      STUDENT_FE_QUAL_AIM_AWD_TITLE
,      UFI_PLACE
,      UFI_PLACE_DESC
,      POSTCODE
,      SOCIAL_CLASS_CODE
,      SOCIAL_CLASS_DESC
,      PRE_2000_PARENTAL_OCCCODE
,      OCCUPATION_CODE
,      OCCUPATION_DESC
,      DOMICILE_CODE
,      DOMCILE_DESC
,      DESTINATION
,      DESTINATION_DESC
,      SOURCE_OF_DH_FUNDING
,      SOURCE_OF_DH_FUNDING_DESC
,      NHS_EMPLOYER
,      NHS_EMPLOYER_DESC
,      ASSOCIATE_UCAS_NUMBER
,      UCAS_NUMBER
,      GTTR_NUMBER
,      SWAS_NUMBER
,      NMAS_NUMBER
,      ASSOCIATE_SCOTT_CAND_NUMBER
,      SCOTT_CAND_NUMBER
,      ASSOCIATE_TEACHER_REF_NUMBER
,      TEACHER_TRAINING_REF_NUMBER
,      ASSOCIATE_REG_BODY_REF_NUMBER
,      REG_BODY_REF_NUMBER
,      TEACHER_TRAINING_COURSE_ID
,      TEACHER_TRAINING_COURSE_DESC
,      ITT_PHASE_SCOPE
,      ITT_PHASE_SCOPE_DESC
,      BILINGUAL_ITT_MARKER
,      BILINGUAL_ITT_MARKER_DESC
,      TEACHING_QUAL_GAIN_SECTOR
,      TEACHING_QUAL_GAIN_SECTOR_DESC
,      TEACHING_QUAL_GAIN_SUBJ1
,      TEACHING_QUAL_GAIN_SUBJ1_DESC
,      TEACHING_QUAL_GAIN_SUBJ2
,      TEACHING_QUAL_GAIN_SUBJ2_DESC
,      TEACHING_QUAL_GAIN_SUBJ3
,      TEACHING_QUAL_GAIN_SUBJ3_DESC
,      ITT_PROG_OUTCOME
,      ITT_PROG_OUTCOME_DESC
,      HESA_SUBMISSION_NAME
,      HESA_SUBMISSION_DESC
,      HESA_RETURN_NAME
,      HESA_USER_RETURN_SUBCLASS
,      HESA_USER_RETURN_SUBCLASS_DESC
,      HESA_RETURN_ID
,      DEPENDANTS_CODE
,      DEPENDANTS_DESC
,      IMPLIED_FUNDING_RATE
,      GOVERNMENT_INITIATIVES_CODE
,      GOVERNMENT_INITIATIVES_DESC
,      UNITS_TO_ACHIEVE_QUALIFICATION
,      DISADVANTAGE_UPLIFT_ELIG_CODE
,      DISADVANTAGE_UPLIFT_ELIG_DESC
,      FRANCHISE_PARTNER_CODE
,      FRANCHISE_PARTNER_DESC
,      UNITS_COMPLETED
,      FRANCHISED_OUT_ARRANGMNTS_CODE
,      FRANCHISED_OUT_ARRANGMNTS_DESC
,      EMPLOYER_ROLE_CODE
,      EMPLOYER_ROLE_DESC
,      DISADVANTAGE_UPLIFT_FACTOR
,      ENHANCED_FUNDING_ELIG_CODE
,      ENHANCED_FUNDING_ELIG_DESC
,      EXCLUDE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_ST_PROG_ATT_HESA_DETAILS;

Dependencies

[top of page]

APPS.IGSFV_ST_PROG_ATT_HESA_DETAILS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES
SynonymIGS_AS_GRD_SCH_GRADE
SynonymIGS_HE_CODE_VALUES
SynonymIGS_HE_EXT_RUN_DTLS
SynonymIGS_HE_ST_SPA_ALL
SynonymIGS_HE_SUBMSN_HEADER
SynonymIGS_HE_USR_RTN_CLAS
SynonymIGS_PE_ALT_PERS_ID
SynonymIGS_PS_AWD
SynonymIGS_PS_FLD_OF_STUDY_ALL
SynonymIGS_PS_VER_ALL

APPS.IGSFV_ST_PROG_ATT_HESA_DETAILS is not referenced by any database object