[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_SUAAI_OUHIST |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_AS_SUAAI_OUHIST
|
| Subobject Name: | |
| Status: | VALID |
The history of the for the student assessment item outcomes is recorded in this table.
The base table for the history table is IGS_AS_SU_ATMPT_ITM. The history is tracked for grading schema,
mark, grade, outcome date and outcome comment change.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_AS_SUAAI_OUHIST_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PERSON_ID
COURSE_CD
UOO_ID
ASS_ID
CREATION_DT
HIST_START_DT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Student for whom the assessment item and its outcome is getting recorded |
| COURSE_CD | VARCHAR2 | (6) | Yes | The program for the student. |
| UNIT_CD | VARCHAR2 | (10) | Yes | The unit for the student to which the assessment item is linked. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | Students enrolled teaching calendar type |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Students teaching calendar sequence number. It helps in identifying the instance for the calendar |
| ASS_ID | NUMBER | (10) | Yes | 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 | Yes | Indicates the date on which an assessment item was created against the student. | |
| 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 | |
| HIST_START_DT | DATE | Yes | Effective start date and time of the history record | |
| HIST_END_DT | DATE | Yes | Effective end date and time of the history record | |
| HIST_WHO | NUMBER | (15) | Yes | Updated by the person |
| 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 | |
| UOO_ID | NUMBER | (7) | Yes | Unit Section identifier |
| SUA_ASS_ITEM_GROUP_ID | NUMBER | (15) | Yes | Unique identifier of a group to which the student unit attempt 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. |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, 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 IGS.IGS_AS_SUAAI_OUHIST;
IGS.IGS_AS_SUAAI_OUHIST does not reference any database object
IGS.IGS_AS_SUAAI_OUHIST is referenced by following:
APPS
IGS_AS_SUAAI_OUHIST
|
|
|
|