tennessee state reporting guide - welcome to synergy! · tennessee state reporting guide ......

Edition 01, Revision 04 May 2016 Copyright 2015 Edupoint Educational Systems, LLC Document Number: SISTNAG-010101

Synergy SIS® Tennessee State Reporting Guide

Edupoint Educational Systems, LLC 1955 South Val Vista Road, Suite 200

Mesa, AZ 85204 Phone (877) 899-9111

Fax (800) 338-76

Tennessee State Reporting Guide

2 Copyright 2015, Edupoint Educational Systems, LLC

This edition applies to Synergy SIS® software and all subsequent releases and modifications until indicated with new editions or revisions.

The Edupoint Synergy Student Information System (SIS) software and any form of supporting documentation are proprietary and confidential. Unauthorized reproduction or distribution of the software and any form of supporting documentation is strictly prohibited and may result in severe civil and criminal penalties.

Information in this document is provided in connection with Edupoint Educational Systems products. No license to any intellectual property rights is granted by this document.

The screens, procedural steps, and sample reports in this manual may be slightly different from the actual software due to modifications in the software based on state requirements and/or school district customization.

The data in this document may include the names of individuals, schools, school districts, companies, brands, and products. Any similarities to actual names and data are entirely coincidental.

Synergy and Edupoint are registered trademarks of Edupoint Educational Systems, LLC.

* Other names and brands may be claimed as the property of others.

Copyright 2015, Edupoint Educational Systems, LLC. All rights reserved.


Edupoint Proprietary and Confidential 3

TABLE OF CONTENTS Chapter One Data Setup and Administration ...................................... 13

Setup Introduction ....................................................................................................................................... 14

Getting Started ............................................................................................................................................ 14

Lookup Tables ............................................................................................................................................. 15

Lookup Tables for Tennessee State Reporting .................................................................................... 15

Lookup Table Definition Screen ........................................................................................................... 20

Add a Value to a Lookup Table ............................................................................................................ 21

Assign a State Reporting Code to an Existing Lookup Table Value .................................................... 21

Deactivate a Lookup Table Value......................................................................................................... 21

Sort Lookup Values .............................................................................................................................. 22

Product Owned Lookup Tables ............................................................................................................ 22

Organization ......................................................................................................................................... 23

District Number ..................................................................................................................................... 23

School Number ..................................................................................................................................... 23

Verify District and School Numbers for State Reporting ...................................................................... 24

Exclude a School from State Reporting ............................................................................................... 24

TN District Calendar, Events, and Requirements ................................................................................. 25

District State Requirements Screen ..................................................................................................... 25

Add District Calendar Details ................................................................................................................ 27

Add a District Wide Event ..................................................................................................................... 27

Define Standard Day Minutes by Grade Level ..................................................................................... 29

Specify Email Address for Critical Extract Error Notifications .............................................................. 29

TN School Calendar Data, Events, and Requirements .............................................................................. 29



School State Requirements Screen ..................................................................................................... 29

Add School Calendar Details ................................................................................................................ 30

Add a School-Specific Event ................................................................................................................ 30

Reporting Periods, School Calendars, and Events ..................................................................................... 31

School Calendars and Reporting Periods ............................................................................................ 31

Events and School Calendars .............................................................................................................. 33

Attendance .................................................................................................................................................. 33

Define Attendance Codes ..................................................................................................................... 34

Include an Attendance Code in State Reporting .................................................................................. 35

Discipline ..................................................................................................................................................... 35

Offenses and Disciplinary Actions ........................................................................................................ 35

Include an Offense Code (Violation) in State Reporting....................................................................... 38

Include a Disciplinary Action Code (Disposition) in State Reporting .................................................... 39

Primary Offense (Violation) by Severity................................................................................................ 41

Courses and Sections ................................................................................................................................. 41

District Course Screen .......................................................................................................................... 42

Section Screen ..................................................................................................................................... 44

Override Instructional Minutes for a Section ........................................................................................ 45

Exclude a District Course from State Reporting ................................................................................... 45

Exclude a School Course (Section) from State Reporting ................................................................... 46

CTE Courses ........................................................................................................................................ 47

Student Classifications ................................................................................................................................ 47

Define a Student Classification ............................................................................................................. 47

Supplemental Education Services (SES) .................................................................................................... 48

Define Supplemental Education Services Codes ................................................................................. 48



TA Support Services ................................................................................................................................... 49

Define TA Support Services Codes ...................................................................................................... 49

TA Instructional Services ............................................................................................................................ 49

Assign TA Instructional Services Code to District Course.................................................................... 50

Student Programs ....................................................................................................................................... 50

Needs/Programs Definition Screen ...................................................................................................... 51

Define a Student Need/Program .......................................................................................................... 52

Specify Grade Level Participation for School Based Needs/Programs................................................ 53

Specify an Exit Method for Needs/Programs ....................................................................................... 54

Exclude a Need/Program from State Reporting ................................................................................... 55

Student Clubs .............................................................................................................................................. 55

Define Student Clubs ............................................................................................................................ 55

Transportation ............................................................................................................................................. 56

Bus Screen ........................................................................................................................................... 56

Add Bus Information ............................................................................................................................. 57

Staff ............................................................................................................................................................. 57

Track Staff Section Assignments .......................................................................................................... 58

Synchronize Staff History ..................................................................................................................... 59

Exclude a Staff Member from State Reporting ..................................................................................... 59

Student ........................................................................................................................................................ 59

Student State ID Import Process .......................................................................................................... 60

Enable Extended Student Enrollment Fields ........................................................................................ 61

Maintain No Show Records upon Subsequent Enrollment .................................................................. 61

Student Leave Dates ............................................................................................................................ 62

Exclude a Student from Funding Calculations (ADA/ADM/ADT) ......................................................... 63



Exclude a Student from State Reporting .............................................................................................. 64

Chapter Two : Data Entry ..................................................................... 66

Introduction.................................................................................................................................................. 67

Staff Data .................................................................................................................................................... 67

Staff Screen .......................................................................................................................................... 67

Staff Name, SSN and License Number Changes ................................................................................ 69

Add a School-Specific Staff Assignment .............................................................................................. 69

Add a District-Wide Staff Assignment................................................................................................... 69

Student Data ............................................................................................................................................... 70

Student Screen ..................................................................................................................................... 70

Student Name, SSN, and PIN Changes ............................................................................................... 74

Student Course Quality Points ............................................................................................................. 75

School Choice for Transfer Students.................................................................................................... 76

Student Classifications ................................................................................................................................ 76

Assign a Classification to a Student ..................................................................................................... 76

Homeless Classification ....................................................................................................................... 77

Free and Reduced Lunch Classifications ............................................................................................. 78

Supplemental Education Services (SES) .................................................................................................... 78

TA Support Services ................................................................................................................................... 78

TA Instructional Services ............................................................................................................................ 78

Designate Student as Class Teacher Aide ........................................................................................... 79

Student Programs ....................................................................................................................................... 79

Student Needs and Programs .............................................................................................................. 79

English Language Learners .................................................................................................................. 82

Free and Reduced Meals ..................................................................................................................... 82



Student Clubs .............................................................................................................................................. 82

Chapter Three : State Reporting Setup ............................................... 84

Introduction.................................................................................................................................................. 85

Critical Extract Error Notification ................................................................................................................. 85

Data Exclusions .......................................................................................................................................... 85

Chapter Four : Tennessee Reports ...................................................... 87

Introduction.................................................................................................................................................. 88

ATD626 – 200 Day Accountability Report .................................................................................................. 90

ATD627 – Director’s Membership and Attendance Report ......................................................................... 93

ATD628 – Director’s Vocational Class FTEADA Report ............................................................................. 97

ATD629 – Director’s Vocational Class FTEADM Report ............................................................................ 99

ATD630 – End of Month Membership Report ........................................................................................... 101

GRD605 – Roster of Graduates ................................................................................................................ 103

GRD606 – Promotions and Retentions Report ......................................................................................... 105

IDS606 – Discipline Report ....................................................................................................................... 107

STU606 – Net Enrollment Report ............................................................................................................. 111

STU607 – Report of 12th Graders ............................................................................................................. 113

STU610 – Dropout Report ........................................................................................................................ 114

STU819 – Electronic Transcript ................................................................................................................ 116

TRN600 – Transportation ADT Report ..................................................................................................... 117

Chapter Five : Tennessee Extracts .................................................... 119

Introduction................................................................................................................................................ 120

Extract Submission ................................................................................................................................... 120

State Submission Screen ................................................................................................................... 120



Automatic Extract Submission ............................................................................................................ 121

Resending Extract .............................................................................................................................. 122

Submitted Extracts.............................................................................................................................. 124

Errors with Submitted Extracts ........................................................................................................... 125

Extract Data Preview ................................................................................................................................. 126

State Reporting Extracts Screen ........................................................................................................ 127

Creating an Extract For Review .......................................................................................................... 128

Viewing History of Extracts Created For Review ................................................................................ 128

Filter Groups ....................................................................................................................................... 129

TDOE Extract Field Locations in Synergy SIS .......................................................................................... 130

010–200 Day Calendar Extract .......................................................................................................... 130

011–200 Day Calendar Event Extract ................................................................................................ 132

015–District Bus.................................................................................................................................. 133

020–Instructional Program Extract ..................................................................................................... 134

021–Instructional Program Report Period Extract .............................................................................. 135

022–School Days Extract ................................................................................................................... 136

030–Class Section Extract ................................................................................................................. 139

031–Class Section Schedule Extract ................................................................................................. 143

040–Student Extract ........................................................................................................................... 145

041–Student Enrollment Extract ......................................................................................................... 147

042–Student Ineligibility Funding Status ............................................................................................ 149

043–Student Instructional Grade ........................................................................................................ 150

044–Student Classification ................................................................................................................. 151

045–Student Transportation ............................................................................................................... 154

046–Student Disciplinary Action ......................................................................................................... 154



047–Student Standard Day ................................................................................................................ 156

048–Student Class Assignment ......................................................................................................... 157

049–Student Attendance .................................................................................................................... 158

050–Student Withdraw ....................................................................................................................... 159

051–Student End of Service ............................................................................................................... 160

052–Student Club Membership .......................................................................................................... 163

060–Staff Member Extract .................................................................................................................. 163

062–Staff Member Current Assignment Extract ................................................................................. 165

063–Staff Member Class Assignment ................................................................................................ 167

080–Student Final Grade ................................................................................................................... 170

081–Student TA Instructional Services .............................................................................................. 173

082–Student TA Support Services ..................................................................................................... 175

083–Student Choice Applied .............................................................................................................. 176

Chapter Six : Mapping ........................................................................ 177

Transmit Header Map ............................................................................................................................... 178

200 Day Calendar Map ............................................................................................................................. 179

200 Day Event Calendar Map ................................................................................................................... 181

District Bus Map ........................................................................................................................................ 182

Instructional Program Map ........................................................................................................................ 184

Instructional Program Report Period Map ................................................................................................. 186

School Days Map ...................................................................................................................................... 187

Class Section Map .................................................................................................................................... 188

Class Section Schedule Map .................................................................................................................... 191

Student Map .............................................................................................................................................. 192

Student Enrollment Map ............................................................................................................................ 195



Student Ineligibility Funding Status Map ................................................................................................... 198

Student Instructional Grade Map .............................................................................................................. 200

Student Classification Map........................................................................................................................ 201

Student Transportation Map...................................................................................................................... 202

Student Disciplinary Action Map ............................................................................................................... 204

Student Standard Day Map ....................................................................................................................... 206

Student Class Assignment Map ................................................................................................................ 208

Student Attendance Map ........................................................................................................................... 210

Student Withdraw Map .............................................................................................................................. 211

Student End of Service Map ..................................................................................................................... 213

Student Club Membership Map ................................................................................................................ 215

Staff Member Map ..................................................................................................................................... 216

Staff Member Current Assignment Map .................................................................................................... 218

Staff Member Class Assignment Map ....................................................................................................... 219

Student Final Grade Map .......................................................................................................................... 220

Student TA Instructional Services Map ..................................................................................................... 222

Student TA Support Services Map ............................................................................................................ 223

Student Choice Applied Map..................................................................................................................... 224

Special Education Option Map .................................................................................................................. 225

Special Education Disabilities Map ........................................................................................................... 226

Transmit Trailer Map ................................................................................................................................. 227



ABOUT THIS MANUAL Edupoint Educational Systems develops software with multiple release dates for the software and related documentation. The documentation is released in multiple volumes to meet this commitment.

DOCUMENT HISTORY Date Edition Revision Content

September 2014 1 0 Initial document release.

September 2014 1 1 Added field locations for extracts.

March 2015 1 2 Added reports.

August 2015 1 3 Updated to release 9.0.11.0.

May 2016 1 4 Added Mapping information.

TENNESSEE STATE REPORTING INTRODUCTION This guide has been created for Tennessee users as a supplement to the standard Synergy SIS documentation. It describes how data fields and functionality differ from the standard product to accommodate Tennessee Department of Education (TDOE) reporting requirements. It also describes the Synergy SIS processes for reviewing and submitting data to TDOE.



CONVENTIONS USED IN THIS GUIDE Bold Text Bold Text - Indicates a button or menu or other text on the screen to

click, or text to type.

Tip – Suggests advanced techniques or alternative ways of approaching the subject.

Note – Provides additional information or expands on the topic at hand.

Reference – Refers to another source of information, such as another manual or website

Caution – Warns of potential problems. Take special care when reading these sections.

BEFORE YOU BEGIN Before installing any of the Edupoint family of software products, please be sure to review the system requirements and make sure the district’s computer hardware and software meet the minimum requirements. If there are any questions about the system requirements, please contact an Edupoint representative at (877) 899-9111.

Caution: The Edupoint family of software does not support the use of pop-up blockers or third-party toolbars in the browser used to access SYNERGY SIS. Please disable any pop-up blockers (also known as pop-up ad blockers) and extra toolbars in the browser before logging into any Edupoint product.

At any point, if there are any technical difficulties, please contact the Edupoint technical support team at [email protected] or by phone at 1-877-899-9111 option 1.

mailto:[email protected]

Chapter One Tennessee State Reporting Guide


Chapter One DATA SETUP AND ADMINISTRATION

This chapter contains the following information:

► Setup Introduction

► Getting Started

► Lookup Tables

► TN School Calendar Data, Events, and Requirements

► Reporting Periods, School Calendars, and Events

► Attendance

► Discipline

► Courses and Sections

► Student Classifications

► Supplemental Education Services (SES) ► TA Support Services

► TA Instructional Services

► Student Programs

► Student Clubs

► Transportation

► Staff ► Student

Tennessee State Reporting Guide Chapter One

14 Copyright 2015 Edupoint Educational Systems, LLC

SETUP INTRODUCTION This chapter provides information about setting up Synergy SIS and performing administrative functions to collect and maintain data for TDOE reporting. It is essential to review and perform the required setup prior to entering data as described in the next chapter.

GETTING STARTED Before performing the setup and data entry instructions in this guide, Tennessee users should complete these activities to support a smoother setup process:

• Consult the Tennessee Department of Education (TDOE) to identify valid codes for state reporting. Helpful information can be found at http://www.tn.gov/education/districts/eis.shtml.

• Identify the state-assigned District Number and the state-assigned School Number for each school in the district as defined in the TDOE SDE Directory.

• Identify a Synergy SIS user with login access to district and school data.

• Gather the Synergy SIS administrator and user guides for reference if needed.

http://www.tn.gov/education/districts/eis.shtml

http://www.k-12.state.tn.us/SDE/default.asp



LOOKUP TABLES A lookup table contains a set of values that appear as options in a Synergy SIS drop-down list. Each value includes a description and one or more codes used for state reporting.

This guide addresses lookup table setup for TDOE reporting.

Reference: For more information about setting up lookup tables, see Synergy® SIS System Administrator Guide.

Lookup Tables for Tennessee State Reporting

These lookup tables are used for TDOE reporting and must have code values defined.

Table Group Table Description K12 Diploma Type State-defined Completion Documents. Refer to TDOE for

valid values.

Grade State-defined Instructional Grades for student grade level assignments. Refer to TDOE for valid values.

Note: The State Code field must be the state-defined instructional grade code. The Alt Code 3 field must be a full grade level code. For example, “Fifth Grade Transitional” would have a State Code of “T5” and an Alt Code 3 of “05”.)

Graduation Semester Periods in which students are awarded Completion Documents (for example, early or summer). Refer to TDOE for valid values.

Initial Ninth Grade Year School year in which students are promoted to the ninth grade.

Language State-defined Language Codes for languages spoken by individuals. Refer to TDOE for valid values.

K12.AttendanceInfo Supplemental Funding Cat Funding sources for sections of a course.

Note: The State Code field must be F for a course to be reported as federally funded.

K12.CourseHistoryInfo Course History Type Configures and stores Course History information for printing transcripts.

Note: The State Code field must be N for a course to be excluded from the 080 Extract.



Table Group Table Description Mark State-defined Student Alpha Grades for letter grade

assignments. Refer to TDOE for valid values. K12.CourseInfo Academic Type Course academic types (for example, standard or honors).

Note: The State Code field must be H for a course to be reported as an Honors course.

Class Indicator Statuses for participation in dual enrollment and dual credit high school courses. Refer to TDOE for valid values.

Course Duration Terms for courses (for example, semester or quarter). Refer to TDOE for valid values.

Department Departments that oversee courses.

Note: The Alt Code 3 field must be the state-defined TA Instructional Services code for the department if students will provide TA instructional assistance for courses in the department. Refer to TDOE for valid values.

Funding Source Funding sources for courses and their sections.

Note: The Alt Code 3 field must be F for a course to be reported as federally funded.

Postsecondary Institution Post-secondary institutions, especially partner institutions that provide dual credit or dual enrollment opportunities to high school students. Refer to TDOE for valid codes.

K12.CourseInfo State Course Code Tennessee SDE course codes.

Note: This table is required only if the checkbox is selected at District Setup Screen > System Tab > Other Options Area > Show State Course Code as Lookup Field.

Technical Provider Provider of a CTE course as it relates to funding.

Note: The State Code field must be F for Funded to indicate the district receives funding for students taking the CTE course. An empty State Code field indicates the district does not receive funding for students taking the course (for example, district students are sent to a different district offering the course).



Table Group Table Description K12.Demographics Year End Status End of service actions for students at the end of the school

year (for example, promoted or retained). Refer to TDOE for valid values.

Note: The State Code field must be P for Promoted or

R for Retained or D for Demoted.

Summer Withdrawal Code State-defined Withdrawal Codes indicating why a student was withdrawn from a school. Refer to TDOE for valid codes.

K12.Discipline Modifications Modifications to the disposition (disciplinary action) of an incident (offense). Refer to TDOE for valid values.

Note: The State Code field must be 1 for modifications for special education students.

K12.DisciplineInfo Authority Authorities for the disposition (disciplinary action) imposed on a special education student. Refer to TDOE for valid values.

K12.Enrollment Course of Study Courses of study for a student’s enrollment. Refer to TDOE for valid values.

District Districts other than an individual’s primary or home district. For example, a district that provides services to students from another district.

Enter Code State-defined Enrollment Reasons for student attendance at a school. Refer to TDOE for valid values.

Note: The State Code field must be a TDOE code. The Alt Code 3 field must be S for out-of-district concurrent enrollments.

Leave Code State-defined Withdrawal Codes indicating why a student was withdrawn from a school. Refer to TDOE for valid codes.

School Schools other than an individual’s primary or home school. For example, a school that provides services to students from another district.

K12.Enrollment School Choice Status Indicators of choice for student transfers.

Note: The State Code field must be Y for a choice to be reported as a transfer due to student choice.

Tuition Payer Code Indicators of student eligibility for state funding. Refer to TDOE for valid values.

K12.ProgramInfo Ell Program Code State defined English Language Background codes for students. Refer to TDOE for valid values.



Table Group Table Description Frm Code State-defined Student Classifications for free and reduced

meal participation. Refer to TDOE for valid codes.

Note: It is not necessary to define the code for full price paid lunch. State reporting assumes that students without a free or reduced lunch meal classification are full price paid lunch students.

Nighttime Residence Homeless student residences. Refer to TDOE for valid values.

K12.ScheduleInfo Defined Class Type Structures for classes (for example, traditional or pull-out). Refer to TDOE for valid values.

Staff Responsibility Responsibilities a teacher or staff member contributes to a class.

Note: The State Code field must contain Y for Teacher of Record and N for Not Teacher of Record.

K12.Setup Calendar Type Value to uniquely identify school calendars for the current school year.

Required format is X## where:

• X = T for Traditional or Y for Year Round Calendar

• ## = Unique digits representing a specific Calendar

Number or Instructional Program

Non District School Type Sources of transferred course credit.

Note: The State Code field must be P for Private and

O for Out-of-State. The State Code field can be blank if the source institution is neither private nor out-of-state.

K12.Staff District Support Type State-defined Staff Assignment Positions held by staff members within a district. Refer to TDOE for valid values.

Support Type State-defined Staff Assignment Positions held by staff members within a school. Refer to TDOE for valid values.

Licensure Check Reasons that licensure information cannot be located for staff members (for example, new or university teacher). Refer to TDOE for valid values.

K12.TN Event Duration Amounts of time for a recognized Calendar Event. Refer to TDOE for valid values.

Event Types State-defined Calendar Events that occur during the school year. Refer to TDOE for valid values.



Table Group Table Description K12.TransportationInfo Fuel Type Types of fuel used by school buses or other vehicles.

Refer to TDOE for valid values.

Vehicle Type Types of school buses or other vehicles. Refer to TDOE for valid values.

Revelation Country Countries of the world.

Note: The State Code field must be the state-assigned country code.

County Counties in U.S. states.

Note: The State Code field must be the state-assigned county code. The Alt Code 3 field must be the two letter postal abbreviation for a state.

Ethnicity Race categories. Refer to TDOE for valid values.

Note: The State Code field must be the state-assigned race code. For the five federally defined race categories, the Alt Code 3 field must be:

• AI – American Indian or Alaska Native

• A – Asian

• B – Black or African American

• N – Native Hawaiian or Other Pacific Islander

• W – White

State States in the United States.

Note: The State Code field must be the state-assigned code for the U.S. state.

SPID The State Person ID generated by the TN-Ed-Fi person identity application.

Date First Enrolled in ESL Date student first enrolled in an ESL program, format CCYYMMDD. Value is all zeroes if never in an ESL program.



Lookup Table Definition Screen

The Lookup Table Definition screen enables users to define the values available for selection in Synergy SIS drop-down fields along with the associated codes for state reporting.

Figure 1-1 - Lookup Table Definition screen

