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]

TABLE: IGS.IGS_HE_LGCY_SPA_INT_OLD

Object Details

Object Name:	IGS_HE_LGCY_SPA_INT_OLD
Object Type:	TABLE
Owner:	IGS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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;

Dependencies

[top of page]

IGS.IGS_HE_LGCY_SPA_INT_OLD does not reference any database object

IGS.IGS_HE_LGCY_SPA_INT_OLD is referenced by following:

APPS: IGS_HE_LGCY_SPA_INT_OLD