DORIS Logo
 Back

  DegreeProgram


Description
Academic courses of study that result in a formal award.

Data includes degree, major, program length, organizational structures and usage properties.

Entity relationship: Degree + FieldOfStudy + AcademicTerm (optional) + Campus (optional) = DegreeProgram

Fields
  campus   string    Campus->campus
Campus code associated with the degree program
Additional Notes
If institution does not associate a campus with degree programs, set value of field to null.
  college   string   
College code associated with the degree program
Additional Notes
If institution does not associate a college with degree programs, set value of field to null.
  degree   string    Degree->degree
Degree code associated with the degree program
  degreeProgram   string   
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 Award and AcademicTrack.
  degreeProgramDescription   string   
Description of the degree program
  department   string   
Department code associated with the degree program
Additional Notes
If institution does not associate a department with degree programs, set value of field to null.
  distanceEducationType   enum   
Distance education property of the degree program.
Additional Notes
If all instructional activity required for program completion cannot be completed remotely, the degree program is not considered distance education. Onsite component can include orientation, testing or other non-instructional activity.
Allowed Values
  • Distance education with no onsite component
  • Distance education with mandatory onsite component
  • Distance education with non-mandatory onsite component
  • Not distance education
Allowed Value Details
'Distance education with no onsite component' - Instructional content is delivered exclusively via distance education.

'Distance education with mandatory onsite component' - Instructional content is delivered via distance education but requires an onsite component such as testing or orientation.

'Distance education with non-mandatory onsite component' - Instructional content is delivered via distance education but has an optional onsite component such as academic support services.

'Not distance education' - Instructional content is not delivered via distance education.
  division   string   
Division code associated with the degree program
Additional Notes
If institution does not associate a division with degree programs, set value of field to null.
  isClockHours   boolean   
If degree program length is reported in clock hours instead of credit hours, value = 1, else 0
Additional Notes
Default value if null: 0/false.
  isESL   boolean   
If degree program is considered English as a Second Language (ESL), then value = 1, else 0
Additional Notes
Default value if null: 0/false.
  isForAdmissions   boolean   
If the degree program is used for recruiting and admissions, value = 1, else 0
  isForDegreeAcadHistory   boolean   
If the degree program is used for degree/graduation and academic history, value = 1, else 0
  isForStudentAcadTrack   boolean   
If the degree program is used for students and academic track, value = 1, else 0
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  lengthInCreditOrClockHours   number   
Number of clock hours or credit hours required for completion of the degree program
  lengthInMonths   number   
Number of months required for completion of the degree program
  major   string    FieldOfStudy->fieldOfStudy
Major code associated with the degree program
Additional Notes
Condition for reference - FieldOfStudy->fieldOfStudyType = 'Major'
  recordActivityDate   date   
Date source record inserted or modified
  startDate   date   
Date on which degree program is active
Additional Notes
Either startDate or termCodeEffective must contain a non-null value.
  termCodeEffective   string    AcademicTerm->termCode
Academic term in which degree program is active
Additional Notes
Either termCodeEffective or startDate must contain a non-null value.
  degreeLevel   enum    deprecated
Level of degree program
Additional Notes
Removed. The degreeLevel field is not required, since the degree level value is located in the Degree entity.
  distanceEducationOption   enum    deprecated
Distance education (DE) option for the degree program
Additional Notes
Renamed to distanceEducationType. Remap the distanceEducationOption field to the distanceEducationType field.

Example SQL