[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_AS_SU_ATMPT_AST_ITEMS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_AS_SU_ATMPT_AST_ITEMS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Describes assessment item allocated to student unit attempt, either manually or by unit's default assessment items.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_NAME | VARCHAR2 | (360) | Yes | Describes the person name. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Describes the person number. |
| ASSESSMENT_ITEM | VARCHAR2 | (180) | Describes an assessment item. | |
| PROGRAM_CODE | VARCHAR2 | (6) | Yes | Describes the students course code |
| PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Title of the identified course code. |
| UNIT_CODE | VARCHAR2 | (10) | Yes | Describes the students enrolled unit code |
| UNIT_TITLE | VARCHAR2 | (90) | Yes | Title of the identified unit code. |
| CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Describes the students enrolled teaching calendar type |
| CALENDAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the teaching calendar sequence number |
| CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Calendar Description | |
| GRADE | VARCHAR2 | (5) | The grade for the assessment item for the student. | |
| MARK | NUMBER | (6) | The mark for the assessment item for the student. | |
| ASSESSMENT_CREATION_DATE | DATE | Yes | The date at which the assessment item is created. | |
| _LA:S_DEFAULT_INDICATOR | CHAR | (55) | Indicates if the assessment item has been assigned manually or by the system | |
| OUTCOME_DATE | DATE | The date on which an outcome was decided for the students attempt at the assessment item. | ||
| OVERRIDE_DUE_DATE | DATE | A user-defined date which overrides the default due date of the assessment item. | ||
| PERFORMANCE | VARCHAR2 | (10) | The outcome of a student unit attempt assessment item. This is not governed by a restricted set it is user-definable. | |
| _LA:OUTCOME_COMMENT_CODE | CHAR | (82) | The reason for changing the grade or marks. This would be a required column whenever the marks or the grade are changed. | |
| ASSESSMENT_PATTERN | VARCHAR2 | (60) | The institution-defined description of the unit assessment pattern. | |
| TRACKING_STATUS | VARCHAR2 | (10) | Describes the tracking status. | |
| GRADING_SCHEMA_DESC | VARCHAR2 | (60) | Describes the grading schema. | |
| GRADING_SCHEMA_CODE | VARCHAR2 | (10) | The grading schema for the assessment item associated with student assessment item | |
| GRADING_SCHEMA_VERSION_NUMBER | NUMBER | (3) | The version of grading schema for the assessment item associated with student assessment item. | |
| 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 |
| PERSON_ID | NUMBER | (15) | Yes | Describes the ID that uniquely identifies a person. |
| ASSESSMENT_ID | NUMBER | (10) | Yes | The assessment item ID of an assessment item, which has been linked to the student. An assessment item ID is a system-generated number, which 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. |
| ASSESSMENT_PATTERN_ID | VARCHAR2 | (0) | The assessment pattern ID of an assessment pattern, which has been linked to the student. An assessment pattern ID is a system-generated number that is used to uniquely identify an assessment pattern. An assessment pattern must first be assigned to one or more unit offerings before it can be assigned to student unit attempts.- OBSOLETE | |
| TRACKING_ID | NUMBER | (9) | The tracking ID of the tracking item, which has been created to track the student's assessment item. A tracking is a system-generated identification number used to uniquely identify a tracking item. | |
| ATTEMPT_NUMBER | NUMBER | (2) | Yes | The attempt number of the assessment. This exists to enable multiple of attempt of a particular assessment item within a single student unit attempt. |
| LOGICAL_DELETE_DATE | DATE | Describes the date on that the record was logically deleted. Logical deletion is used here as a method of retaining the history of decisions made regarding a students assessment. | ||
| 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 |
| SUA_ASS_ITEM_GROUP_ID | NUMBER | (15) | Yes | Unique identifier for a group to which the unit assessment item is attached. |
| SUA_ASS_ITEM_GROUP_NAME | VARCHAR2 | (30) | Yes | Student Unit Attempt Assessment Item Group Name |
| _LA:UAI.MIDTERM_MNDRY_TYP_CD | CHAR | (88) | 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. | |
| _LA:UAI.FINAL_MNDRY_TYP_CODE | CHAR | (86) | 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 | ||
| _LA:WAIVED_FLAG | CHAR | (53) | Allows the user to indicate that the assessment item is being waived for a particular student. | |
| _LA:PENALTY_APPLIED_FLAG | CHAR | (62) | 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_NAME
, PERSON_NUMBER
, ASSESSMENT_ITEM
, PROGRAM_CODE
, PROGRAM_TITLE
, UNIT_CODE
, UNIT_TITLE
, CALENDAR_TYPE
, CALENDAR_SEQUENCE_NUMBER
, CALENDAR_DESCRIPTION
, GRADE
, MARK
, ASSESSMENT_CREATION_DATE
, _LA:S_DEFAULT_INDICATOR
, OUTCOME_DATE
, OVERRIDE_DUE_DATE
, PERFORMANCE
, _LA:OUTCOME_COMMENT_CODE
, ASSESSMENT_PATTERN
, TRACKING_STATUS
, GRADING_SCHEMA_DESC
, GRADING_SCHEMA_CODE
, GRADING_SCHEMA_VERSION_NUMBER
, UNIT_VERSION_NUMBER
, PROGRAM_VERSION_NUMBER
, PERSON_ID
, ASSESSMENT_ID
, ASSESSMENT_PATTERN_ID
, TRACKING_ID
, ATTEMPT_NUMBER
, LOGICAL_DELETE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, UOO_ID
, SUA_ASS_ITEM_GROUP_ID
, SUA_ASS_ITEM_GROUP_NAME
, _LA:UAI.MIDTERM_MNDRY_TYP_CD
, MIDTERM_WEIGHT_QTY
, _LA:UAI.FINAL_MNDRY_TYP_CODE
, FINAL_WEIGHT_QTY
, SUBMITTED_DATE
, _LA:WAIVED_FLAG
, _LA:PENALTY_APPLIED_FLAG
FROM APPS.IGSFV_AS_SU_ATMPT_AST_ITEMS;
APPS
HZ_PARTIES
IGS_AS_ASSESSMNT_ITM_ALL
IGS_AS_GRD_SCHEMA
IGS_AS_SUA_AI_GROUP
IGS_AS_SU_ATMPT_ITM
IGS_AS_UNITASS_ITEM_ALL
IGS_AS_UNTAS_PATTERN_ALL
IGS_CA_INST_ALL
IGS_EN_STDNT_PS_ATT_ALL
IGS_EN_SU_ATTEMPT_ALL
IGS_PS_UNITASS_ITEM
IGS_PS_UNIT_VER_ALL
IGS_PS_VER_ALL
IGS_TR_ITEM_ALL
APPS.IGSFV_AS_SU_ATMPT_AST_ITEMS is not referenced by any database object
|
|
|
|