[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_ST_SPA |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_HE_ST_SPA |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Stores Student Program attempt HESA details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
HESA_ST_SPA_ID | NUMBER | (6) | Yes | |
COURSE_CD | VARCHAR2 | (6) | Yes | |
VERSION_NUMBER | NUMBER | (3) | Yes | Version Number |
PERSON_ID | NUMBER | (15) | Yes | |
FE_STUDENT_MARKER | VARCHAR2 | (30) | ||
DOMICILE_CD | VARCHAR2 | (30) | ||
INST_LAST_ATTENDED | VARCHAR2 | (30) | ||
YEAR_LEFT_LAST_INST | VARCHAR2 | (4) | ||
HIGHEST_QUAL_ON_ENTRY | VARCHAR2 | (30) | ||
DATE_QUAL_ON_ENTRY_CALC | DATE | |||
A_LEVEL_POINT_SCORE | NUMBER | (2) | ||
HIGHERS_POINTS_SCORES | NUMBER | (2) | ||
OCCUPATION_CODE | VARCHAR2 | (30) | ||
COMMENCEMENT_DT | DATE | |||
SPECIAL_STUDENT | VARCHAR2 | (30) | ||
STUDENT_QUAL_AIM | VARCHAR2 | (30) | ||
STUDENT_FE_QUAL_AIM | VARCHAR2 | (30) | ||
TEACHER_TRAIN_PROG_ID | VARCHAR2 | (30) | ||
ITT_PHASE | VARCHAR2 | (30) | ||
BILINGUAL_ITT_MARKER | VARCHAR2 | (30) | ||
TEACHING_QUAL_GAIN_SECTOR | VARCHAR2 | (30) | ||
TEACHING_QUAL_GAIN_SUBJ1 | VARCHAR2 | (30) | ||
TEACHING_QUAL_GAIN_SUBJ2 | VARCHAR2 | (30) | ||
TEACHING_QUAL_GAIN_SUBJ3 | VARCHAR2 | (30) | ||
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) | ||
NHS_FUNDING_SOURCE | VARCHAR2 | (30) | ||
UFI_PLACE | VARCHAR2 | (30) | ||
POSTCODE | VARCHAR2 | (30) | ||
SOCIAL_CLASS_IND | VARCHAR2 | (30) | ||
DESTINATION | VARCHAR2 | (30) | ||
OCCCODE | VARCHAR2 | (30) | ||
TOTAL_UCAS_TARIFF | NUMBER | (5) | ||
NHS_EMPLOYER | VARCHAR2 | (30) | ||
RETURN_TYPE | VARCHAR2 | (3) | ||
CALCULATED_FTE | NUMBER | (5) | ||
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_SUBJ2 | VARCHAR2 | (10) | The Subject2 of qualification aim | |
QUAL_AIM_SUBJ3 | VARCHAR2 | (10) | The Subject3 of qualification aim | |
QUAL_AIM_PROPORTION | VARCHAR2 | (30) | The code which identifies whether the qualification aim is balance or a major or minor | |
DEPENDANTS_CD | VARCHAR2 | (30) | Dependants code | |
IMPLIED_FUND_RATE | NUMBER | Implied rate of Council partial funding | ||
GOV_INITIATIVES_CD | VARCHAR2 | (30) | Government initiatives code | |
UNITS_FOR_QUAL | NUMBER | Number of units to achieve full qualification | ||
DISADV_UPLIFT_ELIG_CD | VARCHAR2 | (30) | Disadvantage uplift factor code | |
FRANCH_PARTNER_CD | VARCHAR2 | (30) | Franchise Partner | |
UNITS_COMPLETED | NUMBER | Number of units completed | ||
FRANCH_OUT_ARR_CD | VARCHAR2 | (30) | Franchised out arrangements code | |
EMPLOYER_ROLE_CD | VARCHAR2 | (30) | Employer role code | |
DISADV_UPLIFT_FACTOR | NUMBER | Disadvantage uplift factor | ||
ENH_FUND_ELIG_CD | VARCHAR2 | (30) | Eligibility for enhanced funding code | |
EXCLUDE_FLAG | VARCHAR2 | (1) | Flag to identify record for exclusion from HESA extract |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, HESA_ST_SPA_ID
, COURSE_CD
, VERSION_NUMBER
, PERSON_ID
, FE_STUDENT_MARKER
, DOMICILE_CD
, INST_LAST_ATTENDED
, YEAR_LEFT_LAST_INST
, HIGHEST_QUAL_ON_ENTRY
, DATE_QUAL_ON_ENTRY_CALC
, A_LEVEL_POINT_SCORE
, HIGHERS_POINTS_SCORES
, OCCUPATION_CODE
, COMMENCEMENT_DT
, SPECIAL_STUDENT
, STUDENT_QUAL_AIM
, STUDENT_FE_QUAL_AIM
, TEACHER_TRAIN_PROG_ID
, ITT_PHASE
, BILINGUAL_ITT_MARKER
, TEACHING_QUAL_GAIN_SECTOR
, TEACHING_QUAL_GAIN_SUBJ1
, TEACHING_QUAL_GAIN_SUBJ2
, TEACHING_QUAL_GAIN_SUBJ3
, 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
, NHS_FUNDING_SOURCE
, UFI_PLACE
, POSTCODE
, SOCIAL_CLASS_IND
, DESTINATION
, OCCCODE
, TOTAL_UCAS_TARIFF
, NHS_EMPLOYER
, RETURN_TYPE
, CALCULATED_FTE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, QUAL_AIM_SUBJ1
, QUAL_AIM_SUBJ2
, QUAL_AIM_SUBJ3
, QUAL_AIM_PROPORTION
, DEPENDANTS_CD
, IMPLIED_FUND_RATE
, GOV_INITIATIVES_CD
, UNITS_FOR_QUAL
, DISADV_UPLIFT_ELIG_CD
, FRANCH_PARTNER_CD
, UNITS_COMPLETED
, FRANCH_OUT_ARR_CD
, EMPLOYER_ROLE_CD
, DISADV_UPLIFT_FACTOR
, ENH_FUND_ELIG_CD
, EXCLUDE_FLAG
FROM APPS.IGS_HE_ST_SPA;
|
|
|