Parent Tag

The Id (GUID) of the school or LEA reporting the incident, usually the school in which the incident occurred.

School.schoolID

District.districtGUID

Report IC generated incident ID

Must be created in order to generated

Parent Tag

Time the incident took place

1. Report the Standard Code of the Incident Context field
2. If null and there is a Default value, report the default value
3. Else, report '397'

1. Report the Name of the Incident Location field
2. If null and there is a Default value, report the Name of the default value
3. Else, do not report

1. Report the Standard Code of the Incident Location field
2. If null and there is a Default value, report the default value
3. Else, do not report

Information regarding the individual reporting the incident

Reports a list of state codes associated with behavior event types for the behavior incident.

Campus Attribute where Object- Behavior

Element = stateEventCode

Behavior > Behavior Management > Event Type

Behavior > Behavior Admin > Event Types > State Event Code

System Administration > Custom Attribute > Behavior > State Event Code

Reports the Standard Code associated with the value selected in Weapon Type on the role from any event/role on the incident that a weapon is reported on

(Note: Reports all the Weapon Type codes related to the incident)

dbo.BehaviorWeapon.weaponType

Behavior > Behavior Admin > Event Types > Classification > Weapon

Behavior Management > Incident >Events and Participants  > Participant(s) Details > Weapon Type

1. When Gang-Related checkbox is checked, report '3068'
2. When Hate-Related checkbox is checked, report '3069'
3. When State Event code is mapped to one of the following, report '3066':
   1. 1010
   2. 1020
   3. 1040
   4. 1030
   5. 1050
   6. 1097
4. When State Event code is mapped to one of the following, report '3067'
   1. MA01
   2. MA02
   3. 1660
   4. 1650
   5. 1610
   6. MA03
   7. 1620
   8. 1630
   9. 1640
   10. 1670
   11. 1680
   12. 1697
   13. MA14
5. When State Event code is mapped to one of the following, report '3070'
   1. 3700
6. When State Event Code is mapped to one of the following, report '04645'
   1. 1700
   2. 3210
   3. 2500
7. ELSE NULL

dbo.BehaviorEvent.gangRelated
dbo.BehaviorEvent.hateCrime
dbo.BehaviorType.stateEventCode

Behavior Management > Incident >Events and Participants  > Event Details > Gang-Related

Behavior Management > Incident >Events and Participants  > Event Details > Hate-Related

Behavior > Behavior Admin > Event Types > State Event Code

• Sends standard code associated with the "Relationship to School" field when the participant has a role of "Offender"
• If Behavior role is null, use default value selected on the attribute dictionary. 
• If default is null, send standard code associated with the value of '1' from the drop list.

object = 'BehaviorRole'
element = 'relationshipToSchool'

Behavior Management > Incident >Events and Participants  > Participant(s) Details > Relationship to School

System Administration > Custom > Custom/Attribute > Behavior Role > Relationship to School

System Administration > Custom > Custom/Attribute > Behavior Role > Relationship to School > Default Value

Hardcoded '04'

Behavior Management > Incident >Events and Participants

Census > People > Demographics > Last Name

Behavior Management > Incident >Events and Participants

Census > People > Demographics > First Name

dboZIAgentRefIDs.
XML_GUID WHERE AttachmentTableName
='StudentPersonal'

System Administration > Custom > Custom/Attribute > Behavior Role > Relationship to School > Student

Report Injury standard code

If no Injury set, report '3065'

dbo.BehaviorRole.injury

dbo.CampusAttribute WHERE object='BehaviorRole' AND element='injury'

Behavior Management > Incident >Events and Participants  > Participant(s) Details > Injury

System Administration > Custom > Custom/Attribute > Behavior Role > Injury

1. If state resolution code is 'MA58', 'MA60, 'MA61', or 'MA62', report '9999'
2. Else, report the state resolution code.

BehaviorResType.stateResType

dbo.CampusAttribute WHERE object='Behavior' AND element='stateResCode

Behavior Management > Incident >Resolution > Resolution Details

Behavior > Behavior Admin > Resolution Types > State Resolution Code

System Administration > Custom > Attribute/Dictionary > Behavior > State Resolution Code

1. If Behavior Resolution "Ed Services Provided Code"  provided is not null, report ed services provided code with the Codeset (field 31) of 'StateProvince'
2. If "Ed Services Provided Code" is null, report the default value with the Codeset (field 31) of 'StateProvince'
3. If "Ed Services Provided Code" is null and the default value is null, report 'AE0' with the Codeset (field 31) of 'StateProvince'
4. If the state resolution code is MA58, report MA58 with the Codeset (field 31) of 'Other'
5. If the state resolution code is MA60, report MA60 with the Codeset (field 31) of 'Other'
6. If the state resolution code is MA61, report MA61 with the Codeset (field 31) of 'Other'
7. If the state resolution code is MA62, report MA62 with the Codeset (field 31) of 'Other'
8. If 'Ed Services Provided Code' is AE2 or AE3, report the ed services provided code with the Codeset(field 31) of 'StateProvince' AND report the value from 'Other specification' with the Codeset (field 31) of 'Text'
9. Else, report blank

Notes:

1. One to many of these may report
2. Only values that apply specifically to the resolution reporting should report

dbo.SifDictionary WHERE object = 'BehaviorResolution' AND element = 'serviceProvided'

dbo.SifDictionary WHERE object = 'BehaviorResolution' AND element = 'altPlacementSped'

Behavior > Behavior Management > Add Resolution > Ed Services Provided Code

Behavior > Behavior Management > Add Resolution > Ed Services Not Provided Code

1. When Resolution code = 3089 report "0"
2. Report number entered in the Duration in School Days Field
3. When End Date is not null, and Resolution code is NOT 3089, count the number of instructional days on the current calendar between the start and end date of resolution.
   1. If the start and end dates are the same day, report 1.

1. If Zero Tolerance is checked, report 'Yes'
2. else, report 'No'

1. If Behavior Resolution Type's name has "expulsion" in it, the start/end dates are not null, and there is more than a year between the start and end date, report "Yes"
2. Else report "No"

1. If Shortened Expulsion is checked, report 'Yes'
2. else, report 'No'

1. If Police Notification is checked, report 'Yes'
2. else, report 'No'

1. When the resolution code is "3089" or the Arrest dropdown is set to any entry with a standard code of yes, report "Y"
   
2. Else, report "N"

dbo.BehaviorResoltuion.
stateResCode

dbo.CampusAttribute WHERE object = 'BehaviorResolution' AND element = 'lawEnforcement'

Behavior > Behavior Management > Add/Edit Resolution > Resolution Details > Arrest

1. When Behavior > Edit Resolution > Ed Services Provided Code is Null or AE0, report "No".
   
2. Else, report "Yes".

dbo.BehaviorResolution.
serviceProvided

Behavior > Behavior Management > Add/Edit Resolution > Resolution Details > Ed Services Provided

Parent Tag

List of weapons involved in the incident used by the offender. If the incident involves weapons, the element must have a value.Each weapon used by the offender is identified by a WeaponType entry. When multiple weapons of a single type are used by the offender, each weapon has a separate entry in this list.

(Note: All weapons used in the incident are reported in WeaponTypeList entries for the incident, including those weapons related to this offender.)

