Assignment Information
The following table outlines the Michigan field names and the assignment information's location.
Data Item | Field Name | Description | Location | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Employee Number | Employee Number | Employee number. Not reported to Registry of Educational Personnel (REP). | employee.empl_no | ||||||||||||||||
Date of Count | Date of Count | The due date for submission of the REP data. | Entered in the Submission Date field while loading data. | ||||||||||||||||
School/Facility Code | School | The state-assigned number in the Educational Entity Master (EEM) for the school where the employee is assigned. | NA | ||||||||||||||||
Assignment | Position | The state-assigned five-character code identifying the position assignment of the employee. The primary assignment should be listed first if multiple assignments are being reported for one individual. | assignment.asncode | ||||||||||||||||
FTE | FTE | The full-time equivalency (FTE) of an employee being employed in this district. This refers to the amount of time required to perform an assignment stated as a proportion of a full-time position. The FTE is computed by dividing the time employed by the time normally required for a full-time position. The FTE submitted should be determined by district policy and contracts within the district. | assignment. Perc_time | ||||||||||||||||
Hourly Wage | Wage | The hourly wage based on contractual agreements, hours per workday, and the number of days per contractual school year. |
wage = pay rate
wage = pay rate / hours per day
wage = docking rate / (hours per day)
If an R type employee has pay rate hours per day = 0 or 1: wage = docking rate / MEIS hours per day. If an R type employee has pay rate hours per day <> 0 or 1: wage = docking rate / hours per day (from pay rate) | ||||||||||||||||
Accounting/Function Code | Account Code | Three-character state-assigned accounting code for each position in a given school district. The Michigan Public School Accounting Manual (Bulletin 1022) serves as a mandatory guide to the uniform classification and recording accounting transactions for public school districts in Michigan. | assignment. Acct_code (if it exists) or The system uses the employee’s primary pay rate and distribution record with the largest percent associated with the primary rate. Using this organization code, the system looks for the level requested during the load process in the organization table and uses this code as the default. Exceptions must be updated manually. | ||||||||||||||||
Current Grade Assignment: Developmental Kindergarten | Developmental -Kindergarten | Enter 1 if the employee works in Developmental Kindergarten (Young Fives, Early Fives, Jump Start, | assignment.gradepk | ||||||||||||||||
Current Grade Assignment: Kindergarten | Kindergarten | Enter 1 if the employee works in Kindergarten. | assignment.gradekg | ||||||||||||||||
Current Grade Assignment: First Grade | 1st Grade | Enter 1 if the employee works in First Grade. | assignment.grade01 | ||||||||||||||||
Current Grade Assignment: Second Grade | 2nd Grade | Enter 1 if the employee works in Second Grade. | assignment.grade02 | ||||||||||||||||
Current Grade Assignment: Third Grade | 3rd Grade | Enter 1 if the employee works in Third Grade. | assignment.grade03 | ||||||||||||||||
Current Grade Assignment: Fourth Grade | 4th Grade | Enter 1 if the employee works in Fourth Grade. | assignment.grade04 | ||||||||||||||||
Current Grade Assignment: Fifth Grade | 5th Grade | Enter 1 if the employee works in Fifth Grade. | assignment.grade05 | ||||||||||||||||
Current Grade Assignment: Sixth Grade | 6th Grade | Enter 1 if the employee works in Sixth Grade. | assignment.grade06 | ||||||||||||||||
Current Grade Assignment: Seventh Grade | 7th Grade | Enter 1 if the employee works in Seventh Grade. | assignment.grade07 | ||||||||||||||||
Current Grade Assignment: Eighth Grade | 8th Grade | Enter 1 if the employee works in Eighth Grade. | assignment.grade08 | ||||||||||||||||
Current Grade Assignment: Ninth Grade | 9th Grade | Enter 1 if the employee works in Ninth Grade. | assignment.grade09 | ||||||||||||||||
Current Grade Assignment: Tenth Grade | 10th Grade | Enter 1 if the employee works in Tenth Grade. | assignment.grade10 | ||||||||||||||||
Current Grade Assignment: Eleventh Grade | 11th Grade | Enter 1 if the employee works in Eleventh Grade. | assignment.grade11 | ||||||||||||||||
Current Grade Assignment: Twelfth Grade | 12th Grade | Enter 1 if the employee works in Twelfth Grade. | assignment.grade12 | ||||||||||||||||
Educational Setting: Alternative Education | Alternative Education | Enter 1 if the special education employee primarily serves Alternative Education. | assignment.grade13 | ||||||||||||||||
Educational Setting: Special Education | Special Education | The age group served by the special education employee. Valid values:
| If assignment. Grade14 = “Y”, 1 If assignment. Grade15 = “Y”, “2” If assignment. Grade16 = “Y”, “3” If assignment. Grade17 = “Y”, “4” | ||||||||||||||||
Educational Setting: Adult Education | Adult Education | Enter 1 if the special education employee primarily serves Adult Education. | assignment.grade18 | ||||||||||||||||
Educational Setting: Early Childhood and/or Parenting Programs | Early Childhood/Parenting | Enter 1 if the special education employee primarily serves Early Childhood and/or Parenting Programs. | assignment.grade19 | ||||||||||||||||
Educational Setting: Career/Technical Education | Career/Technical Education | Enter 1 if the special education employee primarily serves Career/ Technical Education. | assignment.grade20 | ||||||||||||||||
Educational Setting: State Agency | State Agency | Enter 1 if the special education employee primarily serves a State Agency. | assignment.grade21 | ||||||||||||||||
Educational Setting: Early On/Early Intervention | Early On/Early Intervention | Enter 1 if the special education employee primarily serves Early On/ Early Intervention (Part C of IDEA). | assignment.grade22 | ||||||||||||||||
Educational Setting: Administrative or Support Staff, ESL, Bilingual Education, or Migrant Education | Administrative/Support | Valid values:
| assignment.grade23 | ||||||||||||||||
Highly Qualified Status | Highly Qualified Reason | For each assignment required to be submitted for Highly Qualified status, enter 1 (yes) in this position if the employee meets the Highly Qualified requirement. If an employee does not meet the definition for Highly Qualified, enter 2 (no) in this position. For any assignment codes that are not required to be submitted for Highly Qualified status, enter 0 (not applicable) in this position. | Look up assignment. Hqreason in the mi_rep_hq table and load the meis_hq_reason if it is found, otherwise load assignment. Hqreason[1,2] | ||||||||||||||||
Academic Major | Academic Major | For employees assigned to core academic assignment codes, enter 1 (yes) in this field if the employee holds an academic major, coursework equivalent to an undergraduate academic major, a graduate degree, or advanced certification or credentialing for the assignment in this repetition of Field 10. Enter 2 (no) in this position if the employee does not have the required major or equivalency for this assignment. For non-core academic assignment codes that are not required to be submitted for Highly Qualified status, enter 0 (not applicable) in this position. | assignment.user_1 | ||||||||||||||||
Academic Minor | Academic Minor | For employees assigned to core academic assignment codes, enter 1 (yes) in this position if the employee holds an academic minor or coursework equivalent to an undergraduate academic minor for the assignment in this repetition of Field 10. Enter 2 (no) in this position if the employee does not have the required minor or equivalency for this assignment. For non-core academic assignment codes that are not required to be submitted for Highly Qualified status, enter 0 (not applicable) in this position. | assignment.user_2 | ||||||||||||||||
Administrator Continuing Education | Admin Continuing Education | For administrative assignment codes, enter 1 (yes) if the district/building administrator has met the continuing education requirement to be eligible for employment. Enter 2 (no) if the administrator has failed to meet the continuing education requirement. For assignment codes that are not required to be submitted for administrator continuing education, enter 0 (not applicable) in this position. | assignment.user_3 | ||||||||||||||||
Number of Core Academic Classes Taught | Number of Classes | For employees with core academic assignment codes, report the number of core academic classes taught (1 through 9). For non-core academic assignment codes, enter a value of 0 through 9. Reporting of the number of classes taught is optional for non-core academic assignment codes. For all other assignment codes, enter 0 (not applicable) for this position. | assignment.num_classes |