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

TABLE: IGS.IGS_UC_ISTARJ_INTS

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


Holds HESA data information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_ISTARJ_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
HUSID NUMBER (15)
Student HESA Identifier
SCOTVEC VARCHAR2 (9)
Scottish candidate number
SURNAME VARCHAR2 (40)
Surname
FNAMES VARCHAR2 (40)
First name
GENDER VARCHAR2 (1)
Gender
DOMICILE NUMBER (15)
Domicile code
NATION NUMBER (15)
Nationality
ETHNIC VARCHAR2 (2)
Ethnic code
DISABLE NUMBER (15)
Disability code
YRLLINST VARCHAR2 (4)
Year Last left institution
OCCCODE VARCHAR2 (4)
Occupation code
QUALENT2 VARCHAR2 (2)
Highest Qualification on entry code
SBJQA1 VARCHAR2 (4)
Subject of qualification Aim 1
SBJQA2 VARCHAR2 (4)
Subject of qualification Aim 2
SBJQA3 VARCHAR2 (4)
Subject of qualification Aim 3
SBJBID VARCHAR2 (1)
Qualification Aim proportion code
FEEELIG VARCHAR2 (1)
Fee eligibility
POSTCODE VARCHAR2 (8)
Post code
UCASNUM NUMBER (15)
UCAS applicant number
SEC VARCHAR2 (1)
Socio economic Code
SOC2000 VARCHAR2 (4)
Social Class indicator code
PREVINST VARCHAR2 (8)
Previous Institution
GCEASN NUMBER (15)
Number of GCE AS levels
GCEASTS NUMBER (15)
GCE AS Levels Tariff Score
VCEASN NUMBER (15)
No of VCE AS Levels
VCEASTS NUMBER (15)
VCE AS Levels Tariff Score
GCEAN NUMBER (15)
No of GCE A Levels
GCEATS NUMBER (15)
GCE A Levels Tariff Score
VCEAN NUMBER (15)
No of VCE A Levels
VCEATS NUMBER (15)
VCE A Levels Tariff Score
KSQN NUMBER (15)
No of Key Skills
KSQTS NUMBER (15)
Key Skills Tariff Score
UKSAN NUMBER (15)
No of 1 unit key skills
UKSATS NUMBER (15)
1 unit key skills Tariff Score
SAHN NUMBER (15)
No of Advanced Highers
SAHTS NUMBER (15)
Advanced Highers Tariff Score
SHN NUMBER (15)
No of Highers
SHTS NUMBER (15)
No of Highers Tariff Score
SI2N NUMBER (15)
No of Intermediates
SI2TS NUMBER (15)
Intermediates Tariff Score
SSGCN NUMBER (15)
No of standard grade
SSGCTS NUMBER (15)
Standard grade Tariff Score
SCSN NUMBER (15)
No of Scottish core skills
SCSTS NUMBER (15)
Scottish core skills Tariff Score
AEAN NUMBER (15)
No of Advanced Extension Awards
AEATS NUMBER (15)
Advanced Extension Awards Tariff Score
TOTALTS NUMBER (15)
Total UCAS Tariff score
RECORD_STATUS VARCHAR2 (1)
Status of the interface record , takes values N, O, D etc
ERROR_CODE VARCHAR2 (4)
Code for the error encountered during processing of this interface record data
BIRTHDTE VARCHAR2 (10)
Date of Birth
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPNO
,      HUSID
,      SCOTVEC
,      SURNAME
,      FNAMES
,      GENDER
,      DOMICILE
,      NATION
,      ETHNIC
,      DISABLE
,      YRLLINST
,      OCCCODE
,      QUALENT2
,      SBJQA1
,      SBJQA2
,      SBJQA3
,      SBJBID
,      FEEELIG
,      POSTCODE
,      UCASNUM
,      SEC
,      SOC2000
,      PREVINST
,      GCEASN
,      GCEASTS
,      VCEASN
,      VCEASTS
,      GCEAN
,      GCEATS
,      VCEAN
,      VCEATS
,      KSQN
,      KSQTS
,      UKSAN
,      UKSATS
,      SAHN
,      SAHTS
,      SHN
,      SHTS
,      SI2N
,      SI2TS
,      SSGCN
,      SSGCTS
,      SCSN
,      SCSTS
,      AEAN
,      AEATS
,      TOTALTS
,      RECORD_STATUS
,      ERROR_CODE
,      BIRTHDTE
FROM IGS.IGS_UC_ISTARJ_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARJ_INTS does not reference any database object

IGS.IGS_UC_ISTARJ_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_ISTARJ_INTS