dbo.BehaviorWeapon.
weaponType

Behavior>Behavior Event>Event Details> Weapon Type

Parent Tag

List of categories to which the offender’s incident is related.  Report NCES 1049 codes (MA requirement). 

Only SSDR required codes will be extracted for the report.

Report Behavior state event code.

Campus Attribute where Object- Behavior

Element =stateEventCode

Behavior > Behavior Admin >Event Types > State Event Code

Parent Tag

Information regarding the victim(s) in the incident.

1. If reporting from the participant detail, report the Standard Code for the code selected in Relationship to School when Role = Victim.
   1. If Relationship to School is null, report nothing.
2. If reporting from Number of School Personnel Victims text box, report '3422'
3. If reporting from Number of Unknown Victims, report '9997'
4. If reporting from Number of Non-Sch Personnel Victims, report '3059'

dbo.CampusAttribute WHERE object = 'BehaviorRole' AND element = 'relationshipToSchool'

Behavior > Behavior Management > Add/Edit Event > Participant Detail > Role

Behavior Management > Incident Management Editor > Events and participants > Event and Participant Details > Participant Details > Relationship to School

Behavior > Behavior Management > Add/Edit Event > Number of School Personnel Victims

Behavior > Behavior Management > Add/Edit Event > Number of Unknown Victims

Behavior > Behavior Management > Add/Edit Event > Number of Non-Sch Personnel Victims

Parent Tag

The name of the victim.

1. If reporting from the participant detail, report the total number of participants with role of "Victim" in Behavior Incident, based on the relationship to school
2. If reporting from Number of School Personnel Victims text box, report value from that field
3. If reporting from Number of Unknown Victims, report value from that field
4. If reporting from Number of Non-Sch Personnel Victims, report value from that field

Behavior > Behavior Management > Add/Edit Event > Participant Detail > Role

Behavior > Behavior Management > Add/Edit Event > Participant Detail > Relationship to school

Behavior > Behavior Management > Add/Edit Event > Number of School Personnel Victims

Behavior > Behavior Management > Add/Edit Event > Number of Unknown Victims

Behavior > Behavior Management > Add/Edit Event > Number of Non-Sch Personnel Victims

Hardcoded

If there is only one Victim element for this type, then if this element is numeric, it will be used as a total count for this victim type.

Hardcoded 'Count'

dbo.CampusAttribute WHERE object = 'BehaviorRole' AND element = 'relationshipToSchool'

Behavior > Behavior Management > Add/Edit Event > Participant Detail > Role

Behavior Management > Incident Management Editor > Events and participants > Event and Participant Details > Participant Details > Relationship to School

1. When Role = Victim AND Relationship to School has a code of 1. report "StudentPersonal"
2. When Role = Victim AND Relationship to School has a code of 3, report "StaffPersonal"
3. If reporting from the count fields, report blank

dbo.CampusAttribute WHERE object = 'BehaviorRole' AND element = 'relationshipToSchool'

Behavior > Behavior Management > Add/Edit Event > Participant Detail > Role

Behavior Management > Incident Management Editor > Events and participants > Event and Participant Details > Participant Details > Relationship to School

1. Report Standard Code associated in the "Injury" field,
2. If null, report '3065'

dbo.CampusAttribute WHERE object = 'BehaviorRole' AND element = 'injury'

Behavior Management > Incident Management Editor > Events and participants > Event and Participant Details > Participant Details > Injury

Behavior> Behavior Management > Event Details > State Event Code

Behavior Management > Event Details > Comments

Behavior > Behavior Management > Participant Detail > Weapon Type

Behavior > Behavior Management > Participant Detail > Weapon Description

Calculated

Calculated

1. If employment record end date is null
2. If employment record end date is equal to or after the state reporting date
3. If state reported date is 10/1 and the 'Oct 1. Status Override' field equals '01'
4. If state reported date is in the month of June and the 'EOY Status Override' field equals '01'

Else, report 'false'

For HR - If the termination date is before the retirement date, use the termination date as the endDate. Otherwise use the retirement date as the endDate.

Census > District Employment > Employment Records > End Date

HR - Personnel Master > HR General Information - Current Record > Employment Dates > Termination Date or Retirement Date

dbo.Employment.endDate

• Report Start Date from most recent District Employment record.

HR

• Use Hire Date instead of Start Date

Census > District Employment > Employment Records > Start Date

HR:

Personnel Master > HR General Information - Current Record > Employment Dates > Hire Date

dbo.Employment.startDate

1. When Census>District Employment> Employment Records > End Date = NOT Null, AND is <= the State Reporting Date, reports the date in the End Date field (mm/dd/yyyy).
2. When End Date is Null OR is > State Reporting Date, do not report element.

HR

• Use Termination Date instead of End Date

Census > District Employment > Employment Records > End Date 

HR

Personnel Master > HR General Information - Current Record > Employment Dates > Termination Date

dbo.Employment.endDate

The two-digit code that describes an individual’s employment status at the time of the collection.

1. If state reported date is 10/1 and the 'Oct 1. Status Override' field is populated, report the Oct. 1 override status value
2. If state reported date is in the month of June and the 'EOY Status Override' field is populated, report the EOY override status value
3. Else, determine the EmploymentStatus (used in references below):
   • If 'Status' field is populated, use status value
   • If 'Status' field is null and there is a default value, use the default value
   • Else set to Null
4. When District Employment End Date = Null OR District Employment End Date = NOT Null AND is >= State Reported Date (If state reported date is not populated, use current date)
   • If EmploymentStatus (from step 1) is null or equal to '04', report 01.
   • Else, report EmploymentStatus value (from step 1) 
5. Otherwise, report 04.

HR:

• For HR, use termination date in place of district employment end date.

Census > People > District Employment > Employment Information > Status

OR

Census > People > District Employment > Employment Information > Oct. 1 Status Override

OR

Census > People > District Employment > Employment Information > EOY Status Override

HR

Personnel Master > HR General Information > Current Information > Status

OR 

Personnel Master > HR General Information > Current Information > Oct 1. Status Override

OR

Personnel Master > HR General Information > Current Information > EOY Status Override

dbo.Employment.employmentStatus

dbo.Employment.override1

dbo.Employment.override2

dbo.CampusAttribute WHERE object = 'Employment' AND element = 'employmentStatus'

The two-digit code that describes an individual’s reason for no longer being employed by the district.

• If the Employment End Date is on or before the State Reported Date and:
  1. There is an Exit Reason defined on the Employment record, send it.
  2. Else if there is a default Value defined in the Employment Exit Reason dictionary, send it.
• Else, send '00'

For HR, use Termination Date instead of End Date

Census > District Employment > Employment Records > Exit Reason

HR

Personnel Master >HR General Information > Employment Dates > Exit Reason

dbo.Employment.exitReason

dbo.CampusAttribute WHERE object = 'Employment' AND element = 'exitReason'

• Federal Income: 3-digit code selected for Federal Income 1, Federal Income 2, and Federal Income 3.
  • If null or 000, report 000.
• Percentage: 5-digit value entered for Federal Income Percent 1, Federal Income Percent 2, Federal Income Percent 3.
  • If null or 00, report 00.
