[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_ST_SPA_ALL_OLD |
---|---|
Object Type: | TABLE |
Owner: | IGS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HESA_ST_SPA_ID | NUMBER | (6) | Yes | |
ORG_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | Yes | |
COURSE_CD | VARCHAR2 | (6) | Yes | |
VERSION_NUMBER | NUMBER | (3) | 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 | NUMBER | (15) | ||
DESTINATION | VARCHAR2 | (30) | ||
ITT_PROG_OUTCOME | VARCHAR2 | (30) | ||
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) | ||
NHS_FUNDING_SOURCE | VARCHAR2 | (30) | ||
UFI_PLACE | VARCHAR2 | (30) | ||
POSTCODE | VARCHAR2 | (30) | ||
SOCIAL_CLASS_IND | VARCHAR2 | (30) | ||
OCCCODE | VARCHAR2 | (30) | ||
TOTAL_UCAS_TARIFF | NUMBER | (5) | ||
NHS_EMPLOYER | VARCHAR2 | (30) | ||
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) | ||
RETURN_TYPE | VARCHAR2 | (3) | ||
CALCULATED_FTE | NUMBER | (5) | ||
QUAL_AIM_SUBJ1 | VARCHAR2 | (10) | ||
QUAL_AIM_SUBJ2 | VARCHAR2 | (10) | ||
QUAL_AIM_SUBJ3 | VARCHAR2 | (10) | ||
QUAL_AIM_PROPORTION | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT HESA_ST_SPA_ID
, ORG_ID
, PERSON_ID
, COURSE_CD
, VERSION_NUMBER
, 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
, DESTINATION
, ITT_PROG_OUTCOME
, HESA_RETURN_NAME
, HESA_RETURN_ID
, HESA_SUBMISSION_NAME
, ASSOCIATE_UCAS_NUMBER
, ASSOCIATE_SCOTT_CAND
, ASSOCIATE_TEACH_REF_NUM
, ASSOCIATE_NHS_REG_NUM
, NHS_FUNDING_SOURCE
, UFI_PLACE
, POSTCODE
, SOCIAL_CLASS_IND
, OCCCODE
, TOTAL_UCAS_TARIFF
, NHS_EMPLOYER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RETURN_TYPE
, CALCULATED_FTE
, QUAL_AIM_SUBJ1
, QUAL_AIM_SUBJ2
, QUAL_AIM_SUBJ3
, QUAL_AIM_PROPORTION
FROM IGS.IGS_HE_ST_SPA_ALL_OLD;
IGS.IGS_HE_ST_SPA_ALL_OLD does not reference any database object
IGS.IGS_HE_ST_SPA_ALL_OLD is referenced by following:
|
|
|