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_QUAL_DETAILS

Object Details

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

View Type

A Business Intelligence System view

Full View for the qualifications awarded to an applicant

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
QUAL_DETAILS_IDENTIFIER	NUMBER		Yes	Qualification details identifier
OSS_PERSON_IDENTIFIER	NUMBER	(15)	Yes	OSS Person Identifier
EXAM_LEVEL_CODE	VARCHAR2	(20)	Yes	Qualification Code
SUBJECT_CODE	VARCHAR2	(20)		Subject Code
YEAR	NUMBER	(4)		Year
SITTING	VARCHAR2	(1)		Sitting
_LA:SITTING_DESC	CHAR	(55)
AWARDING_BODY_CODE	VARCHAR2	(30)		Awarding Board code
GRADING_SCHEMA_CODE	VARCHAR2	(10)		Grading Schema Code
VERSION_NUMBER	NUMBER	(3)		Grading Schema Version Number
PREDICTED_RESULT	VARCHAR2	(5)		Predicted Result
APPROVED_RESULT	VARCHAR2	(5)		Approved Result
CLAIMED_RESULT	VARCHAR2	(5)		Claimed Result
UCAS_TARIFF	NUMBER	(3)		UCAS Tariff
IMPORTED_FLAG	VARCHAR2	(1)		Record imported from UCAS (Y - YES, N - No)
IMPORTED_DATE	DATE		Yes	Date when Record is imported.
OSS_PERSON_NUMBER	VARCHAR2	(30)		OSS Person Number
OSS_PERSON_NAME	VARCHAR2	(360)		OSS Person Name
EXAM_LEVEL_TITLE	VARCHAR2	(90)		Qualification Title
SUBJECT_CODE_DESC	VARCHAR2	(80)		Subject Description
APPROVED_RESULT_DESCRIPTION	VARCHAR2	(60)		Full name of a Approved Result
APPROVED_RESULT_SCORE	NUMBER	(3)		Rank of the Approved Result in relation to other grades within the same grading schema
PREDICTED_RESULT_DESCRIPTION	VARCHAR2	(60)		Full name of a Predicted Result
PREDICTED_RESULT_SCORE	NUMBER	(3)		Rank of the Predicted Result in relation to other grades within the same grading schema
CLAIMED_RESULT_DESCRIPTION	VARCHAR2	(60)		Full name of a Claimed Result
CLAIMED__RESULT_SCORE	NUMBER	(3)		Rank of the Claimed Result in relation to other grades within the same grading schema
AWARDING_BODY_NAME	VARCHAR2	(360)		Awarding Body Name
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column

Query Text

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


SELECT QUAL_DETAILS_IDENTIFIER
,      OSS_PERSON_IDENTIFIER
,      EXAM_LEVEL_CODE
,      SUBJECT_CODE
,      YEAR
,      SITTING
,      _LA:SITTING_DESC
,      AWARDING_BODY_CODE
,      GRADING_SCHEMA_CODE
,      VERSION_NUMBER
,      PREDICTED_RESULT
,      APPROVED_RESULT
,      CLAIMED_RESULT
,      UCAS_TARIFF
,      IMPORTED_FLAG
,      IMPORTED_DATE
,      OSS_PERSON_NUMBER
,      OSS_PERSON_NAME
,      EXAM_LEVEL_TITLE
,      SUBJECT_CODE_DESC
,      APPROVED_RESULT_DESCRIPTION
,      APPROVED_RESULT_SCORE
,      PREDICTED_RESULT_DESCRIPTION
,      PREDICTED_RESULT_SCORE
,      CLAIMED_RESULT_DESCRIPTION
,      CLAIMED__RESULT_SCORE
,      AWARDING_BODY_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGSFV_UC_QUAL_DETAILS;

Dependencies

[top of page]

APPS.IGSFV_UC_QUAL_DETAILS references the following:

APPS: HZ_PARTIES; IGS_AS_GRD_SCH_GRADE; IGS_PE_HZ_PARTIES; IGS_PS_AWD; IGS_PS_FLD_OF_STUDY_ALL; IGS_UC_QUAL_DETS

APPS.IGSFV_UC_QUAL_DETAILS is not referenced by any database object