• Example:  240:.5
• Note:
  • If there are multiple Federal Incomes and Federal Income Percent values, this must be reported in 1 element separated by a ~ as follows:
    • Example: 240:.5~165:.25~170:.25

Census > District Employment > Employment Records > Federal Income / Federal Income Percent

HR

Personnel Master >HR General Information > Federal Income Information / Federal Income Percent

dbo.CampusAttribute WHERE object = 'Employment' AND element = 'federalIncomeSource(1/2/3)'

dbo.CampusAttribute WHERE object = 'Employment' AND element = 'federalIncomePercent(1/2/3)'

Educator’s current professional teacher status as determined by district policies. This element should be completed for all staff. 

• If there is a StaffEval for the current reporting year, and the District Level Professional Teacher drop down is populated, report that value
• Else if there is a default value set on the dictionary, send it.
• Else send '99'.

Census > People > Staff Eval > Staff Evaluations Detail > District Level Prof Teacher

dbo.CampusAttribute WHERE object = 'Employment' AND element = 'districtLevelProfessionalTeach'

• If employment status defined on record (or default) is null or '01', report 'Yes'
• If there is an Employment Status defined on the Employment record (or default value) of '05', send 'No'. 
• Else, report null.

For HR, use Termination Date instead of End Date

Census > District Employment > Employment Records > End Date 

Census > People > District Employment > Employment Information > Status

HR

Personnel Master > HR General Information - Current Record > Employment Dates > Termination Date

Personnel Master >HR General Information > Current Information > Status

dbo.Employment.employmentStatus

dbo.CampusAttribute WHERE object = 'Employment' AND element = 'employmentStatus'

The Id (GUID) that uniquely identifies this section entity.

Parent Tag

N/A

• Send section's mediumOfInstruction if it is not null.
• Else send the default value from the Section.mediumOfInstruction SIF Dictionary.
• If there is no default value, report a blank element.

Scheduling > Courses > Course > Section > Medium Of Instruction

System Administration > Custom Attribute > Section > mediumOfInstruction

dbo.Section.mediumOfInstruction

dbo.CampusAttribute.defaultValue WHERE object='Section' AND element='mediumOfInstruction'

Parent Tag

Optional overrides of the course information for this section.  If this information is offered, then those elements indicated as mandatory must be completed.

• If @Override = 'Yes', then report the following:

  1. Report the value after the '-' in the Standard Code column of the selected Course Level
  2. When Course Level = Null, report the attribute Default Value when exists.
  3. When Course Level = Null, and a valid attribute Default Value does NOT exist, element does not report.

If @Override = 'Yes', then report the Course State Code.

Else, report a blank element.

If @Override = 'Yes', then report the Course Number

Else do not report.

Parent tag

If @Override = 'Yes', then report the following:

1. When (Scheduling > Courses > Course > Course Info > Course Level) = 01, reports 0570.
2. When (Scheduling > Courses > Course > Course Info > Course Level) = 02, reports 0571.
3. When (Scheduling > Courses > Course > Course Info > Course Level) = 03, reports 0572.
4. When (Scheduling > Courses > Course > Course Info>Course Level) = 04 or 05, reports 0576.
5. When (Scheduling > Courses > Course > Course Info > Course Level) = Null, reports the SIF code mapped to the valid (01, 02, 03, 04) attribute Default Value when exists.
6. When Course Level = Null, and a valid attribute Default Value does NOT exist, report a blank element.

1. Report 9999 if any of the following is met:
   1. When Scheduling > Course > Course Editor > Type = 01: Ungraded
   2. Grading Task is not
      final and state reported
      associated with a score group that has at least one score option marked as passing and credit coefficient > 0
   3. When Credit field value in a final, 'State Reported' Grading Task associated with the course = 99
      1. Does NOT sum with other Grading Task credit values in this case.
   4. When a Grading Task marked as final and 'State Reported' has a Credit field value (Scheduling > Courses > Course > Grading Tasks > Grading Task > Credit) of null or 0
2. Else, report calculation of Credit * scorelistitem.Credit Coefficient
   1. Note: calculation uses the highest value Credit Coefficient from all score options on the score group

dbo.ScoreListITem.creditCoefficient

dbo.GradingTaskCredit.credit

If @Override = 'Yes', then report the Course's Course Sequence

Else do not report.

• Report the Course number concatenated with the read-only Section Number

Course/Section > Course > Course Number

Course/Section > Section > Number

dbo.Course.number

dbo.Section.number

Only report this element if Grade Level is filled out on the Course

Report the grade code selected on the course.

Only report this element if SectionInfo is @Override = Yes

1. When College/Virtual Institution is not null
   1. If the length of the value is greater than 4, then report entire value
   2. Else, append CLBR + the value in College/Virtual institution
2. If College/Virtual Institution is null
   1. Report the school's Standard Code

Course/Section > Course > College/Virtual Institution

System Administration > Resources > School > Standard Code

Course.specialCode

school.standardCode

Parent Tag

The grading-related information for a section, repeating for each marking period (TermInfo) in which the section reports Marks.

When a grading task or standard that is marked as Final and State Reported is tied to a section, report one Mark Info List per reportable termId

If a section does not have a grading task or standard that is marked as Final and State Reported tied to it, only report one Mark Info List

When a grading task or standard that is marked as Final and State Reported is tied to a section, report as follows:

• If there is a Term Type Override on the section or course, report only that corresponding termId
  • If the override is on the section, report the section's override termId
  • If the override is only on the course, report the course's override termId
• If the Term Type Override is null on both the course and section, report each termId the section is scheduled into and the grading task is reportable in

When a section does not have a grading task or standard that is marked as Final and State Reported tied to it, report as follows:

• If there is a Term Type Override on the section or course, report the corresponding termId
  • If the override is on the section, report the section's override termId
  • If the override is only on the course, report the course's override termId
• If the Term Type Override is null on both the course and section, report the max termId the section is scheduled in

System Administration > Calendar > Calendar > Terms

Scheduling > Courses > Course > Section > Term Type Override

Term.termID

Trial.structureID CampusDictionary.code

District.districtGUID

sectionPlacement.termId

School.schoolID,

ScoreGroup.scoreGroupID

1. Report "Yes" when the Primary District Assignment checkbox is checked for the District Assignment record (Census > People > District Assignments > Employment Assignment Info).
   1. Otherwise, when Primary is unchecked, report "No".

Note: In HR, the field is called 'Primary'

Census > People > District Assignments > Assignments > Employment Assignment Info

HR

Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Details >  Primary 

1. Report the Start Date of the employment assignment.
   1. Report the start date of the first term for the school if district assignment start date is before the term start date or null

Census > People > District Assignments > Start date

dbo.Employment
Assignment.startDate

dbo.Calendar.startDate

1. Report the end date of the last term  for the school if district assignment end date is after the term end date or null

If more than one assignment exists, populate with the oldest end date from all assignments. If end date is NULL, consider that the oldest end date and reported based on logic in 1

Census > People > District Assignments > End Date

dbo.Employment
Assignment.endDate

dbo.Calendar.endDate

The ratio between the hours expected of a full-time position and the number of actual hours being provided by an individual (i.e., the percent of workday staff are involved in an assignment: 1.00 is a full-time employee; a half-time employee is a .50 FTE, etc.)

