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.IGS_HE_ST_SPA_DTLS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
HESA_ST_SPA_ID	NUMBER	(6)	Yes	Sequence generated record identifier
COURSE_CD	VARCHAR2	(6)	Yes	Course code
VERSION_NUMBER	NUMBER	(3)	Yes	Course version number
PERSON_ID	NUMBER	(15)	Yes	Person identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
PERSON_NAME	VARCHAR2	(360)	Yes	Person name
FE_STUDENT_MARKER	VARCHAR2	(30)		Further education student marker
FE_STUDENT_MARKER_DESC	VARCHAR2	(240)		Further education student marker description
DOMICILE_CD	VARCHAR2	(30)		Domicile code
DOMICILE_DESC	VARCHAR2	(240)		Domicile code description
INST_LAST_ATTENDED	VARCHAR2	(30)		Institution last attended
YEAR_LEFT_LAST_INST	VARCHAR2	(4)		Year left last institution
A_LEVEL_POINT_SCORE	NUMBER	(2)		A level point score
HIGHERS_POINTS_SCORES	NUMBER	(2)		Highers points scores
OCCUPATION_CODE	VARCHAR2	(30)		Parental Occupation code
OCCUPATION_CODE_DESC	VARCHAR2	(240)		Parental Occupation code description
OCCCODE	VARCHAR2	(30)		Occupation code
COMMENCEMENT_DT	DATE			Course attempt Commencement date
SPECIAL_STUDENT	VARCHAR2	(30)		Special student indicator
SPECIAL_STUDENT_DESC	VARCHAR2	(240)		Special student description
STUDENT_QUAL_AIM	VARCHAR2	(30)		Student qualification aim
STUDENT_QUAL_AIM_DESC	VARCHAR2	(90)		Student qualification aim description
STUDENT_FE_QUAL_AIM	VARCHAR2	(30)		Student further education qualification aim
STUDENT_FE_QUAL_AIM_DESC	VARCHAR2	(90)		Student further education qualification aim description
TEACHER_TRAIN_PROG_ID	VARCHAR2	(30)		Teacher training program identifier
TEACHER_TRAIN_PROG_DESC	VARCHAR2	(240)		Teacher training program identifier description
ITT_PHASE	VARCHAR2	(30)
ITT_PHASE_DESC	VARCHAR2	(240)
BILINGUAL_ITT_MARKER	VARCHAR2	(30)
BILINGUAL_ITT_MARKER_DESC	VARCHAR2	(240)
TEACHING_QUAL_GAIN_SECTOR	VARCHAR2	(30)
TEACHING_QUAL_GAIN_SECTOR_DESC	VARCHAR2	(240)
TEACHING_QUAL_GAIN_SUBJ1	VARCHAR2	(30)
TEACHING_QUAL_GAIN_SUBJ1_DESC	VARCHAR2	(240)
TEACHING_QUAL_GAIN_SUBJ2	VARCHAR2	(30)
TEACHING_QUAL_GAIN_SUBJ2_DESC	VARCHAR2	(240)
TEACHING_QUAL_GAIN_SUBJ3	VARCHAR2	(30)
TEACHING_QUAL_GAIN_SUBJ3_DESC	VARCHAR2	(240)
STUDENT_INST_NUMBER	VARCHAR2	(20)
HESA_RETURN_NAME	VARCHAR2	(50)
HESA_RETURN_ID	NUMBER	(15)
HESA_SUBMISSION_NAME	VARCHAR2	(50)
ASSOCIATE_UCAS_NUMBER	VARCHAR2	(1)
ASSOCIATE_SCOTT_CAND	VARCHAR2	(1)
ASSOCIATE_TEACH_REF_NUM	VARCHAR2	(1)
ASSOCIATE_NHS_REG_NUM	VARCHAR2	(1)
ITT_PROG_OUTCOME	VARCHAR2	(30)
ITT_PROG_OUTCOME_DESC	VARCHAR2	(240)
NHS_FUNDING_SOURCE	VARCHAR2	(30)
NHS_FUNDING_SOURCE_DESC	VARCHAR2	(240)
UFI_PLACE	VARCHAR2	(30)
UFI_PLACE_DESC	VARCHAR2	(240)
POSTCODE	VARCHAR2	(30)
SOCIAL_CLASS_IND	VARCHAR2	(30)
SOCIAL_CLASS_DESC	VARCHAR2	(240)
DESTINATION	VARCHAR2	(30)
DESTINATION_DESC	VARCHAR2	(240)
HIGHEST_QUAL_ON_ENTRY	VARCHAR2	(30)
HIGHEST_QUAL_ON_ENTRY_DESC	VARCHAR2	(60)
DATE_QUAL_ON_ENTRY_CALC	DATE
TOTAL_UCAS_TARIFF	NUMBER	(5)
NHS_EMPLOYER	VARCHAR2	(30)
NHS_EMPLOYER_DESC	VARCHAR2	(240)
RETURN_TYPE	VARCHAR2	(3)		Return Type
RETURN_TYPE_DESC	VARCHAR2	(80)		Return Type Description
CALCULATED_FTE	NUMBER	(5)		Calculated FTE
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
QUAL_AIM_SUBJ1	VARCHAR2	(10)		The Subject1 of qualification aim
QUAL_AIM_SUBJ1_DESC	VARCHAR2	(80)		The Subject1 Description of qualification aim
QUAL_AIM_SUBJ2	VARCHAR2	(10)		The Subject2 of qualification aim
QUAL_AIM_SUBJ2_DESC	VARCHAR2	(80)		The Subject2 Description of qualification aim
QUAL_AIM_SUBJ3	VARCHAR2	(10)		The Subject3 of qualification aim
QUAL_AIM_SUBJ3_DESC	VARCHAR2	(80)		The Subject3 Description of qualification aim
QUAL_AIM_PROPORTION	VARCHAR2	(30)		The code which identifies whether the qualification aim is balance or a major or minor
QUAL_AIM_PROPORTION_DESC	VARCHAR2	(240)		Description of the code identifying whether whether the qualification aim is balance or a major or minor
DEPENDANTS_CD	VARCHAR2	(30)		Dependants code
DEPENDANTS_DESC	VARCHAR2	(240)		Dependants description
IMPLIED_FUND_RATE	NUMBER			Implied rate of Council partial funding
GOV_INITIATIVES_CD	VARCHAR2	(30)		Government initiatives code
GOV_INITIATIVES_DESC	VARCHAR2	(240)		Government initiatives description
UNITS_FOR_QUAL	NUMBER			Number of units to achieve full qualification
DISADV_UPLIFT_ELIG_CD	VARCHAR2	(30)		Disadvantage uplift factor code
DISADV_UPLIFT_ELIG_DESC	VARCHAR2	(240)		Disadvantage uplift factor description
FRANCH_PARTNER_CD	VARCHAR2	(30)		Franchise Partner
FRANCH_PARTNER_DESC	VARCHAR2	(240)		Franchise Partner description
UNITS_COMPLETED	NUMBER			Number of units completed
FRANCH_OUT_ARR_CD	VARCHAR2	(30)		Franchised out arrangements code
FRANCH_OUT_ARR_DESC	VARCHAR2	(240)		Franchised out arrangements description
EMPLOYER_ROLE_CD	VARCHAR2	(30)		Employer role code
EMPLOYER_ROLE_DESC	VARCHAR2	(240)		Employer role description
DISADV_UPLIFT_FACTOR	NUMBER			Disadvantage uplift factor
ENH_FUND_ELIG_CD	VARCHAR2	(30)		Eligibility for enhanced funding code
ENH_FUND_ELIG_DESC	VARCHAR2	(240)		Eligibility for enhanced funding description
EXCLUDE_FLAG	VARCHAR2	(1)		Flag to identify record for exclusion from HESA extract