Field Name TN Description ListOrder Number that determines the sort order of values in both the lookup grid and

associated Synergy drop-down fields. If the column is blank or fields contain the same number, values are sorted by the Code field in ascending alphanumeric order.

Code Unique alphanumeric code (up to five characters) used by the system to link tables in the database. This can be the code used by the state or district. By default this code is used for state reporting unless a code exists in the State Code column, in which case the State Code is used for state reporting.

Description Text that appears for user selection in a drop-down field on a Synergy SIS screen. Other SIS Code defined in a previous student record system for use in the data conversion

process to Synergy SIS. State Code Alphanumeric code used for state reporting. If a code exists in this field, state

reporting uses the State Code rather than the Code field. Alt Code 3 Special value used for data integration with another system or code for state

reporting in specific circumstances. Alt Code SIF Code used by the Schools Interoperability Framework (SIF) schema. Not typically

used for state reporting. Ed-Fi Code Code for Ed-Fi reporting (if applicable).

Status Year Start The school year in which the value becomes available for selection in the system. For example, if the code is valid starting school year 2015-2016, then select 2015. If no start date is selected, the code is available immediately.

Status Year End The final school year in which the value is available for selection in the system. For example, if the code is no longer valid for school year 2015-2016, then select 2014.



Add a Value to a Lookup Table

1. Consult the list of Lookup Tables for Tennessee State Reporting to identify a table that requires a new value.

2. Navigate to Synergy SIS > System > Setup > Lookup Table Definition.

3. Scroll to find the table group that contains the table and then expand the group.

4. Click the table name to see the Lookup Values grid.

5. In the Lookup Values grid, click Add to add a new lookup value line.

6. Complete the lookup value fields.

7. Click Save.

Assign a State Reporting Code to an Existing Lookup Table Value

1. Consult the list of Lookup Tables for Tennessee State Reporting to identify a table that requires state codes.




5. On a populated lookup value line in the Code, State Code, or Alt Code 3 field, type a code required for state reporting.

6. Click Save.

Deactivate a Lookup Table Value

This procedure describes how to deactivate a lookup table value containing codes that are no longer valid for state reporting. Deactivated values are no longer available for selection but remain in the system for historical reporting purposes.

Caution: Do not modify or delete lookup table values that contain outdated state reporting codes that are still used for historical reporting purposes. Instead, deactivate the value and then add a new lookup table value that contains the updated state reporting codes.

1. Consult the list of Lookup Tables for Tennessee State Reporting to identify a table that requires state reporting codes.




5. On the lookup value line in the State Code field, remove the text in the field.



6. In the Status Year End field, select the school year in which the value should no longer be available for selection in the system.

7. Click Save.

Sort Lookup Values

In the Lookup Values grid, click the up and down arrows in any column heading to temporarily sort the grid in ascending or descending alphanumeric order by column data.

To modify the default display order of the grid, use the ListOrder field as described in Lookup Table Definition Screen.

Product Owned Lookup Tables

Certain Synergy lookup tables are “product owned” meaning that values cannot be added, modified, or deleted. In product-owned tables, codes in the Code, State Code, and Alt Code 3 columns are fixed.

The lookup table for gender (Revelation.Gender) is an example of a product-owned table:

Figure 1-2 - Lookup Table Definition Screen for a Product-Owned Lookup Table



Organization

This guide addresses organization setup for TDOE reporting.

Reference: For more information about organization setup, see Synergy® SIS System Administrator Guide.

District Number

The Organization Detail screen for districts stores the District Number, which is essential for TDOE reporting. This must be an active District Number in the Tennessee SDE Directory. Verify the District Number is in Synergy.

Figure 1-3 - Organization Detail Screen for Districts – District Tab

School Number

The Organization Detail screen for schools stores the School Number (State CTDS Code), which is essential for TDOE reporting. This must be an active School Number in the Tennessee SDE Directory. Verify the School Number is recorded in Synergy.

Figure 1-4 - Organization Detail Screen for Schools – School Tab



Verify District and School Numbers for State Reporting

1. Navigate to Synergy SIS > System > Setup > Organization.

2. In the organization tree, click the district name to open the Organization detail screen for districts.

3. On the District tab in the District Number field, verify or type the state-assigned district code.

4. Click Save.

5. In the organization tree beneath the district name, expand a group.

6. Click the school name to open the Organization detail screen for schools.

7. On the School tab in the State CTDS Code field, type or verify the state-assigned school code.

8. Click Save to save changes to district or school numbers.

Exclude a School from State Reporting

The School Setup screen contains an option to exclude a school from TDOE reporting.

Figure 1-5 - School Setup Screen – Basic Info Tab – Other Info Area

1. Change the Focus to the school to be excluded from state reporting.

2. Navigate to Synergy SIS > System > Setup > School Setup.

3. On the Basic Info tab in the Other Info area, select the Exclude from State Reporting checkbox.

Note: Clear the checkbox to include the school in state reporting.

4. Click Save.



TN District Calendar, Events, and Requirements

In addition to defining the District Calendar, district calendar information on the District State Requirements screen must be completed for TDOE reporting.

Reference: See Synergy® SIS Attendance Administrator Guide for information on defining District Calendars.

District State Requirements Screen

The District State Requirements screen for Tennessee collects information related to the 200 Day Calendar and Calendar Events, which are typically applicable to all schools in the district. (For similar school-specific calendar information, see TN School Calendar Data, Events, and Requirements). This screen also collects other district-related information required for TDOE reporting.

Figure 1-6 - District State Requirements Screen – Options Tab



DISTRICT CALENDAR OPTIONS AREA Field Name TN Description Calendar Type Unique value identifying the calendar within the district for the current school year.

See lookup table K12.Setup.Calendar Type.

Stockpile Inclement Weather Days

Number of stockpile days designated for inclement weather.

Stockpile Professional Development Days

Number of stockpile days that may be used for professional development.

In Service Days Number of days for discretionary in-service education. Optional In Service Days Number of days for individual choice of professional development activities. Parent Teacher Conference Days

Number of days planned for parents and teachers to meet.

Teacher Vacation Days Number of days for teacher paid vacation. Abbreviated Days Number of instructional days that have been shortened to less than the state

minimum school day of 6.5 hours. Discretionary Teacher Vacation Days

Number of days for discretionary teacher vacation.

Discretionary In Service Days

Number of days for discretionary in-service education.

Discretionary Administrative Days

Number of days for discretionary administrative activities.

Discretionary Instructional Days

Number of days for discretionary instructional days.

Discretionary Other Days Number of days for discretionary non-administrative activities and discretionary non-instructional days.

Instructional Days Number of days for classroom instruction.

DISTRICT WIDE EVENTS GRID District wide events are applicable to, and reported for, all schools in the district. For information about defining school events that differ from district events, see School Specific Events on the School State Requirements Screen. Field Name TN Description Event Date Date of an instructional or non-instructional event at all district schools.

Event Type State-defined Calendar Event for all district schools. See lookup table K12.TN.Event_Types.

Instructional Day Selected checkbox indicates the event is counted as an instructional day. Cleared checkbox indicates the event is not counted as an instructional day.

Event Duration Amount of time recognized for the event at all district schools. See lookup table K12.TN.Event_Duration.



STUDENT STANDARD DAY GRID Field Name TN Description Grade Student grade level. See lookup table K12.Grade. Minutes Per Day Number of instructional minutes in a standard full-time school day for students in a

specified grade level (sometimes called Standard Day).

• For grades 9-12, this value typically excludes lunch. Per TDOE, lunch minutes do not count as instructional minutes for high school students.

• For grades K-8, this value typically includes lunch. Per TDOE, lunch minutes count as instructional minutes for elementary and middle school students.

This field can be overridden for a specific student on the Student Screen using the Standard Day Minutes field.

Note: This is not the same as Student Minutes Per Day on the School State Requirements Screen.

EXTRACT GENERATION NOTIFICATION Field Name TN Description Email Address for Critical Errors

Email address that receives notification of critical errors resulting from the automated extract submission process.

Add District Calendar Details

1. Navigate to Synergy SIS > TN > Setup > District State Requirements.

2. On the Options tab in the District Calendar Options grid, click Add to open the District Calendar Options screen.

3. Complete the calendar options fields.

4. Click Save.

Add a District Wide Event


2. On the Options tab in the District Calendar Options grid, highlight a calendar type line.

3. Click Show Detail to open the District Calendar Options Detail screen for the calendar type.

4. In the District Wide Events grid, click Add to add a new district event line.

5. Complete the district wide event fields.

6. Click Save.



Caution: When a district event is added, it is possible that each School Calendar in the district must be updated as well. See Events and School Calendars for more information.



Define Standard Day Minutes by Grade Level


2. On the Options tab in the Student Standard Day grid, click Add to add a new grid line.

3. Complete the student standard day fields.

4. Click Save.

Specify Email Address for Critical Extract Error Notifications


2. On the Options tab in the Extract Generation Notifications area, type an email address in the Email Address for Critical Errors field.

3. Click Save.

TN SCHOOL CALENDAR DATA, EVENTS, AND REQUIREMENTS In addition to defining the School Calendar, school calendar information on the State Requirements screen must be completed for TDOE reporting.

Reference: See Synergy® SIS Attendance Administrator Guide for information on defining School Calendars.

School State Requirements Screen

The School State Requirements screen Tennessee collects information related to a school calendar and events. (For calendar information applicable to all district schools, see TN District Calendar, Events, and Requirements.)



Figure 1-7 - State Requirements Screen – Options Tab

SCHOOL CALENDAR OPTIONS AREA Field Name TN Description These fields are specific to the school in Focus.

Student Minutes Per Day Number of minutes in a standard full-time school day, including instructional minutes and lunch, for students at the school (sometimes called Student Day). For example, if high school students receive 390 minutes of instruction plus 30 minutes of lunch, this value is 420.

Note: This is not the same as Standard Day Minutes Per Day on the District State Requirements Screen.

Teacher Minutes Per Day Number of minutes in a standard full-time day, including lunch, for teachers in the instructional program at the school.

Spring Block Begin Date Day spring block begins for a school on block schedule. Stockpile Professional Development Days

Number of stockpile days the school declares for professional development (completed only when the district does not declare stockpiling on the District State Requirements Screen).

Block Schedule Selected checkbox indicates the school uses block schedule. Cleared checkbox indicates the school does not use block schedule.

SCHOOL SPECIFIC EVENTS GRID School specific events are only those that differ from District Wide Events defined on the District State Requirements Screen. District wide events are applicable to, and reported for, all schools in the district and are not repeated in the School Specific Events grid. Field Name TN Description Event Date Date of an instructional or non-instructional event at the school.

Event Type State-defined Calendar Event for the school. See lookup table K12.TN.Event_Types. Instructional Day Selected checkbox indicates the school event is counted as an instructional day.

Cleared checkbox indicates the event is counted as a non-instructional day. Event Duration Amount of time recognized for the school event. See lookup table

K12.TN.Event_Duration.

Add School Calendar Details

1. Change the Focus to a particular school.

2. Navigate to Synergy SIS > TN > Setup > School State Requirements.

3. On the Options tab, complete the school calendar options fields.

4. Click Save.

Add a School-Specific Event

1. Navigate to Synergy SIS > TN > Setup > School State Requirements.



2. On the Options tab in the School Specific Events grid, click Add to add a new school event line.

3. Complete the school specific events fields.

4. Click Save.

Caution: When a school event is added, it is possible that the School Calendar must be updated as well. See Events and School Calendars for more information.

REPORTING PERIODS, SCHOOL CALENDARS, AND EVENTS This section describes the important relationships between reporting periods, school calendars, and TDOE-defined events.

School Calendars and Reporting Periods

A Tennessee reporting period, sometimes called an accounting period or attendance period, comprises 20 successive instructional days. (For schools that stockpile in accordance with Tennessee state law, the final reporting period might have less than 20 days.)

Caution: For TDOE reports and extracts, reporting periods are calculated for each school from the School Calendar Screen in Attendance Setup. For this reason, it is essential that each School Calendar in the district accurately reflect all instructional and non-instructional days.

Reference: The District Calendar can be used to update all School Calendars. For more information about updating School Calendars, see Synergy® SIS Attendance Administrator Guide.)

In this example, Report Period 01 begins on 7/30 and ends on 8/29. Report Period 02 begins on 9/2 and ends on 9/29. Only instructional days are used to calculate each reporting period, and all non-instructional days are skipped.



Figure 1-8 - School Calendar Screen – School Calendar Tab



Events and School Calendars

When events that affect instructional days occur, any change must be recorded in multiple locations including school calendars and Tennessee district-wide or school-specific events.

For example, January 20th is scheduled as an instructional day but schools close that day due to inclement weather. The district does not stockpile via extended school days and must make up the missed day. Although April 3rd had been scheduled as a vacation day, it is designated as the make-up day for January 20th, and students will now attend classes on April 3rd.

1. Revise each School Calendar in the district to reflect the changes. (See School Calendars and Reporting Periods for more information.)

Original School Calendar Revised School Calendar

Figure 1-9 - School Calendar Screen – School Calendar Tab

2. Update the District Wide Events grid to reflect the changes. (If the event had been limited to a single school in the district, update the School Specific Events grid.)

Figure 1-10 - District State Requirements Screen – Options Tab

ATTENDANCE



The Tennessee Department of Education specifies attendance codes that must be reported to the state. Refer to TDOE for the list of valid attendance codes.

Define Attendance Codes

Reference: This guide addresses attendance code definition for TDOE reporting. For more information about setting up attendance information, see Synergy® SIS Attendance Administrator Guide.

In Synergy SIS, the state-specified attendance codes are associated with attendance reasons defined on the District Attendance Code screen.

Caution: When associating TDOE attendance codes with attendance reasons, the State Code must contain a valid TDOE attendance code to be included in state reporting.

For example:

Figure 1-11 - District Attendance Code Screen – Attendance Reasons Tab



Include an Attendance Code in State Reporting

The District Attendance Code screen includes an option to include selected attendance codes in state extracts and reports. Districts and schools can define multiple attendance codes, but only designated codes are included in state reporting.

Figure 1-12 - District Attendance Code Screen – Attendance Reasons Tab

1. Navigate to Synergy SIS > Attendance > Setup > District Attendance Code.

2. On the Attendance Reasons tab in the Attendance Reasons grid, select the Report to State checkbox to include a code in state reporting.

Note: Clear the checkbox to exclude the code from state reporting

3. Ensure that the State Code field contains a valid TDOE attendance code.

Note: If this field is empty, the code will not be included in TDOE reporting.

4. Click Save.

DISCIPLINE The Tennessee Department of Education specifies disciplinary information that must be reported to the state. Refer to TDOE for the list of valid disciplinary codes.

Offenses and Disciplinary Actions

This guide addresses discipline definition for TDOE reporting.

Reference: For more comprehensive information about setting up discipline information, see Synergy® SIS Discipline and Conference Administrator Guide.



Define Offense Codes (Violations)

In Synergy SIS, the state-specified offense codes are defined at the district level as discipline codes on the District Discipline Code Setup screen.

Caution: On the District Discipline Code Setup screen, the State Code fields must match the state-specified offense codes.

For example:

Figure 1-13 - District Discipline Code Setup Screen – Discipline Codes Tab



Define Disciplinary Action Codes (Dispositions)

In Synergy SIS, the state-specified disciplinary action codes are defined at the district level as disposition codes on the District Disposition Code Setup screen.

Caution: When defining disposition codes on the District Disposition Code Setup screen:

• The State Code fields must match the state-specified disciplinary codes.

• A unique Severity number must be specified for each state code (where “1” represents the highest severity).

Figure 1-14 - District Disposition Code Setup Screen – Disposition Codes Tab



Include an Offense Code (Violation) in State Reporting

The District Discipline Code Setup screen includes an option to include selected primary, secondary, and tertiary offense codes (violations) in state extracts and reports. Districts and schools can define multiple offense codes, but only designated codes are included in TDOE reporting.

Caution: All state-defined offense codes should be marked for inclusion in state reporting.

Figure 1-15 - District Discipline Code Setup Screen – Discipline Codes Tab

1. Navigate to Synergy SIS > Discipline Incident > Setup > District Discipline Code Setup.

2. Find the discipline code record.

3. On the Discipline Codes tab, select the primary offense Report To State checkbox to include it (along with any designated secondary and tertiary offenses) in state reporting.

Note: Clear the checkbox to exclude the primary offense (and any secondary and tertiary offenses regardless of their own Report To State selections) from state reporting.

4. In the Discipline Codes grid, select the Report To State checkbox to include a secondary offense (along with any tertiary offenses regardless of their own Report To State selections) in state reporting.

Note: Clear the checkbox to exclude a secondary offense and any tertiary offenses (regardless of their own Report To State selections) from state reporting.

5. In the Discipline Codes grid, select a line and then click Show Detail to open the Discipline Detail screen.

6. On the Discipline Detail tab in the Detail 1 Codes grid, select the Report to State checkbox to include the tertiary offense in state reporting.



Note: Clear the checkbox to exclude a tertiary offense from state reporting.

7. Click Save.

Include a Disciplinary Action Code (Disposition) in State Reporting

The District Disposition Code Setup screen includes an option to include selected disciplinary action codes (dispositions) in state extracts and reports. Districts and schools can define multiple disciplinary action codes, but only designated codes are included in TDOE reporting.

Caution: All state-defined disciplinary action codes should be marked for inclusion in state reporting.

Figure 1-16 - District Disposition Code Setup Screen – Disposition Codes Tab

1. Navigate to Synergy SIS > Discipline Incident > Setup > District Disposition Code Setup.

2. Find the disposition code record.

3. On the Disposition Codes tab, select the primary disciplinary action Report To State checkbox to include it in state reporting.

Note: Clear the checkbox to exclude the primary disciplinary action (and any secondary and tertiary actions regardless of their own Report To State selections) from state reporting.

4. In the Disposition Codes detail screen, select the Report To State checkbox to include a secondary offense (along with any tertiary offenses regardless of their own Report To State selections) in state reporting.

Note: Clear the checkbox to exclude a secondary disciplinary action and any tertiary actions (regardless of their own Report To State selections) from state reporting.

5. In the Disposition Codes grid, select a line and then click Show Detail to open the Disposition Detail screen.



6. On the Disposition Detail tab in the Detail 1 Codes grid, select the Report to State checkbox to include the tertiary disciplinary action in state reporting.

Note: Clear the checkbox to exclude a tertiary action from state reporting.

7. Click Save.



Primary Offense (Violation) by Severity

For TDOE reporting, if there are multiple violations associated with a student incident, identify the student’s primary violation. The primary violation (or main reason that dispositions were administered) is identified by assigning severity to violations where “1” represents the highest severity.

Define the violation severity during violation setup or leave blank. The violation severity (if any) can be overridden at the incident level for all involved students and then again at the student level for a specific participant.

Caution: If a student has multiple violations for a single incident, identify only one violation as the primary using severity. In this example where the student has three violations, the violation with a Severity Override of “1” will be reported as the primary reason the student received one or more dispositions for this incident.

Reference: For more information, see Synergy® SIS Discipline and Conference Administrator Guide.

Figure 1-17 - Student Incident Screen – Discipline Tab

COURSES AND SECTIONS The Tennessee Department of Education specifies course related information that must be reported to the state.



Reference: For more comprehensive information about managing course and section data, see Synergy® SIS Scheduling and Course Guide.

District Course Screen

The District Course screen includes fields that have been customized for TDOE reporting. This section describes data collected by the customized fields.

District Course Screen – Course Tab

Figure 1-18 - District Course Screen – Course Tab

OTHER PROVIDER INFORMATION AREA Field Name TN Description Provider ID SDE District Number and School Number for the location offering the course.

Completed only when the course is offered outside of the current district.

Note: Format must be DDD-SSSS where DDD is the district number and SSSS is a school number. For courses offered by non-public schools and off-campus locations (such as technology centers, universities, or private schools), refer to TDOE for valid district and school values.



District Course Screen – Description Tab

Figure 1-19 - District Course Screen – Description Tab

STATE COURSE CLASSIFICATION AREA Field Name TN Description State Course Code State-defined course code (which might differ from the Course ID).

Note: This field can appear as text entry or dropdown. If the field is a dropdown, see lookup table K12.CourseInfo.State Course Code.

Class Indicator Dual enrollment or dual credit indication for a high school course. See lookup table K12.CourseInfo.Class Indicator.

PostSecondary Institution

Postsecondary partner institution that provides dual enrollment or dual credit for high school students in the course. See lookup table K12.CourseInfo.Postsecondary Institution.



Section Screen

The Section screen includes fields that have been customized for TDOE reporting. This section describes data collected by the customized fields.

Figure 1-20 - Section Screen – Current Students Tab

STATE REPORTING AREA Field Name TN Description Defined Class Type Structure of the class (for example, traditional). See lookup table

K12.ScheduleInfo.Defined Class Type. Vocational Outside IEP Selected checkbox indicates a CTE course is above the base 23.5 Special Education

contact hours. Cleared checkbox indicates a CTE course is not above the base 23.5 Special Education contact hours.



Override Instructional Minutes for a Section

Some classes might need to count toward student scheduled minutes for a different duration than the period in which they occur.

For example, lunch for high school students is scheduled during a 30 minute period, but those 30 minutes are not considered instructional time. By specifying an instructional minutes override of “0”, the lunch class does not count toward a student’s scheduled minutes. In this way, lunch can be reported to TDOE with a duration of 0 minutes.

Figure 1-21 - Section Screen – Current Students Tab

1. Navigate to Synergy SIS > Schedule > Section.

2. Find the section record.

3. In the Instructional Minutes Override field, type a number.

4. Click Save.

Exclude a District Course from State Reporting

The District Course screen contains an option to exclude a selected course (and all sections of the course) from TDOE reporting.

Figure 1-22 - District Course Screen – Course Tab – Other Information Area

1. Navigate to Synergy SIS > Course > District Course.

2. Find the course record.

3. On the Course tab in the Other Information area, select the Exclude From State Reporting checkbox.



Note: Clear the checkbox to include the course and its sections in state reporting. See also Exclude a School Course (Section) from State Reporting to exclude only specific sections of a course.

4. Click Save.

Exclude a School Course (Section) from State Reporting

The Section screen contains an option to exclude a selected section of a course from TDOE reporting.

Figure 1-23 - Section Screen – Current Students Tab – State Reporting Area


2. Find the section record.

3. On the Current Students tab in the State Reporting area, select Yes in the Exclude From State Reporting field.

Note: If the entire course has been excluded, the Course Excluded From State Reporting checkbox will be selected and the section cannot be included in state reporting (see Exclude a District Course from State Reporting for more information).

4. Click Save.



CTE Courses

