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

Object Details

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

View Type

A Business Intelligence System view

Describes a student unit attempt outcome

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_NAME	VARCHAR2	(360)	Yes	Name of this party
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PROGRAM_CODE	VARCHAR2	(6)	Yes	Describes the course code. DETYA element reference 307.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title or full name of the program.
UNIT_CODE	VARCHAR2	(10)	Yes	The code used to identify the unit.
UNIT_TITLE	VARCHAR2	(90)	Yes	Title of the unit.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	An abbreviated name of a type of calendar used within the university. For examples, academic, semester 1.
CALENDAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance
CALENDAR_DESCRIPTION	VARCHAR2	(30)		Description for the Calendar Instance
OUTCOME_DATE	DATE		Yes	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)		Indicates the student's level of achievement in the unit attempt
GRADE	VARCHAR2	(5)	Yes	The grade which the student attained for this unit attempt.
_LA:FINALISED_OUTCOME_IND	CHAR	(63)		Indicates and specifies if or not the outcome for the unit attempt is finalized. Setting the indicator ticked means that the outcome for the unit attempt is finalized. If the indicator is not set and it is the latest outcome, then it is considered recommended pending finalization.
_LA:GRADING_PERIOD	CHAR	(70)		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.
TRANSLATED_DATE	DATE			Describes the date the unit attempt outcome was translated according to the grading schema
TRANSLATED_GRADE	VARCHAR2	(5)		The code representing the translated grade.
TEACHING_CAL_START_DATE	DATE		Yes	Describes the teaching period calendar start date
TEACHING_CAL_END_DATE	DATE		Yes	Describes the teaching period calendar end date
NUMBER_TIMES_KEYED	NUMBER	(2)		Indicates the number of times the outcome has been entered
INCOMP_DEADLINE_DATE	DATE			Completion Date for completing Incomplete Grade.
INCOMP_DEFAULT_GRADE	VARCHAR2	(5)		Default Grade if incomplete Grade is not completed.
INCOMP_DEFAULT_MARK	NUMBER	(6)		Default Mark if incomplete Grade is not completed.
COMMENTS	VARCHAR2	(240)		Comments.
_LA:GRADE_CREATION_METHOD	CHAR	(90)		The system-defined grade creation method types. This value is automatically inserted by the system and identifies the process by which the grade was entered. Available types are conversion, discontinue, keyed, upload and system.
PERSON_ID	NUMBER	(15)	Yes	Describes the ID that uniquely identifies a person.
GRADING_SCHEMA_CODE	VARCHAR2	(10)	Yes	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.
GRADING_SCHEMA_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the number identifying the version of the grading schema
UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the number identifying the version of a unit
PROGRAM_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the number identifying the version of the course in which the student enrolls
INCOMP_GRADING_SCHEMA_CODE	VARCHAR2	(10)		Grading Schema for the incomplete grade.
INCOMP_VERSION_NUMBER	NUMBER	(3)		Grading Schema Version Number for the incomplete grade.
TRANSLATED_GRADING_SCHEMA_CODE	VARCHAR2	(10)		Describes the number identifying the code of the grading schema
TRANSLATED_VERSION_NUMBER	NUMBER	(3)		Describes the number identifying the version of the grading schema
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
UOO_ID	NUMBER	(7)	Yes	Unit Section identifier
_LA:MARK_CAPPED_FLAG	CHAR	(58)		Allows user to indicate whether marks have been capped for a student unit attempt outcome
_LA:SHOW_ON_ACADCM_HIST_FLAG	CHAR	(70)		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
_LA:MANUAL_OVERRIDE_FLAG	CHAR	(62)		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 PERSON_NAME
,      PERSON_NUMBER
,      PROGRAM_CODE
,      PROGRAM_TITLE
,      UNIT_CODE
,      UNIT_TITLE
,      CALENDAR_TYPE
,      CALENDAR_SEQUENCE_NUMBER
,      CALENDAR_DESCRIPTION
,      OUTCOME_DATE
,      MARK
,      GRADE
,      _LA:FINALISED_OUTCOME_IND
,      _LA:GRADING_PERIOD
,      TRANSLATED_DATE
,      TRANSLATED_GRADE
,      TEACHING_CAL_START_DATE
,      TEACHING_CAL_END_DATE
,      NUMBER_TIMES_KEYED
,      INCOMP_DEADLINE_DATE
,      INCOMP_DEFAULT_GRADE
,      INCOMP_DEFAULT_MARK
,      COMMENTS
,      _LA:GRADE_CREATION_METHOD
,      PERSON_ID
,      GRADING_SCHEMA_CODE
,      GRADING_SCHEMA_VERSION_NUMBER
,      UNIT_VERSION_NUMBER
,      PROGRAM_VERSION_NUMBER
,      INCOMP_GRADING_SCHEMA_CODE
,      INCOMP_VERSION_NUMBER
,      TRANSLATED_GRADING_SCHEMA_CODE
,      TRANSLATED_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      UOO_ID
,      _LA:MARK_CAPPED_FLAG
,      _LA:SHOW_ON_ACADCM_HIST_FLAG
,      RELEASE_DATE
,      _LA:MANUAL_OVERRIDE_FLAG
FROM APPS.IGSBV_AS_SU_ATMPT_OUTCOMES;

Dependencies

[top of page]

APPS.IGSBV_AS_SU_ATMPT_OUTCOMES references the following:

APPS: HZ_PARTIES; IGS_AS_SU_STMPTOUT_ALL; IGS_CA_INST_ALL; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_SU_ATTEMPT_ALL; IGS_PS_UNIT_VER_ALL; IGS_PS_VER_ALL

APPS.IGSBV_AS_SU_ATMPT_OUTCOMES is not referenced by any database object