DORIS Logo
 Back

  EmployeePosition


Description
Positions available within the institution.

Data includes classification values, such as position class/group/federal category/skill class, position status, chart of accounts and default values for appointment percent and salary.

Fields
  chartOfAccountsId   string    ChartOfAccounts->chartOfAccountsId
Chart of accounts associated with the position
  defaultAppointmentPercent   number   
Default percentage of full time appointment for an employee in the position
  defaultEmployeeClass   string   
Default employee class code associated with this position, based on position class
  defaultEmployeeClassDesc   string   
Default employee class description
  defaultSalaryGrade   string   
Default salary grade associated with this position, based on position class
  defaultSalaryStep   string   
Default salary step associated with the salary grade associated with this position, based on position class
  defaultSalaryTable   string   
Default salary table associated with this position, based on position class
  endDate   date   
End date of the position
  federalEmploymentCategory   enum   
Employment category code used for IPEDS reporting (ECIP)
Allowed Values
  • 9 Month Instructional
  • 10 Month Instructional
  • 11 Month Instructional
  • 12 Month Instructional
  • Other Full Time
  • Part Time
  • Unreported
Allowed Value Details
'9 Month Instructional' - Instructional staff position that works 9 months. This may differ from the number of months an employee will be paid.

'10 Month Instructional' - Instructional staff position that works 10 months. This may differ from the number of months an employee will be paid.

'11 Month Instructional' - Instructional staff position that works 11 months. This may differ from the number of months an employee will be paid.

'12 Month Instructional' - Instructional staff position that works 12 months. This may differ from the number of months an employee will be paid.

'Other Full Time' - Indicates all other instructional/non-instructional full-time positions as defined by the institution.

'Part Time' - Indicates a part time position as defined by the institution.

'Unreported' - Employment category is not described in the previous options.
  isIPEDSReportable   boolean   
If record is applicable for IPEDS reporting, value = 1, else 0
  position   string   
Unique identifier code of position
  positionClass   string   
Position class code
  positionClassDescription   string   
Position class code description
  positionDescription   string   
Position code description or title
  positionGroup   string   
Position group code
  positionGroupDescription   string   
Position group code description
  positionStatus   enum   
Employee position status
Allowed Values
  • Active
  • Cancelled
  • Frozen
  • Inactive
Allowed Value Details
'Active' - Position is still assigned or being assigned to employees. Employees can only be assigned to 'Active' positions.

'Cancelled' - Position was closed before being assigned to any employees.

'Frozen' - Position is not currently assigned to an employee and new hiring for this position is paused temporarily.

'Inactive' - Position has been replaced or is no longer being assigned.
  recordActivityDate   date   
Date source record inserted or modified
  skillClass   string   
Skill class codes for Equal Employment Opportunity skills reporting as defined by the federal government for higher education
  skillClassDescription   string   
Skill class code description
  standardOccupationalCategory   string   
Standard occupational categories defined by the government for federal reporting (ESOC)
  startDate   date   
Start date of the position

Example SQL