For TDOE reporting, identify CTE courses on the District Course screen.

Figure 1-24 - District Course Screen – Course Tab – Carl Perkins / CTE Programs Area

CARL PERKINS / CTE PROGRAMS AREA Field Name TN Description Program Code State-defined CTE program code for the course (for example: AG, GOV, STEM). All

sections of a course with a CTE Program Code are assumed to be CTE classes.

Technical Provider The provider of the course as it relates to funding. See lookup table K12.CourseInfo.Technical Provider.

STUDENT CLASSIFICATIONS The Tennessee Department of Education specifies student classifications that must be reported to the state. Refer to TDOE for the list of valid student classification codes.

Define a Student Classification

To define the Student Classifications required for TDOE reporting (for example, the Homeless and Title 1 classifications), use the Needs/Programs Definition Screen as described in Define a Student Need/Program.

Caution: On the Needs/Programs Definition screen, the State Code must match the state-specified student classification code.

For example:



Figure 1-25 - Needs/Programs Definition Screen – Programs Tab

Note: The lunch related classifications must be defined in lookup table K12.ProgramInfo.Frm Code rather than here with other student classifications.

SUPPLEMENTAL EDUCATION SERVICES (SES) The Tennessee Department of Education specifies that supplemental education services (SES) information must be reported to the state.

Define Supplemental Education Services Codes

To define Supplemental Education Services required for TDOE reporting, use the Needs/Programs Definition Screen as described in Define a Student Need/Program.

Caution: When defining Supplemental Educational Services Codes on the Needs/Programs Definition screen:

• The overall State Code must be SES.

• In the Programs grid, the State Code must be SES-A to indicate a student has applied for SES.

• In the Programs grid, the State Code must be SES-R to indicate a student is receiving SES.




TA SUPPORT SERVICES The Tennessee Department of Education specifies TA Support Services codes that must be reported to the state. Refer to TDOE for a list of valid codes.

Define TA Support Services Codes

To define TA Support Services required for TDOE reporting, use the Needs/Programs Definition Screen as described in Define a Student Need/Program.

Caution: When defining TA Support Services codes on the Needs/Programs Definition screen:

• The overall State Code must be TASA.

• In the Programs grid, the Program Code and State Code fields must match the state-specified TA Support Services codes.


TA INSTRUCTIONAL SERVICES



The Tennessee Department of Education specifies TA Instructional Services codes that must be reported to the state. Refer to TDOE for a list of valid codes.

Note: Students are identified as providing TA instructional assistance when they are designated as a teacher’s aide in a class where the associated district course is offered by a department with a TA Instructional Services code.

Assign TA Instructional Services Code to District Course

Figure 1-28 - District Course Screen – Course Tab

1. Navigate to Synergy SIS > Course > District Course.

2. On the Course tab in the Course Info area, select a Department for which a TA Instructional Services code has been defined in lookup table K12.CourseInfo.Department.

3. Click Save.

STUDENT PROGRAMS In Student Programs, the Needs/Programs Definition screen is used by districts to define student needs any related programs in which students participate. For TDOE reporting, this screen is used to define information for:

• Student Classifications

• Supplemental Education Services (SES)

• TA Support Services

• TA Instructional Services



Needs/Programs Definition Screen


Field Name TN Description State Code Code for a need or student classification as it appears in reports and extracts. Description Description of a need or student classification as it appears for assignment to

students.

Ed-Fi Code Reserved for future use. Locale N/A School Based A selected checkbox indicates the need can be added automatically to all students in

specified grade levels. A cleared checkbox indicates that the need cannot be added automatically to all students in specified grade levels. See Specify Grade Level Participation for School Based Needs/Programs for more information.

Reporting School School where programs or services for the specified need or classification are provided.

OPTIONS AREA Field Name TN Description Grades Grade levels for which the need or classification can be assigned. For example, if

only grades K-8 are selected, the need cannot be assigned to a ninth grader. If no grade levels are selected, the need can be assigned to students in any grade.

Note: If the need or classification is School Based, these grade selections do not affect student need assignment.

Do Not Report To State Selected checkbox indicates the need and associated programs are not included in state reporting. Cleared checkbox indicates the need and associated programs are included in state reporting.



PROGRAMS GRID Field Name TN Description Program Code State code for the program or service associated with the need or student

classification.

Program Description Description of the program or service associated with the need or student classification.

State Code State code for the program or service associated with the need or student classification.

Ed-Fi Code Reserved for future use. Reporting School N/A Year Start School year in which the program or service became valid (if applicable). Year End School year in which the program or service is no longer valid (if applicable).

Define a Student Need/Program

1. Navigate to Synergy SIS > Student Programs > Setup > Needs/Programs Definition.

2. Click Add to open the Needs/Programs Definition Screen.

3. Complete the screen fields and then click Save.

4. In the Programs grid, click Add to add a new line for a program associated with the code.

5. Complete the grid line fields and then click Save.

6. In the Programs grid, click Show Detail to add or edit additional information about the line item.

7. Click Save.



Specify Grade Level Participation for School Based Needs/Programs

For school based needs/programs, schools can specify the grade levels for which all students participate in the program.

Figure 1-30 - School Need Detail Screen – Program Available Detail Screen

1. Navigate to Synergy SIS > System > Setup > School Setup.

2. On the Basic Info tab in the Needs grid, highlight a need and then click the Show Detail link to open the School Need Detail screen.

Note: Only school based needs appear in the grid.

3. In the Programs Available grid, highlight a program and then click Show Detail to open the School Need Detail screen.

Note: This grid does not appear for needs that do not have programs.

4. In the Program Grade Availability area, select the grade levels for which the need/program is available.

5. Click Save.

6. In the Program Participation Grades grid, select the grades for which a student will be automatically enrolled in the need/program.

7. Click Save to enroll students in the school based need/program.

Note: This need appears on the Student Needs Screen > Needs Transactions tab (unlike manually added needs which appear on the Student Needs Screen > Needs tab).



Figure 1-31 - Student Needs Screen – Needs Transaction Tab

Specify an Exit Method for Needs/Programs

Districts can specify how need/program enrollment is handled when inactivated students return to school:

• Exit Programs/Services on Student Inactivation – Inactivated students are automatically exited from all assigned needs. If a student returns to school in the same district, his or her previous needs must be manually re-added.

• Auto-Generate Needs Transactions – Inactivated students are automatically exited from all assigned needs. If a student returns to school in the same district, the student is automatically re-enrolled in his or her previously assigned needs

Figure 1-32 - Program Exit Codes Screen

1. Navigate to Synergy SIS > Student Programs > Setup > Program Exit Codes.

2. On the Programs tab in the General Area, select an exit method.

3. Click Save.



Exclude a Need/Program from State Reporting

The Needs/Programs Definition screen includes an option to exclude a need from state reporting. Ensure that no classifications or services required for TDOE reporting are excluded in this way.

Figure 1-33 - Needs/Programs Definition Screen – Programs Tab – Options Area

1. Navigate to Synergy SIS > Student Programs > Setup > Needs/Programs Definition.

2. Find the need record.

3. On the Programs tab in the Options area, select the Do Not Report To State checkbox.

Note: Clear the checkbox to include the need in state extracts and reports.

4. Click Save.

STUDENT CLUBS The Tennessee Department of Education specifies Student Clubs that must be reported to the state. Refer to TDOE for the list of valid student club IDs.

Define Student Clubs

The state-specified student clubs are defined via Synergy SIS Student Groups.

Reference: For more information about setting up and managing student groups, see Synergy® SIS Student Groups Administrator Guide.

Caution: When defining Student Clubs on the District Groups screen, the group Code must match the state-specified Student Club ID.

For example:



Figure 1-34 - District Groups Screen – Groups Tab

TRANSPORTATION The Tennessee Department of Education specifies district vehicle information that must be reported to the state.

Bus Screen

The Bus screen contains fields customized for TDOE reporting. This section describes data collected by the customized fields.

Figure 1-35 - Bus Screen – Bus Info Tab

VEHICLE SPECIFICATIONS AREA Field Name TN Description Bus Type Type of bus. See lookup table K12.TransportationInfo.Vehicle Type.

Fuel Type Type of fuel used by the bus. See lookup table K12.TransportationInfo.Fuel Type. Gross Vehicle Weight N/A Seating Capacity N/A



VEHICLE SPECIFICATIONS AREA Field Name TN Description Occupant Restraints Selected checkbox indicates the bus is equipped with occupant restraints. Cleared

checkbox indicates the bus is not equipped with occupant restraints.

Specially Equipped Selected checkbox indicates the bus is specially equipped. Cleared checkbox indicates the bus is not specially equipped.

Two Way Communication Selected checkbox indicates the bus has two way communication equipment. Cleared checkbox indicates the bus does not have two way communication equipment.

Air Conditioning Selected checkbox indicates the bus has air conditioning. Cleared checkbox indicates the bus does not have air conditioning.

Special Lift Equipment Selected checkbox indicates the bus has a wheelchair lift. Cleared checkbox indicates the bus does not have a wheelchair lift.

Audio Video Surveillance Selected checkbox indicates the bus has audio/video surveillance equipment. Cleared checkbox indicates the bus does not have audio/video surveillance equipment.

GPS System Selected checkbox indicates the bus has a GPS system. Cleared checkbox indicates the bus does not have a GPS system.

OTHER INFORMATION AREA Field Name TN Description Year Began Operation School year when the bus first became operational. Days In Use N/A Number of Accidents Number of accidents involving the bus.

Inspected By State Selected checkbox indicates the bus has a current inspection by the Tennessee Department of Safety. Cleared checkbox indicates the bus does not have a current inspection by the department of safety.

Commercial Advertising Selected checkbox indicates there is commercial advertising on the bus. Cleared checkbox indicates there is no commercial advertising on the bus.

Privately Owned Selected checkbox indicates the bus is privately owned. Cleared checkbox indicates the bus is not privately owned.

Add Bus Information

1. Navigate to Synergy SIS > Transportation > Bus.

2. Click Add to open the Bus screen.

3. Complete the screen fields.

4. Click Save.

STAFF For TDOE reporting, configure Synergy SIS to track changes in the primary teacher assignment for sections.



Reference: For more information setting up staff data, see Synergy® SIS System Administrator Guide.

Track Staff Section Assignments

Figure 1-36 - District Setup Screen – System Tab – Other Options Area

1. Navigate to Synergy SIS > System > Setup > District Setup.

2. On the System tab in the Other Options Area, select the Enable historical tracking of staff in sections checkbox.

3. Click Save.

4. Run the Synchronize Staff History process.

Note: When staff section assignment tracking is enabled, the Section screen includes a Staff History tab where historical primary teacher assignments for sections can be viewed or deleted.

Reference: See Synergy® SIS Scheduling and Course Guide for more information about staff history for sections.



Synchronize Staff History

Run the Synchronize Staff History process at the beginning of the school year after scheduling is complete (and typically prior to the first day of class). Also run this process immediately after performing the Track Staff Section Assignments procedure.

1. Change the Focus to a particular school.

Note: Run this process separately for each school in the district.


3. From the Menu, select Synchronize Staff History to open the Synchronize Staff History Options screen.

4. Select the Synchronize all sections across the entire district checkbox.

5. Click Synchronize.

Exclude a Staff Member from State Reporting

The Staff screen includes an option to exclude a staff member from TDOE reporting.

Figure 1-37 - Staff Screen – General Tab – Other Info Area

1. Navigate to Synergy SIS > Staff > Staff. 2. Find the staff record.

3. On the General tab in the Other Info area, select the Exclude From State Reporting checkbox.

Note: Clear the checkbox to include the staff member in state reporting.

4. Click Save.

STUDENT



Reference: For more information about setting up student data, see Synergy® SIS Student Information Administrator Guide.

Student State ID Import Process

The student state ID import process populates empty Synergy SIS State Student ID fields with student IDs from TDOE. The process also identifies student ID discrepancies between Synergy SIS and TDOE for user review.

Figure 1-38 - Student Screen – Demographics Tab – Student Information Area

Run the Student State ID Import Process

Figure 1-39 - Tennessee State Import Processes Screen

1. Obtain the TDOE student ID file and save it where it can be accessed.

2. Navigate to Synergy SIS > TN > Tennessee State Import Processes.

3. On the State ID Import tab in the Student ID File From The State grid, click Add to open the Upload File screen.

4. Browse to find the TDOE student ID file and then click Upload.

5. Click Process File to run the process.

Note: To override existing Synergy student IDs with TDOE student IDs, select the Allow State IDs to be changed checkbox before clicking Process File. This action cannot be undone.

6. Click the Err Log File icon to open the error log and review import process results.



Enable Extended Student Enrollment Fields

For TDOE reporting, configure Synergy SIS to collect immigration enrollment information.

Figure 1-40 - District Setup Screen – System Tab – Enrollment Options Area


2. On the System tab in the Enrollment Options area, select the Show Extended Other Enrollment Information checkbox.

3. Click Save.

4. Navigate to Synergy SIS > Student > Student. 5. On the Enrollment tab in the Other Enrollment Information area, verify that the US

School Entry Date is visible (other fields will be visible as well).

Maintain No Show Records upon Subsequent Enrollment

For TDOE reporting, Synergy SIS must be configured to maintain the code and date used to No Show students. This ensures that if a No Show student enrolls later in the school year, the original No Show record is retained.

Figure 1-41 - District Setup Screen – System Tab – Enrollment Options Area


2. On the System tab in the Enrollment Options area, select the Do Not Clear Summer Withdrawal Code and Date checkbox.

3. Click Save.



Student Leave Dates

The State Leave Date is a view-only field that indicates the first day of non-attendance for a student who is Inactivated or No Showed. The State Leave Date is typically reported in TDOE extracts.

Reference: For more information about withdrawing students, see Synergy® SIS Student Information User Guide).

Leave Date for Inactivated Students

Students are inactivated when they have attended class for any portion of any day in the school year. In Enrollment History, the Leave Date is a student’s last day of attendance. The State Leave Date is the next valid attendance day, which is a student’s first day of non-attendance.

In this example, the student was inactivated with a Leave Date of Friday October 31, indicating the student was still enrolled and in attendance for at least part of the 31st. The State Leave Date appears as Monday November 4, which is the next valid attendance day as well as the student’s first day of non-attendance.

Figure 1-42 - Student Screen – Enrollment History Tab

Leave Date for No Show Students

Students are “no showed” when they do not return in the new school year to attend class for any portion of any day. In Enrollment History, the Summer Withdrawal Date is any date prior to first calendar day. The State Leave Date is the first attendance day of the school year, which is the student’s first day of non-attendance.

Caution: A student must be No Showed to enable another school in the district to enroll that student on the first attendance day of the school year.



In this example, the student was “no showed” with a Summer Withdrawal Date with a July date prior to the calendar start date. The State Leave Date appears as August 4th, which is the first valid attendance day of the school year as well as the student’s first day of non-attendance.

Figure 1-43 - Student Screen – Enrollment History Tab

Exclude a Student from Funding Calculations (ADA/ADM/ADT)

The Enrollment History screen includes an option to exclude students from Average Daily Attendance (ADA), Average Daily Membership (ADM), and Average Daily Transportation (ADT) in Synergy reports.

For example, students who attend school with Form I-20 are not eligible for funding and can be excluded from generating ADA, ADM, or ADT in Synergy reports.

Caution: This setting only excludes students from Synergy report calculations related to ADA, ADM, and ADT. It does not exclude students from TDOE extracts and does not affect how TDOE calculates student funding.

Figure 1-44 - Enrollment History Screen – Enrollment Tab

1. Navigate to Synergy SIS > Student > Student. 2. Find the student record.



3. On the Enrollment History tab in the Enrollment History grid, identify the enrollment line that requires modification.

4. In either the Enter Date or Enter Code field, click the link to open the Enrollment History screen.

5. On the Enrollment tab in the School Enrollment grid, identify the line that requires modification.

6. In the ADA/ADM field, select No ADA/ADM.

7. Click Save and then close the Enrollment History screen.

8. On the Enrollment tab in the Enrollment Information area, verify status in the ADA/ADM field.

Exclude a Student from State Reporting

The Enrollment History screen includes an option to exclude students from all state reporting.

Caution: This setting excludes students from all state reporting including Tennessee extracts and reports.

Figure 1-45 - Enrollment History Screen – Enrollment Tab


3. On the Enrollment History tab in the Enrollment History grid, identify the enrollment line that requires modification.

4. In either the Enter Date or Enter Code field, click the link to open the Enrollment History screen.

5. On the Enrollment tab in the School Enrollment grid, identify the line that requires modification.

6. In the ADA/ADM field, select Exclude from State Reporting.



7. Click Save and then close the Enrollment History screen.

8. On the Enrollment tab in the Enrollment Information area, verify status in the ADA/ADM field.

Tennessee State Reporting Guide Chapter Two


Chapter Two : DATA ENTRY


► Introduction

► Staff Data

► Student Data

► Student Classifications

► Supplemental Education Services (SES)

► TA Support Services

► TA Instructional Services

► Student Programs

► Student Clubs

Chapter Two Tennessee State Reporting Guide


INTRODUCTION Before performing the data entry activities described in this chapter, consult Chapter One Data Setup for important Synergy SIS setup information.

STAFF DATA The Staff screen collects much of the staff information required for TDOE reporting.

Reference: For more information about managing staff data, see Synergy® SIS System Administrator Guide.

Staff Screen

The Staff screen contains fields customized for TDOE reporting. This section describes data collected by the customized fields.

Staff Screen – General Tab

Figure 2-1 - Staff Screen – General Tab

STAFF INFO AREA Field Name TN Description Previous Social Security Number

Staff member’s Social Security Number as previously reported if different than current Social Security Number. See also Staff Name, SSN and License Number Changes.



STAFF INFO AREA Field Name TN Description Previous License Number

Staff member’s teacher license number as previously reported if different than current teacher license number. See also Staff Name, SSN and License Number Changes.

Licensure Check Reason the staff member might not be located in an educator licensure search. See lookup table K12.Staff.Licensure_Check.

Staff Screen – Schools Tab

Figure 2-2 - Staff Screen – Schools Tab

ASSIGNMENT DETAILS (STAFF SCHOOL ASSIGNMENTS DETAIL SCREEN) Fields are visible using Show Detail.

Field Name TN Description FTE Employment status of the staff member within a school (expressed in format 0.00).

Note: If blank, the staff member is assumed to be full-time for extract reporting.

DEFAULT SUPPORT TYPE GRID (STAFF SCHOOL ASSIGNMENTS DETAIL SCREEN) Fields are visible using Show Detail. Field Name TN Description Support Type Assignment or position held by staff member within a school. Begin Date First day of staff member’s school level assignment.

End Date Final day of staff member’s school level assignment.



DISTRICT WIDE SUPPORT TYPE GRID Field Name TN Description Support Type Assignment or position held by staff member within the district. See lookup table

K12.Staff.Support_Type.

Begin Date First day of staff member’s school level assignment. End Date Final day of staff member’s school level assignment.

Staff Name, SSN and License Number Changes

If a staff member’s name, SSN, or teacher license number changes after sending to TDOE, the original information should be recorded in a designated field to ensure that subsequent state reporting accurately identifies the staff member.

Change Staff Name, SSN, or License Numbers

1. Navigate to Synergy SIS > Staff > Staff. 2. On the General tab in the Staff Info area, record the numbers already sent to TDOE in

the Previous Social Security Number and Previous License Number fields.

3. In the same area, record the new numbers in the Social Security Number and Teacher / Administrator License Number fields.

4. On the General tab in the Former Names area, record the names already sent to TDOE.

5. Use Edit Staff Data to change the staff member’s current name.

6. Click Save.

Add a School-Specific Staff Assignment

1. Navigate to Synergy SIS > Staff > Staff. 2. Find the staff record.

3. Click the Schools tab.

4. In the Staff School Assignments grid, highlight an assignment line.

5. Click Show Detail to open the Staff School Assignment Details screen.

6. In the Default Support Type grid, click Add to a new support line.

7. Complete the school support fields.

8. Click Save.

Note: When a staff assignment ends, record an End Date rather than delete the assignment.

Add a District-Wide Staff Assignment

1. Navigate to Synergy SIS > Staff > Staff.



2. Find the staff record.

3. Click the Schools tab.

4. In the District Wide Support Type grid, click Add to add a new support line.

5. Complete district support fields.

6. Click Save.

Note: When a staff assignment ends, record an End Date rather than delete the assignment.

STUDENT DATA The Student screen collects much of the student information required for TDOE reporting.

Reference: For more information about managing student data, see Synergy® SIS Student Information User Guide.

Student Screen

The Student screen contains fields customized for TDOE reporting. This section describes data collected by the customized fields.

Student Screen – Demographics Tab

Figure 2-3 - Student Screen – Demographics Tab

STUDENT INFORMATION AREA Field Name TN Description Previous Last Name Student’s last name as previously reported if different than current last name. See

also Student Name, SSN, and PIN Changes.



STUDENT INFORMATION AREA Field Name TN Description Previous First Name Student’s first name as previously reported if different than current first name. See

also Student Name, SSN, and PIN Changes.

Previous Middle Name Student’s middle name as previously reported if different from current middle name. See also Student Name, SSN, and PIN Changes.

Mother’s Maiden Name Original surname of female parent. Birth County Student’s county of birth. Options are based on selection in the Birth State field.

See lookup table Revelation.County.

Student Screen – Other Info Tab

Figure 2-4 - Student Screen – Other Info Tab

OTHER INFORMATION AREA Field Name TN Description Previous SSN Student’s Social Security Number as previously reported if different than current

Social Security Number. See also Student Name, SSN, and PIN Changes.



OTHER INFORMATION AREA Field Name TN Description PIN Student’s unique identifier provided by the school if the student’s Social Security

Number is not available.

Previous PIN Student’s unique school-assigned identifier as previously reported if different than current PIN. See also Student Name, SSN, and PIN Changes.

TRANSPORTATION AREA Field Name TN Description Estimated Mileage Estimated number of miles the student is transported one way to school or from

school.

PICK UP INFORMATION AREA Field Name TN Description Bus Number Bus number the student rides in the morning (AM bus).

DROP OFF INFORMATION AREA Field Name TN Description Bus Number Bus number the student rides in the evening (PM bus).



Student Screen – Enrollment Tab

Figure 2-5 - Student Screen – Enrollment Tab

ENROLLMENT ACTIVITY AREA Field Name TN Description Standard Day Minutes Number of instructional minutes per school day for a specific student.

Completed only when the Standard Day Minutes Per Day (or value of instructional minutes per day for all students in a particular grade level) is not applicable for the student (for example, student is part-time).

Course of Study Course of study for the student’s enrollment. See lookup table K12.Enrollment.Course_Of_Study.

