[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_CSCHCNT_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_UC_CSCHCNT_INTS |
Subobject Name: | |
Status: | VALID |
Holds School contacts information loaded from UCAS
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_UC_CSCHCNT_INTS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
RECORD_STATUS
SCHOOL SITECODE CONTACTCODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHOOL | NUMBER | (22) | School Code | |
SITECODE | VARCHAR2 | (1) | For future use - when one organization has several site addresses | |
CONTACTCODE | NUMBER | (22) | Set to 1 for primary contact and 2 for any existing secondary contacts | |
CONTACTPOST | VARCHAR2 | (35) | Name of Post e.g. Headmaster, Head of Sixth, Director of Education etc (Title1) | |
CONTACTNAME | VARCHAR2 | (35) | Post holders name e.g. Mr J Smith Dr A Waters etc (Name1) | |
TELEPHONE | VARCHAR2 | (20) | Includes STD code e.g. 01242 123456 | |
FAX | VARCHAR2 | (20) | Fax Number | |
VARCHAR2 | (50) | Email address | ||
PRINCIPAL | VARCHAR2 | (1) | Y = This post is the head of the organization | |
LISTS | VARCHAR2 | (1) | Y = This post orders or receives lists | |
ORDERS | VARCHAR2 | (1) | Y = This post deals with material orders (handbooks, forms etc) | |
FORMS | VARCHAR2 | (1) | Y = This post returns or co-ordinates transmission of forms to UCAS (incl. Payment) | |
REFEREE | VARCHAR2 | (1) | Y = This post acts as a referee on some or all UCAS forms | |
CAREERS | VARCHAR2 | (1) | Y = This is the careers material contact | |
EASCONTACT | VARCHAR2 | (1) | Y = This is the EAS installer or administrator | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SCHOOL
, SITECODE
, CONTACTCODE
, CONTACTPOST
, CONTACTNAME
, TELEPHONE
, FAX
, EMAIL
, PRINCIPAL
, LISTS
, ORDERS
, FORMS
, REFEREE
, CAREERS
, EASCONTACT
, RECORD_STATUS
, ERROR_CODE
FROM IGS.IGS_UC_CSCHCNT_INTS;
IGS.IGS_UC_CSCHCNT_INTS does not reference any database object
IGS.IGS_UC_CSCHCNT_INTS is referenced by following:
|
|
|