FTE must be computed on a term basis.  Compute a part-time employee’s FTE by dividing the time worked by the amount of time required for a full-time position for each term reported in the collection.

1. Report the value of the FTE of Assignment for the staff where the assignment was active at any point during the reporting period.
   1. Report October 1 FTE Override value if this field is populated and the reporting date is 10/01.
   2. Report FTE EOY if this field is populated and the reporting date is in the month of June.

HR

1. Report the value of the Wage Detail Record FTE of Assignment for the staff where the assignment was active at any point during the reporting period.
   1. Be sure to use the Wage Detail Record FTE that is effective as of the State Reported Date or within the reporting period.  If the State Reported Date is not populated, then use the current date.

Note:

1. The value reported cannot exceed 1.00.
2. When the District Employment FTE of Assignment field = Null, assume 0.0 in this field.
3. When multiple District Assignment records exist with the same Standard Code (JobFunction/OtherCodeList/OtherCode) for a staff member within the same school and school year, sum the FTE values of the active assignments. Active assignments are assignments where the end date is null or greater than or equal to the state reporting date.
   1. If all district assignment records are end dated prior to the state reporting date, then sum the FTE values from all assignments that were active at any point during the reporting period.

Census > People > District Assignment > FTE 

Census > People > District Assignment > October 1 FTE Override

Census > People > District Assignment > EOY FTE Override

HR

Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Details >  Wage Detail Records > FTE

dbo.Employment
Assignment.fte

Parent Tag

A description of the specific group of duties and responsibilities of a position.

1. If Employment Assignment Info > Title contains the string "Principal" (case sensitive), report 2410
2. If the "Teacher" checkbox = Checked, report 1000
3. If the "Health" checkbox = Checked, report 2130
4. Else, report 9999

Note:

For HR, use the Roles multi-select box in Roles & Qualifications to determine if 'Teacher' or 'Health' should report

Census > People > District Assignments > Assignments > Employment Assignment Info > Title

Census > People > District Assignments > Assignments > Employment Assignment Info > Teacher

Census > People > District Assignments > Assignments > Employment Assignment Info > Health

HR

Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Details > Title

Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Details > Roles & Qualifications > Roles

dbo.Employment
Assignment.title

dbo.Employment
Assignment.teacher

dbo.Employment
Assignment.health

Report 4-digit Standard Code of the Assignment Title. 

Course > Section > Primary Teacher > District Assignment or Census > People > District Assignment > Employment Assignment Information > Title

dbo.CampusAttribute WHERE object= 'EmploymentAssignment' AND element = 'title'

Parent Tag

The specific educational support activity in which teachers, paraprofessionals, and other instructional staff are involved and employed on a daily basis. This data element is not applicable for all staff.

N/A

1. Report the 3 digit assignment code for job titles 4100 and 2310
2. Else report 000.

Census > People > District Assignment > Employment Assignment Information > Assignment Code

HR

Human Resources > Personnel > Personnel Master > Work Assignments > Work Assignment Editor > Work Assignment Detail > Work Assignment Code

dbo.CampusAttribute WHERE object= 'EmploymentAssignment' AND element = 'title'

dbo.Enrollment
Assignment.assignmentCode

1. Report the value selected for "Beginning Educator".
2. If null, report 00.

Census > People > District Assignment > Beginning Educator

HR

Human Resources > Personnel > Personnel Master > Work Assignments > Beginning Educator

dbo.CampusAttribute WHERE object=' EmploymentAssignment' AND element = 'beginningEducator'

Cumulative number of days a staff member has been present (defined as at least half the school day) in the district.

1. If assignment is marked as 'Primary Assignment', report the value entered in "Staff Actual Attendance" 
   1. When Actual Attendance is null or 0 and a valid attribute default value exists in Default Value field on the attribute, report the value entered in Default Value
   2. If null or 0, report 999.
2. Else, report 0

Census > People > District Assignment > Beginning Educator

System Administration > Custom > Attribute/Dictionary > Employment > Staff Actual Attendance > Campus Attribute Detail > Default Value

HR

Human Resources > Personnel > Personnel Master > HR General Information > Employment Dates > Actual Attendance

dbo.CampusAttribute WHERE object=' EmploymentAssignment' AND element = 'staffActualAttendance'

Cumulative number of days a staff member was expected to be present (defined as at least half the school day) in the district.   

1. If assignment is marked as 'Primary Assignment', report the value entered in "Staff Expected Attendance" 
   1. When Expected Attendance is null or 0 and a valid attribute default value exists in Default Value field on the attribute, report the value entered in Default Value
   2. If null or 0, report 999.
2. Else, report 0

Census > People > District Employment> Staff Expected Attendance

System Admin > Custom > Attribute/Dictionary >   Employment > Staff Expected Attendance  > Campus Attribute Detail > Default Value

HR

Human Resources > Personnel > Personnel Master > HR General Information> Employment Dates >  Expected Attendance

dbo.CampusAttribute WHERE object=' EmploymentAssignment' AND element = 'staffExpectedAttendance'

HR

1. If there is more than one work location on the assignment, report from the primary location
   1. If the primary location is marked as 'SIF Exclude', report from the work location with the highest id

Census > People > Staff Eval > Evaluation Date

dbo.StaffEval.evaluationDate

Hardcoded to be "MA ESE Educator Evaluation"

Parent Tag

The set of the Evaluation Parts.

N/A

• Report the code selected for "SR30 Standard 1 Eval".
• If blank or null, report 99

Census > People > Staff Eval >SR30 Standard 1 Eval

dbo.StaffEval.evaluationPart1Score

• Report the code selected for "SR31 Standard 2 Eval".
• If blank or null, report 99

Census > People > Staff Eval > SR31 Standard 2 Eval

dbo.StaffEval.evaluationPart2Score

Report the code selected for "SR32 Standard 3 Eval".

If blank or null, report 99

Census > People > Staff Eval > SR32 Standard 3 Eval

dbo.StaffEval.
evaluationPart3Score

• Report the code selected for "SR33 Standard 4 Eval".
• If blank or null, report 99

Census > People > Staff Eval

dbo.StaffEval.evaluationPart4Score

• Report the code selected for "SR29 Overall Eval Score".
• If blank or null, report 99

Census > People > Staff Eval > SR29 Overall Eval Score

dbo.StaffEval.holisticScore

Census > People > Demographics > Local Staff Number

HR

Personnel Master > HR General Information > Personnel Number

Person.staffNumber

Non-HR

Census > People > Demogarphics > Staff State ID

HR

Personnel Master > HR General Information > State Number

Person.staffStateID

Teacher's License Number

1. If License Number is not null, report value
2. Else, do not report element

HR

1. When there is a Qualification of type License and the start date is before or equal to the state reporting date and the expiration date is null or the expiration date is after or equal to the state reporting date, report the Number
   1. If the state reporting date is blank, use the current date
   2. When multiple active licenses exist for the same Employment record as of the state reporting date, then report the License that contains the latest Start Date. If there is more than one with the same start date, report the License with the largest record id
2. Else, do not report element

Census > People > District Employment > Employment Records > Employment Info > License Number

HR

Human Resources > Personnel > Personnel Master > Qualifications > Qualifications Details > Number

Employment.licenseNumber