OTHER ENROLLMENT INFORMATION AREA Field Name TN Description US School Entry Date Date on which a student who immigrated to the United States first enrolled in a U.S.

school. If this field is not visible, see Enable Extended Student Enrollment Fields.



Student Name, SSN, and PIN Changes

If a student’s name, SSN, or PIN changes after sending to TDOE, the original information should be recorded in a designated field to ensure that subsequent state reporting accurately identifies the student.

Figure 2-6 - Student Screen – Demographics Tab – Student Information Area

Figure 2-7 - Student Screen – Other Info Tab – Other Information Area

Change Student Name, SSN, or PIN

1. Navigate to Synergy SIS > Student > Student. 2. On the Demographics tab in the Student Information area, record the student name

already sent to TDOE in the Previous Last Name, Previous First Name, or Previous Middle Name fields.

3. Use Edit Student Data to change the student’s current name.

4. On the Other Info tab in the Other Information area, record the student SSN or PIN already sent to TDOE in the Previous Social Security Number or Previous Student PIN field.

5. In the same area, record the new student SSN or PIN in the Social Security Number or Student PIN field.



6. Click Save.

Student Course Quality Points

The Student Course History screen collects the Quality Point value for a course completed by a student.

Caution: For TDOE reporting on Extract 080-Student Final Grade, the Quality Point value is subtracted from the student Mark. In this example, the Mark of 98 appears on student report cards and transcripts, but extract 080 reports a Quality Point of 3 and a Numeric Grade of 95 (98 – 3).

Figure 2-8 - Student Course History Screen – Course History Tab

Define Quality Points for a Course Completed by Student

1. Navigate to Synergy SIS > Course History > Student Course History.

2. Find the student record.

3. On the Course History tab in the Courses grid, highlight a record.

4. Click Show Detail to open the Courses detail screen.

5. On the Student Course Information tab in the Course Information area, type a numeric value in the Quality Point field.

6. Click Save.



School Choice for Transfer Students

The Tennessee Department of Education collects information about school choice for student transfers within the public education system.

Indicate School Choice Status for a Transfer Student

Figure 2-9 - Student Screen – Enrollment Tab


3. On the Enrollment History tab in the Enrollment history grid, click the Enter Date link for an enrollment line to open the Enrollment History screen.

4. On the Options tab in the School Information area, select an option in the School Choice Status field (see lookup table K12.Enrollment.School Choice Status).

5. Click Save.

STUDENT CLASSIFICATIONS The screens in Synergy SIS Student Programs are used to assign students to the state-defined student classifications for TDOE reporting.

Assign a Classification to a Student

To assign a state-defined Student Classification to a student, use the Student Needs Screen as described in Assign a Need/Program to a Student.

Note: Refer to Homeless Classification and Free and Reduced Lunch Classifications to see how their assignment differs from other student classifications.



Homeless Classification

The Homeless student classification differs slightly from other classifications in that additional student information can be recorded.

Student Needs Screen for the Homeless Student Classification

On the Student Needs Screen, the Needs Detail screen is customized to collect additional information when a student is assigned the homeless classification.

Figure 2-10 - Student Needs Screen – Needs Detail Screen for Homeless Classification

NEEDS DETAIL GRID FOR THE HOMELESS CLASSIFICATION Fields are visible using Show Detail for the Homeless classification. Field Name TN Description Nighttime Residence Residence for the homeless student at time of enrollment or when the student was

identified as homeless. See lookup table K12.ProgramInfo.Nighttime_Residence. Service by McKinney Vento

Selected checkbox indicates the student is or was served by federal McKinney-Vento funds at any time during the school year.

Unaccompanied Youth Selected checkbox indicates the student is not living with a parent or guardian.

Assign Student to Homeless Classification and Nighttime Residence Code

1. Navigate to Synergy > Student Programs > Student Needs.


3. In the Add area in the Needs field, select the Homeless classification.

4. Click Add New Need to add the homeless classification to the Needs grid.

5. In the Needs grid, highlight the homeless classification line.

6. Click Show Detail to open the Student Needs Screen for the Homeless Student Classification.



7. On the Detail tab, complete the fields.

8. Click Save.

Free and Reduced Lunch Classifications

The lunch related student classifications differ slightly from other classifications in that they are assigned from the Free and Reduced Meals screen in Student Programs.

Figure 2-11 - Student Programs – Free and Reduced Meals Screen

Assign Student to a Free or Reduced Lunch Classification

1. Navigate to Synergy SIS > Student Programs > Free and Reduced Meals.


3. On the FRM tab in the Free and Reduced Meals grid, click Add to add a grid line.

4. Complete the grid line fields and then click Save.

Note: If a student is not assigned a free or reduced lunch classification, then the student is assumed to have the classification for paid (full price) lunch.

SUPPLEMENTAL EDUCATION SERVICES (SES) To assign supplemental education services (SES) to a student, use the Student Needs Screen as described in Assign a Need/Program to a Student.

TA SUPPORT SERVICES To assign TA Support Services to a student, use the Student Needs Screen as described in Assign a Need/Program to a Student.

TA INSTRUCTIONAL SERVICES Students are identified as providing TA instructional assistance when they are designated as a teacher’s aide in a class that was set up with a TA instructional services code.



Designate Student as Class Teacher Aide

Figure 2-12 - Student Screen – Classes Tab

1. Navigate to Synergy SIS > Student > Student. 2. On the Classes tab in the Class Schedule grid, select the Teacher Aide checkbox for

any class in which the student provides TA assistance.

3. Click Save.

STUDENT PROGRAMS The screens in Synergy SIS Student Programs are used to assign and manage student participation in various programs and services.

Student Needs and Programs

In Student Programs, the Student Needs screen associates students with needs and identifies participation in need-related programs. For TDOE reporting, use this screen to assign students to:

• Student Classifications

• Supplemental Education Services (SES)

• TA Support Services



Student Needs Screen

Figure 2-13 - Student Needs Screen – Needs Tab – Needs Detail Screen

ADD AREA Field Name TN Description Needs Description of a student need or student classification.

HISTORY GRID (NEEDS DETAIL SCREEN) Fields are visible using Show Detail.

Field Name TN Description Enter Date Date on which student entered the program or service associated with a specified

need or classification. Exit Date Date on which student existed the program or service associated with a specified

need or classification.

Exit Reason Reason for the student’s exit from the program or service association with a specified need or classification.

Receiving Sch CTDS N/A

Assign a Need/Program to a Student

1. Navigate to Synergy SIS > Student Programs > Student Needs.


3. On the Needs tab in the Add area, select a need or classification.

4. Click Add New Need to open the Student Program Add screen.



5. Complete the screen fields and then click Save Program.

6. In the Needs grid, highlight a need and then click Show Detail to open the Needs Detail Screen.

Note: See also Student Needs Screen for the Homeless Student Classification.

7. Edit or add more information for the highlighted need.

8. Click Save.



English Language Learners

In Student Programs, the English Language Learners screen is used to associate students with English language background (ELB) codes for TDOE reporting.

Assign ELB Codes to Students

Figure 2-14 - English Languages Learners Screen – ELL Tab

1. Navigate to Synergy SIS > Student Programs > Setup > English Language Learners.


3. On the ELL tab in the ELL Status area, select an option in the Program field. (See lookup table K12.ProgramInfo.Ell_Program_Code.)

4. Click Save.

Free and Reduced Meals

In Student Programs, the Free and Reduced Meals screen is used to assign lunch related classifications to students as described in Assign Student to a Free or Reduced Lunch Classification.

STUDENT CLUBS In Synergy SIS, schools use the Student Groups screens to assign students to state-defined clubs.

Reference: For information about assigning students to clubs and groups, see Synergy® SIS Student Groups User Guide.

Tennessee State Reporting Guide Chapter Three


Chapter Three : STATE REPORTING SETUP


► Introduction

► Critical Extract Error Notification

► Data Exclusions

Chapter Three Tennessee State Reporting Guide


INTRODUCTION This chapter describes information to review prior to running state extracts and reports.

CRITICAL EXTRACT ERROR NOTIFICATION Before submitting TDOE extracts, see how to Specify Email Address for Critical Extract Error Notifications.

DATA EXCLUSIONS Before submitting TDOE extracts or running Tennessee reports, verify that specific types of data have been included or excluded as required for TDOE reporting.

• Exclude a School from State Reporting

Schools are included in state reporting unless marked for exclusion.

• Include an Attendance Code in State Reporting

Attendance codes are not included in state reporting unless marked for inclusion.

• Include an Offense Code (Violation) in State Reporting

Offenses (and their associated disciplinary actions) are not included in state reporting unless marked for inclusion.

• Include a Disciplinary Action Code (Disposition) in State Reporting

Disciplinary actions are not included in state reporting unless marked for inclusion.

• Exclude a District Course from State Reporting

District courses are included in state reporting unless marked for exclusion.

• Exclude a School Course (Section) from State Reporting

Sections are included in state reporting unless marked for exclusion.

• Exclude a Need/Program from State Reporting

Classifications, services, and programs are included in state reporting unless marked for exclusion.

• Exclude a Staff Member from State Reporting

Staff members are included in state reporting unless marked for exclusion.

Tennessee State Reporting Guide Chapter Three


• Exclude a Student from Funding Calculations (ADA/ADM/ADT)

Students are included in state reporting unless marked for exclusion.

• Exclude a Student from State Reporting

Students are included in state reporting unless marked for exclusion.

Chapter Four Tennessee State Reporting Guide


Chapter Four : TENNESSEE REPORTS


► Introduction

► ATD626 – 200 Day Accountability Report ► ATD627 – Director’s Membership and Attendance Report ► ATD628 – Director’s Vocational Class FTEADA Report ► ATD629 – Director’s Vocational Class FTEADM Report ► ATD630 – End of Month Membership Report ► GRD605 – Roster of Graduates

► GRD606 – Promotions and Retentions Report ► IDS606 – Discipline Report ► STU606 – Net Enrollment Report ► STU607 – Report of 12th Graders

► STU610 – Dropout Report ► STU819 – Electronic Transcript ► TRN600 – Transportation ADT Report

Tennessee State Reporting Guide Chapter Four


INTRODUCTION This chapter describes the Tennessee-specific reports available in Synergy. It also describes the settings and filters on the Report Interface Options tab.

Reference: For more information about other Report Interface tabs, see Synergy® SIS Query & Reporting Guide.

Tennessee reports are located at Synergy SIS > TN > Reports.

• Focus – When a report is run from School Focus, the report prints for the school. When a report is run from District Focus, the report prints for each school separately and then prints for all schools combined.

• Concurrency – Concurrently enrolled students are counted only in their primary school and not in schools where they receive partial services (unless otherwise noted).

• Ethnicity/Race – Where data is reported by ethnicity and race, students are counted only once (unless otherwise noted). Hispanic students are counted as Hispanic. Non-Hispanic students with a single race designation are counted in their specified race. Non-Hispanic students with more than one race designation are counted as multi-racial.

• Report Periods – For reports that can be filtered by Report Period on the RI, when a report is run from School Focus, period begin and end dates appear based on periods calculated for the school. When a report is run from District Focus, dates do not appear because schools within the district might have different period begin and end dates. For more information about how reporting periods are calculated, see School Calendars and Reporting Periods.

School Focus District Focus

Figure 4-1 - Tennessee Report Interface – Report Period Field



ATD626 – 200 DAY ACCOUNTABILITY REPORT The 200 Day Accountability Report runs for districts to review district calendar information submitted to TDOE for approval.

ATD626 Report Interface Options

Report data can be filtered using selections on the Options tab.

Figure 4-2 - Tennessee 200 Day Accountability Report – Options Tab

Field Name TN Description Calendar Type Filters report by selected calendar. Leave blank to include all calendars (a separate

report prints for each calendar type).

As Of Date Filters report by dates up to and including the specified date.



ATD626 Report Sample

Figure 4-3 - ATD626 Report Sample



ATD627 – DIRECTOR’S MEMBERSHIP AND ATTENDANCE REPORT The Director’s Membership and Attendance Report counts enrolled students and calculates Average Daily Attendance (ADA) and Average Daily Membership (ADM).



Figure 4-5 - Tennessee Membership and Attendance Report Interface – Options Tab

Field Name TN Description Report Period Filters report by selected period or range.

Begin Date – End Date Filters report by specified date range (if no Report Period selected). Grades to Include Filters report by selected grade levels. Sort Grades By Sorts grade levels on the report by selected option.





Report Field TN Description Grade Student grade level. Net Enrollment to Date Number of students with an enrollment reason of E, E1, or EC who had an active

primary enrollment at any time in the selected reporting range.

End of Month Membership

Number of students with an active primary enrollment on the last day of the selected reporting range.

Average Daily Attendance

Total Average Daily Attendance (ADA) for students with an active enrollment in the selected reporting range. See Troubleshooting ADA/ADM for more information.

Note: A student can achieve a maximum of 1.0 ADA. If a student is calculated to have greater than 1.0 ADA (for example, the student is overscheduled), the student will be reported as 1.0000 in this column.

Average Daily Membership

Total Average Daily Membership (ADM) for students with an active enrollment in the selected reporting range. See Troubleshooting ADA/ADM for more information.

Note: A student can achieve a maximum of 1.0 ADM. If a student is calculated to have greater than 1.0 ADM (for example, the student is overscheduled), the student will be reported as 1.0000 in this column.



Troubleshooting ADA/ADM

This section provides tips for troubleshooting ADA/ADM.

Audit File Review

• Enrollment Dates: Students must be enrolled each day in the reporting range to achieve 1.0 ADM.

• Standard Day: The student’s standard day must not be greater than his or her scheduled minutes to achieve 1.0 ADM.

• Scheduled Minutes: The student’s scheduled minutes must be equal to or greater than the student’s standard day (meaning the student is fully scheduled) to achieve 1.0 ADM.

• Expulsion: Students must not be expelled for any day in the reporting range to achieve 1.0 ADM.

Data Exclusions

Check that data has not been excluded from state reporting (see Data Exclusions).

TDOE EIS Error Review

Review EIS error logs for errors that might prevent a student from generating ADA/ADM.

In particular when the Synergy ADA/ADM is higher than TDOE ADA/ADM, it is possible that TDOE has not received valid information for a student, staff member, or class. For example, if a course is missing a valid State Course Code or the Defined Class Type for a section is not accurate, students in the class might not generate ADA/ADM.



ATD628 – DIRECTOR’S VOCATIONAL CLASS FTEADA REPORT The Director’s Vocational Class FTEADM Report calculates the Full Time Equivalent Average Daily Attendance for students in designated CTE courses.



Figure 4-7 - Tennessee Vocational Class FTEADA Report Interface – Options Tab

Field Name TN Description Report Period Filters report by selected period or range. Begin Date – End Date Filters report by specified date range (if no Report Period selected).





Report Field TN Description Columns 1- 4 FTEADA/FTEADM per specified grade level for students with a primary enrollment in

the reporting district.

Note: This includes students in CTE classes taught by the reporting district (funded FTEADA/FTEADM), taught by a Tennessee Technology Center (funded FTEADA/FTEADM), or taught by another district (unfunded FTEADA/FTEADM).

Column5 Total FTEADA/FTEADM for all grade levels (sum of columns 1-4) for students with a primary enrollment in the reporting district.

Column 6 FTEADA/FTEADM that is coming from, and going to, another district.

• FTEADA/FTEADM is added when students from another district take CTE courses in the reporting district.

• FTEADA/FTEADM is subtracted when students from the reporting district take CTE courses in a different district.

Column 7 Net District FTEADA/FTEADM (Column 5 – Column 6 = Net).



ATD629 – DIRECTOR’S VOCATIONAL CLASS FTEADM REPORT The Director’s Vocational Class FTEADM Report calculates the Full Time Equivalent Average Daily Membership for students in designated CTE courses.



Figure 4-9 - Tennessee Vocational Class FTEADM Report Interface – Options Tab






Report Field TN Description Columns 1- 4 FTEADA/FTEADM per specified grade level for students with a primary enrollment in

the reporting district.

Note: This includes students in CTE classes taught by the reporting district (funded FTEADA/FTEADM), taught by a Tennessee Technology Center (funded FTEADA/FTEADM), or taught by another district (unfunded FTEADA/FTEADM).

Column5 Total FTEADA/FTEADM for all grade levels (sum of columns 1-4) for students with a primary enrollment in the reporting district.

Column 6 FTEADA/FTEADM that is coming from, and going to, another district.

• FTEADA/FTEADM is added when students from another district take CTE courses in the reporting district.

• FTEADA/FTEADM is subtracted when students from the reporting district take CTE courses in a different district.

Column 7 Net District FTEADA/FTEADM (Column 5 – Column 6 = Net).



ATD630 – END OF MONTH MEMBERSHIP REPORT The End of Month Membership Report counts the number of students who had an active primary enrollment on the last day of the selected reporting range.

For example, if the report is run for a period that ends on April 21:

• A student whose last day was April 22 is included in membership.

• A student whose last day was April 20 is not included in membership.

• A student who enrolled on April 21 is included in membership.



Figure 4-11 - Tennessee End of Month Membership Report Interface – Options Tab

Field Name TN Description Report Period Filters report by selected period or range. Report Date Filters report to include only the specified date (if no Report Period selected). Grades to Include Filters report by selected grade levels. Completed By Name of individual printed on the report. Leave blank to print name of current user.

Phone Number Phone number of individual printed on the report. Leave blank to omit phone number.



GRD605 – ROSTER OF GRADUATES The Roster of Graduates Report identifies students who receive a completion document during the school year.

Note: To appear on the report, students must have a Graduation Date, Graduation Semester, and Diploma Type on the Student Screen – Other Info tab.

GRD505 Report Interface Options


Figure 4-13 - Tennessee Roster of Graduates Report Interface – Options Tab

Field Name TN Description Completion Document Filters report by selected completion documents. Completion Period Filters report by selected completion periods.



GRD505 Report Sample

Figure 4-14 - GRD605 Report Sample



GRD606 – PROMOTIONS AND RETENTIONS REPORT The Promotions and Retentions Report counts the number of students with a Year End Status of promoted or retained. It also counts students as promoted if they have a Graduation Date, Graduation Semester, and Diploma Type on the Student Screen – Other Info Tab.

GRD606 Report Interface Options


Figure 4-15 - Tennessee Promotions and Retentions Report Interface – Options Tab

Field Name TN Description As Of Date Filters report by dates up to and including the specified date. Include Summer School Enrollments

Filters report to include dates through the end of summer school.

Select Students Filters report by selected students:

• All Students Except CDC Option 7,8,9 • Special Ed Including CDC Option 7,8,9

Grades to Include Filters report by selected grade levels. Sort Grades By Sorts grade levels on the report by selected option.



GRD606 Report Sample

Figure 4-16 -GRD606 Report Sample



IDS606 – DISCIPLINE REPORT The Discipline Report counts the number of students with incidents that resulted in TDOE Disciplinary Actions of state code E, R, S, or I.

• Students are counted only once per incident based on the disposition with highest severity. For example, if an incident results in a student’s suspension and expulsion, where the expulsion has a higher severity, the student counts as an expulsion only. However, if a student is involved in two separate incidents that both resulted in a suspension, the student counts twice in suspensions.

• Students are counted only once per incident based on the violation with the highest severity. For example, if a student is suspended for fighting and bullying where fighting has the higher severity, the student will be counted for fighting only.

IDS606 Report Interface Options


Figure 4-17 -Tennessee Discipline Report Interface – Options Tab

Field Name TN Description Report Period Filters report by selected period or range. Print Report by Grade Selected option prints report Section 1 – Incident Counts by Ethnicity/Race and

Grade with a page for each TDOE disposition.

Print Report by Cause Selected option prints report Section 2 – Incident Counts by Cause and Ethnicity/Race with a page for each TDOE disposition.

Print Summary Selected option prints report Section 3 – Incident Counts by Ethnicity/Race with a single page summary of TDOE disposition counts.

Grades to Include Filters report by selected grade levels.



IDS606 Report Sample

The IDS606 Discipline Report has three sections.

Section 1 – Incident Counts by Ethnicity/Race and Grade

This section of the report has the following headings based on the State Codes used:

• State Code E – Incidents of Expulsion by Grade

• State Code S – Incidents of Suspensions by Grade

• State Code I – In-School Suspensions by Grade

• State Code R – Long Term Changes of Placement by Grade

Figure 4-18 - IDS606 Report, Section 1 Sample



Section 2 – Incident Counts by Cause and Ethnicity/Race


• State Code E – Incidents of Expulsion by Cause

• State Code S – Incidents of Suspensions by Cause

• State Code I – In-School Suspensions by Cause

• State Code R – Long Term Changes of Placement by Cause

Figure 4-19 -IDS606 Report, Section 2 Sample



Section 3 – Incident Counts by Ethnicity/Race and Disciplinary Action


• State Code E – Expelled

• State Code S – Incidents of Suspensions

• State Code I – In-School Suspensions

• State Code R – Long Term Changes of Placement

Figure 4-20 - IDS606 Report, Section 3 Sample



STU606 – NET ENROLLMENT REPORT The Net Enrollment Report counts the number of students with an enrollment reason of E, E1, or EC who had an active primary enrollment at any time in the selected reporting range. Students with other enrollment reasons do not count in net enrollment.

For example, if the report is run for a period that spans March 24 to April 21:

• An E student who was inactivated on March 24 is included in net enrollment.

• An E1 student who enrolled on April 21 is included in net enrollment.

• A TR student who was enrolled all days from March 24 to April 21 is not included in net enrollment.

Note: Summer withdrawal students are not counted in net enrollment even if they had E, E1, or EC prior to being No Showed.

STU606 Report Interface Options


Figure 4-21 - Tennessee Net Enrollment Report Interface – Options Tab

Field Name TN Description Report Period Filters report by selected period or range. Report Date Filters report by dates up to and including the specified date (if no Report Period

selected).

Grades to Include Filters report by selected grade levels. Completed By Name of individual printed on the report. Leave blank to print name of current user.



Field Name TN Description Phone Number Phone number of individual printed on the report. Leave blank to omit phone

number.

STU606 Report Sample

Figure 4-22 - STU606 Report Sample



STU607 – REPORT OF 12TH GRADERS The Report of 12th Graders counts the number of students in grade level 12 by completion document.



Figure 4-23 - Tennessee Report of 12th Graders Report Interface – Options Tab

Field Name TN Description As Of Date Filters report by dates up to and including the specified date. Select Students Filters report by selected students:

• All Students

• Special Ed Students Only





STU610 – DROPOUT REPORT The Dropout Report counts the number of students who left the school with a withdrawal code of 00 (dropout under 18) or 01 (dropout over 18).



