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

VIEW: APPS.IGSBV_ST_PROG_ATT_HESA_DETAILS

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

View Type

A Business Intelligence System view


Base 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
PROGRAM_CODE VARCHAR2 (6) Yes Unique identifier for program of study student enrolled on
PROGRAM_VERSION_NUMBER NUMBER (3) Yes Version number of program student enrolled on
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
FE_STUDENT_MARKER VARCHAR2 (30)
FE student marker.Returned as HESA FESTUMK
HIGHEST_QUAL_ON_ENTRY VARCHAR2 (30)
Highest Qualification on Entry.Returned as HESA QUALENT2
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 program.Returned as HESA COMDATEOverrides student program attempt start date.
SPECIAL_STUDENT_CODE VARCHAR2 (30)
Special Student indicator.Returned as HESA SPCSTU
STUDENT_QUAL_AIM_AWD VARCHAR2 (30)
General qualification aim award of student.Returned as HESA QUALAIM.Overrides value derived from student program attempt award aim
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_SUBJ2 VARCHAR2 (10)
Subject(s) of qualification aim 2.Returned as HESA SBJQA2.Overrides values derived from program field of study
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_PROPORTION VARCHAR2 (30)
Proportion indicator.Returned as HESA SBJBID
STUDENT_FE_QUAL_AIM_AWD VARCHAR2 (30)
FE general qualification award aim of student.Returned as HESA FEQAIM
UFI_PLACE VARCHAR2 (30)
University for Industry Place.Returned as HESA UFIPLACE
POSTCODE VARCHAR2 (30)
Postcode on Entry.Returned as HESA POSTCODE
SOCIAL_CLASS_CODE VARCHAR2 (30)
Socio-economic classification on entry.Returned as HESA SEC
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 SOC2000
DOMICILE_CODE VARCHAR2 (30)
Domicile on entry.Returned as HESA DOMICILE
DESTINATION VARCHAR2 (30)
Destination.Returned as HESA DESTIN.
SOURCE_OF_DH_FUNDING VARCHAR2 (30)
Source of Department of Health funding Program override for HESA DHFUND
NHS_EMPLOYER VARCHAR2 (30)
National Health Service employer code. Returned as HESA NHSEMP
ASSOCIATE_UCAS_NUMBER VARCHAR2 (1)
If Y then UCASNUM returned to HESA for student
ASSOCIATE_SCOTT_CAND_NUMBER VARCHAR2 (1)
If Y then SCOTVEC number returned to HESA for Student
ASSOCIATE_TEACHER_REF_NUMBER VARCHAR2 (1)
If Y then TREFNO returned to HESA for student
ASSOCIATE_REG_BODY_REF_NUMBER VARCHAR2 (1)
If Y then DHREGREF number returned to HESA for Student
TEACHER_TRAINING_COURSE_ID VARCHAR2 (30)
Teacher training course identifier student.Program attempt override for HESA TTCID
ITT_PHASE_SCOPE VARCHAR2 (30)
Initial Teacher Training Phase/Scope.Program attempt override for HESA ITTPHSC
BILINGUAL_ITT_MARKER VARCHAR2 (30)
Bilingual Initial Teacher Training marker student.Program attempt override for HESA BITTM
TEACHING_QUAL_GAIN_SECTOR VARCHAR2 (30)
Teaching qualification gained sector .Program attempt override for HESA TQGSEC
TEACHING_QUAL_GAIN_SUBJ1 VARCHAR2 (30)
Teaching qualification gained subject 1.Returned as HESA TQGSUB1.
TEACHING_QUAL_GAIN_SUBJ2 VARCHAR2 (30)
Teaching qualification gained subject 2.Returned as HESA TQGSUB2.
TEACHING_QUAL_GAIN_SUBJ3 VARCHAR2 (30)
Teaching qualification gained subject 3.Returned as HESA TQGSUB3.
ITT_PROG_OUTCOME VARCHAR2 (30)
Outcome of Initial Teacher Training programme.Returned as HESA OUTCOME
HESA_SUBMISSION_NAME VARCHAR2 (50)
HESA submission name 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_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
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
UNITS_TO_ACHIEVE_QUALIFICATION NUMBER

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
FRANCHISE_PARTNER_CODE VARCHAR2 (30)
Franchise Partner.Program attempt override for HESA FRANPART
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
EMPLOYER_ROLE_CODE VARCHAR2 (30)
Employer Role.Returned as HESA EMPROLE
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
EXCLUDE_FLAG VARCHAR2 (1)
CREATED_BY DATE
Yes Standard WHO column
CREATION_DATE NUMBER (15) Yes Standard WHO column
LAST_UPDATED_BY DATE
Yes Standard WHO column
LAST_UPDATE_DATE NUMBER (15) Yes Standard WHO column
Query Text

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


SELECT HESA_STATS_SPA_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      STUDENT_INSTANCE_NUMBER
,      HESA_RETURN_TYPE
,      FE_STUDENT_MARKER
,      HIGHEST_QUAL_ON_ENTRY
,      UCAS_TARIFF_CALC_LAST_RUN_DATE
,      TOTAL_UCAS_TARIFF
,      COMMENCEMENT_DATE
,      SPECIAL_STUDENT_CODE
,      STUDENT_QUAL_AIM_AWD
,      QUAL_AIM_SUBJ1
,      QUAL_AIM_SUBJ2
,      QUAL_AIM_SUBJ3
,      QUAL_AIM_PROPORTION
,      STUDENT_FE_QUAL_AIM_AWD
,      UFI_PLACE
,      POSTCODE
,      SOCIAL_CLASS_CODE
,      PRE_2000_PARENTAL_OCCCODE
,      OCCUPATION_CODE
,      DOMICILE_CODE
,      DESTINATION
,      SOURCE_OF_DH_FUNDING
,      NHS_EMPLOYER
,      ASSOCIATE_UCAS_NUMBER
,      ASSOCIATE_SCOTT_CAND_NUMBER
,      ASSOCIATE_TEACHER_REF_NUMBER
,      ASSOCIATE_REG_BODY_REF_NUMBER
,      TEACHER_TRAINING_COURSE_ID
,      ITT_PHASE_SCOPE
,      BILINGUAL_ITT_MARKER
,      TEACHING_QUAL_GAIN_SECTOR
,      TEACHING_QUAL_GAIN_SUBJ1
,      TEACHING_QUAL_GAIN_SUBJ2
,      TEACHING_QUAL_GAIN_SUBJ3
,      ITT_PROG_OUTCOME
,      HESA_SUBMISSION_NAME
,      HESA_RETURN_NAME
,      HESA_RETURN_ID
,      DEPENDANTS_CODE
,      IMPLIED_FUNDING_RATE
,      GOVERNMENT_INITIATIVES_CODE
,      UNITS_TO_ACHIEVE_QUALIFICATION
,      DISADVANTAGE_UPLIFT_ELIG_CODE
,      FRANCHISE_PARTNER_CODE
,      UNITS_COMPLETED
,      FRANCHISED_OUT_ARRANGMNTS_CODE
,      EMPLOYER_ROLE_CODE
,      DISADVANTAGE_UPLIFT_FACTOR
,      ENHANCED_FUNDING_ELIG_CODE
,      EXCLUDE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_ST_PROG_ATT_HESA_DETAILS;

Dependencies

[top of page]

APPS.IGSBV_ST_PROG_ATT_HESA_DETAILS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_HE_ST_SPA_ALL

APPS.IGSBV_ST_PROG_ATT_HESA_DETAILS is not referenced by any database object