DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_AS_SUAAI_OUTHIST_V

Object Details
Object Name: IGS_AS_SUAAI_OUTHIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AS_SUAAI_OUTHIST_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 Mandatory Comments
ROW_ID ROWID (10)
Rowid.
PERSON_ID NUMBER (15)
Student for whom the assessment item and its outcome is getting recorded
COURSE_CD VARCHAR2 (6)
The program for the student.
UNIT_CD VARCHAR2 (10)
The unit for the student to which the assessment item is linked.
CAL_TYPE VARCHAR2 (10)
Students enrolled teaching calendar type
CI_SEQUENCE_NUMBER NUMBER (6)
Students teaching calendar sequence number. It helps in identifying the instance for the calendar
ASS_ID NUMBER (10)
The assessment item ID of an assessment item that has been linked to the student and against whom the history is getting tracked. An assessment item ID is a system-generated number that is used to uniquely identify an assessment item. An assessment item must first be assigned to one or more unit offerings before it can be assigned to student unit attempts.
CREATION_DT DATE

Creation Date
GRADING_SCHEMA_CD VARCHAR2 (10)
The grading schema for the assessment item associated with student assessment item
GS_VERSION_NUMBER NUMBER (3)
The version of grading schema for the assessment item associated with student assessment item.
GRADE VARCHAR2 (10)
The grade for a student unit attempt assessment item
OUTCOME_DT DATE

The date on which an outcome was decided for the students attempt at the assessment item
MARK NUMBER (6)
The marks for a student unit attempt assessment item
OUTCOME_COMMENT_CODE VARCHAR2 (30)
The reason for changing the grade or marks. This would be a required column whenever the marks or grade are changed
OUTCOME_COMMENT_MEANING VARCHAR2 (4000)
Meaning of outcome.
HIST_START_DT DATE

Effective start date and time of the history record
HIST_END_DT DATE

Effective end date and time of the history record
HIST_WHO NUMBER (15)
Updated by the person
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
UOO_ID NUMBER (7)
Unit Section identifier
SUA_ASS_ITEM_GROUP_ID NUMBER (15)
Unique identifier for a group to which the unit assessment item is attached.
MIDTERM_MANDATORY_TYPE_CODE VARCHAR2 (30)
For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
MIDTERM_WEIGHT_QTY NUMBER (6)
Allows user to define the weight of the assessment item relative to other assessment items for Midterm grading period.
FINAL_MANDATORY_TYPE_CODE VARCHAR2 (30)
For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default)
FINAL_WEIGHT_QTY NUMBER (6)
Allows user to define the weight of the assessment item relative to other assessment items for Final grading period.
SUBMITTED_DATE DATE

Date on which the student submitted the assessment item for grading
WAIVED_FLAG VARCHAR2 (1)
Allows the user to indicate that the assessment item is being waived for a particular student.
PENALTY_APPLIED_FLAG VARCHAR2 (1)
Allows the user to indicate that the captured mark/grade have been subjected to a penalty.
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
,      ASS_ID
,      CREATION_DT
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      GRADE
,      OUTCOME_DT
,      MARK
,      OUTCOME_COMMENT_CODE
,      OUTCOME_COMMENT_MEANING
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UOO_ID
,      SUA_ASS_ITEM_GROUP_ID
,      MIDTERM_MANDATORY_TYPE_CODE
,      MIDTERM_WEIGHT_QTY
,      FINAL_MANDATORY_TYPE_CODE
,      FINAL_WEIGHT_QTY
,      SUBMITTED_DATE
,      WAIVED_FLAG
,      PENALTY_APPLIED_FLAG
FROM APPS.IGS_AS_SUAAI_OUTHIST_V;

Dependencies

[top of page]

APPS.IGS_AS_SUAAI_OUTHIST_V references the following:

SchemaAPPS
SynonymIGS_AS_SUAAI_OUHIST
SynonymIGS_AS_SU_ATMPT_ITM
PL/SQL PackageIGS_GE_GEN_004 - show dependent code

APPS.IGS_AS_SUAAI_OUTHIST_V is not referenced by any database object