Figure 4-25 - Tennessee Dropout Report – Options Tab

Field Name TN Description Report Period Filters report by selected period or range.

Begin Date – End Date Filters report by specified date range (if no Report Period selected). Include Dropouts Under 18

Selected option includes students with TDOE withdrawal code 00.

Include Dropouts 18 and Older

Selected option includes students with TDOE withdrawal code 01.

Grades to Include Filters report by selected grade levels.



STU819 – ELECTRONIC TRANSCRIPT STU819 Report Interface Options


Note: Line 1 and 2 of the Grading Summary grid must be defined for the student on the Student Course History screen, GPA tab.

Figure 4-27 -Electronic Transcript Report – Options Tab

Field Name TN Description Transcript Option Filters the type of transcript to print

Perm ID Filters report by specified student permanent ID Grade Filters report by specified grade Counselor Filters report by specified counselor




Figure 4-28 -STU819 Electronic Transcript Sample

TRN600 – TRANSPORTATION ADT REPORT The Transportation ADT Report counts the number students designated as bus riders and calculates ADT (Average Daily Transported) for students that quality for transportation funding.

Note: To qualify for transportation funding, students must have an estimated mileage of 1.5 or greater or they must ride a specially equipped bus regardless of mileage.

TRN600 Report Interface Options


Figure 4-29 -Tennessee Transportation ADT Report Interface – Options Tab




TRN600 Report Sample

Figure 4-30 -TRN600 Report Sample

Report Field TN Description Bus Enrollment YTD Count of students assigned to a bus and had an active enrollment for any portion of

the school year. Students who ride an AM or PM bus count as 0.50 in the designated column.

Bus Enrollment Total for Period

Count of students who are assigned to a bus and had an active enrollment for any portion of the selected reporting period. Students who ride an AM or PM bus count as 0.50 in the designated column.

Bus Enrollment 1.5 Miles or Greater for Period

Count of students who qualify for transportation funding and had an active enrollment for any portion of the selected reporting period. Students who ride an AM or PM bus count as 0.50 in the designated column.

Attendance for Transportation

Days present for students who qualify for transportation funding and had an active enrollment for any portion of the selected reporting period. Students who ride an AM or PM bus receive 0.50 in the designated column for each day they are considered present for transportation.

ADT Total Average Daily Transported (ADT) for students who qualify for funding and had an active enrollment in the selected reporting range.

Chapter Five Tennessee State Reporting Guide


Chapter Five : TENNESSEE EXTRACTS


► Introduction

► Extract Submission

► Extract Data Preview

► TDOE Extract Field Locations in Synergy SIS

Tennessee State Reporting Guide Chapter Five


INTRODUCTION This chapter describes how to work with TDOE extracts.

EXTRACT SUBMISSION This section describes how extracts are submitted to TDOE.

State Submission Screen

Use the State Submission screen to monitor TDOE extract submissions.

Figure 5-1 - State Submission Screen – Submission Process Tab

STEP 1: DATA GENERATION AREA Field Name Description Select Which Extract(s) to Generate

Available TDOE extracts and extract groups.

Includes Extracts List of currently selected extracts.



STEP 1: DATA GENERATION AREA Field Name Description Resend Data Selected checkbox indicates an extract will be created to resend data. See

Resending Extract for more information

STEP 2: REVIEW/SUBMISSION AREA – PENDING SUBMISSIONS GRID Field Name Description Date/Time Generated Date and time the extract file is generated in Synergy. File Name System-assigned name of extract file per TDOE naming convention. Pending File Click icon to open the extract file in a text editor. Submit File Sends extract file to TDOE. See Resending Extract for more information

Mark as Submitted N/A

STEP 2: REVIEW/SUBMISSION AREA – SUBMITTED FILES GRID Field Name Description Submission Date Date the extract submitted to TDOE. File Name Name of extract file submitted to TDOE. Submitted File Click icon to open the extract file in a text editor.

Automatic Extract Submission

Configure Synergy SIS to submit extracts automatically at regular intervals specified by TDOE.

To enable or disable Automatic Submissions:

1. Navigate to Synergy SIS > TN > State Submission.

2. On the Submission Process tab in the Automatic Submission area:

• To enable, click Enable Automatic Submissions

• To disable, click Disable Automatic Submissions



Figure 5-2 - State Submission screen

3. In the Auto Submission Status field, verify the status.

4. Click Save.

NOTE: The job displays in Synergy SIS > System > Job Queue > Job Q Adm Viewer with the Pending icon in the State column.

Resending Extract

Note: Resent extracts are picked up by TDOE during regularly scheduled extract processing.

Extracts are not typically resent because relevant data changes in Synergy are captured as New, Edit, or Delete records in automated extract submissions. However, if Synergy and TDOE become out-of-sync for any reason, extract records can be resent.

• Before resending data, check TDOE EIS error logs as it is possible that data has been submitted, but errors are preventing records from being stored or approved.

• Generate and submit files to the state one at a time.

NOTE: Each file is generated with the same file name. If more than one file is generated without submitting to the state, the state pulls the record with the most recent time stamp.



Figure 5-3 - State Submission Screen with Resend Data – Submission Process Tab



To resend an extract:


2. In the Step 1: Data Generation area, select an extract from the Select Which Extract(s) to Generate drop down.

3. Click Resend Data to open the Filters area.

4. Use Chooser to narrow the extract records by school, student, staff or class.

5. Click Generate Extract(s). 6. In the Step 2: Review / Submission area, review the Pending Submissions grid for

the file to be submitted.

Figure 5-4 - State Submission, Pending Submissions

7. Click Pending File to open the extract in a text editor and verify it has the expected records.

8. Click Submit File to send the extract file to the TDOE FTP server.

Notes:

• The extract file moves to the Submitted Files grid.

• Once a file is submitted the record cannot be deleted.

Submitted Extracts

Extracts created by the automatic submission process or a resend procedure can be viewed after submission.

To view submitted extracts:




2. Under Step 2: Review / Submission, find an extract in the Submitted Files grid.

3. In the Submitted File column, click the icon to open or save the extract file.

Errors with Submitted Extracts

Clearing Hung Jobs

In the event a server outage occurs, clear any hung Daily Extract jobs from the Job Queue. This applies to both the scheduled Daily submissions and data being resent. Review the Job Queue the morning after any reported server outages and clear any pending jobs.

Figure 5-5 - Extract Error Message

To clear this error:

1. Navigate to Synergy SIS > System > Job Queue > Job Q Adm Viewer. 2. In the Job ID field enter Daily and click Filter. 3. In the Jobs in Queue grid, click the Result icon in the Results column. The progress

window displays:

Figure 5-6 - Job Q Adm Viewer screen

4. Click Abort.



Figure 5-7 - Job Status screen

5. Click the box in the delete column to delete the job from the Job Queue.

6. Click Save.

7. Navigate to Synergy SIS > TN > State Submission and verify that the Auto Submission Status reads as Enabled.

Figure 5-8 - State Submission screen

NOTE: Once all hung jobs are removed, Daily Submissions run from the State Submission screen without error.

EXTRACT DATA PREVIEW Use the State Reporting Extracts screen to preview or troubleshoot extract data without submitting the extract to TDOE.

For example, a district might preview extract data to look for potential issues that could result in submission errors at TDOE (like missing data elements). Or a district might run an extract



outside of the submission process to determine which records or data elements are getting included or excluded.

State Reporting Extracts Screen

Figure 5-9 - State Reporting Extracts Screen – Extract Tab

Field Name TN Description Extract Name Available TDOE extracts.

SETTINGS AREA Field Name TN Description Log Type Type of log file that accompanies an extract. Extract File Type Type of extract file generated. Column Header Options Type of header for extract data columns.

FILTER GROUP OPTIONS AREA Field Name TN Description Filter Group User-defined groups of schools, students, staff, or sections that can be used to limit

the data set for an extract created for review. See Filter Groups for more information



ADDITIONAL FILTERS AREA Organizations Use Chooser to limit the extract to selected schools. Students Use Chooser to limit the extract to selected students. Staff Use Chooser to limit the extract to selected staff. Section Use Chooser to limit the extract to selected classes.

Creating an Extract For Review

This procedure creates the extract for data review but does not submit the extract.

1. Navigate to Synergy SIS > TN > State Reporting Extracts.

2. On the Extract tab in the Extract Name field, select an extract.

3. Complete the screen fields as needed.

4. Click Create.

Note: Depending on selected settings, either the Job Result screen or the extract opens.

5. On the Job Result screen in the Job Results Files grid, click the icon in the Result field to open the extract.

Viewing History of Extracts Created For Review

This procedure enables users to see extracts created for review only.

Note: To view extracts submitted to TDOE, see To view submitted extracts.

1. Navigate to Synergy SIS > TN > State Reporting Extracts.

2. On the History tab in the Extract History grid, find the extract.

3. Click the icon in the Download field to open an extract file for review.



Filter Groups

Filter groups are selected groups of schools, students, staff, or classes that can be used to limit the data in an extract created for review.

Creating a Pre-Defined Filter Group Definition

1. Navigate to Synergy SIS > TN > Setup > Filter Group Definition.

2. Click Add to open the Add Filter Group Definition screen.

3. Complete the screen fields and then click Save.

4. In the Organizations grid, use Chooser to add selected schools to the filter.

5. In the Students grid, use Chooser to add selected students to the filter.

6. In the Staff grid, use Chooser to add selected staff members to the filter.

7. In the Section grid, use Chooser to add selected classes to the filter.

8. Click Save.

Creating a Filter Group Definition During Extract Review

This procedure occurs while creating an extract for review:

1. In the Organizations grid, use Chooser to add selected schools to the filter.

2. In the Students grid, use Chooser to add selected students to the filter.

3. In the Staff grid, use Chooser to add selected staff members to the filter.

4. In the Section grid, use Chooser to add selected classes to the filter.

5. In the Filter Group Options area, select Create New Filter Group.

6. In the New Filter Group Name field, type a name for the filter.

Note: After the extract is created, the filter is available for future selection.



TDOE EXTRACT FIELD LOCATIONS IN SYNERGY SIS This section provides the Synergy SIS field locations for data elements in TDOE extracts.

010–200 Day Calendar Extract

Data Element Synergy SIS Location Edupoint BO and Property Lookup Table District ID System > Setup > Organization Screen > District Detail Screen

> District Tab > District Information Area > District Number Field K12.Setup.DistrictSetup.DistrictNumber N/A

School Year Focus Area N/A N/A

Calendar Number CALCULATED FROM:

Attendance > Setup > District Calendar Screen > District Calendar Tab > District Calendar Type Options Area > Calendar Type Field

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.CalType

K12.Setup.Calendar Type

Instructional Calendar CALCULATED FROM:






Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Scheduled Days CALCULATED FROM:

Attendance > Setup > District Calendar Screen > District Calendar Options Tab > District Calendar Options Fields

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.IncMonday

AND

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.IncTuesday

AND

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.IncWednesday

AND

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.IncThursday

AND

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.IncFriday

AND

K12.AttendanceInfo.Setup.AttendanceCalendarOpt.IncSaturday

N/A

Stockpile Inclement Weather Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Stockpile Inclement Weather Days Field

K12.Setup.TN.DistrictCalendarOptions.StockpileInclementWeatherDays

N/A

Stockpile Professional Development Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Stockpile Professional Development Days Field

K12.Setup.TN.DistrictCalendarOptions.StockpileProfessionalDevelopmentDays

N/A

In Service Days TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > In Service Days Field

K12.Setup.TN.DistrictCalendarOptions.InServiceDays N/A

Optional In Service Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Optional In Service Days Field

K12.Setup.TN.DistrictCalendarOptions.OptionalInServiceDays N/A

Parent Teacher Conference Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Parent Teacher Conference Days Field

K12.Setup.TN.DistrictCalendarOptions.ParentTeacherConferenceDays

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Teacher Vacation Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Teacher Vacation Days Field

K12.Setup.TN.DistrictCalendarOptions.TeacherVacationDays N/A

Abbreviated Days TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Abbreviated Days Field

K12.Setup.TN.DistrictCalendarOptions.AbbreviatedDays N/A

Discretionary Teacher Vacation Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Discretionary Teacher Vacation Days Field

K12.Setup.TN.DistrictCalendarOptions.DiscretionaryTeacherVacationDays

N/A

Discretionary In Service Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Discretionary In Service Days Field

K12.Setup.TN.DistrictCalendarOptions.DiscretionaryInServiceDays

N/A

Discretionary Administrative Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Discretionary Administrative Days Field

K12.Setup.TN.DistrictCalendarOptions.DiscretionaryAdministrativeDays

N/A

Discretionary Instructional Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Discretionary Instructional Days Field

K12.Setup.TN.DistrictCalendarOptions.DiscretionaryInstructionalDays

N/A

Discretionary Other Days

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Discretionary Other Days Field

K12.Setup.TN.DistrictCalendarOptions.DiscretionaryOtherDays N/A

Instructional Days TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > Instructional Days Field

K12.Setup.TN.DistrictCalendarOptions.InstructionalDays N/A

011–200 Day Calendar Event Extract

Data Element Synergy SIS Location Edupoint BO and Property Lookup Table District ID System > Setup > Organization Screen > District Detail Screen

> District Tab > District Information Area > District Number Field K12.Setup.DistrictSetup.DistrictNumber N/A






Event Date TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Event Date Field

K12.Setup.TN.DistrictEvent.EventDate N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Event Type TN > Setup > District State Requirements Screen > Options

Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Event Type Field

K12.Setup.TN.DistrictEvent.EventType K12.TN.Event Types

School Day Type TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Instructional Day Field

K12.Setup.TN.DistrictEvent.InstructionalDay N/A

Event Duration TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Event Duration Field

K12.Setup.TN.DistrictEvent.EventDuration

K12.TN.Event Duration

015–District Bus

Data Element Synergy SIS Location Edupoint BO and Property Lookup Table District ID System > Setup > Organization Screen > District Detail Screen >

District Tab > District Information Area > District Number Field K12.Setup.DistrictSetup.DistrictNumber N/A


Bus Number Transportation > Bus Screen > Vehicle ID Field K12.TransportationInfo.Bus.VehicleID N/A

Specially Equipped Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Specially Equipped Field

K12.TransportationInfo.Bus.SpeciallyEquipped N/A

Daily Miles CALCULATED FROM:

Transportation > Bus Screen > Bus Info Tab > Mileage Grid > Daily Mileage Field

K12.TransportationInfo.BusMileage.DailyMileage

N/A

Bus Type Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Bus Type Field

K12.TransportationInfo.Bus.BusType K12.TransportationInfo.Vehicle Type

Year Bus Began Operation

Transportation > Bus Screen > Bus Info Tab > Other Information Area > Year Began Operation Field

K12.TransportationInfo.Bus.YearBeganOperation N/A

Inspected by TN Dept of Safety

Transportation > Bus Screen > Bus Info Tab > Other Information Area > Inspected by State Field

K12.TransportationInfo.Bus.InspectedByState N/A

Privately Owned Transportation > Bus Screen > Bus Info Tab > Other Information Area > Privately Owned Field

K12.TransportationInfo.Bus.PrivatelyOwned N/A

Wheel Chair Lifts Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Special Lift Equipment Field

K12.TransportationInfo.Bus.SpecialLiftEquipment N/A

Commercial Advertising

Transportation > Bus Screen > Bus Info Tab > Other Information Area > Commercial Advertising Field

K12.TransportationInfo.Bus.CommercialAdvertising N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Involved Accident Transportation > Bus Screen > Bus Info Tab > Other Information

Area > Number of Accidents Field K12.TransportationInfo.Bus.NumberOfAccidents N/A

Occupant Restraints Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Occupant Restraints Field

K12.TransportationInfo.Bus.OccupantRestraints N/A

Two Way Communication

Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Two Way Communication Field

K12.TransportationInfo.Bus.TwoWayCommunication N/A

Audio/Video Surveillance

Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Audio/Video Surveillance Field

K12.TransportationInfo.Bus.AudioVideoSurveillance N/A

Type of Fuel Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Fuel Type Field

K12.TransportationInfo.Bus.FuelType K12.TransportationInfo.Fuel Type

GPS System Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > GPS System Field

K12.TransportationInfo.Bus.GpsSystem N/A

Air Conditioning Transportation > Bus Screen > Bus Info Tab > Vehicle Specifications Area > Air Conditioning Field

K12.TransportationInfo.Bus.AirConditioning N/A

020–Instructional Program Extract



School ID System > Setup > Organization Screen > School Detail Screen > School Tab > Other Information Area > State CTDS Code Field

K12.School.StateSchoolCode N/A






Instructional Program Number

CALCULATED FROM:




Instructional Calendar CALCULATED FROM:




Student Day TN > Setup > State Requirements Screen > Options Tab > Student Minutes Per Day Field

K12.Setup.TN.SchoolSetupOptionsTN.StudentMinutesPerDay N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Teacher Day TN > Setup > State Requirements Screen > Options Tab >

Teacher Minutes Per Day Field K12.Setup.TN.SchoolSetupOptionsTN.TeacherMinutesPerDay N/A

School Stockpile Professional Development Days

TN > Setup > State Requirements Screen > Options Tab > Stockpile Professional Development Days Field

K12.Setup.TN.SchoolSetupOptionsTN.StockpileProfessionalDevelopmentDays

N/A

Block Schedule TN > Setup > State Requirements Screen > Options Tab > Block Schedule Field

K12.Setup.TN.SchoolSetupOptionsTN.BlockSchedule N/A

Spring Block Begin Date

TN > Setup > State Requirements Screen > Options Tab > Spring Block Begin Date Field

K12.Setup.TN.SchoolSetupOptionsTN.SpringBlockBeginDate N/A

021–Instructional Program Report Period Extract

Reporting periods consist of 20 successive instructional days where the first reporting period begins on the first instructional day of the school year. See Reporting Periods.







CALCULATED FROM:




Report Period Number

CALCULATED FROM:

Attendance > Setup > School Calendar Screen > School Calendar Tab > School Calendar Area

N/A N/A

Report Period Begin Date

CALCULATED FROM:


N/A N/A

Report Period End Date

CALCULATED FROM:


N/A N/A



022–School Days Extract

School days are determined by both district wide events and school specific events. If a school specific event exists, a district event will not appear on that day.







CALCULATED FROM:




Event Date TN > Setup > State Requirements Screen > Options Tab > School Specific Events Grid > Event Date Field

OR

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Event Date Field

K12.Setup.TN.SchoolEvent.EventDate

OR

K12.Setup.TN.DistrictEvent.EventDate

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Event Type TN > Setup > State Requirements Screen > Options Tab > School

Specific Events Grid > Event Type Field

OR

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Event Type Field

K12.Setup.TN.SchoolEvent.EventType

OR

K12.Setup.TN.DistrictEvent.EventType

K12.TN.Event Types

K12.TN.Event Types

Event Duration TN > Setup > State Requirements Screen > Options Tab > School Specific Events Grid > Event Duration Field

OR

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Event Duration Field

K12.Setup.TN.SchoolEvent.EventDuration

OR

K12.Setup.TN.DistrictEvent.EventDuration



School Day Type TN > Setup > State Requirements Screen > Options Tab > School Specific Events Grid > Instructional Day Field

OR

TN > Setup > District State Requirements Screen > Options Tab > District Calendar Options Area > District Calendar Options Detail Screen > District Wide Events Grid > Instructional Day Field

K12.Setup.TN.SchoolEvent.InstructionalDay

OR

K12.Setup.TN.DistrictEvent.InstructionalDay

N/A



030–Class Section Extract







CALCULATED FROM:




Course Code Course > District Course Screen > Description Tab > State Course Classification Area > State Course Code Field

K12.CourseInfo.Course.StateCourseCode K12.CourseInfo.StateCourseCode

Local Class Number Schedule > Section Screen > Section ID K12.ScheduleInfo.Section.SectionID N/A

Service District ID CALCULATED FROM:

Course > District Course Screen > Course Tab > Other Provider Information Area > Provider ID Field

OR

System > Setup > Organization Screen > District Detail Screen > District Tab > District Information Area > District Number Field

K12.CourseInfo.Course.OtherProviderID

OR

K12.Setup.DistrictSetup.DistrictNumber

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Service School ID CALCULATED FROM:

Course > District Course Screen > Course Tab > Other Provider Information Area > Provider ID Field

OR

System > Setup > Organization Screen > School Detail Screen > School Tab > Other Information Area > State CTDS Code Field

K12.CourseInfo.Course.OtherProviderID

OR

K12.School.StateSchoolCode

N/A

Class Type Schedule > Section Screen > Current Students Tab > State Reporting Area > Defined Class Type Field

K12.ScheduleInfo.Section.DefinedClassType K12.ScheduleInfo.Defined Class Type



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Teaching Method CALCULATED FROM:

Course > District Course Screen > Course Tab > Course InfoArea > Distance Learning Course Field

AND

Course > District Course Screen > Course Tab > Course InfoArea > Online Course Field

AND

Schedule > Section Screen > Current Students Tab > Section Info Area > Distance Learning Field

AND

Schedule > Section Screen > Current Students Tab > Section Info Area > Online Course Override Field

K12.CourseInfo.Course.DistanceLearningCourse

AND

K12.CourseInfo.Course.OnlineCourse

AND

K12.ScheduleInfo.Section.DistanceLearning

AND

K12.ScheduleInfo.Section.OnlineCourseOverride

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Class Begin Date CALCULATED FROM:

Schedule > Section Screen > Current Students Tab > Section Info Area > Term Code Field

AND

System > Setup > School Setup Screen > Basic Info Tab > Term Definition Grid > Term Begin Date Field

K12.ScheduleInfo.Section.TermCode

AND

K12.Setup.SchoolYearTrmDef.BeginDate

N/A

Class End Date CALCULATED FROM:

Course > District Course Screen > Course Tab > Course Info Area > Course Duration Field

AND


AND

System > Setup > School Setup Screen > Basic Info Tab > Term Definition Grid > Term End Date Field

K12.CourseInfo.Course.CourseDuration

AND


AND

K12.Setup.SchoolYearTrmDef.EventDate

N/A

Honors Class Indicator

Course > District Course Screen > Course Tab > Course Info Area > Academic Type Field

K12.CourseInfo.Course.AcademicType K12.CourseInfo.AcademicType

State Dual Credit Course > District Course Screen > Description Tab > State Course Classification Area > Class Indicator Field

K12.CourseInfo.Course.ClassIndicator K12.CourseInfo.Class Indicator



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Local Dual Credit Course > District Course Screen > Description Tab > State Course

Classification Area > Class Indicator Field K12.CourseInfo.Course.ClassIndicator K12.CourseInfo.Class Indicator

Dual Enrollment Course > District Course Screen > Description Tab > State Course Classification Area > Class Indicator Field