Hard coded '04'

Census > People > Demographics > Last Name

HR

Personnel Master > HR General Information > Last Name

Identity.lastName

Census > People > Demographics > First Name

HR

Personnel Master > HR General Information > First Name

Identity.firstName

1. When null, report "NMN"
2. Else, report middle name of staff member

Census > People > Demographics > Middle Name

HR

Personnel Master > HR General Information > Middle Name

Identity.middleName

Demographics

The general racial category which reflects the individual's recognition of his or her community or with which the individual most identifies.

Based on SIF standard

• If AmericanIndianAlaskaNative checked, report 0998
• If BlackAfricanAmerican checked, report 1000
• If White checked, report 1002
• If Asian checekd, report 0999
• If NativeHawaiianPacificIslander checked, report 1001
  • Else 1002
• If multiple boxes are checked, send multiple code tags (Example: AmericanIdianAlaskaNative and BlackAfricanAmerican are both checked, send <Code>0998<\Code>
  <Code>1000<\Code>)

Census > People > Demographics > Race/Ethnicity

HR

Personnel Master > HR General Information > Race/Ethnicity

SIFRaceEthnicity.code

dbo.IdentityRaceEthnicity

Indication of the Staff's Federal Race/Ethnicity

Expand below for more information

Census > People > Demographics >Race/Ethnicity > Is the individual from one or more of these races?
(check all that apply)

HR

Personnel Master > HR General Information > Is the individual from one or more of these races?
(check all that apply)

dbo.RaceEthnicity

dbo.Identityt.raceEthnicity

An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central or South America, or other Spanish cultures, regardless of race.

• If Yes, report "Yes"
• Else report "No"

Census > People > Demographics > Race/Ethnicity > "Is the individual Hispanic/Latino?"

HR

Personnel Master > HR General Information >

"Is the individual Hispanic/Latino?"

dbo.Identity.hispanicEthnicity

Staff person's date of birth

If Birthdate is null, then 0

Census > People > Demographics > Birthdate

HR

Personnel Master > HR General Information > Birth Date

Identity.birthDate

Indicates Degree Type, Degree Institution and Degree subject of the staff person.

1. Report the concatenated values selected in the Degree Type, Degree Institution, and Degree Subject fields separated by a colon in the format of Type:Institution:Subject. If any one of the fields are Null, then do not report any of the fields,
   1. Type: 3-digit value selected for Degree Type 1, Degree Type 2, and Degree Type 3
      1. If 00, report 00
      2. Else, report 3-digit value
   2. Institution: 4-digit value selected for Degree Institution 1, Degree Institution 2, and Degree Institution 3
      1. If 00, report 00
      2. Else, report 4-digit value
   3. Subject: 2-digit value selected for Degree Subject 1, Degree Subject 2, and Degree Subject 3.
      1. If 00, report 00
      2. Else, report 2-digit value
   4. Example: 003:3786:33

HR

1. Report the concatenated values selected in the Degree Type, Education Institution and Degree Subject Major fields of the 3 most recent Qualifications of type 'Education' where the the Date Received is before or equal to the state reporting date separated by a colon in the format of Type:Institution:Subject. If any one of the fields are Null, then do not report any of the fields,
   1. Type: 3-digit value selected for Degree Type 1, Degree Type 2, and Degree Type 3
      1. If 00, report 00
      2. Else, report 3-digit value
   2. Institution: 4-digit value selected for Degree Institution 1, Degree Institution 2, and Degree Institution 3
      1. If 00, report 00
      2. Else, report 4-digit value
   3. Subject: 2-digit value selected for Degree Subject 1, Degree Subject 2, and Degree Subject 3.
      1. If 00, report 00
      2. Else, report 2-digit value
   4. Example: 003:3786:33

Note:

1. If there are multiple degree types/institutions/subjects, this must be reported in 1 element separated by a ~ as follows:
   1. Example: 003:3786:33~001:7777:41

Census > People > District Employment > Employment Info

HR

Personnel Master > Qualifications > Education

dbo.CustomEmployment

[object] = 'Employment#' AND element = 'degreeInstitution#'

[object] = 'Employment#' AND element = 'degreeSubject#'

[object] = 'Employment#' AND element = 'degreeType#'

N/A

1. Report Start Date under Staff History
   • If it is null, report start date of the Calendar instead.
     • If both dates come before the Term Start Date, then report the Term Start Date

Scheduling > Courses > Course > Section > Staff History > Staff History Detail > Start Date

System Administration > Calendar > Calendar > Start Date

System Administration > Calendar > Calendar > Terms > Start Date

SectionStaffHistory.startDate

Calendar.startDate

Term.startDate

1. Report End Date under Staff History.
   1. If it is null, then report end date of the Calendar instead.
      1. If both dates come after the Term End Date, then report the Term End Date

Scheduling > Courses > Course > Section > Staff History > Staff History Detail > End Date

System Administration > Calendar > Calendar > End Date

System Administration > Calendar > Calendar > Terms > End Date

SectionStaffHistory.endDate

Calendar.startDate

Term.startDate

1. When District Assignment has a value with Standard Code of 2305 or 2307 or a Code of 2325-05, report "LeadTeacher".
2. When District Assignment has a value with Standard Code of 2306 or 2308 or a Code of 2325-06, report "TeamTeacher".
3. When District Assignment has a value with Standard Code of 2310 or a Code of 2325-10, report "ContributingProfessional".'
4. When District Assignment has a value with Standard Code 4100, report "Paraprofessional"
5. If Standard Code is not one of the values listed above, report blank

Note:

Look at district assignment that is tied to the Staff History record on the Section

Course > Section > Staff History > District Assignment > Title

EmploymentAssignment.title

• Report the 3-digit Assignment Code for the staff when Title has a Standard Code = 2305, 2306, 2307, 2308, 2325, 2330, 2310, or 4100.
  • Pull the default value from the EmployementAssignment. assignmentCode dictionary if no assignment code exists.
• Else, report 000

Course > Section > Staff History > District Assignment > Assignment Code

EmployementAssignment.
assignmentCode

1. When (District Assignments > Employment Assignment Information > Title) = 2325 (standard code), report "Yes".
2. Otherwise, "No"

Course > Section > Staff History > District Assignment > Title

EmploymentAssignment.
assignmentCode

The Id (GUID) that uniquely identifies the SchoolInfo object that this item refers to.

Can be used to find SchoolInfo/StateProvinceId via SchoolInfo

Student Information > General > Enrollment > Start Date

System Administration > Calendar > Calendar > Days > Instruction

Enrollment.startDate

Day.instruction

Day.date

Does not report

Student Information > General > Enrollment > End Date

System Administration > Calendar > Calendar > Days > Instruction

Enrollment.endDate

Day.instruction

Day.date

Does not report

Does not report

DaysAttended

Report the total number of Days Attended as defined by the school's.

1. If there is a filter date on the request from the state
   1. Report the number of instructional days the student was enrolled, attending in person and present as of the Filter Date. 
2. Else, report the number of instructional days the student was enrolled, attending in person and present as of the Current Date. 

Attended Days Calculation:

1. Sum the number of instructional, in person days a student is enrolled and subtract the number of days a student is in person and either has an excused or unexcused absence.
   1. See the Excused Absences and Unexcused Absences fields to see the absent calculations.

