DORIS Logo
 Back

  Award


Description
Student degrees, diplomas, certificates or other awards granted by the institution upon the completion of a degree program.

Data includes award status, awarded date or academic term and GPA.

Entity relationship: Person + Student + AcademicTerm + DegreeProgram + Campus (optional) = Award

Fields
  awardedDate   date   
Date on which degree/certificate was awarded
  awardedTermCode   string    AcademicTerm->termCode
Academic term in which degree/certificate was awarded
  awardStatus   enum   
Status of the award
Allowed Values
  • Pending
  • Awarded
Allowed Value Details
'Pending' - Award has not yet been conferred and is pending confirmation of completion of program requirements.

'Awarded' - Award has been conferred and an 'AwardedDate' is available (not necessarily tied to a graduation date). Indicates that record reflects completion of program.
  campusOverride   string    Campus->campus
Campus associated with the award if it differs from the degree program campus
Additional Notes
If campus offering the award is different than DegreeProgram.campus, field should include the alternate campus code. If null, DegreeProgram.campus value will be used.
  classRank   number   
Rank in graduating class
  collegeOverride   string   
College associated with the award if it differs from the degree program college
Additional Notes
If college offering the award is different than DegreeProgram.college, field should include the alternate college code. If null, DegreeProgram.college value will be used.
  degreeProgram   string    DegreeProgram->degreeProgram
Unique identifier for an academic course of study that results in a formal award
Additional Notes
Value is client-defined, but typically includes the degree and major and/or a combination of data fields that result in a unique value.
The value for degreeProgram will be referenced as a one-to-one relationship in DegreeProgram and AcademicTrack.
  departmentOverride   string   
Department associated with the award if it differs from the degree program department
Additional Notes
If department offering the award is different than DegreeProgram.department, field should include the alternate department code. If null, DegreeProgram.department value will be used.
  divisionOverride   string   
Division associated with the award if it differs from the degree program division
Additional Notes
If division offering the award is different than DegreeProgram.division, field should include the alternate division code. If null, DegreeProgram.division value will be used.
  gpa   string   
Final GPA at awarded date
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  personId   string    Student->personId
Unique identifier of student
  recordActivityDate   date   
Date source record inserted or modified
  campus   string    deprecated
Campus associated with the degree/certificate awarded
Additional Notes
Renamed to campusOverride. If the campus value differs from the degree program campus value, remap the campus field to the campusOverride field.
  college   string    deprecated
College code associated with the degree/certificate awarded
Additional Notes
Renamed to collegeOverride. If the college value differs from the degree program college value, remap the college field to the collegeOverride field.
  degree   string    deprecated
Degree/certificate associated with the award
Additional Notes
Removed. The degree field is not required, since the degree value is located in the Degree Program entity.
  degreeLevel   enum    deprecated
Level of study for the degree/certificate
Additional Notes
Removed. The degreeLevel field is not required, since the degree level value is located in the Degree entity.

Example SQL