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


TABLE: IGS.IGS_UC_CVSCH_INTS

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


Holds Schools information loaded from UCAS


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_CVSCH_INTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnRECORD_STATUS
ColumnSCHOOL
Columns
Name Datatype Length Mandatory Comments
SCHOOL NUMBER (22)
UCAS school code
SITECODE VARCHAR2 (1)
For future use - when one organization has several site addresses
SCHOOLNAME VARCHAR2 (35)
School Name
NAMECHANGEDATE DATE

Date when school name last changed
FORMERNAME VARCHAR2 (35)
Schools former name
NCN VARCHAR2 (5)
Cambridge NCN for exam matching purposes
EDEXCELNCN VARCHAR2 (6)
Formerly BTEC National Center Number
DFEECODE VARCHAR2 (7)
7 digit DFEE code (DFEE schools only)
COUNTRY NUMBER (22)
Use APR codes for meaning
LEA VARCHAR2 (3)
APR codes which are also LEAs
UCASSTATUS VARCHAR2 (1)
L,M,N,C (Live, Merged, Not Live, Closed)
ESTABGRP VARCHAR2 (1)
cvRefEstGroup
SCHOOLTYPE VARCHAR2 (1)
cvRefSchoolType
STATSDATE DATE

Date when statistics collected - no on roll through No going to HE
NOROLL NUMBER (22)
No on Roll
NO5TH NUMBER (22)
Number in 5th form
NO6TH NUMBER (22)
Number in 6th form
NOHE NUMBER (22)
Number going to higher education
ADDRESS1 VARCHAR2 (50)
School address line 1
ADDRESS2 VARCHAR2 (50)
School address line 2
ADDRESS3 VARCHAR2 (50)
School address line 3
ADDRESS4 VARCHAR2 (50)
School address line 4
POSTCODE VARCHAR2 (8)
UK addresses only
MAILSORT VARCHAR2 (5)
UK only - 5 digit mail sort code for bulk mailing
TOWNKEY VARCHAR2 (12)
Town key
COUNTYKEY VARCHAR2 (12)
County Key
COUNTRYCODE VARCHAR2 (1)
E,N,S,W,O for England, N.Ireland etc
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 SCHOOL
,      SITECODE
,      SCHOOLNAME
,      NAMECHANGEDATE
,      FORMERNAME
,      NCN
,      EDEXCELNCN
,      DFEECODE
,      COUNTRY
,      LEA
,      UCASSTATUS
,      ESTABGRP
,      SCHOOLTYPE
,      STATSDATE
,      NOROLL
,      NO5TH
,      NO6TH
,      NOHE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      POSTCODE
,      MAILSORT
,      TOWNKEY
,      COUNTYKEY
,      COUNTRYCODE
,      RECORD_STATUS
,      ERROR_CODE
FROM IGS.IGS_UC_CVSCH_INTS;

Dependencies

[top of page]

IGS.IGS_UC_CVSCH_INTS does not reference any database object

IGS.IGS_UC_CVSCH_INTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_CVSCH_INTS