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]

TABLE: IGS.IGS_AS_SU_STMPTOUT_ALL

Object Details

Object Name:	IGS_AS_SU_STMPTOUT_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_AS_SU_STMPTOUT_ALL
Subobject Name:
Status:	VALID

IGS_AS_SU_STMPTOUT_ALL describes the outcome to a student unit attempt, in the form of a mark and possibly a grade, if the default grade for the mark is overridden.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_SU_STMPTOUT_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID OUTCOME_DT GRADING_PERIOD_CD
IGS_AS_SU_STMPTOUT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADING_SCHEMA_CD VERSION_NUMBER GRADE
IGS_AS_SU_STMPTOUT_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSLATED_GRADING_SCHEMA_CD TRANSLATED_VERSION_NUMBER TRANSLATED_GRADE
IGS_AS_SU_STMPTOUT_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAL_TYPE CI_SEQUENCE_NUMBER CI_START_DT CI_END_DT
IGS_AS_SU_STMPTOUT_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UOO_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the ID code that uniquely identifies a person
COURSE_CD	VARCHAR2	(6)	Yes	Describes the course code. DETYA element reference 307.
UNIT_CD	VARCHAR2	(10)	Yes	The code used to identify the unit.
CAL_TYPE	VARCHAR2	(10)	Yes	An abbreviated name of a type of calendar used within the university. For examples, academic, semester 1.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance
CI_START_DT	DATE		Yes	Describes the teaching period calendar start date
CI_END_DT	DATE		Yes	Describes the teaching period calendar end date
OUTCOME_DT	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.
GRADING_SCHEMA_CD	VARCHAR2	(10)	Yes	Describes the set of available marks, grades and results which can be used in the assessment of student unit attempts. There can be multiple grading schemas for any one institution.
VERSION_NUMBER	NUMBER	(3)	Yes	Describes the number identifying the version of the grading schema
GRADE	VARCHAR2	(5)	Yes	The grade which the student attained for this unit attempt.
S_GRADE_CREATION_METHOD_TYPE	VARCHAR2	(30)	Yes	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, discontin, keyed, upload and system.
FINALISED_OUTCOME_IND	VARCHAR2	(1)	Yes	Indicates and specifies if 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 finalization.
MARK	NUMBER	(6)		Indicates the student's level of achievement in the unit attempt
NUMBER_TIMES_KEYED	NUMBER	(2)		Indicates the number of times the outcome has been entered
TRANSLATED_GRADING_SCHEMA_CD	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
TRANSLATED_GRADE	VARCHAR2	(5)		The code representing the translated grade.
TRANSLATED_DT	DATE			Describes the date the unit attempt outcome was translated according to 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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
ORG_ID	NUMBER	(15)		Operating unit identifier.
GRADING_PERIOD_CD	VARCHAR2	(30)	Yes	Grading Period Cd.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard DFF Column
ATTRIBUTE1	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE2	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE3	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE4	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE5	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE6	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE7	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE8	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE9	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE10	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE11	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE12	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE13	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE14	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE15	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE16	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE17	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE18	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE19	VARCHAR2	(150)		Standard DFF Column
ATTRIBUTE20	VARCHAR2	(150)		Standard DFF Column
INCOMP_DEADLINE_DATE	DATE			Completion Date for completing Incomplete Grade.
INCOMP_GRADING_SCHEMA_CD	VARCHAR2	(10)		Grading Schema for the incomplete grade.
INCOMP_VERSION_NUMBER	NUMBER	(3)		Grading SchemaVersion Number for the 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.
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 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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      GRADING_PERIOD_CD
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      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 IGS.IGS_AS_SU_STMPTOUT_ALL;

Dependencies

[top of page]

IGS.IGS_AS_SU_STMPTOUT_ALL does not reference any database object

IGS.IGS_AS_SU_STMPTOUT_ALL is referenced by following:

APPS: IGS_AS_SU_STMPTOUT_ALL