Annual Staff Report - Data Definitions

Report Year

Year to be reported.

Character

4

Entered when data is loaded.

Employee Number

Employee Number.

Integer

Not Applicable

employee.empl_no

Social Security

The employee’s Social Security number.

Character

11

employee.ssn

Last Name

The employee’s last name.

Character

30

employee.l_name

First Name

The employee’s first name.

Character

30

employee.f_name

LEA

Local Education Agency Code.

Character

2

hrmstate.state27

EEO Race Code

No longer used.

Character

6

Blank

Gender

The employee’s gender.

Character

1

person.sex

Birth Date

The employee’s date of birth.

Date

Not Applicable

employee.birthdate

Degree

The degree status of professional staff (highest degree).

Character

2

emp_degree.dtype for the highest degree or the associated degtable.state_degree if it exists

Years of Experience

The total years (two digits) and months (one digit - expressed in decimals) of prior experience in the current position type, including experiences outside and inside the local unit.

Small Integer

Not Applicable

If the employee’s position is less than 26, the Person.yrs_total *10, unless the hire date is in the start to end date range, is calculated based on the state’s chart.

Hire Date

The date the staff member started the current assignment.

Date

Not Applicable

employee. hire_date

Termination Date

The date the employee resigned or left the school system between the start and end dates.

Date

Not Applicable

employee.term_date

Termination Cause

Cause of separation code.

Character

2

tertable.state_term_code where tertable.code = person.term_code if it exists, or just person.term_code

Contract Months

The type of contract month assignment.

Character

2

The desc_x field in the user-defined code reference table where the table code = “CA” and the code equals the system calendar code from the employee’s primary rate.

Percent

The percentage of the employee's time spent on the assignment.

Decimal

5,4

assignment.perc_time

FTE

The FTE code calculated based on a standard workweek (40 hours) for all positions.

Small Integer

Not Applicable

empuser.ftext6 where page_no=’32000’ if exists, otherwise r_payrate.fte * 1000

Previous Year of Employment

The last school year in which the person worked.

Character

4

empuser.ftext1 where page_no = ‘10’

Where Employed

The code for where the person worked before the current assignment.

Character

2

empuser.ftext2 where page_no = ’10;

Residence

The state from which the new employee came.

Character

2

empuser.ftext3 where page_no = ‘10’

Experience Type

The code for prior experience of professional staff.

Character

1

empuser.ftext4 where page_no = ‘10’

Location

The location code for the level at which the employee is working.

Character

1

hrm_locn.state_locn_code, where the code equals the employee’s assignment location code. 

If using position control hrm_locn.state_locn_code, where the code equals positiondata.locn

Building

Building number the employee is assigned to.

Character

4

The location associated with the employee’s assignment, assignment.location. 

The school number is blank if the staff location is 1 or 7.

Budget

Budget code.

Character

16

assignment.fin_field1.  If using the budget code crosswalk, this value crosswalks to retrieve mdbudcross.md_bud

Position

The code for the assignment level of the position.

For Position 11, you must select a value in the National Board Certification field.

Character

2

This is retrieved from the POSITION field on the employee assignment table, r_assignment.position, or the first two characters of the MSDE pos/subj field on the edit position control screen. 

The MSDE pos/subj should be entered in the following manner PP-SSSS where PP is the two-digit position code, and SSSS is the four-digit subject code.

Salary

The total salaries earned, including bonuses, stipends, and so on.

Decimal

10,2

The sum of all salaries included in the docking rate calculation is multiplied by the percent field on the employee’s assignment table.

Subject 1

Subject code for the classroom teacher.

Character

4

This is retrieved from the State Assignment Number field on the Assignment Code Table page.

The employee’s assignment code crosswalks to the corresponding assignment code in the assignment code table.

If using position control, the subject is retrieved from the MSDE pos/subj field for the corresponding position code on the edit position control screen. The MSDE pos/subj should be entered in the following manner:

PP-SSSS, where PP is the two-digit position code, and SSSS is the four-digit subject code.  

Up to 6 employee subject codes are reported in the percentage of time order.

Subject 2

Subject code for the classroom teacher.

Character

4

Refer to Subject 1.

Subject 3

Subject code for the classroom teacher.

Character

4

Refer to Subject 1.

Subject 4

Subject code for the classroom teacher.

Character

4

Refer to Subject 1.

Subject 5

Subject code for the classroom teacher.

Character

4

Refer to Subject 1.

Subject 6

Subject code for the classroom teacher.

Character

4

Refer to Subject 1.

Targeted Assistance School (TAS) FTE

The full-time equivalent status for staff funded by a Title I, Part A Targeted Assistance School (TAS) program.

Decimal

4,3

assignment.user_7 or md_pos_staff.tas_fte if using position control

Title I Para Professional