1. If there is more than one enrollment, calculate each enrollment absent count, then sum across the enrollments.
2. If 'Exclude No Show Enrollments' is NOT checked on SIF Zone Options and "No Show" is checked on the enrollment,  report 0
   1. If there is more than one enrollment in the same school for the same school year and the most recent enrollment is a 'No Show' enrollment, use the No Show enrollment for reporting.
      1. The most recent enrollment is determined by the latest start date. If more than one enrollment has the same latest start date, then use the enrollment with the highest enrollment id.
3. In Person is defined as a student who does not have a Blended Learning Group assigned to them or is in a Blended Learning Group that is not assigned to a Day Event on the Calendar or there is NOT a Virtual Day Override Event on the calendar.

Student Information > General > Enrollment > Start Date

Student Information > General > Enrollment > End Date

System Administration > Calendar > Calendar Days > Instruction

Student Information > General > Attendance

System Administration > Attendance > Attendance Codes > Status = Absent > Excuse = Anything BUT Exempt

dbo.Enrollment.noShow

dbo.Enrollment.startDate

dbo.Enrollment.endDate

dbo.AttendanceCode.status

dbo.AttendanceCode.excuse

dbo.AttendanceCode.date

dbo.Day.date

dbo.Day.instruction

ExcusedAbsences

Send the number of excused absences a student has had so far in this calendar.

1. If there is a filter date on the request from the state
   1. Report the number of in person, instructional days the student was enrolled and has an excused absence as of the Filter Date.
2. Else, report the number of in person, instructional days the student was enrolled and has an excused absence as of the Current Date

Absent Calculation:

1. For a given in person, instructional day, sum the period minutes from each period a student is marked with an absent attendance code of Excused
   1. Total minutes for a given period should not include lunch time, periods marked as 'Non-Instructional', or any present minutes entered for a student
   2. Calculated excused absent minutes should be > the half day absence calculation for a student to be considered absent.

Half Day Absence Calculation:

1. If both System Admin > Calendar > Grade Level > Half Day Absence and System Admin > Calendar > Calendar Info > Half Day Absence are populated, use Grade Level -> Half Day Absence 

2. If only one of System Admin > Calendar > Grade Level > Half Day Absence or System Admin > Calendar > Calendar Info > Half Day Absence is populated, use the populated value

3. Else, add up instructional minutes and divide by 2

Note:

1. If there is more than one enrollment, calculate each enrollment absent count, then sum across the enrollments.
2. An excused absence is a day where a student has an attendance code with the Status of 'Absent' and the excuse of 'Excused'.
3. If 'Exclude No Show Enrollments' is NOT checked on SIF Zone Options and "No Show" is checked on the enrollment,  report 0
   1. If there is more than one enrollment in the same school for the same school year and the most recent enrollment is a 'No Show' enrollment, use the No Show enrollment for reporting.
      1. The most recent enrollment is determined by the latest start date. If more than one enrollment has the same latest start date, then use the enrollment with the highest enrollment id.
4. In Person is defined as a student who does not have a Blended Learning Group assigned to them or is in a Blended Learning Group that is not assigned to a Day Event on the Calendar or there is NOT a Virtual Day Override Event on the calendar.

System Administration > Calendar > Calendar Days > Instruction

Student Information > General > Attendance

System Administration > Attendance > Attendance Codes > Status = Absent > Excuse = Excused

System Administration > Calendar > Calendar > Student Day (minutes)

System Administration > Calendar > Calendar > Period Schedule > Total Minutes

dbo.AttendanceCode.status

dbo.AttendanceCode.excuse

dbo.AttendanceCode.date

dbo.Day.date

dbo.Day.instruction

dbo.Period.periodCount

dbo.Period.periodMinutes

dbo.AttendanceCode.
presentMinutes

dbo.Calendar.studentDay

UnexcusedAbsences

Send 3 characters for the number of unexcused absences a student has had so far in this calendar. EG, 012, or 003. (This is pulled from the core calculation).

1. If there is a filter date on the request from the state
   1. Report the number of instructional days the student was enrolled and has an unexcused absence as of the Filter Date.
2. Else, report the number of instructional days the student was enrolled and has an unexcused absence as of the Current Date

Absent Calculation:

1. For a given instructional day, sum the period minutes from each period a student is marked with an absent attendance code of Unexcused
   1. Total minutes for a given period should not include lunch time, periods marked as 'Non-Instructional', or any present minutes entered for a student
   2. Calculated unexcused absent minutes should be > the half day absence calculation for a student to be considered absent.

Half Day Absence Calculation:

1. If both System Admin>Calendar>Grade Level> Half Day Absence and System Admin>Calendar>Calendar Info> Half Day Absence are populated, use Grade Level -> Half Day Absence 

2. If only one of System Admin>Calendar>Grade Level> Half Day Absence or System Admin>Calendar>Calendar Info> Half Day Absence is populated, use the populated value

3. Else, add up instructional minutes and divide by 2

Note:

1. If there is more than one enrollment, calculate each enrollment absent count, then sum across the enrollments.
2. An unexcused absence is a day where a student has an attendance code with the Status of 'Absent' and the excuse of 'Unexcused'.
3. If 'Exclude No Show Enrollments' is NOT checked on SIF Zone Options and "No Show" is checked on the enrollment,  report 0
   1. If there is more than one enrollment in the same school for the same school year and the most recent enrollment is a 'No Show' enrollment, use the No Show enrollment for reporting.
      1. The most recent enrollment is determined by the latest start date. If more than one enrollment has the same latest start date, then use the enrollment with the highest enrollment id.

Student Information > General > Enrollments > State Reporting Fields >Truancy Days

Student Information > General > Attendance

System Administration > Attendance > Attendance Codes > Status = Absent > Excuse = Unexcused

dbo.EnrollmentMA.studentTruancy

dbo.v_AttDayDetail_Federal

dbo.Enrollment.personID

1. If there is a filter date on the request from the state
   1. Report the number of instructional days based on the student's Enrollment Start dates and End Dates as of the Filter Date
2. Else, report the number of instructional days based on the student's Enrollment Start dates and End Dates as of the Current Date

Note:

1. If 'Exclude No Show Enrollments' is NOT checked on SIF Zone Options and "No Show" is checked on the enrollment,  report 1
   1. If there is more than one enrollment in the same school for the same school year and the most recent enrollment is a 'No Show' enrollment, use the No Show enrollment for reporting.
      1. The most recent enrollment is determined by the latest start date. If more than one enrollment has the same latest start date, then use the enrollment with the highest enrollment id.

Student Information > General > Enrollment > Start Date

Student Information > General > Enrollment > End Date

System Administration > Calendar > Calendar > Days > Instruction

dbo.Enrollment.startDate

dbo.Enrollment.endDate

dbo.Day.date

dbo.Day.instruction

dbo.Enrollment.noShow

• If the calculated date is before enrollment start date, report "Future"
• If the calculated date is after the enrollment end date, report "Historical"
• Else "Current"

Student Information > General > Enrollment > Start Date

Student Information > General > Enrollment > End Date

dbo.Enrollment.startDate

dbo.Enrollment.endDate

Student Information > General > Calendar