K12.CourseInfo.Course.ClassIndicator K12.CourseInfo.Class Indicator

Post-Secondary Institution

Course > District Course Screen > Description Tab > State Course Classification Area > PostSecondary Institution Field

K12.CourseInfo.Course.PostSecondaryInstitution K12.CourseInfo.Postsecondary Institution

031–Class Section Schedule Extract







CALCULATED FROM:




Local Class Number Schedule > Section Screen > Current Students Tab > Section ID K12.ScheduleInfo.Section.SectionID N/A

Monday Duration CALCULATED* N/A N/A

Monday Assigned Period

CALCULATED* N/A N/A

Tuesday Duration CALCULATED* N/A N/A

Tuesday Assigned Period

CALCULATED* N/A N/A

Wednesday Duration CALCULATED* N/A N/A

Wednesday Assigned Period

CALCULATED* N/A N/A

Thursday Duration CALCULATED* N/A N/A

Thursday Assigned Period

CALCULATED* N/A N/A

Friday Duration CALCULATED* N/A N/A

Friday Assigned Period

CALCULATED* N/A N/A

Saturday Duration CALCULATED* N/A N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Saturday Assigned Period

CALCULATED* N/A N/A

*The Duration (average minutes for a specific day) and Assigned Period are calculated based on variables related to the days and periods during which classes are scheduled. If the class takes place during different periods over multiple weeks, the Assigned Period comes from the first week in the repeating cycle.



040–Student Extract







CALCULATED FROM:




Student Social Security Number

Student > Student Screen > Other Info Tab > Other Information Area > Social Security Number Field

K12.Student.SocialSecurityNumber N/A

Student PIN Student > Student Screen > Other Info Tab > Other Information Area > Student PIN Field

K12.TN.StudentTN.StudentPin N/A

Local Student Key Student > Student Screen > Perm ID Field K12.Student.SisNumber N/A

First Name Student > Student Screen > First Name Field K12.Student.FirstName N/A

Middle Name Student > Student Screen > Middle Name Field K12.Student.MiddleName N/A

Last Name Student > Student Screen > Last Name Field K12.Student.LastName N/A

Suffix Student > Student Screen > Suffix Field K12.Student.Suffix N/A

Date of Birth Student > Student Screen > Demographics Tab > Student Information Area > Birth Date

K12.Student.BirthDate N/A

Student Previous Social Security Number

Student > Student Screen > Other Info Tab > Other Information Area > Previous Social Security Number Field

K12.Student.PreviousSocialSecurityNumber N/A

Student Previous PIN Student > Student Screen > Other Info Tab > Other Information Area > Previous Student PIN Field

K12.TN.StudentTN.PreviousStudentPin N/A

Previous First Name Student > Student Screen > Demographics Tab > Student Information Area > Previous First Name Field

K12.Student.AKAFirstName N/A

Previous Middle Name

Student > Student Screen > Demographics Tab > Student Information Area > Previous Middle Name Field

K12.Student.AKAMiddleName N/A

Previous Last Name Student > Student Screen > Demographics Tab > Student Information Area > Previous Last Name

K12.Student.AKALastName N/A

Gender Student > Student Screen > Gender K12.Student.Gender Revelation.Gender

Immigrant Student Student > Student Screen > Other Info Tab > Other Information Area > Immigration Date Field

K12.Student.ImmigrationDate N/A

Date First Enrolled in a US School

Student Programs > ELL > ELL History Tab > ELL Grid K12.Student.UsEntryDateSchool N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Year Entered Ninth Grade

Student > Student Screen > Other Info Tab > Graduation Information Area > Ninth Grade Entry Year Field

K12.Student.InitialNinthGradeYear K12.Initial Ninth Grade Year

Native Language Student > Student Screen > Demographics Tab > Student Information Area > Home Language Field

K12.Student.HomeLanguage K12.Language

State Assigned Student ID

Student > Student Screen > Demographics Tab > Student Information Area > State Student ID Field

K12.Student.StateStudentNumber N/A

Mother’s Maiden Last Name

Student > Student Screen > Demographics Tab > Student Information Area > Mother’s Maiden Name Field

K12.ParentGuardianInfo.Parent.AKALastName N/A

Student’s City of Birth Student > Student Screen > Other Info Tab > Graduation Information Area > Birth Place Field

K12.Student.BirthPlace N/A

Student’s County of Birth Code

Student > Student Screen > Demographics Tab > Student Information Area > Birth County Field

K12.Student.BirthCounty Revelation.County

Student’s State of Birth Code

Student > Student Screen > Demographics Tab > Student Information Area > Birth State Field

K12.Student.BirthState Revelation.State

Student’s Country of Birth Code

Student > Student Screen > Demographics Tab > Student Information Area > Birth Country Field

K12.Student.BirthCountry Revelation.Country

Hispanic Student > Student Screen > Demographics Tab > Race and Ethnicity Area > Hispanic/Latino Field

K12.Student.HispanicIndicator Revelation.Hispanic Ethnicity

American Indian Alaskan Native

Student > Student Screen > Demographics Tab > Race and Ethnicity Area > Race Fields

RevPersonSecondaryEthnic.EthnicCode Revelation.Ethnicity

Asian Student > Student Screen > Demographics Tab > Race and Ethnicity Area > Race Fields


Native Hawaiian or Pacific Islander



Black or African American



White Student > Student Screen > Demographics Tab > Race and Ethnicity Area > Race Fields


SPID (State Person ID)

Student > Student Screen > Demographics Tab >Student Information Area > EdFi ID

K12.Student.EdfiID Revelation.SPID

Date First Enrolled ESL

Student Programs > English Language Learners > ELL History Tab > ELL History Area > Entry Date

K12.ProgramInfo.ELLHistory.EntryDate Revelation.ESL Date



041–Student Enrollment Extract







CALCULATED FROM:










Instr Service Period Type of Service

CALCULATED FROM:

Student > Student Screen > Enrollment Tab > Enrollment Information Area > Enter Code Field

K12.EnrollmentInfo.StudentSOREnrollment.EnterCode

K12.Enrollment.EnterCode

Enrollment Date Student > Student Screen > Enrollment Tab > Enrollment Information Area > Enter Date Field

K12.EnrollmentInfo.StudentEnrollment.EnterDate N/A

Enrollment Reason Student > Student Screen > Enrollment Tab > Enrollment Information Area > Enter Code Field

K12.EnrollmentInfo.StudentSOREnrollment.EnterCode K12.Enrollment.EnterCode

English Language Background

Student Programs > English Language Learners Screen > ELL Status Area > Program Field

K12.ProgramInfo.ELL.ProgramCode K12.ProgramInfo.ELL Program Code

Course of Study Student > Student Screen > Enrollment Tab > Enrollment Activity Area >Course of Study Field

K12.EnrollmentInfo.StudentSOREnrollment.CourseOfStudy K12.Enrollment.Course of Study



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Primary District ID STUDENT RECEIVES SERVICES IN PRIMARY DISTRICT:

System > Setup > Organization Screen > School Detail Screen > School Tab > District Information Area > District Number Field

OR

STUDENT RECEIVES PARTIAL SERVICES OUTSIDE OF PRIMARY DISTRICT:

Student > Student Screen > Enrollment History Tab > Enrollment History Grid > Enter Date Link > Enrollment History Screen > Enrollment Tab > School Enrollment Grid > School Enrollment Detail Screen > Enrollment Activity Grid > Serving District Field


OR

K12.EnrollmentInfo.StudentEnrollmentActivity.ServingDistrict

K12.Enrollment.District

Primary School ID STUDENT RECEIVES SERVICES IN PRIMARY DISTRICT:

System > Setup > Organization Screen > District Detail Screen > District Tab > School Information Area > School Code Field

OR

STUDENT RECEIVES PARTIAL SERVICES OUTSIDE OF PRIMARY DISTRICT:

Student > Student Screen > Enrollment History Tab > Enrollment History Grid > Enter Date Link > Enrollment History Screen > Enrollment Tab > School Enrollment Grid > School Enrollment Detail Screen > Enrollment Activity Grid > Serving School Field


OR

K12.EnrollmentInfo.StudentEnrollmentActivity.ServingSchool

K12.Enrollment.School



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table State Assigned ID Student > Student Screen > Demographics Tab > Student

Information Area > State Student ID Field K12.Student.StateStudentNumber N/A

Homeless Primary Night Time Residence

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > Homeless Need Line > Needs Detail Screen > Detail Tab > History Grid > Nighttime Residence Field

K12.ProgramInfo.StudentProgramGridDetail.NighttimeResidence

K12.ProgramInfo.Nighttime Residence

Homeless Served by McKinney – Vento

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > Homeless Need Line > Needs Detail Screen > Detail Tab > History Grid > Service by McKinney Vento Field

K12.ProgramInfo.StudentProgramGridDetail.ServedMckinney N/A

Homeless Unaccompanied Youth

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > Homeless Need Line > Needs Detail Screen > Detail Tab > History Grid > Unaccompanied Youth Field

K12.ProgramInfo.StudentProgramGridDetail.UnaccompaniedYouth

N/A

SES Applied CALCULATED FROM:

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > SES Line > Program Code Field

K12.ProgramInfo.StudentProgramGrid.ProgramCode N/A

SES Receiving CALCULATED FROM:

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > SES Line > Program Code Field


042–Student Ineligibility Funding Status







CALCULATED FROM:










Fund Inelig Status Student > Student Screen > Enrollment Tab > Enrollment Activity Area > Tuition Payer Code Field

K12.EnrollmentInfo.StudentSOREnrollment.TuitionPayerCode K12.Enrollment.Tuition Payer Code



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Fund Inelig Begin Date

Student > Student Screen > Enrollment Tab > Enrollment Information Area > Enter Date Field

K12.EnrollmentInfo.StudentEnrollment.EnterDate N/A

Fund Inelig End Date CALCULATED FROM:

Student > Student Screen > Enrollment Tab >Enrollment Information Area > Leave Date Field

OR

Student > Student Screen > Enrollment Tab >Enrollment Information Area > Summer Withdrawal Date Field

K12.EnrollmentInfo.StudentSOREnrollment.LeaveDate

OR

K12.EnrollmentInfo.StudentSchoolYear.SummerWithdrawalCode

N/A




043–Student Instructional Grade







CALCULATED FROM:










Instructional Grade Assignment

Student > Student Screen > Grade K12.EnrollmentInfo.StudentSOREnrollment.Grade K12.Grade



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Instr Grade Assignment Date

Student > Student Screen > Enrollment History Tab > Enrollment History Grid > Enter Date Link > Enrollment History Screen > Enrollment Tab > School Enrollment Grid > School Enrollment Detail Screen > Enrollment Activity Grid > Effective Date Field

OR


K12.EnrollmentInfo.StudentEnrollmentActivity.EffectiveDate

OR

K12.EnrollmentInfo.StudentEnrollment.EnterDate

N/A




044–Student Classification







CALCULATED FROM:












Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Student Classification Type

CALCULATED FROM:

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > Student Classification Line > Need Description Field

AND

Student Programs > Free and Reduced Meals Screen > Frm Code Field

K12.ProgramInfo.StudentProgramGrid.Description

AND

K12.ProgramInfo.StudentFRMHistory.FrmCode

K12.ProgramInfo.Frm Code

Student Classify Begin Date

CALCULATED FROM:

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > Student Classification Line > Enter Date Field

AND

Student Programs > Free and Reduced Meals Screen > Enter Date Field

K12.ProgramInfo.StudentProgramGrid.EnterDate

AND

K12.ProgramInfo.StudentFRMHistory.EnterDate

N/A

Student Classify End Date

CALCULATED FROM:

Student Programs > Student Needs Screen > Needs Tab > Needs Grid > Student Classification Line > Exit Date Field

AND

Student Programs > Free and Reduced Meals Screen > Exit Date Field

K12.ProgramInfo.StudentProgramGrid.ExitDate

AND

K12.ProgramInfo.StudentFRMHistory.ExitDate

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table State Assigned Student ID





045–Student Transportation







CALCULATED FROM:










AM Bus Number Student > Student Screen > Other Info Tab > Pick Up Information Area > Bus Number Field

K12.EnrollmentInfo.StudentSOREnrollment.PickUpBusNumber

N/A

PM Bus Number Student > Student Screen > Other Info Tab > Drop Off Information Area > Bus Number Field

K12.EnrollmentInfo.StudentSOREnrollment.DropOffBusNumber

N/A

Est Miles Transported Student > Student Screen > Other Info Tab > Transportation Area > Estimated Mileage Field

K12.EnrollmentInfo.StudentSOREnrollment.BusEstimatedMileage

N/A




046–Student Disciplinary Action







CALCULATED FROM:






Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Student Social Security Number






Disciplinary Action Type

Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Discipline Incidents Detail Screen > Student Incident Detail Tab > Disposition Grid > Disposition Code Field

K12.DisciplineInfo.StudentIncidentDisposition.CodeDispGU

Disciplinary Begin Date

Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Discipline Incidents Detail Screen > Student Incident Detail Tab > Disposition Grid > Start Date Field*

K12.DisciplineInfo.StudentIncidentDisposition.DispositionStartDate

N/A

Disciplinary End Date Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Discipline Incidents Detail Screen > Student Incident Detail Tab > Disposition Grid > End Date Field

K12.DisciplineInfo.StudentIncidentDisposition.DispositionEndDate

N/A

Disciplinary Primary Reason

CALCULATED FROM:

Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Violation List Field

K12.DisciplineInfo.StudentIncidentGrid.ViolationList

N/A

Disciplinary Offense Date

Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Incident Date Field

K12.DisciplineInfo.StudentIncidentGrid.IncidentDate N/A




Zero-Tolerance Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Discipline Incidents Detail Screen > Student Incident Detail Tab > Disposition Grid > Detail Field Link > Student Disposition Screen > Information Tab > Zero Tolerance Field

K12.DisciplineInfo.StudentIncidentDisposition.ZeroTolerance N/A

SE Modified Action Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Discipline Incidents Detail Screen > Student Incident Detail Tab > Disposition Grid > Detail Field Link > Student Disposition Screen > Information Tab > Modification Field

K12.DisciplineInfo.StudentIncidentDisposition.Modification K12.Discipline.Modifications

SE Disciplinary Action Authority

Discipline Incident > Student Incident Screen > Discipline Tab > Discipline Incidents Grid > Discipline Incidents Detail Screen > Student Incident Detail Tab > Disposition Grid > Detail Field Link > Student Disposition Screen > Information Tab > Disposition Description Area > Authority Code Field

12.DisciplineInfo.StudentIncidentDisposition.AuthorityCode K12.DisciplineInfo.Authority

*If the disposition started in the previous school year and runs through the current school year, then the Disciplinary Begin Date is the first instructional day of the current school year.



047–Student Standard Day







CALCULATED FROM:










Student Standard Day CALCULATED FROM:

Student > Student Screen > Enrollment Tab > Enrollment Activity > Standard Day Minutes Field

OR

TN > Setup > District State Requirements Screen > Options Tab >Student Standard Day Grid > Grade Field

AND

TN > Setup > District State Requirements Screen > Options Tab >Student Standard Day Grid > Minutes Per Day Field

K12.EnrollmentInfo.StudentSOREnrollment.StandardDayMinutes

OR

K12.Setup.TN.StudentStandardDay.Grade

AND

K12.Setup.TN.StudentStandardDay.MinutesPerDay

K12.Grade



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Student Std Day Effective Date

CALCULATED FROM:

Student > Student Screen > Enrollment History Tab > Enrollment History Grid > Enter Date Link > Enrollment History Screen > Enrollment Tab > School Enrollment Grid > School Enrollment Detail Screen > Enrollment Activity Grid > Effective Date Field

OR



OR


N/A




048–Student Class Assignment







CALCULATED FROM:












Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Local Class Number Student > Student Screen > Classes Tab > Class Schedule Grid >

Section ID Field K12.ScheduleInfo.Section.SectionID N/A

Student Class Begin Date

Student > Student Screen > Classes Tab > Class Schedule Grid > Enter Date Field

K12.ScheduleInfo.StudentClassGrid.EnterDate N/A

Student Class End Date

Student > Student Screen > Classes Tab > Class Schedule Grid > Leave Date Field

OR


AND

Setup > System > School Setup Screen > Basic Info Tab > Term Definition Grid > Term End Date Field

K12.ScheduleInfo.StudentClassGrid.LeaveDate

OR


AND


N/A

Vocational Outside IEP

Schedule > Section Screen > Current Students Tab > State Reporting Area > Vocational Outside IEP Field

K12.ScheduleInfo.Section.VocationalOutsideIIEP N/A




049–Student Attendance







CALCULATED FROM:






Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Student Social Security Number






Attendance Date Date for a populated All Day Code field for Period Attendance Schools

OR

Date for a populated Attendance Reason 1 field for Daily Attendance Schools

N/A

Attendance Type All Day Code field for Period Attendance Schools

OR

Attendance Reason 1 field for Daily Attendance Schools

AND

Attendance > Setup > District Attendance Code Screen > Attendance Reasons Tab > Attendance Reasons Grid > State Code Field

K12.AttendanceInfo.Setup.DistrictAttendanceReasons.StateCode

N/A




050–Student Withdraw








Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Instructional Program Number

CALCULATED FROM:










Withdraw Date Student > Student Screen > Enrollment Tab > Enrollment Information Area > Leave Date Field

OR

Student > Student Screen > Enrollment Tab > Summer Withdrawal Area > Summer Withdrawal Date

K12.EnrollmentInfo.StudentSOREnrollment.LeaveDate

K12.EnrollmentInfo.StudentSOREnrollment.SummerWithdrawlDate

N/A

Withdraw Reason Student > Student Screen > Enrollment Tab > Enrollment Information Area > Leave Code Field

OR

Student > Student Screen > Enrollment Tab > Summer Withdrawal Area > Summer Withdrawal Code Field

K12.EnrollmentInfo.StudentSOREnrollment.LeaveCode

K12.EnrollmentInfo.StudentSOREnrollment.SummerWithdrawlCode

K12.Enrollment.Leave Code

K12.Demographics.Summer Withdrawal Code




051–Student End of Service

Students who have withdrawn before the last day of the school are not included in the extract.









CALCULATED FROM:










End Of Service Action Date

GRADUATED STUDENTS:

Student > Student Screen > Other Info Tab > Graduation Information Area > Graduation Date Field

NON-GRADUATED STUDENTS:

Last day of the school year as determined by Attendance > Setup > School Calendar Screen > School Calendar Tab > School Calendar Grid

K12.Student.GraduationDate

N/A

End Of Service Action CALCULATED FROM:

Student > Student Screen > Other Info Tab > Next Year Area > Year End Status Field

AND


K12.EnrollmentInfo.StudentSOREnrollment.YearEndStatus

AND


K12.Demographics.Year End Status



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Completion Document Date


K12.Student.GraduationDate N/A

Completion Document Type

Student > Student Screen > Other Info Tab > Graduation Information Area > Diploma Type Field

K12.Student.DiplomaType K12.Diploma Type

Completion Document Period

Student > Student Screen > Other Info Tab > Graduation Information Area > Graduation Semester Field

K12.Student.GraduationSemester K12.Graduation Semester






052–Student Club Membership

This extract includes student who are assigned to a TDOE student club.







CALCULATED FROM:










Club ID Student > Student Groups Screen > Student Groups Tab > Currently Assigned Groups Field > Club Line > Code Field

K12.StudentGroupsInfo.Setup.SchoolStudentGroups.Code N/A

Club Membership Begin Date

Student > Student Groups Screen > Student Groups Tab > Currently Assigned Groups Grid > Club Line > Enter Date Field

K12.StudentGroupsInfo.StudentGroup.EnterDate N/A

Club Membership End Date

Student > Student Groups Screen > Student Groups Tab > Currently Assigned Groups Grid > Club Line > Leave Date Field

K12.StudentGroupsInfo.StudentGroup.LeaveDate N/A




060–Staff Member Extract








Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Instructional Program Number

CALCULATED FROM:




Staff Social Security Number

Staff > Staff Screen > General Tab > Staff Info Area > Social Security Number Field

K12.Staff.SocialSecurityNumber N/A

Teacher License Number

Staff > Staff Screen > General Tab > Staff Info Area > Teacher / Administrator License Number Field

K12.Staff.TeacherAdminLicNumber N/A

Local Staff Key Staff > Staff Screen > General Tab > Staff Info Area > Badge Number Field

K12.Staff.BadgeNum N/A

First Name Staff > Staff Screen > First Name Field K12.Staff.FirstName N/A

Middle Name Staff > Staff Screen > Middle Name Field K12.Staff.MiddleName N/A

Last Name Staff > Staff Screen > Last Name Field K12.Staff.LastName N/A

Suffix Staff > Staff Screen > Suffix Field K12.Staff.Suffix N/A

Date of Birth Staff > Staff Screen > General Tab > Staff Info Area > Birth Date Field

K12.Staff.BirthDate N/A

Staff Previous Social Security Number

Staff > Staff Screen > General Tab > Staff Info Area > Previous Social Security Number Field

K12.Staff.PreviousSocialSecurityNumber N/A

Staff Previous Teacher License Number

Staff > Staff Screen > General Tab > Staff Info Area > Previous Teacher License Number Field

K12.Staff.PreviousLicenseNumber N/A

Previous First Name Staff > Staff Screen > General Tab > Staff Info Area > Former Names Area > First Name Field

K12.Staff.AKAFirstName N/A

Previous Last Name Staff > Staff Screen > General Tab > Staff Info Area > Former Names Area > Last Name Field

K12.Staff.AKALastName N/A

Gender Staff > Staff Screen > Gender Field K12.Staff.Gender Revelation.Gender

Ethnicity Staff > Staff Screen > General Tab > Race and Ethnicity Area > Hispanic / Latino Field

K12.Staff.HispanicIndicator Revelation.HispanicEthnicity

American Indian or Alaskan Native



Asian Student > Student Screen > Demographics Tab > Race and Ethnicity Area > Race Fields


Native Hawaiian or Pacific Islander



Black or African American



White Student > Student Screen > Demographics Tab > Race and Ethnicity Area > Race Fields




Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Licensure Check Staff > Staff Screen > General Tab > Staff Info Area > Licensure

Check Field K12.Staff.LicensureCheck K12.Staff.Licensure Check

Waive Request Course

N/A N/A N/A

Staff Status Staff > Staff Screen > Schools Tab > Staff School Assignments Grid > Staff School Assignments Detail Screen > Assignment Details Area > FTE Field

K12.StaffSchoolYear.Fte N/A

062–Staff Member Current Assignment Extract
















Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Current Assignment SCHOOL ASSIGNMENTS:

