DORIS Logo
 Back

  FacultyAppointment


Description
Teaching, research or public service staff and academic position, based on status and length of appointment.

Data includes position, appointment start/end dates, tenure status and tenure associated dates.

Entity relationship: Person + Employee + EmployeePosition = FacultyAppointment

Fields
  appointmentDecision   enum   
Faculty appointment decision
Allowed Values
  • Accepted
  • Not Accepted
Allowed Value Details
'Accepted' - Faculty appointment request was accepted. An 'Accepted' decision should be accompanied by an 'AppointmentStartDate'.

'Not Accepted' - Faculty appointment request was denied.
  appointmentDecisionDate   date   
The date of the appointment decision
  appointmentEndDate   date   
Appointment end date
Additional Notes
The official end date of the faculty members appointment or reappointment
  appointmentPosition   string    EmployeePosition->position
Position of appointment
  appointmentStartDate   date   
Appointment start date
Additional Notes
The official begin date of the faculty members appointment or reappointment
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  nonTenureContractLength   enum   
Contract type (length) for non-tenured faculty members
Allowed Values
  • Multi-year
  • Annual
  • Less than Annual
  • Indefinite
Allowed Value Details
'Multi-year' - Non-tenure agreement/contract with a renewal period greater than 1 year.

'Annual' - Non-tenure agreement/contract with an annual renewal period.

'Less than Annual' - Non-tenure agreement/contract with a renewal period less than 1 year.

'Indefinite' - Non-tenure agreement with an indefinite duration. This includes agreements or contracts that can be terminated by the employer or employee at any time.
  personId   string    Employee->personId
Unique identifier of an employee
  recordActivityDate   date   
Date source record inserted or modified
  tenureEffectiveDate   date   
Date on which the tenure status was effective
  tenureStatus   enum   
Tenure status of the faculty member
Allowed Values
  • Tenured
  • On Tenure Track
  • Not on Tenure Track
Allowed Value Details
'Tenured' - Attained permanence of the appointment position. Should be accompanied by a value for 'TenureEffectiveDate'.

'On Tenure Track' - Under tenure consideration for the appointment position. Should be accompanied by a value for 'TenureTrackStartDate'.

'Not on Tenure Track' - Not under tenure consideration for the appointment position.
  tenureTrackStartDate   date   
Tenure track process start date
Additional Notes
The official start date of faculty members tenure track process

Example SQL