Query Text

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


SELECT ROW_ID
,      HESA_ST_SPA_ID
,      COURSE_CD
,      VERSION_NUMBER
,      PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      FE_STUDENT_MARKER
,      FE_STUDENT_MARKER_DESC
,      DOMICILE_CD
,      DOMICILE_DESC
,      INST_LAST_ATTENDED
,      YEAR_LEFT_LAST_INST
,      A_LEVEL_POINT_SCORE
,      HIGHERS_POINTS_SCORES
,      OCCUPATION_CODE
,      OCCUPATION_CODE_DESC
,      OCCCODE
,      COMMENCEMENT_DT
,      SPECIAL_STUDENT
,      SPECIAL_STUDENT_DESC
,      STUDENT_QUAL_AIM
,      STUDENT_QUAL_AIM_DESC
,      STUDENT_FE_QUAL_AIM
,      STUDENT_FE_QUAL_AIM_DESC
,      TEACHER_TRAIN_PROG_ID
,      TEACHER_TRAIN_PROG_DESC
,      ITT_PHASE
,      ITT_PHASE_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
,      STUDENT_INST_NUMBER
,      HESA_RETURN_NAME
,      HESA_RETURN_ID
,      HESA_SUBMISSION_NAME
,      ASSOCIATE_UCAS_NUMBER
,      ASSOCIATE_SCOTT_CAND
,      ASSOCIATE_TEACH_REF_NUM
,      ASSOCIATE_NHS_REG_NUM
,      ITT_PROG_OUTCOME
,      ITT_PROG_OUTCOME_DESC
,      NHS_FUNDING_SOURCE
,      NHS_FUNDING_SOURCE_DESC
,      UFI_PLACE
,      UFI_PLACE_DESC
,      POSTCODE
,      SOCIAL_CLASS_IND
,      SOCIAL_CLASS_DESC
,      DESTINATION
,      DESTINATION_DESC
,      HIGHEST_QUAL_ON_ENTRY
,      HIGHEST_QUAL_ON_ENTRY_DESC
,      DATE_QUAL_ON_ENTRY_CALC
,      TOTAL_UCAS_TARIFF
,      NHS_EMPLOYER
,      NHS_EMPLOYER_DESC
,      RETURN_TYPE
,      RETURN_TYPE_DESC
,      CALCULATED_FTE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      DEPENDANTS_CD
,      DEPENDANTS_DESC
,      IMPLIED_FUND_RATE
,      GOV_INITIATIVES_CD
,      GOV_INITIATIVES_DESC
,      UNITS_FOR_QUAL
,      DISADV_UPLIFT_ELIG_CD
,      DISADV_UPLIFT_ELIG_DESC
,      FRANCH_PARTNER_CD
,      FRANCH_PARTNER_DESC
,      UNITS_COMPLETED
,      FRANCH_OUT_ARR_CD
,      FRANCH_OUT_ARR_DESC
,      EMPLOYER_ROLE_CD
,      EMPLOYER_ROLE_DESC
,      DISADV_UPLIFT_FACTOR
,      ENH_FUND_ELIG_CD
,      ENH_FUND_ELIG_DESC
,      EXCLUDE_FLAG
FROM APPS.IGS_HE_ST_SPA_DTLS_V;

Dependencies

[top of page]

APPS.IGS_HE_ST_SPA_DTLS_V references the following:

APPS: IGS_AS_GRD_SCH_GRADE_V; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code; IGS_HE_CODE_VALUES; IGS_HE_ST_SPA; IGS_LOOKUPS_VIEW; IGS_PE_PERSON; IGS_PS_AWD; IGS_PS_FLD_OF_STUDY

APPS.IGS_HE_ST_SPA_DTLS_V is not referenced by any database object