Staff > Staff Screen > Schools Tab > Staff School Assignments Area > Staff School Assignments Detail Screen > Default Support Type Grid > Support Type Field

AND

DISTRICT ASSIGNMENTS:

Staff > Staff Screen > Schools Tab > District Wide Support Type Grid > Support Type Field

K12.StaffInfo.StaffSchoolYearSupportType.SupportType

AND

K12.StaffInfo.StaffDistrictSupportType.SupportType

K12.Staff.District Support Type

K12.Staff.Support Type

Current Assignment Begin Date

SCHOOL ASSIGNMENTS:

Staff > Staff Screen > Schools Tab > Staff School Assignments Area > Staff School Assignments Detail Screen > Default Support Type Grid > Begin Date Field

AND


Staff > Staff Screen > Schools Tab > District Wide Support Type Grid > Begin Date Field

K12.StaffInfo.StaffSchoolYearSupportType.BeginDate

AND

K12.StaffInfo.StaffDistrictSupportType.BeginDate

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Current Assignment End Date

SCHOOL ASSIGNMENTS:

Staff > Staff Screen > Schools Tab > Staff School Assignments Area > Staff School Assignments Detail Screen > Default Support Type Grid > End Date Field

AND


Staff > Staff Screen > Schools Tab > District Wide Support Type Grid > End Date Field

K12.StaffInfo.StaffSchoolYearSupportType.EndDate

AND

K12.StaffInfo.StaffDistrictSupportType.EndDate

N/A

063–Staff Member Class Assignment














Local Class Number Schedule > Section Screen > Section ID Field K12.ScheduleInfo.Section.SectionID N/A

Staff Class Begin Date

Schedule > Section Screen > Staff History Tab > Historical Staff Grid > Effective Date Field

K12.ScheduleInfo.SchoolYearSectionStaffHistory.EffectiveDate

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Staff Class End Date CALCULATED FROM:


AND

System > Setup > School Setup Screen > Basic Info Tab > Term Definition Grid > Term End Date Field


AND


N/A

Teacher of Record CALCULATED FROM:

Schedule > Section Screen > Staff Name Field

AND

Schedule > Section Screen > Current Students Tab > Staff Contributions Area > Responsibility Field

K12.ScheduleInfo.Section.StafContr.Respon

K12.ScheduleInfo.Staff Responsibility

Federally Funded Class

Schedule > Section Screen > Current Students Tab > Section Info Area > Supplemental Funding Category Field

OR

Course > District Course Screen > Course Tab > Other Provider Information Area > Funding Source Field

K12.ScheduleInfo.Section.SupplementalFundingCategory

K12.CourseInfo.Course.FundingSource

K12.AttendanceInfo.Supplemental Funding Cat

K12.CourseInfo.Funding Source



080–Student Final Grade







CALCULATED FROM:










Year Class Was Taken

Course History > Student Course History Screen > Course History Tab > Courses Grid > Calendar Year Field

K12.CourseHistoryInfo.StudentCourseHistory.CalendarYear N/A

Term Class Was Taken

Course History > Student Course History Screen > Course History Tab > Courses Grid > Courses Detail Screen > Student Course Information Tab > Year Information Area > Term Code Field

OR

Course History > Student Course History Screen > Course History Tab > Courses Grid > Courses Detail Screen > Student Course Information Tab > Year Information Area >Term Code Actual Field

K12.CourseHistoryInfo.StudentCourseHistory.TermCode

K12.CourseHistoryInfo.StudentCourseHistory.TermCodeActual

K12.CourseInfo.Course Duration

Grade Assignment When Class Was Taken

Course History > Student Course History Screen > Course History Tab > Courses Grid > Grade Field

K12.CourseHistoryInfo.StudentCourseHistory.Grade K12.Grade



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Private or Out of State Transfer

CALCULATED FROM:

Course History > Student Course History Screen > Course History Tab > Courses Grid > Courses Detail Screen > Student Course Information Tab > School Information Area > Non-District School Field

AND

System > Setup > Non-District School Screen > Non-District School Tab > School Info Area > School Type Field

K12.CourseHistoryInfo.StudentCourseHistory.SchoolNonDistrictGU

AND

K12.Setup.SchoolNonDistrict.SchoolType

K12.Setup.Non District School Type

Course Code Course History > Student Course History Screen > Course History Tab > Courses Grid > Course ID Field

AND

Course > District Course Screen > Description Tab > State Course Classification Area > State Course Code Field

K12.CourseHistoryInfo.StudentCourseHistory.CourseID

AND

K12.CourseInfo.Course.StateCourseCode

K12.CourseInfo.State Course Code

Local Course Number Course History > Student Course History Screen > Course History Tab > Courses Grid > Course ID Field

AND

Schedule > Section Screen > Section ID


AND

K12.ScheduleInfo.Section.SectionID

N/A



Data Element Synergy SIS Location Edupoint BO and Property Lookup Table Credits Attempted Course History > Student Course History Screen > Course History

Tab > Courses Grid > Credits Att Field K12.CourseHistoryInfo.StudentCourseHistory.CreditAttempted N/A

Credits Earned Course History > Student Course History Screen > Course History Tab > Courses Grid > Credits Cmpltd Field

K12.CourseHistoryInfo.StudentCourseHistory.CreditCompleted

N/A

Alpha Grade Course History > Student Course History Screen > Course History Tab > Courses Grid > Mark Field *

K12.CourseHistoryInfo.StudentCourseHistory.MarkDD K12.CourseHistoryInfo.Mark

Numeric Grade Course History > Student Course History Screen > Course History Tab > Courses Grid > Mark Field*

AND

Course History > Student Course History Screen > Course History Tab > Courses Grid > Courses Detail Screen > Student Course Information Tab > Course Information Area > Quality Point Field**

K12.CourseHistoryInfo.StudentCourseHistory.Mark

Quality Points Course History > Student Course History Screen > Course History Tab > Courses Grid > Courses Detail Screen > Student Course Information Tab > Course Information Area > Quality Point Field**

K12.CourseHistoryInfo.StudentCourseHistory.RigorPoint N/A




*Because students can receive an alpha or numeric mark but not both, the extract uses information defined at Grading > Setup > Mark Definition Screen to convert values between alpha and numeric marks for extract reporting purposes only.

**See Student Course Quality Points for important information about how Quality Points affect the Numeric Grade.



081–Student TA Instructional Services

Students are identified as providing TA instructional assistance when they are designated as a teacher’s aide in a class where the associated district course is offered by a department that has been assigned a TA Instructional Services code.







CALCULATED FROM:










TA Instructional Assistance

CALCULATED FROM:

Course > District Course Screen > Course Tab > Course Info Area > Department Field

AND

Student > Student Screen > Classes Tab > Class Schedule Grid > Teacher Aide Field

K12.CourseInfo.Course.Department

AND

K12.ScheduleInfo.StudentClassGrid.TeacherAide

K12.CourseInfo.Department






082–Student TA Support Services

Students are identified as receiving targeted support assistance if they are assigned a TA Support Services code. For students with more than one code, the extract includes a row for each code assigned to the student. See information about defining TA Support Services codes.







CALCULATED FROM:










TA Support Assistance

Student Programs > Student Needs Screen > Needs Tab > Program Code Field







083–Student Choice Applied

See School Choice for Transfer Students.







CALCULATED FROM:










Student Choice Applied

Student > Student Screen > Enrollment History Tab > Enrollment History Grid > Enter Date Link > Enrollment History Screen > Other Information Tab > School Choice Status Field

K12.EnrollmentInfo.StudentSchoolYear.SchoolChoiceStatus K12.Enrollment.School Choice Status




Chapter Six

Edupoint Proprietary and Confidential

Chapter Six : MAPPING


► Transmit Header Map

► 200 Day Calendar Map

► 200 Day Event Calendar Map

► District Bus Map

► Instructional Program Map

► Instructional Program Report Period Map

► School Days Map

► Class Section Map

► Class Section Schedule Map

► Student Map

► Student Enrollment Map

► Student Ineligibility Funding Status Map

► Student Instructional Grade Map

► Student Classification Map

► Student Transportation Map

► Student Disciplinary Action Map

► Student Standard Day Map

► Student Standard Day Map1

► Student Class Assignment Map

► Student Attendance Map

► Student Withdraw Map

► Student End of Service Map

► Student Club Membership Map

► Staff Member Map

► Staff Member Current Assignment Map

► Staff Member Current Assignment Map1

► Staff Member Class Assignment Map

► Student Final Grade Map

► Student TA Instructional Services Map

► Student TA Support Services Map

► Student Choice Applied Map

► Special Education Option Map

► Special Education Disabilities Map

► Transmit Trailer Map

Tennessee State Reporting Guide Chapter Six


TRANSMIT HEADER MAP

Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 1 Record ID 3 9(3) 2 Record Version 2 99 3 Filler 2 99 4 District ID 3 9(3) System > Setup > Organization

> District > District Information K12.Setup.DistrictSetup.

DistrictNumber

5 TH Extract Date 8 9(8) 6 TH File Name 20 X(20) 7 Filler 20 X(20)

Chapter Six Tennessee State Reporting Guide


200 DAY CALENDAR MAP Filler

Key Fields

Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 1 Record ID 3 9(3) 2 Record Version 2 99 3 Record Type 1 X 4 Filler 2 99 5 District ID 3 9(3) System > Setup > Organization


DistrictNumber

N/A

6 School Year 4 9(4) Focus Year N/A 7 Calendar Number 2 99 Attendance > Setup > District

Calendar > District Calendar Type Options > Calendar Type

Calculated from:

K12.Setup.TN.DistrictCalendarOptions.

CalendarType


8 Instructional Calendar 1 X Attendance > Setup > District Calendar > District Calendar Type Options > Calendar Type

Calculated from:


CalendarType


9 Scheduled Days 1 9 Attendance > Setup > District Calendar > District Calendar Options

Calculated from:

K12.AttendanceInfo.Setup.

AttendanceCalendarOpt.IncSaturday

N/A

10 Stockpile Inclement Weather Days

2 99 System > Setup > District State Requirements > District Calendar Options > Stockpile Inclement Weather Days

K12.Setup.TN.DistrictCalendarOptions. StockpileInclementWeatherDays

N/A

11 Stockpile Professional Development Days

2 99 System > Setup > District State Requirements > District Calendar Options > Stockpile Professional Development Days


StockpileProfessionalDevelopmentDays

N/A

12 In Service Days 4 99v99 System > Setup > District State Requirements > District Calendar Options > In Service Days

K12.Setup.TN.DistrictCalendarOptions.InServiceDays

N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 13 Optional In Service Days 4 99V99 System > Setup > District State

Requirements > District Calendar Options > Optional In Service Days


OptionalInServiceDays

N/A

14 Parent Teacher Conference Days

1 9 System > Setup > District State Requirements > District Calendar Options > Parent Teacher Conference Days


ParentTeacherConferenceDays

N/A

15 Teacher Vacation Days 2 99 System > Setup > District State Requirements > District Calendar Options > Teacher Vacation Days


TeacherVacationDays

N/A

16 Abbreviated Days 1 9 System > Setup > District State Requirements > District Calendar Options > Abbreviated Days


AbbreviatedDays

N/A

17 Discretionary Teacher Vacation Days

4 99v99 System > Setup > District State Requirements > District Calendar Options > Discretionary Teacher Vacation Days


DiscretionaryTeacherVacationDays

N/A

18 Discretionary In Service Days

4 99v99 System > Setup > District State Requirements > District Calendar Options > Discretionary In Service Days


DiscretionaryInServiceDays

N/A

19 Discretionary Administrative Days

4 99v99 System > Setup > District State Requirements > District Calendar Options > Discretionary Administrative Days


DiscretionaryAdministrativeDays

N/A

20 Discretionary Instructional Days

4 99v99 System > Setup > District State Requirements > District Calendar Options > Discretionary Instructional Days


DiscretionaryInstructionalDays

N/A

21 Discretionary Other Days 4 99v99 System > Setup > District State Requirements > District Calendar Options > Discretionary Other Days


DiscretionaryOtherDays

N/A

22 Instructional Days 3 9(3) System > Setup > District State Requirements > District Calendar Options > Instructional Days


InstructionalDays

N/A

23 Filler 20 X(20)



200 DAY EVENT CALENDAR MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School Year 4 9(4) Focus Year N/A N/A 7 Calendar Number 2 99 Attendance > Setup > District


Calculated from:



8 Event Date 8 9(8) System > Setup > District State Requirements > District Calendar Options > District Wide Events > Event Date

K12.Setup.TN.DistrictEvent.EventDate

N/A

9 Event Type 2 XX System > Setup > District State Requirements > District Calendar Options > District Wide Events > Event Type

K12.Setup.TN.DistrictEvent.EventType

K12.TN.Event Types

10 School Day Type 1 X System > Setup > District State Requirements > District Calendar Options > District Wide Events > Instructional Day

K12.Setup.TN.DistrictEvent.

InstructionalDay

11 Event Duration 3 9V99 System > Setup > District State Requirements > District Calendar Options > District Wide Events > Event Duration

K12.Setup.TN.DistrictEvent.

EventDuration


12 Filler 20 X(20)



DISTRICT BUS MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School Year 4 9(4) Focus Year N/A N/A 7 Bus Number 6 X(6) Transportation > Bus > Bus Info

> Vehicle ID K12.TransportationInfo.Bus.VehicleID N/A

8 Specially Equipped 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Specially Equipped

K12.TransportationInfo.Bus.

SpeciallyEquipped

N/A

9 Daily Miles 4 9(4) Transportation > Bus > Bus Info > Mileage > Daily Mileage

Calculated from:

K12.TransportationInfo.BusMileage.

DailyMileage

N/A

10 Bus Type 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Vehicle Type


VehicleType

K12.TransportationInfo.Vehicle Type

11 Year Bus Began Operation

4 9(4) Transportation > Bus > Bus Info > Other Information > Year Began Operation


YearBeganOperation

N/A

12 Inspected by TN Dept of Safety

1 X Transportation > Bus > Bus Info > Other Information > Inspected by State


InspectedByState

N/A

13 Privately Owned 1 X Transportation > Bus > Bus Info > Other Information > Privately Owned


PrivatelyOwned

N/A

14 Wheel Chair Lifts 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Special Lift Equipment


SpecialLiftEquipment

N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 15 Commercial Advertising 1 X Transportation > Bus > Bus Info

> Other Information > Commercial Advertising


CommercialAdvertising

N/A

16 Involved Accident /

Number of Accidents

1 9 Transportation > Bus > Bus Info > Other Information > Number of Accidents


NumberOfAccidents

N/A

17 Occupant Restraints 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Occupant Restraints


OccupantRestraints

N/A

18 Two Way Communication 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Two Way Communication


TwoWayCommunication

N/A

19 Audio/Video Surveillance 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Audio/Video Surveillance


AudioVideoSurveillance

N/A

20 Type of Fuel 6 X(6) Transportation > Bus > Bus Info > Vehicle Specifications > Fuel Type

K12.TransportationInfo.Bus.FuelType K12.TransportationInfo.Fuel Type

21 GPS System 1 X Transportation > Bus > Bus Info > Vehicle Specifications > GPS System


GPSSystem

N/A

22 Air Conditioning 1 X Transportation > Bus > Bus Info > Vehicle Specifications > Air Conditioning


AirConditioning

N/A

23 Filler 20 X(20)



INSTRUCTIONAL PROGRAM MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School ID 4 9(4) System > Setup > Organization

> School > Other Information > State CTDS Code


7 School Year 4 9(4) Focus Year N/A N/A 8 Calendar Number 2 99 Attendance > Setup > District


Calculated from:



9 Instructional Program Number

2 99 Attendance > Setup > District Calendar > District Calendar Type Options > Calendar Type

Calculated from:



10 Instructional Calendar 1 X Attendance > Setup > District Calendar > District Calendar Type Options > Calendar Type

Calculated from:



11 Student Day 3 9(3) System > Setup > State Requirements > Student Minutes per Day

K12.Setup.TN.SchoolSetupOptionsTN.

StudentMinutesPerDay

N/A

12 Teacher Day 3 9(3) System > Setup > State

Requirements > Teacher Minutes per Day


TeacherMinutesPerDay

N/A

13 School Stockpile

Professional Development Days

2 99 System > Setup > State Requirements > Stockpile Professional Development Days

K12.Setup.TN. SchoolSetupOptionsTN.

StockpileProfessionalDevelopmentDays

N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 14 Block Schedule 1 X System > Setup > State

Requirements > Block Schedule K12.Setup.TN.SchoolSetupOptionsTN.

BlockSchedule

N/A

15 Spring Block Begin Date 8 9(8) System > Setup > State

Requirements > Spring Block Begin Date


SpringBlockBeginDate

N/A

16 Filler 11 X(11)



INSTRUCTIONAL PROGRAM REPORT PERIOD MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School ID 4 9(4) System > Setup > Organization > School > Other Information > State CTDS Code


7 School Year 4 9(4) Focus Year N/A N/A 8 Instructional Program

Number 2 99 Attendance > Setup > District


Calculated from:



9 Report Period Number 2 99 Calculated from:

Attendance > Setup > School Calendar

Calculated N/A

10 Report Period Begin Date 8 9(8) Calculated from:


Calculated N/A

11 Report Period End Date 8 9(8) Calculated from:


Calculated N/A

12 Filler 20 X(20)



SCHOOL DAYS MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School ID 4 9(4) System > Setup > Organization

> School > Other Information > State CTDS Code


7 School Year 4 9(4) Focus Year

N/A N/A

8 Instructional Program



Calculated from:



9 Event Date 8 9(8) Attendance > Setup > School Calendar > State Reporting > Calendar Events > Date

K12.Setup.TN.SchoolEvent.

EventDate

N/A

10 Event Type 2 XX Attendance > Setup > School Calendar > State Reporting > Calendar Events > Event Type

K12. Setup.TN.SchoolEvent.

EventType

K12.TN.Event Types

11 Event Duration 3 9V99 Attendance > Setup > School Calendar > State Reporting > Calendar Events > Duration


EventDuration


12 School Day Type 1 X Attendance > Setup > School Calendar > State Reporting > Calendar Events >

Instructional Day


InstructionalDay

K12.TN.InstructionalDay

13 Filler 20 X(20)



CLASS SECTION MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A






Calculated from:



9 Course Code 5 9(5) Course > District Course > Description > State Course Code

K12.CourseInfo.Course.

StateCourseCode

N/A

10 Local Class Number 15 X(15) Schedule > Section > Current Students > Section ID

K12.ScheduleInfo.Section.SectionID N/A

11 Filler 2 99 12 Service District ID 3 9(3) Calculated from:

Course > District Course > Other Provide Information > Provider ID

Calculated

N/A

13 Service School ID 4 9(4) Calculated from:

Course > District Course > Other Provide Information > Provider ID

Calculated

N/A

14 Class Type 1 X Schedule > Section > State Reporting > Defined Class Type

K12.ScheduleInfo.Section.DefinedClassType

K12.ScheduleInfo.Defined Class Type



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 15 Teaching Method 1 X Calculated from:

Schedule > Section > Current Students > Section Info > Distance Learning and Online Course Override

and

Course > District Course > Course > Course Info > Distance Learning Course & Online Course

Calculated from:

K12.CourseInfo.Course.DistanceLearningCourse

K12.CourseInfo.Course.OnlineCourse

K12.ScheduleInfo.Section.DistanceLearning

K12.ScheduleInfo.Section.OnlineCourseOverride

N/A

16 Class Begin Date 8 9(8) Calculated from:

Schedule > Section > Current Students > Section Info > Term Code

and

System > Setup > School Setup > Term Definition > Term Begin Date

Calculated from:


and

K12.Setup.SchoolYearTrmDef.BeginDate

N/A

17 Class End Date 8 9(8) Calculated from:

Schedule > Section > Current Students > Section Info > Term Code

And

System > Setup > School Setup > Term Definition > Term End Date

Calculated from:

K12.CourseInfo.Course.CourseDuration

and


and


N/A

18 Honors Class Indicator 1 X Course > District Course > Course Info > Academic Type

K12.CourseInfo.Course.AcademicType

K12.CourseInfo.AcademicType

19 State Dual Credit 1 X Course > District Course > Description > State Course Classification > Class Indicator

Calculated

K12.CourseInfo.CLASS_INDICATOR



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 20 Local Dual Credit 1 X Course > District Course >

Description > State Course Classification > Class Indicator

Calculated


21 Dual Enrollment 1 X Course > District Course > Description > State Course Classification > Class Indicator

Calculated


22 Post-Secondary Institution 6 X(06) Course > District Course > Description > State Course Classification > Postsecondary Institution

Calculated K12.CourseInfo.POSTSECONDARY_INSTITUTION

19 Filler 9 X(9)



CLASS SECTION SCHEDULE MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A N/A



Calculated from:



9 Local Class Number 15 X(15) Schedule > Section > Current Students > Section ID

K12.ScheduleInfo.Section.SectionID N/A

10 Monday Duration 3 9(3) Average Duration Calculation N/A 11 Monday Assigned Period 2 99 Assigned Period Calculation N/A 12 Tuesday Duration 3 9(3) Average Duration Calculation N/A 13 Tuesday Assigned Period 2 99 Assigned Period Calculation N/A 14 Wednesday Duration 3 9(3) Average Duration Calculation N/A 15 Wednesday Assigned

Period 2 99 Assigned Period Calculation N/A

16 Thursday Duration 3 9(3) Average Duration Calculation N/A 17 Thursday Assigned

Period 2 99 Assigned Period Calculation N/A

18 Friday Duration 3 9(3) Average Duration Calculation N/A 19 Friday Assigned Period 2 99 Assigned Period Calculation N/A 20 Saturday Duration 3 9(3) Average Duration Calculation N/A 21 Saturday Assigned Period 2 99 Assigned Period Calculation N/A 22 Filler 20 X(20)



STUDENT MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School ID 4 9(4) Student > Enrollment / Enrollment History

K12.EnrollmentInfo.StudentSOREnrollment


N/A




Calculated from:



9 Student Social Security Number

9 9(9) Student > Other Info > Other Information > Social Security Number


10 Student PIN 9 9(9) Student > Other Info > Student PIN

K12.TN.Student.StudentPIN N/A

11 Local Student Key 10 9(10) Student > Demographics > Perm ID

K12.Student.SisNumber N/A

12 First Name 15 X(15) Student > First Name K12.Student.FirstName N/A 13 Middle Name 15 X(15) Student > Demographics >

Middle Name K12.Student.MiddleName N/A

14 Last Name 25 X(25) Student > Last Name K12.Student.LastName N/A 15 Suffix 3 X(3) Student > Suffix K12.Student.Suffix N/A 16 Date of Birth 8 9(8) Student > Demographics >

