[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_UC_MV_CVSCHOOL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_UC_MV_CVSCHOOL
|
| Subobject Name: | |
| Status: | VALID |
List of school details and addresses - OBSOLETE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCHOOL | NUMBER | (5) | UCAS school code | |
| SITECODE | VARCHAR2 | (1) | For future use - when one organization has several site addresses | |
| TIMESTAMP | DATE | Time stamp - date and time of last change | ||
| 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) | Formally BTEC National Center Number | |
| DFEECODE | VARCHAR2 | (7) | 7 digit DfEE code (DfEE schools only) | |
| COUNTRY | NUMBER | (3) | Use APR codes for meaning | |
| LEA | VARCHAR2 | (3) | APR codes which are also LEA | |
| 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 | (4) | No on Roll | |
| NO5TH | NUMBER | (4) | Number in 5th form | |
| NO6TH | NUMBER | (4) | Number in 6th form | |
| NOHE | NUMBER | (4) | Number going to higher education | |
| ADDRESS1 | VARCHAR2 | (27) | School address line 1 | |
| ADDRESS2 | VARCHAR2 | (27) | School address line 2 | |
| ADDRESS3 | VARCHAR2 | (27) | School address line 3 | |
| ADDRESS4 | VARCHAR2 | (27) | 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, Northern .Ireland etc | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT SCHOOL
, SITECODE
, TIMESTAMP
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_MV_CVSCHOOL;
IGS.IGS_UC_MV_CVSCHOOL does not reference any database object
IGS.IGS_UC_MV_CVSCHOOL is referenced by following:
APPS
IGS_UC_MV_CVSCHOOL
|
|
|
|