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

TABLE: IGS.IGS_UC_INST_CONTS

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


Holds the institution contact codes. It synchronizes with UCAS view 'uvContact'.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_INST_CONTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTACT_CODE
Columns
Name Datatype Length Mandatory Comments
CONTACT_CODE VARCHAR2 (1) Yes 'A' to 'Z'
DATETIMESTAMP DATE

Timestamp to synchronize with UCAS view uvContact - Obsolete
UPDATER VARCHAR2 (20)
ID of last updater
NAME VARCHAR2 (35) Yes Contact name
POST VARCHAR2 (35) Yes Post held by contact
ADDRESS1 VARCHAR2 (35) Yes Contact address line 1
ADDRESS2 VARCHAR2 (35)
Contact address line 2
ADDRESS3 VARCHAR2 (35)
Contact address line 3
ADDRESS4 VARCHAR2 (35)
Contact address line 4
TELEPHONE VARCHAR2 (20)
Telephone number
FAX VARCHAR2 (20)
FAX number
EMAIL VARCHAR2 (40)
Email address
SENT_TO_UCAS VARCHAR2 (1) Yes Update sent to UCAS ('Y' - yes, 'N' - no)
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 CONTACT_CODE
,      DATETIMESTAMP
,      UPDATER
,      NAME
,      POST
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      TELEPHONE
,      FAX
,      EMAIL
,      SENT_TO_UCAS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_INST_CONTS;

Dependencies

[top of page]

IGS.IGS_UC_INST_CONTS does not reference any database object

IGS.IGS_UC_INST_CONTS is referenced by following:

SchemaAPPS
SynonymIGS_UC_INST_CONTS