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.IGS_PR_ACAD_QUAL_CREDIT_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains the details of credit granted through advanced standing based on the UK Qualifications structure. The credit is shown only as an aggregated summary figure.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PROGRAM_CD	VARCHAR2	(6)	Yes	A code used to identify the course in which the student is enrolled.See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.
EXAM_LEVEL	VARCHAR2	(20)	Yes	Examination level
EXAM_LEVEL_DESCRIPTION	VARCHAR2	(90)		Description for examination level
SUBJECT_CODE	VARCHAR2	(20)		Subject Code
SUBJECT_CODE_DESCRIPTION	VARCHAR2	(80)		Description of Subject
YEAR	NUMBER	(4)		Year
SITTING	VARCHAR2	(1)		Sitting
AWARDING_BODY	VARCHAR2	(30)		Awarding institution
AWARDING_BODY_DESCRIPTION	VARCHAR2	(60)		Description for awarding institution
PREDICTED_RESULT	VARCHAR2	(5)		Predicted result
APPROVED_RESULT	VARCHAR2	(5)		Approved result
CLAIMED_RESULT	VARCHAR2	(5)		Claimed result
UCAS_TARIFF	NUMBER	(3)		UCAS tariff
QUAL_DETS_ID	NUMBER		Yes	Qualification details identifier
CREDIT_POINTS	NUMBER			Credit points

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      PROGRAM_CD
,      EXAM_LEVEL
,      EXAM_LEVEL_DESCRIPTION
,      SUBJECT_CODE
,      SUBJECT_CODE_DESCRIPTION
,      YEAR
,      SITTING
,      AWARDING_BODY
,      AWARDING_BODY_DESCRIPTION
,      PREDICTED_RESULT
,      APPROVED_RESULT
,      CLAIMED_RESULT
,      UCAS_TARIFF
,      QUAL_DETS_ID
,      CREDIT_POINTS
FROM APPS.IGS_PR_ACAD_QUAL_CREDIT_V;

Dependencies

[top of page]

APPS.IGS_PR_ACAD_QUAL_CREDIT_V references the following:

APPS: HZ_PARTIES; IGS_AV_STND_UNIT_LVL_ALL; IGS_EN_STDNT_PS_ATT_ALL; IGS_OR_INSTITUTION; IGS_PS_AWD; IGS_PS_FLD_OF_STUDY_ALL; IGS_UC_QUAL_DETS

APPS.IGS_PR_ACAD_QUAL_CREDIT_V is not referenced by any database object