Skip to content

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

TABLE: IGS.IGS_UC_ISTARK_INTS

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


Holds Applicant details columns for small systems


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_ISTARK_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnAPPNO
Columns
Name Datatype Length Mandatory Comments
APPNO NUMBER (22)
Application Number
APPLICATIONDATE DATE

Application Date
SENTDATE DATE

Date sent out
RUNSENT NUMBER (22)
Run or Batch number when sent
CODEDCHANGEDATE DATE

Coded information changed date
SCHOOL NUMBER (22)
School code
RESCAT VARCHAR2 (1)
Residential Category
FEELEVEL VARCHAR2 (1)
F - full fee, S - single entry fee(UCAS fee level received from applicant)
FEEPAYER NUMBER (22)
Fee Payer Code see Error! Reference source not found. cvRefFee
FEETEXT VARCHAR2 (30)
EAS fee payer name
APR NUMBER (22)
Refers to Error. Reference source not found.cvrefAPR - all values
LEA VARCHAR2 (1)
**FIELD NO LONGER USED (2002)** deprecated
COUNTRYBIRTH NUMBER (22)
Refers to Error.Reference source not found.cvrefAPR - Countries
NATIONALITY NUMBER (22)
Refers to Error. Reference source not found.cvrefAPR - Countries
DUALNATIONALITY NUMBER (22)
EAS - same format as Nationality, but contains other nationality
WITHDRAWN VARCHAR2 (1)
Null - not withdrawn, C - candidate withdrew, R - reinstatedW - UF withdrawal
WITHDRAWNDATE DATE

Date candidate withdrew or was reinstated
ROUTEB VARCHAR2 (1)
Y - route B is required
EXAMCHANGEDATE DATE

Exam details changed date
ALEVELS VARCHAR2 (1)
** FIELD NO LONGER USED (2002)** deprecated
ASLEVELS VARCHAR2 (1)
** FIELD NO LONGER USED (2002)** deprecated
HIGHERS VARCHAR2 (1)
** FIELD NO LONGER USED (2002)** deprecated
CSYS VARCHAR2 (1)
** FIELD NO LONGER USED (2002)** deprecated
GCE NUMBER (22)
Number of GCE (A + AS) expected
VCE NUMBER (22)
Number of VCE (A + AS + Double) expected
SQA VARCHAR2 (1)
Y - SQA Candidate
WINTER NUMBER (22)
Number of Winter A Levels
PREVIOUSA NUMBER (22)
Number of previous Summer A levels
PREVIOUSAS NUMBER (22)
Number of previous Summer AS levels
KEYSKILLS VARCHAR2 (1)
Y - taking Key Skills, N - not taking Key Skills
VOCATIONAL VARCHAR2 (1)
Null - not taking vocational exams, 1 - taking Higher BTEC (HNC or HND), 2 - taking Lower BTEC (NC or ND), 3 - taking Foundation Art and Design course
GNVQ VARCHAR2 (1)
** FIELD NO LONGER USED (2002)** deprecated
BTEC VARCHAR2 (1)
Y - BTEC
ILC VARCHAR2 (1)
Y - ILC
AICE VARCHAR2 (1)
Y - AICE
IB VARCHAR2 (1)
Y - International Baccalaureate
MANUAL VARCHAR2 (1)
Y - manual investigation of previous results required
REGNO VARCHAR2 (7)
BTEC registration number
SCN VARCHAR2 (9)
Scottish Candidate Number
OEQ VARCHAR2 (1)
Other Examination Qualifications
PREVOEQ VARCHAR2 (1)
Previous Other Examination Qualifications
EAS VARCHAR2 (1)
Y - Applied through EAS
ROA VARCHAR2 (1)
Y - record of achievement (EAS applicants only)
SPECIALNEEDS VARCHAR2 (1)
0 - No disability, 1 - Dyslexia, 2 - Blind or partial sight, 3 - Deaf or partial hearing, 4 - Wheelchair or mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability
CRIMINALCONV VARCHAR2 (1)
Criminal Conviction. Null - not known, Y - Yes, N - No
UKENTRYDATE DATE

Date of first entry to UK
STATUS VARCHAR2 (3)
Status code from cvRefStatus
FIRMNOW NUMBER (22)
Firm choice number
FIRMREPLY NUMBER (22)
Firm Reply
INSURANCEREPLY NUMBER (22)
Insurance Reply
CONFHISTFIRMREPLY NUMBER (22)
Confirmation history firm reply
CONFHISTINSURANCEREPLY NUMBER (22)
Confirmation history insurance reply
CHOICESALLTRANSPARENT VARCHAR2 (1)
Indicates whether the Student Applications Choices are visible to institution or not
EXTRASTATUS NUMBER (22)
Indicates whether the applicant is in extra processing
EXTRAPASSPORTNO VARCHAR2 (6)
Passport ID used in UCAS Extra. For applicants applying on web will contain WEB
WELSHSPEAKER VARCHAR2 (1)
SWAS - Welsh Speaker
NINUMBER VARCHAR2 (12)
NMAS - NI Number
EARLIESTSTART VARCHAR2 (4)
NMAS - Earliest Start Date
NEARINST VARCHAR2 (4)
NMAS - Nearest Institution
PREFREG NUMBER (22)
NMAS - Preferred Region
QUALENG VARCHAR2 (1)
NMAS - Qualified In English
QUALMATH VARCHAR2 (1)
NMAS - Qualified In Maths
QUALSCI VARCHAR2 (1)
NMAS - Qualified In Science
MAINQUAL VARCHAR2 (1)
NMAS - Main Qualification
QUAL5 VARCHAR2 (1)
NMAS - Qualified With 5 Points
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
Query Text

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


SELECT APPNO
,      APPLICATIONDATE
,      SENTDATE
,      RUNSENT
,      CODEDCHANGEDATE
,      SCHOOL
,      RESCAT
,      FEELEVEL
,      FEEPAYER
,      FEETEXT
,      APR
,      LEA
,      COUNTRYBIRTH
,      NATIONALITY
,      DUALNATIONALITY
,      WITHDRAWN
,      WITHDRAWNDATE
,      ROUTEB
,      EXAMCHANGEDATE
,      ALEVELS
,      ASLEVELS
,      HIGHERS
,      CSYS
,      GCE
,      VCE
,      SQA
,      WINTER
,      PREVIOUSA
,      PREVIOUSAS
,      KEYSKILLS
,      VOCATIONAL
,      GNVQ
,      BTEC
,      ILC
,      AICE
,      IB
,      MANUAL
,      REGNO
,      SCN
,      OEQ
,      PREVOEQ
,      EAS
,      ROA
,      SPECIALNEEDS
,      CRIMINALCONV
,      UKENTRYDATE
,      STATUS
,      FIRMNOW
,      FIRMREPLY
,      INSURANCEREPLY
,      CONFHISTFIRMREPLY
,      CONFHISTINSURANCEREPLY
,      CHOICESALLTRANSPARENT
,      EXTRASTATUS
,      EXTRAPASSPORTNO
,      WELSHSPEAKER
,      NINUMBER
,      EARLIESTSTART
,      NEARINST
,      PREFREG
,      QUALENG
,      QUALMATH
,      QUALSCI
,      MAINQUAL
,      QUAL5
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_ISTARK_INTS;

Dependencies

[top of page]

IGS.IGS_UC_ISTARK_INTS does not reference any database object

IGS.IGS_UC_ISTARK_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_ISTARK_INTS