System Administration > Calendar > Calendar

System Administration > Calendar > School Years

dbo.Enrollment.endYear

See MA SIF Guide for a discussion of how this is used.

Report enrollment start date

1. Report State Grade Level Code associated with grade level on the enrollment (required on UI)
   1. If the Standard Code (SIF code) is populated on the Grade Level, report that value
   2. Else, report the State Grade Level Code
2. If the Grade Level is not populated on the enrollment, report 'UN'

System Administration > Calendar > Calenadr > Grade Level > State Grade Level Code

Student Information > General > Enrollment > Grade Level

dbo.GradeLevel.standardCode
dbo.Enrollment.grade

Parent Tag

Required for exited students.  See MA SIF Guide for a discussion of how this is used.

Calculate date to use:

1. If current date is before the last instructional day on the calendar, then use current date
2. Else, use the last instructional day on the calendar

Logic:

1. If State Enrollment End Status has a value of 4099 or 40, report the last 4 digits of the standard code (9999) 
   1. End Date can be Null or contain a value but Enrollment Status must still report the last 4 digits of the standard code value.
2. If Enrollment End Date is equal to or after the Calculated Date and the State Enrollment End Status has a valid value of 4199 or 41, then report the last 4 digits of the standard code for 4099 or 40 (9999).
3. Report the last 4 digits of the State Enrollment End Status Standard Code Value if State Enrollment End Status has a valid value of 1921, 1925, 1923, 1926, 1928, 1922, 1931, 04, 05, 06, 09, 10, 11, or 36 AND Calculated Date is = to enrollment End Date.
4. Report the last 4 digits of the State Enrollment End Status Standard Code Value if State Enrollment End Status has a valid value AND Calculated Date is after Enrollment End Date
5. Otherwise report 9999.

System Administration > Custom > Attribute/Dictionary > Enrollment > State Enrollment Status

System Administration > Enrollment > End Status Type > State End Status Code (Mapping)

Student Information > General > Enrollment > Local Enrollment Status

Student Information > General > Enrollment > End Date

Student Information > General > Enrollment > Local Enrollment Status

dbo.CampusAttribute WHERE object='Enrollment' and element='startStatus'

 
dbo.Enrollment.endStatus

dbo.Enrollment.endDate

dbo.SIFPreference.stateReportingDate

1. If current date is before the last instructional day on the calendar, then use current date
2. Else, use the last instructional day on the calendar

Logic:

1. If State Enrollment End Status has a value of 4099 or 40 "Not Enrolled: Receiving SPED Services only", report the first 2 digits of the standard code value (40).
   • End Date can be Null or contain a value but State Enrollment End Status must still report the first 2 digits of the standard code value (40).
2. If End Date is equal to or after the Calculated Date and the State Enrollment End Status has a valid value of 4199 or 41: transfer, then report the first 2 digits of the standard code value for 4099 (40).
3. Report the first 2 digits of the State Enrollment End Status standard code if State Enrollment End Status has a valid value of 1921, 1925, 1923, 1926, 1928, 1922, 1931, 04, 05, 06, 09, 10, 11, or 36 AND Calculated Date is = to enrollment End Date.
4. Report the first 2 digits of the State Enrollment End Status standard code if State Enrollment End Status has a valid value AND Calculated Date is after Enrollment End Date.
5. Otherwise report 01.

System Administration > Custom > Attribute/Dictionary > Enrollment > State Enrollment Status

System Administration > Enrollment > End Status Type > State End Status Code (Mapping)

Student Information > General > Enrollment > Local Enrollment Status

Student Information > General > Enrollment > End Date

Student Information > General > Enrollment > State Enrollment Status

Calculated

dbo.Enrollment

1. When Reporting Reason = 02, report '1655'
2. When Reporting Reason = 03, report '1654'
3. else report '1652'

Student Information > General > Enrollment > State Reporting Fields > Reporting Reason

System Administration > Custom > Attribute/Dictionary > Enrollment > Reporting Reason

dbo.Enrollment.stateAid

1. When Reporting Reason = 02, report '02'
2. When Reporting Reason = 03, report '03'
3. else report '01'

Student Information > General > Enrollment > State Reporting Fields > Reporting Reason

System Administration > Custom > Attribute/Dictionary > Enrollment > Reporting Reason

dbo.Enrollment.stateAid

• When  Attending School ID Number NOT = Null, report the code selected 
• Else, do not report element

Student Information > General > Enrollments > State Reporting Fields > Attending School ID Number

dbo.EnrollmentMA

SIMS DOE013

1. Report Enrollment Start Status
2. IF null, report from Default Value on the Enrollment Start Status Dictionary
3. else report null

Student Information > General > Enrollment >Start Status

System Administration > Enrollment > Start Status Type

dbo.Enrollment

Calculate date to use:

1. If current date is before the last instructional day on the calendar, then use current date
2. Else, use the last instructional day on the calendar

Logic:

1. When Enrollment End Status= 4099 or 40, report Yes. 
2. If enrollment End Date is equal to or after the calculated date and the Enrollment Status has a valid value of 4199 or 41, then report Yes.
3. Otherwise, report No.

Student Information > Genearl > Enrollment > End Status

System Administration > Enrollment > End Status Type

Student Information > General > End Date

dbo.Enrollment

Calculated

1. Report Active School History record based off of State Reporting Date
2. When Title 1 = Targeted Assistance Eligible - No Program, Schoolwide Eligible - No Program, Schoolwide Program or Not a Title 1 School, Repot '00'
3. When Title 1 is null OR = Targeted Assistance Program or Schoolwide Eligible - Targeted Assistance, Report value selected from Title 1 Non Instructional on a student's enrollment.
4. If Title 1 Non Instructional on student's enrollment is null, pull default value from Non Instructional Title 1 Dictionary
5. Else, report '00'

System Administration > Resources > School > School History > Title 1

Student Information > General > Enrollment > State Reporting Fields > Non-Instructional Title 1

dbo.schoolAttribute

dbo.Enrollment

1. Report Active School History record based off of State Reporting Date
2. When Title 1 = Targeted Assistance Eligible - No Program, Schoolwide Eligible - No Program or Not a Title 1 School, Report '00'
3. When Title 1 = Schoolwide Program, Report 01
4. When Title 1 is null OR = Targeted Assistance Program or Schoolwide Eligible - Targeted Assistance, Report value selected from Title 1 Participation on a student's enrollment.
5. If Title 1 Participation on student's enrollment is null, pull default value from Title 1 Participation Dictionary
6. Else, report '00'

System Administration > Resources > School > School History or > Title 1

Student Information > General > Enrollment > State Reporting Fields >  Title 1 Participation

dbo.schoolAttribute

dbo.Enrollment

When student has an EL record where the Identified date is on or before the current date and the Program Exit date is null or the Program Exit Date is on or after the current date, use following logic

1. When Student has an EL Services record, complete the following logic:
   1. If Parent Refused services is checked and Date Refused is before or equal to the current date, report 04
   2. Else, report EL Service Type code (01, 02, 03 or 05)
2. Else, reports 00.

Note:

