- STUDENT_COURSE_MEMBERSHIP_ID [1] *
- ASSESS_INSTANCE_ID [1] *
- ASSESS_SEQ_ID [1] *
- STUDENT_COURSE_MEMBERSHIP_SEQ [1] *
- MOD_INSTANCE_ID [1]
- STUDENT_ID [1]
- ASSESS_DUE_DATE [0..1]
- ASSESS_RETAKE [0..1]
- ASSESS_AGREED_MARK [0..1]
- ASSESS_ACTUAL_MARK [0..1]
- ASSESS_AGREED_GRADE [0..1]
- ASSESS_ACTUAL_GRADE [0..1]
- ASSESSMENT_CURRENT_ATTEMPT [0..1]
- ASSESSMENT_RESULT [0..1]
- GRADE_DATE [0..1]
- MAX_POINTS [0..1]
- X_ASSESS_DETAIL [0..1]
- X_MOD_NAME [0..1]
- X_MOD_ID [0..1]
- X_MOD_ACADEMIC_YEAR [0..1]
* indicates that the property is part of a composite primary key for this entity.
A unique sequence number to indicate the order of assessments taken by a student on the assessment instance.
To help identify the latest assessment and the order of assessments for a student, especially for those in reassessment. This could differ from the ASSESS_CURRENT_ATTEMPT/ASSESS_COMPLETED_ATTEMPT attributes when a student has mitigating circumstances.
Jisc
Any
Integer
The ASSESS_SEQ_ID number needs to increment with the chronological order of assessments.
The date an assessment instance for a student was due for submission.
Analytics and display
Jisc
YYYY-MM-DD
ISO 8601
Whether this is a retake of the asessment for that student.
Analytics
Jisc
| ASSESS_RETAKE | DESCRIPTION(ENGLISH) | DESCRIPTION(WELSH) |
| 1 | Yes | Ie |
| 2 | No | Na |
Integer
The mark awarded to the learner after any moderation process, but before any formal confirmation process. Moderation processes typically involve multiple markers, and confirmation processes typically involve external examiners.
Analytics
Jisc
0-100
Decimal
ASSESS_ACTUAL_MARK should only be part of a UDD compliant dataset if there is a moderation process and if the result of that process is available in the source data.
The mark recorded after any moderation or confirmation processes, or the only recorded mark if there are no moderation or confirmation processes.
Analytics
Jisc
0-100
Decimal
ASSESS_AGREED_MARK is expected to be present in any UDD compliant dataset as soon as it becomes available.
The grade awarded to the learner after any moderation process, but before any formal confirmation process. Moderation processes typically involve multiple markers, and confirmation processes typically involve external examiners.
Analytics
Jisc
Any
String (255)
ASSESS_ACTUAL_GRADE should only be part of a UDD compliant dataset if there is a moderation process and if the result of that process is available in the source data.
The grade recorded after any moderation or confirmation processes, or the only recorded grade if there are no moderation or confirmation processes.
Analytics
Jisc
Any
String (255)
ASSESS_AGREED_GRADE is expected to be present in any UDD compliant dataset as soon as it becomes available.
Number of attempts taken by a student so far on an assessment instance.
Analytics
Jisc
Any
Integer
Omitting this property may hinder the development or use of an effective analytics model.
Indicates whether the student passed the assessment, didn't pass the assessment, deferred the assessment or whether this information is not known because the assessment hasn't been due yet.
Analytics
Jisc; student_on_a_module_instance.MOD_RESULT
| ASSESSMENT_RESULT | DESCRIPTION(ENGLISH) | DESCRIPTION(WELSH) |
| 1 | Pass | |
| 2 | Fail | |
| 3 | Not known | |
| 4 | deprecated (was: 'deferred') |
Int
Code 3 is applied in all cases where the outcome is either not known (yet), or doesn't apply because the student hasn't been assessed yet. Code 4 is deprecated because deferral or withdrawal is indicated by WITHDRAWAL_REASON in student_course_membership. Omitting this property could impair the functionality of analytics applications such as student apps or dashboards.
The date at which the grade result has been confirmed and awarded.
Analytics
Jisc
Not specified
Date (ISO format) - YYYY-MM-DD
This is the date when a grade has been moderated and agreed, but before exam board confirmation. It is typically the date at which the grade is entered in a SRS.
The maximum points that an instructor can allocate to an assessment. Used to indicate the marking scale used for an assignment.
Analytics
Jisc
Not specified
String (256)
The value can be any alphanumeric used by any type of marking scale. E.g. 80%, B11 or 'excellent'. There is also the similar MAX_MARKS property on assessment_instance, which is for analytic purposes. It only accepts decimal data.
An extra implementation optimisation that isn't part of the UDD model. It's value is identical to that of the relevant assessment_instance.ASSESS_DETAIL.
Implementation optimisation
Jisc; assessment_instance.ASSESS_DETAIL
Any
String (255)
This data is generated internally from existing data, and does not need to be supplied by an institution.
An extra implementation optimisation that isn't part of the UDD model. Its value is identical to that of the relevant module.MOD_ID.
Implementation optimisation
Jisc; module.MOD_ID
Any
String (255)
This data is generated internally from existing data, and does not need to be supplied by an institution.
An extra implementation optimisation that isn't part of the UDD model. Its value is identical to that of MOD_ACADEMIC_YEAR on the mod_instance identified by the relevant MOD_INSTANCE_ID.
Analytics
Jisc
4 digit year
Int
This is the starting year for the academic year.