Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_HE_LGCY_SPA_INT

Object Details
Object Name: IGS_HE_LGCY_SPA_INT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_HE_LGCY_SPA_INT
Subobject Name:
Status: VALID


Contains Student Program Attempt HESA details to be imported into the IGS_HE_ST_SPA_ALL table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Student Program Attempt HESA Detail
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_HE_LGCY_SPA_INT_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnLEGACY_HESA_SPA_INT_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Batch Identifier, used to identify the set of records to be processed.
LEGACY_HESA_SPA_INT_ID NUMBER (15) Yes Unique identifier of the HESA Student program attempt statistics record.
PERSON_NUMBER VARCHAR2 (30) Yes Person Number
PROGRAM_CD VARCHAR2 (6) Yes Program Code
FE_STUDENT_MARKER VARCHAR2 (30)
Further Education Student Marker
DOMICILE_CD VARCHAR2 (30)
Domicile code
HIGHEST_QUAL_ON_ENTRY VARCHAR2 (30)
Highest qualification on entry
OCCUPATION_CODE VARCHAR2 (30)
Parental Occupation
COMMENCEMENT_DT DATE

Commencement date
SPECIAL_STUDENT VARCHAR2 (30)
Special Student
STUDENT_QUAL_AIM VARCHAR2 (30)
Student qualification aim
STUDENT_FE_QUAL_AIM VARCHAR2 (30)
Student Further Education qualification aim
TEACHER_TRAIN_PROG_ID VARCHAR2 (30)
Teacher Training Program ID
ITT_PHASE VARCHAR2 (30)
Initial teacher training Phase
BILINGUAL_ITT_MARKER VARCHAR2 (30)
Bilingual Initial teacher training Marker
TEACHING_QUAL_GAIN_SECTOR VARCHAR2 (30)
Teaching Qualification Gain Sector
TEACHING_QUAL_GAIN_SUBJ1 VARCHAR2 (30)
Teaching Qualification Gain Subject 1
TEACHING_QUAL_GAIN_SUBJ2 VARCHAR2 (30)
Teaching Qualification Gain Subject 2
TEACHING_QUAL_GAIN_SUBJ3 VARCHAR2 (30)
Teaching Qualification Gain Subject 3
STUDENT_INST_NUMBER VARCHAR2 (20) Yes Student Instance Number
DESTINATION VARCHAR2 (30)
Destination
ITT_PROG_OUTCOME VARCHAR2 (30)
Initial teacher training Program Outcome
ASSOCIATE_UCAS_NUMBER VARCHAR2 (1)
Associate UCAS number
ASSOCIATE_SCOTT_CAND VARCHAR2 (1)
Associate Scottish Candidate
ASSOCIATE_TEACH_REF_NUM VARCHAR2 (1)
Associate Teaching reference number
ASSOCIATE_NHS_REG_NUM VARCHAR2 (1)
Associate National Health Service registration number
NHS_FUNDING_SOURCE VARCHAR2 (30)
National Health Service Funding Source
UFI_PLACE VARCHAR2 (30)
University for Industry Place
POSTCODE VARCHAR2 (30)
Post code
SOCIAL_CLASS_IND VARCHAR2 (30)
Social Class Indicator
OCCCODE VARCHAR2 (30)
Pre-2000 Parental Occupation
NHS_EMPLOYER VARCHAR2 (30)
National Health Service Employer
RETURN_TYPE VARCHAR2 (3)
Return type
SUBJ_QUALAIM1 VARCHAR2 (10)
Subject Qualification Aim 1
SUBJ_QUALAIM2 VARCHAR2 (10)
Subject Qualification Aim 2
SUBJ_QUALAIM3 VARCHAR2 (10)
Subject Qualification Aim 3
QUALAIM_PROPORTION VARCHAR2 (30)
Qualification Aim Proportion
IMPORT_STATUS VARCHAR2 (1)
Record's Import status, allowable values are 'U' - Unprocessed (Default),'R' - Ready for Reprocessing,'E' - Error,'W' - Warning and 'I' - Imported
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
REQUEST_ID NUMBER (15)
Standard concurrent program who column
PROGRAM_ID NUMBER (15)
Standard concurrent program who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard concurrent program who column
PROGRAM_UPDATE_DATE DATE

Standard concurrent program who column
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 code
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
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
,      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
FROM IGS.IGS_HE_LGCY_SPA_INT;

Dependencies

[top of page]

IGS.IGS_HE_LGCY_SPA_INT does not reference any database object

IGS.IGS_HE_LGCY_SPA_INT is referenced by following:

SchemaAPPS
SynonymIGS_HE_LGCY_SPA_INT