1. If multiple service records meet the above requirement, reports the most recent state service where the start date is before or equal to the current date
2. If multiple services have the same start date that is before or equal to the current date, reports the Service with the latest End Date.
3. When > 1 service exists with the same latest Start Date that is before or equal to the current date and End Date, report the service with the highest Code (Example: when 01 and 02 service exist, reports 02).

Student Information > Program Participation > EL

Student Information > Program Participation > EL > EL Services > El Service Type

Student Information > Program Participation > EL > EL Services > Parent Refused Services

Student Information > Program Participation > EL > EL Services > Date Refused

dbo.Lep
dbo.LepServices
dbo.LepServiceType

Report whatever value selected on ALternative Education School Choice

Else, report '00000000'.

• Report Program Type under  Career Vocational Technical Education
• If null, report default value of the Enrollment Vocational Code dictionary
• Else, report 00

Student Information > General > Enrollments > State Reporting Fields > Career Vocational Technical Education > Program Type

System Administration > Custom > Attribute / Dictionary > Enrollment > Program Type

dbo.EnrollmentMA

Student Information > General > Enrollments > State Reporting Fields > Career Vocational Technical Education > Program Type

System Administration > Custom > Attribute / Dictionary > Enrollment >Chap 74 Approved Program

dbo.EnrollmentMA

Student Information > General > Enrollments > State Reporting Fields > Career Vocational Technical Education > Program Type

System Administration > Custom > Attribute / Dictionary > Enrollment >Non Chap 74 Approved Program

dbo.EnrollmentMA

1. If Local Enrollment Status is 1921
   1. Report value selected in Seal of Biliteracy.
      1. If multiple records exist, report the most recent based on date earned
      2. If multiple records exist with the same date, report based on the largest record id
   2. If no value entered, report Default value set in Graduation State Seal dictionary
   3. If null, report 00.
2. Else, report 00

Student Information > General > Graduation > State Seal Information

System Administration > Custom > Attribute / Dictionary > GraduationSeal

Student Information > General > Enrollment> Local Enrollment Status

Student Information > General > Graduation > Date Earned

dbo.GraduationSeal

• Report the value selected for HQCP Program Type.
• If null, report off default value
• If null, report 500

Student Information > General > Enrollments > State Reporting Fields > Career Vocational Technical Education > HQCP Program Type

System Administration > Custom > Attribute / Dictionary > Enrollment > HQCP Program Type

dbo.EnrollmentMA

• Report the value selected for HQCP Program Participation.
• If null, report off default value
• If null, report 500

dbo.EnrollmentMA

Date from when this course section enrollment is valid.

• If the Enrollment Start Date is after or equal to the Roster Start Date, send the Enrollment Start Date,
• Else send Roster Start Date
• If Roster Start Date is null, replace it with the Term Start Date

Student Information > General > Enrollment > Start Date

Student Information > General > Schedule > Start Date

Course > Section > Roster Batch Edit > Start Date

System Administration > Calendar > Calendar < Terms > Start Date

dbo.Term.startDate
dbo.Roster.startDate
dbo.Enrollment.startDate

The last school calendar day (membership day) the student was enrolled in the course section (inclusive).

• If the Enrollment End Date is before or equal to the Roster End Date, send the Enrollment End Date,
• Else send Roster End Date
• If Roster End Date is null, replace it with the Term End Date

Student Information > General > Enrollment > End Date

Student Information > General > Schedule > End Date

Course > Section > Roster Batch Edit > End Date

System Administration > Calendar > Calendar < Terms > End Date

dbo.Term.endDate

dbo.Roster.endDate

dbo.Enrollment.endDate

1. If Roster End Date is null or Roster End Date is <= the state reporting date and Roster Enrollment Status is not null, report Roster Enrollment Status
2. Else:
   1. If Local Enrollment Status is 1921 or 1928 OR grade level is 'KP', 'KT', or 'KF' and Roster End Date = NOT Null and Roster End Date = the calendar day in the enrollment calendar with a Day Event = SD and course term end date is < = the state reporting date, report 03
   2. When student has a (latest) score mapped to 50  in a Grading Task or Standard with both State Reported and Final Checked, report 05.
   3. When student has a (latest) score mapped to 40  in a Grading Task or Standard with both State Reported and Final Checked,  report 04.
   4. When any of the following conditions are met, report 02:
      1. Roster End Date = NOT Null and before course/section Term End Date AND Roster End Date is before State Reporting Date 
      2. When student has a (latest) score mapped to 21,22 or 23  in a Grading Task or Standard with both State Reported and Final Checked
   5. When any of the following conditions are met, report 03:
      1. When the course term end date is <= the state reporting date and the roster end date is null, equal to or after the term end date
      2. When student has a (latest) score that is not mapped to 21,22, 23, 40 or 50  in a Grading Task or Standard with both State Reported and Final Checked and Roster End Date is null or is <= the state reporting date
   6. When State Reporting Date >= the course term Start Date and < course term End Date, report 01.
   7. Else, report 02

Course > Section > Roster Batch Edit > Course Enrollment Status

Student Information > General > Enrollment

Grading & Standards>Score Groups & Rubrics>Score Group List Items Detail>State Score

Roster.status

Roster.startDate

Roster.endDate

Enrollment.startDate

Enrollment.EndDate

Term.startDate,

Term.endDate

System Administration > Data Interchange > Zones > SIF Zone Options > Reporting Zone > State Reporting Date

1. If Special Ed Setting is not equal to "05", then report the Primary Disability standard code
   1. If Primary Disability is null, report '500'
2. If Special Ed Setting is "05", do not report element

Student Information > Special Ed > General > State Reporting > Primary Disability

Student Information > Special Ed > General > State Reporting > Special Ed Setting

For IEP:

Student Information > Special Ed > General > Documents > IEP > Enrollment Status > Primary Disability

Student Information > Special Ed > General > Documents > IEP > Enrollment Status > Special Ed Setting

Parent Tag

Collects elements of interest for each StudentParticipation.

Special Ed Setting

Not required if DOE040 is 02, 08 or 09

Report Special Ed Setting code, if populated.

• Otherwise, report 00.

Student Information > Special Ed > General > State Reporting > Special Ed Setting

For IEP: Student Information > Special Ed > General > Documents > IEP > Enrollment Status > Special Ed Setting

Enrollment.specialEdSetting

1. Report the standard code associated with the value selected for Eval Results.
2. If Eval Results = null, report 9999.

Student Information > Special Ed > General > State Reporting > Eval Results 

For IEP: Student Information > Special Ed > General > Documents > IEP > Enrollment Status > Eval Results

Enrollment.specialEdSetting

1. Report the 2-digit code selected for Eval Results. The code must be 2 digits.
2. Else, report 00.

Student Information > Special Ed > General > State Reporting > Eval Results Sys Admin > Custom > Attribute/Dictionary > Enrollment > Eval Results 

For IEP: Student Information > Special Ed > General > Documents > IEP > Enrollment Status > Eval Results

EnrollmentMA.
specialEdEvalResults

1. Report the Sped Eval Date.
2. If reporting from an IEP, report null

Student Information > Special Ed > General > State Reporting > Sped Eval Date

• Report Special Ed Level Of Need, if populated.
  1. Otherwise report 500.

For IEP:

Student Information > Special Ed > General > Documents > IEP > Enrollment Status > Special Ed Level of Need

specialEdStatus