Indicates whether the staff person is Title I [serving in a school-wide (SW) Title I school or funded by Title I Targeted Assistance (TAS) and is a paraprofessional as defined by Title I, Part A.

Character

1

assignment.user_1 or md_pos_staff.titleI_para if using position control

Title I Qualified Paraprofessional

Paraprofessionals are qualified if they meet the following requirements:

• Completed two years of study at an institution of higher education.

• Obtained an associate’s (or higher) degree.

• Met a rigorous standard of quality and demonstrated, through a formal State or local academic assessment, knowledge of and the ability to assist in instructing reading, writing, and mathematics (or, as appropriate, reading readiness, writing readiness, and mathematics readiness).

Valid values:

• Y = Yes, Title I paraprofessional is qualified

• N = No, Title I paraprofessional is not qualified

(Instructional Paraprofessionals only, Title I Paraprofessional = I.)

Character

1

assignment.user_2 or md_pos_staff.titleI_qual_para if using position control

National Board Certification

Indicates if the employee has a National Board Certification.

Valid values:

• Y - Yes

• N - No

If the Position field value is 11, you must select a value in this field.

Character

1

mdstaff.natl_brd_cert

Maiden Name

The employee’s maiden name from the birth certificate.

Character

25

employee.prev_lname

Ethnicity

Indicates if the employee is Hispanic or Latino.

Character

1

person.ethnic_code

Race - Indian

American Indian/Alaska Native

Character

1

Each employee's race code in the table empl_races is first crosswalked to the race_state field in the racetable table. 

The New Race Code will be set if the race_state field contains an appropriate race (A, I, B, P, or W).  If the race code cannot be translated, the program attempts to translate the racetable.race_fed and the racetable.race fields.

Race - Asian

Asian

Character

1

Race - Black

Black or African American

Character

1

Race - Hawaiian

Native Hawaiian or Other Pacific Islander

Character

1

Race - White

White

Character

1

Tenure Status

The employee's tenure status.

Character

1

empuser.ftext7 where page_no = ‘10’

Unique Statewide Identifier

The state-assigned teacher identification number.

Character

10

person.staff_state_id

Middle Name

The employee’s middle name.

Character

15

employee.m_name

Suffix

The employee’s name suffix.

Character

3

employee.name_suffix

Teacher/ Principal Effectiveness Rating

Effectiveness rating for the school year.

Valid values:

• H – Highly Effective

• E – Effective

• I – Ineffective

• N – Not Evaluated

Only required for Teachers (position code 11) and Principals (position code 08), active or separated.

Character

1

pat_act.sit_data5

where pat_act.sit_type = “EFFECTIVENESS” and

pat_act.sit_data1 = mdstaff.rpt_yr for the employee number.  The effectiveness rating is loaded for the most recent activity with the highest FTE.

Teacher/ Principal Evaluation School

The school where the teacher or principal was evaluated during the school year.

Character

4

pat_act.sit_data3

where pat_act.sit_type = “EFFECTIVENESS” and

pat_act.sit_data1 = mdstaff.rpt_yr for the employee number.  The evaluation school is loaded for the most recent activity with the highest FTE.

Teacher/ Principal Evaluation Position

The position for which the teacher or principal was evaluated during the school year.

Character

2

pat_act.sit_data6

where pat_act.sit_type = “EFFECTIVENESS” and

pat_act.sit_data1 = mdstaff.rpt_yr for the employee number.  The evaluation school is loaded for the most recent activity with the highest FTE.

Subject 1 -Teacher Certificated in Subject

Indicates if the teacher is certificated in the subject reported in Subject 1.

Character

1

This is determined by taking the teacher's subject and certifications against the crosswalk table.

Subject 2 -Teacher Certificated in Subject

Indicates if the teacher is certificated in the subject reported in Subject 2.

Character

1

This is determined by taking the teacher's subject and certifications against the crosswalk table.

Subject 3 -Teacher Certificated in Subject

Indicates if the teacher is certificated in the subject reported in Subject 3.

Character

1

This is determined by taking the teacher's subject and certifications against the crosswalk table.

Subject 4 -Teacher Certificated in Subject

Indicates if the teacher is certificated in the subject reported in Subject 4.

Character

1

This is determined by taking the teacher's subject and certifications against the crosswalk table.

Subject 5 -Teacher Certificated in Subject

Indicates if the teacher is certificated in the subject reported in Subject 5.

Character

1

This is determined by taking the teacher's subject and certifications against the crosswalk table.

Subject 6 -Teacher Certificated in Subject

Indicates if the teacher is certificated in the subject reported in Subject 6.

Character

1

This is determined by taking the teacher's subject and certifications against the crosswalk table.

Subject 1 FTE

Indicates the full-time equivalency (FTE) spent teaching Subject 1.

Decimal

4,3

assignment.perc_time

Subject 2 FTE

Indicates the full-time equivalency (FTE) spent teaching Subject 2.

Decimal

4,3

assignment.perc_time

Subject 3 FTE

Indicates the full-time equivalency (FTE) spent teaching Subject 3.

Decimal

4,3

assignment.perc_time

Subject 4 FTE

Indicates the full-time equivalency (FTE) spent teaching Subject 4.

Decimal

4,3

assignment.perc_time

Subject 5 FTE

Indicates the full-time equivalency (FTE) spent teaching Subject 5.

Decimal

4,3

assignment.perc_time

Subject 6 FTE

Indicates the full-time equivalency (FTE) spent teaching Subject 6.

Decimal

4,3

assignment.perc_time