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 | |||||||
Type | Field | ||||||
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 Rules | Quality Rules to follow | ||||||
Minimum Occurrence | 0 | ||||||
Maximum Occurrence | 1 | ||||||
Primary Key? | False | ||||||
Revision History |
|