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_AS_SU_ATMPT_OUTCOMES

Object Details

Object Name:	IGSFV_AS_SU_ATMPT_OUTCOMES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_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	Describes the person name.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Describes the person number.
PROGRAM_CODE	VARCHAR2	(6)	Yes	Describes the course code. DETYA element reference 307.
PROGRAM_TITLE	VARCHAR2	(90)	Yes	Title of the identified course code.
UNIT_CODE	VARCHAR2	(10)	Yes	The code used to identify the unit.
UNIT_TITLE	VARCHAR2	(90)	Yes	Title of the identified unit code.
CALENDAR_TYPE	VARCHAR2	(10)	Yes	This stores the Calendar Type.
CALENDAR_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This stores the sequence number.
CALENDAR_DESCRIPTION	VARCHAR2	(30)		Calendar Description
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	This will store the Grade details, should be a valid grade.
_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.
GRADING_SCHEMA_DESC	VARCHAR2	(60)	Yes	Describes the grading schema.
TRANSLATED_GRADING_SCHEMA_DESC	VARCHAR2	(60)		Describes the translated grading schema
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.
ASSESSMENT_STATUS	VARCHAR2	(4000)

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
,      GRADING_SCHEMA_DESC
,      TRANSLATED_GRADING_SCHEMA_DESC
,      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
,      ASSESSMENT_STATUS
FROM APPS.IGSFV_AS_SU_ATMPT_OUTCOMES;

Dependencies

[top of page]

APPS.IGSFV_AS_SU_ATMPT_OUTCOMES references the following:

APPS: HZ_PARTIES; IGS_AS_DERIVE_GRADE - show dependent code; IGS_AS_GRD_SCHEMA; 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.IGSFV_AS_SU_ATMPT_OUTCOMES is not referenced by any database object