[Home] [Help] [Dependency Information]
Object Name: | IGS_HE_LGCY_SPA_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.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
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_HE_LGCY_SPA_INT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | LEGACY_HESA_SPA_INT_ID |
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 |
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;
IGS.IGS_HE_LGCY_SPA_INT does not reference any database object
IGS.IGS_HE_LGCY_SPA_INT is referenced by following:
|
|
|