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

VIEW: APPS.IGS_UC_CVSCHOOLCONTACT_2003

Object Details
Object Name: IGS_UC_CVSCHOOLCONTACT_2003
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_UC_CVSCHOOLCONTACT_2003
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
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 holder's 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 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
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
FROM APPS.IGS_UC_CVSCHOOLCONTACT_2003;

Dependencies

[top of page]

APPS.IGS_UC_CVSCHOOLCONTACT_2003 references the following:

SchemaAPPS
SynonymIGS_UC_CSCHCNT_INTS
APPS.IGS_UC_CVSCHOOLCONTACT_2003 is referenced by following:

SchemaAPPS
SynonymIGS_UC_U_CVSCHOOLCONTACT_2003