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_SUA_FINAL_OUTCOME_V

Object Details

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

View Type

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

Describes the outcome to a student unit attempt, in the window of a mark and possibly a grade and if the default grade for the mark is overridden. It also descibes a student's attempt at studying a particular unit offered by the university.

[View Source]

Columns

Name	Datatype	Length	Comments
PERSON_ID	NUMBER	(15)	Describes the ID code that uniquely identifies a person
COURSE_CD	VARCHAR2	(6)	A code used to identify the program that the student is enrolled
UNIT_CD	VARCHAR2	(10)	The code used to identify the unit
CAL_TYPE	VARCHAR2	(10)	Name of a type of teaching calendar within the university. For example, SEM-1, YR-LONG.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Uniquely identifies the calendar instance
CI_START_DT	DATE		Describes the date from that an instance of a calendar is effective
CI_END_DT	DATE		Date from that an instance of a calendar is no longer effective. For example, teaching period semester 1, 1999 can end on 30/06/1999.
OUTCOME_DT	DATE		The date the outcome was entered for the student unit attempt. This date is automatically inserted by the system and cannot be updated.
MARK	NUMBER	(6)	A numeric code that indicates the student's level of achievement in the unit attempt
GRADING_SCHEMA_CD	VARCHAR2	(10)	Describes the set of available marks, grades and results that can be used in the assessment of student unit attempts. There can be multiple grading schemas for any one institution.
GS_VERSION_NUMBER	NUMBER	(3)	Describes the number identifying the version of the grading schema
GRADE	VARCHAR2	(5)	The grade that the student attained for this unit attempt
TRANSLATED_GRADING_SCHEMA_CD	VARCHAR2	(10)	Describes the code of the grading schema
TRANSLATED_GS_VERSION_NUMBER	NUMBER	(3)	Describes the number identifying the version of the grading schema
TRANSLATED_GRADE	VARCHAR2	(5)	The code representing the translated grade
DEG_AUD_DETAIL_ID	NUMBER		Degree Audit Detail Id
UOO_ID	NUMBER	(7)	Unit Section identifier

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      OUTCOME_DT
,      MARK
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADE
,      TRANSLATED_GRADING_SCHEMA_CD
,      TRANSLATED_GS_VERSION_NUMBER
,      TRANSLATED_GRADE
,      DEG_AUD_DETAIL_ID
,      UOO_ID
FROM APPS.IGS_PR_SUA_FINAL_OUTCOME_V;

Dependencies

[top of page]

APPS.IGS_PR_SUA_FINAL_OUTCOME_V references the following:

APPS: IGS_AS_SU_STMPTOUT; IGS_EN_SU_ATTEMPT; IGS_PS_STDNT_UNT_TRN

APPS.IGS_PR_SUA_FINAL_OUTCOME_V is referenced by following:

APPS: IGS_PR_SUA_INQ_V