DORIS Logo
 Back

  AcademicTerm


Description
Periods of time in which the institution begins and ends educational sessions. Academic terms are defined by an institution based on their academic programs. Terms are typically semesters, trimesters or quarters, but can run any length of time, up to and including an academic year.

Data includes academic year, financial aid year, applicable dates, term properties and full-time credit hour requirements.

Fields
  academicYear   string   
Academic year associated with the academic term
  censusDate   date   
Official enrollment reporting date of academic term or part of term (if applicable); also known as the last day to add/drop courses
  endDate   date   
End date of academic term or part of term (if applicable)
  financialAidYear   string   
Financial aid year associated with the academic term
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  partOfTermCode   string   
Part of academic term
Additional Notes
If field is not applicable or value unknown, use default value of 1 for full term.
  partOfTermCodeDescription   string   
Part of term description
  recordActivityDate   date   
Date source record inserted or modified
  requiredFTClockHoursUG   number   
Full-time clock hour requirement for an undergraduate student; value can differ depending on the term classification of standard length or non-standard length
Additional Notes
If field is applicable, but value unknown, use the default value of 24 clock hours.
  requiredFTCreditHoursGR   number   
Full-time credit hour requirement for a graduate student within academic term; value can differ depending on the term classification of standard length or non-standard length
Additional Notes
If field is applicable, but value unknown, use the default value of 9 credits hours.
  requiredFTCreditHoursUG   number   
Full-time credit hour requirement for an undergraduate student; value can differ depending on the term classification of standard length or non-standard length
Additional Notes
If field is applicable, but value unknown, use the default value of 12 credits hours.
  startDate   date   
Start date of academic term or part of term (if applicable)
  termClassification   enum   
Classification of academic term based on the US Dept of Education established guidelines for term length and full-time credit requirement
Allowed Values
  • Standard Length
  • Non-Standard Length
Allowed Value Details
'Standard Length' - A term duration between 9 and 21 weeks.

'Non-Standard Length' - A term duration that is less than 9 weeks or greater than 21 weeks.
  termCode   string   
Unique identifier for an academic term, i.e., semester, trimester, or quarter
  termCodeDescription   string   
Academic term description
  termType   enum   
Type of academic term which coincides with the time of year the term occurs
Allowed Values
  • Fall
  • Spring
  • Summer
Allowed Value Details
'Fall' - The standard length period within an academic year spanning between late August and November 1.

'Spring' - The second standard length period within an academic year usually spanning between late January and June 1.

'Summer' - Non-standard length term held before the Fall term within an academic year.

Example SQL