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

TABLE: IGS.IGS_UC_MV_CVSCHL_CT

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


List of School Contacts. - OBSOLETE


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SCHOOL NUMBER

School Code
SITECODE VARCHAR2 (1)
For future use - when one organization has several site addresses
CONTACTCODE NUMBER

Set to 1 for primary contact and 2 for any existing secondary contacts
TIMESTAMP DATE

Time stamp - date and time of last change
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
EMAIL VARCHAR2 (50)
Email address
PRINCIPAL VARCHAR2 (1)
Y = This post is the head of the organization
LISTS VARCHAR2 (1)
Y = This post orders/receives lists
ORDERS VARCHAR2 (1)
Y = This post deals with material orders (handbooks, forms etc)
FORMS VARCHAR2 (1)
Y = This post returns/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/administrator
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
Query Text

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


SELECT SCHOOL
,      SITECODE
,      CONTACTCODE
,      TIMESTAMP
,      CONTACTPOST
,      CONTACTNAME
,      TELEPHONE
,      FAX
,      EMAIL
,      PRINCIPAL
,      LISTS
,      ORDERS
,      FORMS
,      REFEREE
,      CAREERS
,      EASCONTACT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_MV_CVSCHL_CT;

Dependencies

[top of page]

IGS.IGS_UC_MV_CVSCHL_CT does not reference any database object

IGS.IGS_UC_MV_CVSCHL_CT is referenced by following:

SchemaAPPS
SynonymIGS_UC_MV_CVSCHL_CT