eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGS.IGS_UC_APP_RESULTS

Object Details

Object Name:	IGS_UC_APP_RESULTS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_UC_APP_RESULTS
Subobject Name:
Status:	VALID

Holds applicant examination results . It synchronizes with UCAS view 'ivStarPQR'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_APP_RESULTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_RESULT_ID
IGS_UC_APP_RESULTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBJECT_ID APP_NO

Columns

Name	Datatype	Length	Mandatory	Comments
APP_RESULT_ID	NUMBER		Yes	Unique Record Identifier
APP_ID	NUMBER		Yes	Unique applicant identifier
APP_NO	NUMBER	(8)		UCAS application number
ENQUIRY_NO	NUMBER			Clearing enquiry number
EXAM_LEVEL	VARCHAR2	(2)	Yes	Examination level
YEAR	VARCHAR2	(4)	Yes	Examination year
SITTING	VARCHAR2	(1)	Yes	(S - summer, W - winter)
AWARD_BODY	VARCHAR2	(1)	Yes	Awarding body
SUBJECT_ID	NUMBER		Yes	Subject code synchronized with ivStarPQR
PREDICTED_RESULT	VARCHAR2	(2)		Predicted result
RESULT_IN_OFFER	VARCHAR2	(2)		Result stated in conditional offer
EBL_RESULT	VARCHAR2	(2)		Result declared by exam board synchronized with ivStarPQR
EBL_AMENDED_RESULT	VARCHAR2	(2)		Amended result declared by exam board synchronized with ivStarPQR
CLAIMED_RESULT	VARCHAR2	(2)		Applicant claimed result synchronized with ivStarPQR
IVSTARPQR_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view ivStarPQR - Obsolete
IMPORTED	VARCHAR2	(1)	Yes	Record imported from 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 APP_RESULT_ID
,      APP_ID
,      APP_NO
,      ENQUIRY_NO
,      EXAM_LEVEL
,      YEAR
,      SITTING
,      AWARD_BODY
,      SUBJECT_ID
,      PREDICTED_RESULT
,      RESULT_IN_OFFER
,      EBL_RESULT
,      EBL_AMENDED_RESULT
,      CLAIMED_RESULT
,      IVSTARPQR_TIMESTAMP
,      IMPORTED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_UC_APP_RESULTS;

Dependencies

[top of page]

IGS.IGS_UC_APP_RESULTS does not reference any database object

IGS.IGS_UC_APP_RESULTS is referenced by following:

APPS: IGS_UC_APP_RESULTS