Student course session expected end date(SCSEXPECTEDENDDATE)


Navigation: Index / Data Dictionary / StudentCourseSession / SCSEXPECTEDENDDATE

Key

Value

Name
Student course session expected end date
Short Name
SCSEXPECTEDENDDATE
Parent Entity
TypeField
Applicable To
Scotland
Coverage

All StudentCourseSessions at providers in Scotland where StudentCourseSession.SCSENDDATE does not exist

Description
This field records the expected end date for the StudentCourseSession.
Notes

The expected end date for the StudentCourseSession is recorded in this field. Once the StudentCourseSesion has ended the actual end date is recorded in StudentCourseSession.SCSENDDATE.

Once the StudentCourseSession.SCSENDDATE has been returned, the expected end date does not need to updated.

For example, if the StudentCourseSession is expected to end on 2020-06-01, this would be returned in the expected end date. If the student then left the StudentCourseSession early on 2020-01-02, the StudentCourseSession.SCSENDDATE would be returned as 2020-01-02 and the expected end date would not need to be updated so could remain as 2020-06-01.

All date fields must be completed using the ISO8601 format of YYYY-MM-DD.

Reason Required
This field will be used to indicate if a Student Course Session is contained within an academic year and will be used to inform the allocation of student FTE to academic years.
Field Length
10
Quality RulesQuality Rules to follow
Minimum Occurrence
0
Maximum Occurrence
1
Primary Key?
False
Revision HistoryNo Revision History entries for this collection.