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

TABLE: IGS.IGS_UC_APP_REFEREES

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


Holds UCAS Applicant Reference details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_APP_REFEREES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPP_NO
ColumnREFEREE_NAME
SYS_IL0000328082C00012$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
APP_NO NUMBER (22) Yes Applicant Number
REFEREE_NAME VARCHAR2 (50) Yes Referee Name
REFEREE_POST VARCHAR2 (35)
Referee post
ESTAB_NAME VARCHAR2 (60)
Establishment name
ADDRESS1 VARCHAR2 (50)
Address line 1
ADDRESS2 VARCHAR2 (50)
Address line 2
ADDRESS3 VARCHAR2 (50)
Address line 3
ADDRESS4 VARCHAR2 (50)
Address line 4
TELEPHONE VARCHAR2 (35)
Telephone number
FAX VARCHAR2 (35)
Facsimile
EMAIL VARCHAR2 (60)
Email address
STATEMENT CLOB (4000)
Electronic Application Statement
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
PREDICTED_GRADES VARCHAR2 (150)
The predicted grades as given by the referee
Query Text

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


SELECT APP_NO
,      REFEREE_NAME
,      REFEREE_POST
,      ESTAB_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      TELEPHONE
,      FAX
,      EMAIL
,      STATEMENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PREDICTED_GRADES
FROM IGS.IGS_UC_APP_REFEREES;

Dependencies

[top of page]

IGS.IGS_UC_APP_REFEREES does not reference any database object

IGS.IGS_UC_APP_REFEREES is referenced by following:

SchemaAPPS
SynonymIGS_UC_APP_REFEREES