[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_LGCY_SPA_INT_OLD |
---|---|
Object Type: | TABLE |
Owner: | IGS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | |
LEGACY_HESA_SPA_INT_ID | NUMBER | (15) | Yes | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | |
PROGRAM_CD | VARCHAR2 | (6) | Yes | |
FE_STUDENT_MARKER | VARCHAR2 | (30) | ||
DOMICILE_CD | VARCHAR2 | (30) | ||
HIGHEST_QUAL_ON_ENTRY | VARCHAR2 | (30) | ||
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) | Yes | |
DESTINATION | VARCHAR2 | (30) | ||
ITT_PROG_OUTCOME | VARCHAR2 | (30) | ||
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) | ||
NHS_EMPLOYER | VARCHAR2 | (30) | ||
RETURN_TYPE | VARCHAR2 | (3) | ||
SUBJ_QUALAIM1 | VARCHAR2 | (10) | ||
SUBJ_QUALAIM2 | VARCHAR2 | (10) | ||
SUBJ_QUALAIM3 | VARCHAR2 | (10) | ||
QUALAIM_PROPORTION | VARCHAR2 | (30) | ||
IMPORT_STATUS | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, LEGACY_HESA_SPA_INT_ID
, PERSON_NUMBER
, PROGRAM_CD
, FE_STUDENT_MARKER
, DOMICILE_CD
, HIGHEST_QUAL_ON_ENTRY
, 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
, ASSOCIATE_UCAS_NUMBER
, ASSOCIATE_SCOTT_CAND
, ASSOCIATE_TEACH_REF_NUM
, ASSOCIATE_NHS_REG_NUM
, NHS_FUNDING_SOURCE
, UFI_PLACE
, POSTCODE
, SOCIAL_CLASS_IND
, OCCCODE
, NHS_EMPLOYER
, RETURN_TYPE
, SUBJ_QUALAIM1
, SUBJ_QUALAIM2
, SUBJ_QUALAIM3
, QUALAIM_PROPORTION
, IMPORT_STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM IGS.IGS_HE_LGCY_SPA_INT_OLD;
IGS.IGS_HE_LGCY_SPA_INT_OLD does not reference any database object
IGS.IGS_HE_LGCY_SPA_INT_OLD is referenced by following:
|
|
|