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]

VIEW: APPS.IGSFV_UC_APPLICANT_RESULTS

Object Details

Object Name:	IGSFV_UC_APPLICANT_RESULTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_UC_APPLICANT_RESULTS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Full View for Applicant Examination Results

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICANT_RESULT_IDENTIFIER	NUMBER		Yes	Unique Record Identifier
UCAS_APPLICANT_NUMBER	NUMBER	(8)		UCAS application number
ENQUIRY_NUMBER	NUMBER			Clearing enquiry number
EXAM_LEVEL	VARCHAR2	(2)	Yes	Examination level
EXAM_YEAR	VARCHAR2	(4)	Yes	Examination year
SITTING	VARCHAR2	(1)	Yes	Sitting
_LA:SITTING_DESC	CHAR	(55)
AWARDING_BODY	VARCHAR2	(1)	Yes	Awarding body
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
EBL_AMENDED_RESULT	VARCHAR2	(2)		Amended result declared by exam board
CLAIMED_RESULT	VARCHAR2	(2)		Applicant claimed result
IMPORTED_FLAG	VARCHAR2	(1)	Yes	Record imported from UCAS ('Y' Yes, 'N' No)
OSS_PERSON_IDENTIFIER	NUMBER	(15)		OSS Person Identifier
OSS_PERSON_NUMBER	VARCHAR2	(30)		OSS Person Number
OSS_PERSON_NAME	VARCHAR2	(360)		OSS Person Name
SUBJECT_CODE	VARCHAR2	(6)	Yes	Subject abbreviation
SUBJECT_TITLE	VARCHAR2	(45)		Subject Title
AWARDING_BODY_NAME	VARCHAR2	(30)		Awarding Body Name
APPLICANT_IDENTIFIER	NUMBER		Yes	Unique applicant identifier
SUBJECT_IDENTIFIER	NUMBER		Yes	Subject Identifier
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 APPLICANT_RESULT_IDENTIFIER
,      UCAS_APPLICANT_NUMBER
,      ENQUIRY_NUMBER
,      EXAM_LEVEL
,      EXAM_YEAR
,      SITTING
,      _LA:SITTING_DESC
,      AWARDING_BODY
,      PREDICTED_RESULT
,      RESULT_IN_OFFER
,      EBL_RESULT
,      EBL_AMENDED_RESULT
,      CLAIMED_RESULT
,      IMPORTED_FLAG
,      OSS_PERSON_IDENTIFIER
,      OSS_PERSON_NUMBER
,      OSS_PERSON_NAME
,      SUBJECT_CODE
,      SUBJECT_TITLE
,      AWARDING_BODY_NAME
,      APPLICANT_IDENTIFIER
,      SUBJECT_IDENTIFIER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_APPLICANT_RESULTS;

Dependencies

[top of page]

APPS.IGSFV_UC_APPLICANT_RESULTS references the following:

APPS: HZ_PARTIES; IGS_UC_APPLICANTS; IGS_UC_APP_RESULTS; IGS_UC_COM_EBL_SUBJ; IGS_UC_REF_AWRDBDY

APPS.IGSFV_UC_APPLICANT_RESULTS is not referenced by any database object