[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_APP_REFEREES |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_UC_APP_REFEREES |
Subobject Name: | |
Status: | VALID |
Holds UCAS Applicant Reference details
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_UC_APP_REFEREES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APP_NO
REFEREE_NAME |
SYS_IL0000328082C00012$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
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 | |
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 |
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;
IGS.IGS_UC_APP_REFEREES does not reference any database object
IGS.IGS_UC_APP_REFEREES is referenced by following:
|
|
|