Student Information > Birth Date K12.Student.BirthDate N/A

17 Student Previous Social Security Number

9 9(9) Student > Other Info > Previous Social Security Number

K12.TN.Student.PreviousSocialSecurityNumber

N/A

18 Student Previous PIN 9 9(9) Student > Other Info > Previous Student PIN

K12.TN.Student.PreviousStudentPIN N/A

19 Previous First Name 15 X(15) Student > Demographics > Previous First Name

K12.Student.AKAFirstName N/A

20 Previous Middle Name 15 X(15) Student > Demographics > Previous Middle Name

K12.Student.AKAMiddleName N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 21 Previous Last Name 25 X(25) Student > Demographics >

Previous Last Name K12.Student.AKALastName N/A

22 Gender 1 X Student > Demographics > Gender

K12.Student.Gender Revelation.Gender

23 Filler ! X 24 Filler 4 X(4) 25 Immigrant Student 1 X Student > Other Info > Other

Information > Immigration Date K12.Student.ImmigrationDate N/A

26 Date First Enrolled in a US School

8 9(8) Student > Enrollment > Other Enrollment Information > US School Entry Date

K12.Student.UsEntryDateSchool N/A

27 Year Entered Ninth Grade 4 9(4) Student > Other Info > Graduation Information > Ninth Grade Entry Year

K12.Student.InitialNinthGradeYear K12.INITAL_NINTH_GRADE_YEAR

28 Native Language 3 X(3) Student > Demographics > Student Information > Home Language

K12.Student.HomeLanguage K12.Language

29 State Assigned Student ID

9 9(9) Student > Demographics > Student Information > State ID


30 Mother’s Maiden Last Name

25 X(25) Parent > Demographics > Parent Info > Maiden Name

Calculated from:

K12.Student.SrUserText1

or

K12.ParentGuardianInfo.Parent.

AKALastName

N/A

31 Student’s City of Birth 30 X(30) Student > Demographics > Student Information > Birth Place

K12.Student.BirthPlace N/A

32 Student’s County of Birth Code

3 9(3) Student > Demographics > Student Information >

K12.Student.BirthCounty Revelation.County

33 Student’s State of Birth Code

2 X(2) Student > Demographics > Student Information > Birth State

K12.Student.BirthState Revelation.State

34 Student’s Country of Birth Code

2 X(2) Student > Demographics > Student Information > Birth Country

K12.Student.BirthCountry Revelation.Country

35 Hispanic 1 X Student > Demographics > Race and Ethnicity > Hispanic/Latino

K12.Student.HispanicIndicator Revelation.HispanicEthnicity

36 American Indian Alaskan Native

1 X Student > Demographics > Race and Ethnicity > Race

RevPersonSecondaryEthnic.EthnicCode

Revelation.Ethnicity

37 Asian 1 X Student > Demographics > Race and Ethnicity > Race



38 Native Hawaiian or Pacific Islander

1 X Student > Demographics > Race and Ethnicity > Race





Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 39 Black or African American 1 X Student > Demographics > Race

and Ethnicity > Race RevPersonSecondaryEthnic.EthnicCode


40 White 1 X Student > Demographics > Race and Ethnicity > Race



41 Filler 20 X(20)



STUDENT ENROLLMENT MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:







K12.TN.Student.StudentPIN

N/A



12 Instr Service Period Type of Service

1 X Student > Enrollment History > School Enrollment

Calculated N/A

13 Enrollment Date 8 9(8) Student > Enrollment History > School Enrollment > Enter Date

Calculated from:


N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table or

Schools Calendar Start Date 14 Enrollment Reason 2 XX Student > Demographics >

Reason for Attendance K12.EnrollmentInfo.StudentEnrollment.EnterCode

K12.Enrollment.EnterCode

15 English Language Background

1 X Student Programs > English Language Learners > ELL Status > Program

K12.ProgramInfo.ELL.ProgramCode K12.ProgramInfo.ELL Program Code

16 Course of Study 1 X Student > Enrollment > Enrollment Activity >Course of Study

K12.EnrollmentInfo.StudentSOREnrollment.CourseOfStudy

K12.Enrollment.Course of Study

17 Filler 1 X 18 Filler 2 99 19 Primary District ID 3 9(3) Calculated from:

Student > Enrollment > Enrollment Activity > Serving District

or

System > Setup > Organization > District > District Information

Calculated from:

K12.EnrollmentInfo.StudentSOREnrollment.ServingDistrict

or

K12.Setup.DistrictSetup.

DistrictNumber

K12.Enrollment. District

20 Primary School ID 4 9(4) Calculated from:

Student > Enrollment > Enrollment Activity > Serving School

or

Student > Enrollment / Enrollment History

Calculated from:

K12.EnrollmentInfo.StudentSOREnrollment.ServingSchool

or



K12.Enrollment. School

21 State Assigned ID 9 (9) Student > Demographics > Student Information > State ID


22 Filler 11 X(11) 23 Homeless Primary Night

Time Residence 2 99 Student Programs > Student

Needs Calculated

24 Homeless Served by McKinney – Vento

1 X Student Programs > Student Needs

Calculated



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 25 Homeless

Unaccompanied Youth 1 X Student Programs > Student

Needs Calculated

26 SES Applied 1 X Student Programs > Student Needs

Calculated

27 SES Receiving 1 X Student Programs > Student Needs

Calculated

28 Filler 20 X(20)



STUDENT INELIGIBILITY FUNDING STATUS MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A



Calculated from:








N/A



12 Fund Inelig Status 1 9 Student > Enrollment > Enrollment Activity > Tuition Payer Code

Calculated from:

K12.EnrollmentInfo.StudentEnrollmentActivity.TuitionPayerCode

K12.Enrollment.Tuition Payer Code

13 Fund Inelig Begin Date 8 9(8) Student > Enrollment > Enrollment Activity > Effective Date

Calculated from: K12.EnrollmentInfo.StudentEnrollmentActivity.EffectiveDate

N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 14 Fund Inelig End Date 8 9(8) Calculated From:

Student > Enrollment > Enrollment Activity > Effective Date

or

Student > Enrollment > Leave Date

Calculated From:


or

K12.EnrollmentInfo.StudentEnrollment.LeaveDate

N/A




16 Filler 11 X(11)



STUDENT INSTRUCTIONAL GRADE MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:










12 Instructional Grade Assignment

2 XX Student > Enrollment > Enrollment Activity > Grade

K12.EnrollmentInfo.StudentEnrollmentActivity.Grade

K12.Grade

13 Instr Grade Assignment Date

8 9(8) Student > Enrollment > Enrollment Activity > Effective Date


N/A




15 Filler 11 X(11)



STUDENT CLASSIFICATION MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 Student Classification Type

1 X Calculated Calculated N/A

13 Student Classify Begin Date

8 9(8) Calculated Calculated N/A

14 Student Classify End Date 8 9(8) Calculated Calculated N/A 15 State Assigned Student

ID 9 9(9) Student > Demographics >

Student Information > State ID K12.Student.StateStudentNumber N/A

16 Filler 11 X(11)



STUDENT TRANSPORTATION MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 AM Bus Number 6 X(6) Student > Other Info > Pick Up Information > Bus Number

K12.EnrollmentInfo.StudentSchoolYear.PickUpBusNumber

(New Property)

N/A

13 PM Bus Number 6 X(6) Student > Other Info > Drop Off Information > Bus Number

K12.EnrollmentInfo.StudentSchoolYear.DropOffBusNumber

(New Property)

N/A

14 Est Miles Transported 4 99V99 Student > Other Info > Transportation > Estimated Mileage

K12.EnrollmentInfo.StudentSchoolYear.BusEstimatedMileage

(New Property)

15 Filler 2 99 16 Filler 3 X(3)



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 17 State Assigned Student



18 Filler 11 X(11)



STUDENT DISCIPLINARY ACTION MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:










12 Disciplinary Action Type 1 X Student Disposition > Information > Disposition Description > Disposition Code

Calculated from:

K12.DisciplineInfo.StudentIncidentDisposition.CodeDispGU

N/A

13 Disciplinary Begin Date 8 9(8) Student Disposition > Information > Dates > Start Date

K12.DisciplineInfo.StudentIncidentDispositio.DispositionStartDate

N/A

14 Disciplinary End Date 8 9(8) Student Disposition > Information > Dates > End Date

K12.DisciplineInfo.StudentIncidentDispositio.DispositionEndDate

N/A

15 Disciplinary Primary Reason

2 99 Discipline Incidents > Incidents > Violations > Category

K12.DisciplineInfo.StudentIncidentViolation.CodeDiscGU

District Discipline Code Setup



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 16 Disciplinary Offense Date 8 9(8) Discipline Incidents > Incidents >

Information > Date K12.DisciplineInfo.SchoolIncident.IncidentDate

N/A




18 Zero-Tolerance 1 X Student Disposition >Information > Disposition Description > Zero Tolerance

K12.DisciplineInfo.StudentIncidentDisposition.ZeroTolerance

N/A

19 SE Modified Action 1 X Student Disposition > Information > Disposition Description > Modification

K12.DisciplineInfo.StudentIncidentDisposition.Modification

K12.Discipline.Modifications

20 SE Disciplinary Action Authority

1 9 Student Disposition > Information > Disposition Description > Authority Code

K12.DisciplineInfo.StudentIncidentDisposition.AuthorityCode

K12.DisciplineInfo.Authority

18 Filler 8 X(8)



STUDENT STANDARD DAY MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:












Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 12 Student Standard Day 3 9(3) Calculated from:

Student > Demographics > Grade

and

System > Setup > District State Requirements > Student Standard Day

and

Student > Enrollment > Standard Day Minutes

Calculated N/A

13 Student Std Day Effective Date

8 9(8) Calculated from:

Student > Demographics > Grade

and

System > Setup > District State Requirements

and

Student > Enrollment > Standard Day Minutes

Calculated N/A




18 Filler 11 X(11)



STUDENT CLASS ASSIGNMENT MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 Local Class Number 15 X(15) Student > Classes > Class Schedule > Section ID

Calculated from:

K12.ScheduleInfo.StudentClass.SectionGU

and

K12.ScheduleInfo.Section.SectionID

N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 13 Student Class Begin Date 8 9(8) Student > Classes > Class

Schedule > Enter Date Calculated from:

K12.ScheduleInfo.StudentClass.

SectionGU

and

K12.ScheduleInfo.StudentClass.

EnterDate

N/A

14 Student Class End Date 8 9(8) Calculated Calculated N/A 15 Vocational Outside IEP 1 X Schedule > Section > Current

Students > State Reporting > Vocational Outside IEP

K12.ScheduleInfo.Section.VocationalOutsideIEP




17 Filler 11 X(11)



STUDENT ATTENDANCE MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A

7 School Year 4 9(4) Focus Year N/A N/A



Calculated from:










12 Attendance Date 8 9(8) Calculated Calculated

13 Attendance Type 1 X Calculated Calculated District Attendance Codes 14 State Assigned Student



15 Filler 11 X(11)



STUDENT WITHDRAW MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:










12 Withdraw Date 8 9(8) Student > Enrollment History > Leave Date

K12.EnrollmentInfo.StudentEnrollment.LeaveDate

K12.EnrollmentInfo StudentSOREnrollment SummerWithdrawalDate

N/A

13 Withdraw Reason 2 99 Student > Enrollment History > Leave Code

K12.EnrollmentInfo.StudentEnrollment.LeaveCode

K12.EnrollmentInfo StudentSOREnrollment SummerWithdrawlCode

K12.Enrollment.Leave Code

K12.Demographics.SUMMER_WITHDRAWAL_CODE



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 14 State Assigned Student



15 Filler 11 X(11)



STUDENT END OF SERVICE MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 End Of Service Action Date


13 End Of Service Action 1 X Student > Other Info > Next Year > Year End Status

and

Student > Other Info > Graduation Information > Graduation Date

K12.EnrollmentInfo.StudentSOREnrollment.YearEndStatus

and


K12.Demographics.Year End Status

14 Completion Document Date

8 9(8) Student > Other Info > Graduation Information > Graduation Date

K12.Student.GraduationDate N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 15 Completion Document

Type 1 9 Student > Other Info >

Graduation Information > Diploma Type

K12.Student.DiplomaType K12.Diploma Type

16 Completion Document Period

2 X(2) Student > Other Info > Graduation Information > Graduation Semester

K12.Student.GraduationSemester K12.GraduationSemester




18 Filler 11 X(11)



STUDENT CLUB MEMBERSHIP MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:










12 Club ID 15 X(15) Calculated Calculated N/A

13 Club Membership Begin Date


14 Club Membership End Date





16 Filler 20 X(20)



STAFF MEMBER MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A

6 School ID 4 9(4) System > Setup > Organization > District > District Information





Calculated from:



9 Staff Social Security Number

9 9(9) Staff > Staff > General > Staff Info > Social Security Number


10 Teacher License Number 9 9(9) Staff > Staff > General > Staff Info > Teacher / Administrator License Number


11 Local Staff Key 10 9(10) Synergy > Schedule > Section

Synergy> Staff> Staff >General>Badge Number

K12.Staff.Badgenum N/A

12 First Name 15 X(15) Staff > Staff > General > First Name

K12.Staff.FirstName N/A

13 Middle Name 15 X(15) Staff > Staff > General > Middle Name

K12.Staff.MiddleName N/A

14 Last Name 25 X(25) Staff > Staff > General > Last Name

K12.Staff.LastName N/A

15 Suffix 3 X(3) Staff > Staff > General > Suffix K12.Staff.Suffix N/A 16 Date of Birth 8 9(8) Staff > Staff > General > Staff

Info >Birth Date K12.Staff.BirthDate N/A

17 Staff Previous Social Security Number

9 9(9) Staff > Staff > General > Staff Info > Previous Social Security Number

K12.Staff.

PreviousSocialSecurityNumber

N/A

18 Staff Previous Teacher License Number

9 9(9) Staff > Staff > General > Staff Info > Previous Teacher License Number

K12.Staff.

PreviousTeacherLicenseNumber

N/A



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 19 Previous First Name 15 X(15) Staff > Staff > General > Former

Names > First Name K12.Staff.AKAFirstName N/A

20 Previous Last Name 25 X(25) Staff > Staff > General > Former Names > Last Name

K12.Staff.AKALastName N/A

21 Gender 1 X Staff > Staff > General > Gender K12.Staff.Gender Revelation.Gender 22 Ethnicity 1 X Staff > Staff > General > Race

and Ethnicity > Hispanic / Latino K12.Staff.HispanicIndicator Revelation.HispanicEthnicity

23 American Indian or Alaskan Native

1 X Staff > Staff > General > Race and Ethnicity > Race



24 Asian 1 X Staff > Staff > General > Race and Ethnicity > Race



25 Native Hawaiian or Pacific Islander

1 X Staff > Staff > General > Race and Ethnicity > Race



26 Black or African American 1 X Staff > Staff > General > Race and Ethnicity > Race



27 White 1 X Staff > Staff > General > Race and Ethnicity > Race



28 Filler 4 X(4) 29 Licensure Check 1 X Staff > Staff > General > Staff

Info > Licensure Check K12.Staff.LicensureCheck K12.Licensure Check

30 Waive Request Course 4 9(4) N/A N/A N/A 31 Staff Status 1 X Staff > Schools > Staff School

Assignments Detail > FTE K12.StaffSchoolYear.FTE N/A

32 Filler 20 X(20)



STAFF MEMBER CURRENT ASSIGNMENT MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A



7 School Year 4 9(4) Focus Year N/A 8 Staff Social Security

Number 9 9(9) Staff > Staff > General > Staff

Info > Social Security Number K12.Staff.SocialSecurityNumber N/A



10 Local Staff Key 10 9(10) Staff > Staff > General > Staff Info > Badge Number


11 Current Assignment 2 XX Calculated Calculated K12.Staff.SupportType

K12.Staff.District Support Type 12 Current Assignment Begin

Date 8 9(8) Calculated Calculated

13 Current Assignment End Date

8 9(8) Calculated Calculated

14 Filler 12 X(20)



STAFF MEMBER CLASS ASSIGNMENT MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A



7 School Year 4 9(4) Focus Year N/A 8 Staff Social Security

Number 9 9(9) Staff > Staff > General > Staff

Info > Social Security Number K12.Staff.SocialSecurityNumber N/A



10 Local Staff Key 10 9(10) Staff > Staff > General > Staff Info > Badge Number


11 Local Class Number 15 X(15) Schedule > Section > Section ID K12.ScheduleInfo.Section.SectionID N/A

12 Staff Class Begin Date 8 9(8) Schedule > Section > Staff History (Tab)

K12.ScheduleInfo.SchoolYearSectionStaffHistory.EffectiveDate

N/A

13 Staff Class End Date 8 9(8) Calculated Calculated N/A 14 Teacher of Record 1 X Calculated Calculated K12.ScheduleInfo.Staff Responsibility 15 Federally Funded Class 1 X Calculated from:

Course > District Course > Course > Other Information > Funding Source

and

Schedule > Section > Section Info > Supplemental Funding Category

Calculated from:

K12.CourseInfo.Course.FundingSource

and

K12.ScheduleInfo.Section.

SupplementalFundingCategory

K12.CourseInfo.Funding Source

K12.AttendanceInfo.Supplemental Funding Cat

16 Filler 18 X(18)



STUDENT FINAL GRADE MAP Filler

Key Fields Info Needed

Columns Field Max



DistrictNumber

N/A




N/A


N/A N/A



Calculated from:










12 Year Class Was Taken 4 9(4) Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.CalendarYear

N/A

13 Term Class Was Taken 2 X(2) Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.TermCode

Or

K12.CourseHistoryInfo.StudentCourseHistory.TermCodeActual

K12.CourseInfo.Course Duration

14 Grade Assignment When Class Was Taken

2 X(2) Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.Grade

K12.Grade



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 15 Private or Out of State

Transfer 1 X Calculated Calculated K12.Setup.Non District School Type

16 Course Code 5 9(5) Course > District Course K12.CourseInfo.Course.StateCourseCode

Or

K12.CourseInfo.Course.StateCourseCodeDD

If option is selected in the District Setup

K12.courseinfo.STATE_COURSE_CODE

17 Local Course Number 15 X(15) Course History > Student

Course History

Or

Course > District Course


Or

K12.CourseInfo.Course.CourseID

N/A

18 Credits Attempted 3 9V99 Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.CreditAttempted

N/A

19 Credits Earned 3 9V99 Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.CreditCompleted

N/A

20 Alpha Grade 2 X(2) Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.MarkDD

K12.CourseHistoryInfo.Mark

21 Numeric Grade 3 9(3) Course History > Student Course History

K12.CourseHistoryInfo.StudentCourseHistory.Mark

22 Quality Points 1 9 Course History > Student Course History Screen > Course History Tab > Courses Grid > Courses Detail Screen > Student Course Information Tab > Course Information Area > Quality Point Field

K12.CourseHistoryInfo.StudentCourseHistory.RigorPoint

N/A




24 Filler 20 X(20)



STUDENT TA INSTRUCTIONAL SERVICES MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 TA Instructional Assistance

2 9(2) Calculated Calculated K12.CourseInfo.Department




14 Filler 20 X(20)



STUDENT TA SUPPORT SERVICES MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 TA Support Assistance 2 9(2) Student Programs > Student Needs

Calculated TA Support Assistance




14 Filler 20 X(20)



STUDENT CHOICE APPLIED MAP Filler

Key Fields

Columns Field Max



DistrictNumber

N/A




N/A




Calculated from:










12 Student Choice Applied 1 X Student > Enrollment History > Other Information > School Information > School of Choice Status (DD)

K12.Student.StudentSchoolYear.SchoolChoiceStatus

K12.Enrollment.School Choice Status


9 9(9) Synergy> Student> Student


14 Filler 20 X(20)



SPECIAL EDUCATION OPTION MAP Filler


Columns Field Max



DistrictNumber

N/A




N/A









11 SE Option Level 1 X 13 SE Option Number 2 99 14 SE Option Begin Date 8 9(8) N/A 15 SE Option End Date 8 9(8) N/A 16 State Assigned Student



17 Filler 11 X(11)



SPECIAL EDUCATION DISABILITIES MAP Filler


Columns Field Max



DistrictNumber

N/A




N/A

7 School Year 4 9(4) Focus Year n/a N/A








11 SE Disability Level 1 X Student Programs > Special Ed Student Services > Services > Services (Detail View) > Primary Need

N/A

12 SE Disability Code 2 99 Student Programs > Special Ed Student Services > Services > Services > Service Code

Calculated Special Ed Service Definition

13 SE Disability Begin Date 8 9(8) Student Programs > Special Ed Student Services > Services > Services > Enter Date

Calculated N/A

14 SE Disability End Date 8 9(8) Student Programs > Special Ed Student Services > Services > Services > Exit Date

Calculated N/A




16 Filler 11 X(11)



TRANSMIT TRAILER MAP Filler

Key Fields

Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 1 Record ID 3 9(3) 2 Record Version 2 99 3 Filler 2 99 4 District ID 3 9(3) System > Setup > Organization


DistrictNumber

N/A

5 TT Extract Date 8 9(8) 6 TT File Name 20 X(20) 7 TT Count 010 9 9(9) 8 TT Count 011 9 9(9) 9 TT Count 015 9 9(9)

10 TT Count 020 9 9(9) 11 TT Count 021 9 9(9) 12 TT Count 022 9 9(9) 13 TT Count 030 9 9(9) 14 TT Count 031 9 9(9) 15 TT Count 040 9 9(9) 16 TT Count 041 9 9(9) 17 TT Count 042 9 9(9) 18 TT Count 043 9 9(9) 19 TT Count 044 9 9(9) 20 TT Count 045 9 9(9) 21 TT Count 046 9 9(9) 22 TT Count 047 9 9(9) 23 TT Count 048 9 9(9) 24 TT Count 049 9 9(9) 25 TT Count 050 9 9(9) 26 TT Count 051 9 9(9) 27 TT Count 052 9 9(9) 28 TT Count 060 9 9(9) 29 TT Count 061 9 9(9) 30 TT Count 062 9 9(9) 31 TT Count 063 9 9(9) 32 TT Count 080 9 9(9) 33 TT Count 081 9 9(9) 34 TT Count 082 9 9(9) 35 TT Count 083 9 9(9) 36 TT Count 090 9 9(9) 37 TT Count 091 9 9(9)



Columns Field Max

Length Format Synergy SIS Location Edupoint BO and Property Lookup Table 38 TT Count 092 9 9(9) 39 TT Count 093 9 9(9) 40 TT Total Count All Record

Types 9 9(9)

41 Filler 2 X(2)