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_STD_UNT_ATMPT_OTCM_H_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
PERSON_ID	NUMBER	(15)	This field describes the ID code that uniquely identifies a person.
COURSE_CD	VARCHAR2	(6)	This field describes the course code. DETYA element reference 307.
UNIT_CD	VARCHAR2	(10)	The code used to identify the unit.
CAL_TYPE	VARCHAR2	(10)	This field is the abbreviated name of a type of calendar used within the university. Examples- Academic, Semester 1.
CI_SEQUENCE_NUMBER	NUMBER	(6)	This field uniquely identifies the calendar instance.
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.
HIST_START_DT	DATE		The effective start date/time of the history record.
HIST_END_DT	DATE		This field contains the date and time the record was last updated.
HIST_WHO	NUMBER	(15)	The Oracle Username of the person who last updated the record.
GRADING_SCHEMA_CD	VARCHAR2	(10)	This field describes the set of available marks, grades and results which can be used in the assessment of student unit attempts. There may be multiple grading schemas for any one institution.
VERSION_NUMBER	NUMBER		This field describes the number identifying the version of the grading schema.
GRADE	VARCHAR2	(5)	The grade which the student attained for this unit attempt.
S_GRADE_CREATION_METHOD_TYPE	VARCHAR2	(30)	The system-defined grade creation method types. This value is automatically inserted by the system and identifies the process by which the grade was recorded. Available types are CONVERSION, DISCONTIN, KEYED, UPLOAD, and SYSTEM.
FINALISED_OUTCOME_IND	VARCHAR2	(1)	An indicator which specifies whether or not the outcome for the unit attempt is finalised. Setting the indicator -ticked- means that the outcome for the unit attempt is finalised. If the indicator is not set and it is the latest outcome, then it is considered recommended pending finalisation.
MARK	NUMBER		A numeric code which indicates the student's level of achievement in the unit attempt.
NUMBER_TIMES_KEYED	NUMBER		This field indicates the number of times the outcome has been keyed.
TRANSLATED_GRADING_SCHEMA_CD	VARCHAR2	(10)	STDNT_UNIT_ATMPT_OUTCOME.TRANSLATED_GRADING_SCHEMA_CD
TRANSLATED_VERSION_NUMBER	NUMBER		This field describes the number identifying the version of the grading schema.
TRANSLATED_GRADE	VARCHAR2	(5)	The code representing the translated grade.
TRANSLATED_DT	DATE		This field describes the date the unit attempt outcome was translated according to the grading schema.
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
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
,      OUTCOME_DT
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      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
,      UOO_ID
FROM APPS.IGS_AS_STD_UNT_ATMPT_OTCM_H_V;

Dependencies

[top of page]

APPS.IGS_AS_STD_UNT_ATMPT_OTCM_H_V references the following:

APPS: IGS_AS_SU_ATMPTOUT_H; IGS_AS_SU_STMPTOUT; IGS_AU_GEN_003 - show dependent code; IGS_GE_DATE - show dependent code

APPS.IGS_AS_STD_UNT_ATMPT_OTCM_H_V is not referenced by any database object