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_AS_SUAOA_V

Object Details

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

View Type

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

Describes the most recent outcome of student unit attempt as grade or mark for different grading periods

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Idenifier.
COURSE_CD	VARCHAR2	(6)	Yes	Course Code.
UNIT_CD	VARCHAR2	(10)	Yes	Unit Code.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Type.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar Instance Sequence Number.
CI_START_DT	DATE		Yes	Calendar Instance Start Date.
CI_END_DT	DATE		Yes	Calendar Instance end Date.
OUTCOME_DT	DATE		Yes	Outcome Date.
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	Grading Schema Code.
VERSION_NUMBER	NUMBER	(3)	Yes	Grading Schema Version Number.
GRADE	VARCHAR2	(5)	Yes	Grade Recorded.
S_GRADE_CREATION_METHOD_TYPE	VARCHAR2	(30)	Yes	Grade Creation Method.
FINALISED_OUTCOME_IND	VARCHAR2	(1)	Yes	Finalised Outcome Indicator.
MARK	NUMBER	(6)		Mark Recorded.
NUMBER_TIMES_KEYED	NUMBER	(2)		Number of times keyed.
TRANSLATED_GRADING_SCHEMA_CD	VARCHAR2	(10)		Translated Grading Schema Code.
TRANSLATED_VERSION_NUMBER	NUMBER	(3)		Translated version number.
TRANSLATED_GRADE	VARCHAR2	(5)		Translated Grade.
TRANSLATED_DT	DATE			Translated Date.
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.
GRADING_PERIOD_CD	VARCHAR2	(30)	Yes	Grading Period Code.
INCOMP_DEADLINE_DATE	DATE			Deadline Date for completing Incomplete Grade.
INCOMP_GRADING_SCHEMA_CD	VARCHAR2	(10)		Grading Schema for the Incomplete Grade.
INCOMP_VERSION_NUMBER	NUMBER	(3)		Grading Schema Version Number for the Incomplete Grade.
INCOMP_DEFAULT_GRADE	VARCHAR2	(5)		Deafult Grade if Incomplete Grade is not completed.
INCOMP_DEFAULT_MARK	NUMBER	(6)		Deafult Mark if Incomplete Grade is not completed.
COMMENTS	VARCHAR2	(240)		Comments.
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
MARK_CAPPED_FLAG	VARCHAR2	(1)		Allows user to indicate whether marks have been capped for a student unit attempt outcome
SHOW_ON_ACADEMIC_HISTRY_FLAG	VARCHAR2	(1)		Allows user to define whether the changed grade be displayed on the Academic History self-service page.
RELEASE_DATE	DATE			Date on which the student unit attempt outcome will be released to the student for viewing
MANUAL_OVERRIDE_FLAG	VARCHAR2	(1)		The user should select this checkbox to keep the system from replacing the manually assigned marks with the system calculated ones.

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      COURSE_CD
,      UNIT_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      OUTCOME_DT
,      GRADING_SCHEMA_CD
,      VERSION_NUMBER
,      GRADE
,      S_GRADE_CREATION_METHOD_TYPE
,      FINALISED_OUTCOME_IND
,      MARK
,      NUMBER_TIMES_KEYED
,      TRANSLATED_GRADING_SCHEMA_CD
,      TRANSLATED_VERSION_NUMBER
,      TRANSLATED_GRADE
,      TRANSLATED_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GRADING_PERIOD_CD
,      INCOMP_DEADLINE_DATE
,      INCOMP_GRADING_SCHEMA_CD
,      INCOMP_VERSION_NUMBER
,      INCOMP_DEFAULT_GRADE
,      INCOMP_DEFAULT_MARK
,      COMMENTS
,      UOO_ID
,      MARK_CAPPED_FLAG
,      SHOW_ON_ACADEMIC_HISTRY_FLAG
,      RELEASE_DATE
,      MANUAL_OVERRIDE_FLAG
FROM APPS.IGS_AS_SUAOA_V;

Dependencies

[top of page]

APPS.IGS_AS_SUAOA_V references the following:

APPS: IGS_AS_SU_STMPTOUT

APPS.IGS_AS_SUAOA_V is referenced by following:

APPS: IGS_AS_GEN_008 - show dependent code; IGS_AS_INCOMP_GRADE - show dependent code; IGS_AS_PROD_DOC - show dependent code