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

VIEW: APPS.IGSBV_UC_APPLICANT_REFEREES

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

View Type

A Business Intelligence System view


Base View for Applicant Reference details


[View Source]

Columns
Name Datatype Length Mandatory Comments
UCAS_APPLICANT_NUMBER NUMBER (22) Yes UCAS Application Number
REFEREE_NAME VARCHAR2 (50) Yes Referee Name
REFEREE_POST VARCHAR2 (35)
Referee post
ESTABLISHMENT_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
OSS_PERSON_IDENTIFIER NUMBER (15)
OSS Person Identifier
PREDICTED_GRADES VARCHAR2 (150)
Predicted grades as given by the referee
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
Query Text

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


SELECT UCAS_APPLICANT_NUMBER
,      REFEREE_NAME
,      REFEREE_POST
,      ESTABLISHMENT_NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      TELEPHONE
,      FAX
,      EMAIL
,      STATEMENT
,      OSS_PERSON_IDENTIFIER
,      PREDICTED_GRADES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_UC_APPLICANT_REFEREES;

Dependencies

[top of page]

APPS.IGSBV_UC_APPLICANT_REFEREES references the following:

SchemaAPPS
SynonymIGS_UC_APPLICANTS
SynonymIGS_UC_APP_REFEREES

APPS.IGSBV_UC_APPLICANT_REFEREES is not referenced by any database object