[Home] [Help]
[Dependency Information]
[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:
APPS
IGS_HE_ST_SPA_ALL_OLD
|
|
|
|