Filter and Report Designer

Technical Guide

Objectives:

Filter and Report Designer Tools

Filter Field Mappings and Definitions

©2009 Infinite Campus, Inc. All rights reserved.

INFINITE CAMPUS and Transforming K12 Education are registered trademarks of Infinite

Campus, Inc. The INFINITE CAMPUS logo is a trademark of Infinite Campus, Inc. This

publication, or any part thereof, may not be reproduced or transmitted in any form or any means,

electronic or mechanical, including photocopying, recording, storage in an information retrieval

system, or otherwise, by anyone other than Infinite Campus, Inc. without written permission of

Infinite Campus, Inc., 4321 109th Avenue NE, Blaine, MN 55449, tel. (651) 631-0000, email info@

infinitecampus.com.

Introduction

5

How to Use This Document

6

Overview

7

Filter Designer

7

Report Designer

7

Tool Rights

7

Filter and Report Designers

8

Data Warehouse Tool Rights

8

Filter Data Types

10

Filter Operators

10

Report

Designer

12

Appendix A – Student Filter Fields (Filter and Report Designer)

14

Student > Demographics

14

Student > School Calendar

18

Student > School

19

Student > District

21

Student > Learner > Active Enrollment

23

Student > Learner > Graduation Elements

26

Student > Learner > State Localized Elements*

27

Student > Learner > Enrollment History

27

Student > Learner > Membership Day Counts

45

Student > Learner > Membership/Attendance Detail

45

Student > Learner > Programs

46

Student > Medicaid

77

Student > Behavior

81

Student > Attendance

86

Student > Assessment

98

Student > Grading

104

Student > Learner Portfolio

107

Student > Locker

110

Student > Fee

112

Student > Transportation

113

Student > Activities

114

Student > Campus Usage

115

Appendix B – Census/Staff Filter Fields (Query Wizard)

118

(Census/Staff) Person > Demographics

118

(Census/Staff) Person > Census

120

(Census/Staff) Person > Staff

127

(Census/Staff) Person > Campus Usage

142

Appendix C – Course/Section Filter Fields (Query Wizard)

144

Course > Course Information

144

Course > Section Information

147

Course > School Calendar

150

Course > School

152

This technical guide provides definitions and mappings of the field-level elements used in ad

hoc reporting. Elements defined in this document include fields from the Report Designer tool

and fields from the Query Wizard of the Filter Designer tool. A general technical section about

these tools is also included.

NOTE: For general documentation purposes, this guide was based off of a specific

instance of ad hoc setup. Localized elements may not appear in this document.

As desired, customers may request state-specific documentation.

Audience

The information contained in this document is intended for use by Campus internal staff,

Cam-pus district/system administrators and district/school staff members in charge of ad hoc

report-ing.

Documentation

Related documentation may be available. Please check the Help Index and/or the Customer

Support Portal: http://support.infinitecampus.com.

• For detailed user information on the ad hoc reporting tools, please see the Ad Hoc

User Guide.

• For technical information on other ad hoc reporting tools, please see the Cube

De-signer Technical Reference or the Ad Hoc Reporting Technical Reference.

• For information on configuring the Data Warehouse for use with ad hoc reporting,

please see the Data Warehouse Technical Reference.

Software Support

Contact the District Campus Administrator for additional guidance and software support.

Campus administrators should contact their designated support representative or Campus

Support.

Feature Updates

Please see the most current release notes for product fixes and enhancements. Recently

addressed modifications to the user interface are viewable within the Help Index when those

items have adequately passed quality assurance procedures.

Hardware Requirements

The tasks mentioned in this technical guide may be performed on a PC or Macintosh. Please see

the Supported Platforms Technical Reference, available on the Customer Support Portal, for specific

requirements.

NOTE: Please read this page for best results in using this document.

The name of an ad hoc element is not necessarily the name listed in the user interface; therefore,

this document briefly defines and maps ad hoc element to the appropriate interface locations/

fields.

As this document has been rendered into a PDF, searching for specific ad hoc elements can be

done quickly through the Find toolbar in Adobe Acrobat/Reader.

Using the “Find” Toolbar to Locate Information

When viewing this document in Adobe Acrobat/Reader:

1.

Hold the keyboard “Ctrl” key down while also hitting the “F.” This enables the Find

feature.

Step 1

2.

Enter the element for which to search. (Example: “endYear”)

3.

Hit “Enter” on the keyboard. The first instance of the searched element (“endYear”) will

be located, as shown:

Step 3

4.

Use the “Next” arrow on the Find toolbar to view additional entries for the searched

element.

The ad hoc reporting tools allow users to create custom queries and reports on various types

of information stored within the Campus database. Reports may be used for data analysis

and state reporting and queries may be exported out of Campus or used to create filters for

standard reports. Custom filters and reports are built by adding elements from ad hoc reporting

tools like the Filter Designer and the Report Designer.

Filter Designer

To assist users in creating custom filters, the ad hoc Filter Designer tool has three main

components: the Query Wizard, the Selection Editor and the Pass-Through SQL Query. Filters

can be tested, used and saved for later use within the Filter Designer tool.

• The Query Wizard allows users to create a filter by selecting specific data fields from

within the product. These elements are similar to those available within the Report

Designer.

• The Selection Editor allows users to manually select a group of students on whom a

report can be run. This editor is for creating student filters only.

• A Pass-Through SQL Query allows users with basic SQL and Campus schema

knowledge to build their own queries on student information.

Report Designer

The Report Designer tool allows users to build custom letters that can be saved and later

generated and printed through the Report Builder. Reports can be formatted as blank form

letters or addressed form letters.

Filter elements available in the Report Designer are similar to those available in the Query

Wizard of the Filter Designer. In addition to adding field elements, the Report Designer allows

users the option of inserting entire sub-reports into the report/form being designed.

Tool Rights

This section explains the user tool rights necessary for controlling access to the Filter Designer

and Report Designer tools.

NOTE: A system administrator will already have access to the following areas, as long

as the All Tools checkbox is flagged on his/her user account.

TOOL RIGHTS PATH: Ad Hoc Reporting > Filter Designer and Report Designer

The following tool rights control access to the ad hoc tools, as they relate to this document:

R – Allows user to view the list of existing Ad hoc filters.

W – Allows user to edit existing Ad hoc filters.

A – Allows user to create new Ad hoc filters.

D – Allows user to delete existing Ad hoc filters.

Filter and Report Designer Tool Rights

In addition to these rights, the user may need R rights assigned to the following areas to allow

full access to reporting on Student, Census/Staff or Course/Section filter data types.

• Student Information > General > Summary > GUID

• Student Information > General > Summary > State ID

• Census > People > Demographics > GUID

• Census > People > Demographics > State ID

• Census > People > Demographics > SSN

• Scheduling > Courses > Sections > Section

• Scheduling > Courses > Course

Data Warehouse Tool Rights

and query purposes.

Campus installations that utilize Data Warehouse functionality may choose to use it for ad hoc

reporting. After the Data Warehouse (DW) has been properly configured, tool rights may be set

for each (ad hoc) user to define his/her data source for reporting purposes.

NOTE:

When a DW is enabled on a site, it becomes the default data source for all ad hoc

reporting.

If a user needs the option to choose to report on data from the live Campus database OR the

DW snapshot, he/she must be assigned R rights to the Data Warehouse: Allow Live Data As

Source tool right.

In the Filter Designer, the user will then be able to select which data source to use for the report:

Data Source Options (when R rights to Data Warehouse: Allow Live Data Source)

If the user does not have R rights to the Data Warehouse: Allow Live Data As Source tool

right, the DW will be the only data source available:

In combination with the Query Wizard, Selection Editor and Pass Through SQL Query filters,

data is categorized in three ways: Student, Census/Staff and Course/Section.

• Student: When a filter is created for Student data, the information is pulled from the

calendar and school currently displaying in the Campus toolbar. Users who have

permission may select All Years and/or All Schools from the Campus Toolbar to

view information from more than one calendar.

• Course/Section: When a filter is created for Course/Section data, the information

is pulled from the calendar and school currently displaying in the Campus toolbar

(unless All Years or All Schools is selected). Data cannot be selected for this option

when using the Selection Editor, which is a student filter only.

• Census/Staff: When a filter is created for Census/Staff data, census information is

pulled from the entire Campus database; staff information is pulled for the school

selected in the Campus Toolbar. Data cannot be selected for this option when using

the Selection Editor, which is a student filter only.

NOTE:

(Data Warehouse customers: please disregard this note)

Large queries pulling from

the live database may slow server time and affect performance district-wide. As

such, queries should be created in sets that avoid large results.

Filter Operators

Data selected within the Query Wizard can be filtered with the following filter operators:

Operator

Results

Example

= Equals

Returns exact match of value.

student.grade=3

will return all students in grade

3.

<

> Does Not Equal

Returns results not equal to

value.

student.gender<>M

will return all females or

students whose gender field is

null.

> Greater Than

Returns results that are greater

_{than value.}

age>=16

will return all students older

than age 16.

>

=

Greater Than or

Equal To

Returns results that are greater

than or equal to value.

age>=16

will return all students age 16

and older.

<

=

Less Than or Equal

To

Returns results that are less

than or equal to value.

will return all students age 16

_{and younger.}

IN

Includes value.

student.grade IN 9,10

will return students in 9th and

10th grade. No spaces between

commas.

NOT IN

Excludes value.

student.grade NOT IN 11,12

will return all students not in

11th or 12th grade. No spaces

between commas.

LIKE

Searches for text string in field.

course LIKE hist

will return courses like History

101.

SOUNDS LIKE

Returns names with similar

_{Soundex patterns.}

student.LastName SOUNDS

LIKE Ball

will return “Ball,” “Bell” and

“Boll.”

IS NULL

Returns empty fields.

student.StateID IS NULL

will return all students without

a stateID.

IS NOT NULL

Returns fields containing data.

student.ssn IS NOT NULL

will return all students who

have social security numbers

entered in Campus.

IS TODAY

Returns results dated as today.

start.date IS TODAY

will return results for current

date.

IS YESTERDAY

Returns date results dated as

_yesterday.

end.date IS YESTERDAY

will return results for one day

previous to current date.

=TRUE

Returns checkbox values of

_{“true” (flagged checkbox).}

enrollment.stateExclude=TRUE

will return students who have

the State Exclude checkbox

flagged.

=FALSE

Returns checkbox values of

_{“false” (unflagged checkbox).}

householdMember.

guardian=FALSE

will return household members

who do not have the Guardian

checkbox flagged.

Query Wizard filter fields are defined and mapped in Appendices A-C, located at the end of

this document.

In the Report Designer, a user may insert sub-reports and student filter fields similar to those

available in the Filter Designer Query Wizard. Report Designer filter fields are defined and

mapped in Appendix A, located at the end of this document.

NOTE: The Report Designer allows elements to be added and formatted into a report,

but does NOT actually generate a report. To generate the report created in

Report Designer, the Report Builder tool or the student’s Ad Hoc tab must be

used. Therefore, all sub-report information returned by the Report Builder

will depend on the year and school selected in the Campus Toolbar at the time

report is generated.

The following sub-reports are available for insertion into a report created in the Report

Designer:

Area

Report Designer

Sub-Reports

Sub-Report Description

Learner

Student Schedule

Inserts student’s course schedule, displayed

by term and period.

Attendance

Exact Day Summary

Inserts the exact decimal of days absent

in relation to whole days (i.e. Term 2

absent days might display as 4.83 absent

days). A count of tardies is also included.

Attendance events display per term and as

a total.

Grading

Grade Detail

Inserts course information (i.e. number,

name, teacher), grading task name (e.g.

progress grade, semester grade), term (e.g.

T1, T4) and the student’s grade.

Term GPA Summary

Inserts GPA value, calculated per term.

Behavior

Discipline Summary

Inserts the following information on

student behavior events, organized by date:

behavior event, behavior event comments,

behavior role comments, resolution

comments, reported by staff member,

referred to staff member, resolution,

resolution start date and resolution end

date.

Student

Health

Immunization

Inserts immunization information,

including: immunization certificate

date, expiration and type; immunization

compliance status and immunization shot

dates.

Point of Sale

POS Account Balance

The following fields are available in the Filter Designer. The filter field name and the actual

interface field name may differ. Interface field names are capitalized within the definition when

referenced.

Student > Demographics

Filter Field

Mapping and Definition

Student > Demographics

personID Census > People > Demographics _{Internal database identifier.}

stateID Census > People > Demographics Unique identifier issued to a student by the state department of education for state reporting purposes.

otherID Census > People > Demographics Additional identifier for student, used in multi-state implementations.

studentNumber

Census > People > Demographics

The unique numerical identifier assigned to a student enrolled in a school that can be formatted to district preferences and is used in state reporting.

personGUID Census > People > Demographics _{Internal database identifier.} identityID Internal database identifier. effectiveDate Census > People > Identities_{Date identity became active.}

lastName Census > People > Demographics _{Last name of identity.}

firstName Census > People > Demographics _{First name of identity.}

middleName Census > People > Demographics _{Middle name of identity.}

suffix Census > People > Demographics _{Indication of Jr., Sr., III, IV, etc.}

alias Census > People > Demographics _{Nickname used instead of given name.}

gender Census > People > Demographics _{Male or female.}

birthdate Census > People > Demographics _{Birth date of person.}

ssn Census > People > Demographics _{Social security number of individual.}

raceEthnicity Census > People > Demographics _{Race/ethnicity of person.}

hispanicEthnicity Census > People > IdentitiesIf flagged, checkbox indicates person is considered to be of Hispanic/ Latino ethnicity. Not used in all states.

raceEthnicityFed Student Information > DemographicsFederal race/ethnicity code. May be different than the raceEthnicity selection.

raceEthnicityDetermination Student Information > DemographicsSelection of how the individual was determined to be the selected race/ethnicity.

birthCountry Census > People > Demographics _{Selection of country of birth, if not US.} enrollmentID Internal database identifier.

grade Census > People > Enrollments Notes the grade level of the student.

serviceType Census > People > Enrollments Lists the assigned type of enrollment. Options include Primary, Special Education and Partial.

startDate Census > People > EnrollmentsNotes the start date of enrollment at the school, defined as the first day student began receiving instruction.

startStatus Census > People > EnrollmentsLists the enrollment start code for the student. Codes are often state-specific and are used in several state reporting extracts.

endDate Census > People > Enrollments Notes the end date of enrollment at the school. This must be the last day the student received instruction.

endStatus Census > People > EnrollmentsLists the enrollment end code for the student. These codes are often state-specific and are used in several state reporting extracts. calendarID Internal database identifier.

structureID Internal database identifier. schoolID Internal database identifier. districtID Internal database identifier.

calendarName System Administration > Calendar > CalendarUser-entered name of the calendar name associated with this historical enrollment.

calendarStart System Administration > Calendar > CalendarLists the date when the calendar is first used. This is NOT the first day of instruction, but could be the first day the staff is available.

calendarEnd System Administration > Calendar > CalendarLists the date when the calendar is last used. This is NOT the last day of instruction, but could be the last day the staff is available.

startYear System Administration > Calendar > CalendarThe 4-digit year marking the start of the school year (i.e. 2005 would be the start of the 05-06 school year).

endYear System Administration > Calendar > CalendarThe 4-digit year marking the end of the school year (i.e. 2006 would be the end of the 05-06 school year).

label System Administration > Calendar > CalendarThe name used to represent the school year (i.e. 05-06, 2005-2006, etc.).

activeYear System Administration > Calendar > CalendarFlag to indicate that this is the current active school year. This controls things like default information in the parent portal, etc.

activeToday

Internal indication that calendar is currently active.

activeToday means the student must be active on the current date. Operator rules such as = , <=, etc., do not work for this data element. This field uses the following logic:

• If the student is active on the date the report was generated, will display as 1: active.

• Considers the Start Date greater than or equal to (>=) the current date and will display as 1.

• Considers the End Date of less than or equal to(<=) the current date and will display as 1.

teamName Displays in Student Information Header_{Scheduling team to which student is assigned.}

age Displays in Student Information Header_{Calculation of age based on birth date and current date.}

he_she Reporting element only_{Pronouns available for personalizing form letters.}

He_She_capital Reporting element only_{Pronouns available for personalizing form letters.}

his_her Reporting element only_{Pronouns available for personalizing form letters.}

His_Her_capital Reporting element only_{Pronouns available for personalizing form letters.}

stateGrade System Administration > Calendar > Grade Levels > State Grade level Code_{How the local grade level maps to the state grade level.}

homeroomTeacher Reporting element onlyStudent’s assigned homeroom teacher, as designated by Homeroom checkbox of Course > Section. Not used in all states.

Identity History

identityID Internal database identifier. personID Internal database identifier. effectiveDate Census > People > Identities_{Date identity became active.}

lastName Census > People > Identities_{Last name of identity.}

firstName Census > People > Identities_{First name of identity.}

middleName Census > People > Identities_{Middle name of identity.}

suffix Census > People > Identities_{Indication of Jr., Sr., III, IV, etc.}

alias Census > People > Identities_{Nickname used instead of given name.}

gender Census > People > Identities_{Male or female.}

birthdate Census > People > Identities_{Birth date of person.}

ssn Census > People > Identities_{Social security number of individual.}

raceEthnicity Census > People > Identities_{Race/ethnicity of person.}

birthCountry Census > People > Identities_{Selection of country of birth, if not U.S.}

dateEnteredUS Census > People > Identities_{Date person entered U.S.}

birthVerification Census > People > IdentitiesBirth Verification certificate type (e.g. birth certificate, immigration document, physician’s certificate). Not used in all states.

comments Census > People > Identities_{Additional information associated with identity of person.} districtID Internal database identifier.

hispanicEthnicity Census > People > IdentitiesIf flagged, checkbox indicates person is considered to be of Hispanic/ Latino ethnicity. Not used in all states.

identityGUID Internal database identifier. lastNamePhonetic Used in sound-alike searches. firstNamePhonetic Used in sound-alike searches. dateEnteredState Census > People > Identities_{Date student originally entered state.}

birthCertificate Census > People > Identities_{Type of document used to verify existence of person.}

immigrant Student Information > General > Enrollments_{Indicates the student being of immigrant status.}

dateEnteredUSSchool Census > People > Identities_{Date student entered a U.S. school for the first time.}

raceEthnicityFed Student Information > DemographicsFederal race/ethnicity code. May be different than the raceEthnicity selection.

raceEthnicityDetermination Student Information > DemographicsSelection of how the individual was determined to be the selected race/ethnicity.

Student > School Calendar

calendarID Internal database identifier. districtID Internal database identifier. schoolID Internal database identifier.

endYear System Administration > Calendar > School YearsRefers to the last year of a school year. For example, calendars for 2007-08 have the end year 2008.

name System Administration > Calendar > Calendar_{Displays the name of the calendar.}

number System Administration > Calendar > Calendar_{Displays the number of the calendar for reference purposes.}

startDate System Administration > Calendar > CalendarLists the date when the calendar is first used. This is NOT the first day of instruction, but could be the first day staff is available.

endDate System Administration > Calendar > CalendarLists the date when the calendar is last used. This is NOT the last day of instruction, but could be the last day staff are available. comments System Administration > Calendar > Calendar_{Notes any comments associated with the calendar.}

exclude System Administration > Calendar > CalendarWhen this checkbox is marked, the calendar is not used in state reporting extracts.

summerSchool System Administration > Calendar > CalendarWhen this checkbox is marked, the calendar is labeled as a summer school calendar.

studentDay System Administration > Calendar > CalendarLists the total number of minutes students are scheduled into courses.

teacherDay System Administration > Calendar > CalendarLists the total number of minutes teachers are available for instruction and prep time.

wholeDayAbsence

System Administration > Calendar > Calendar

Lists the total number of minutes that constitutes a full day of absence per a district or state decision. Used in calculating ADM and ADA.

halfDayAbsence

System Administration > Calendar > Calendar

Lists the total number of minutes that constitutes a half day of absence per a district or state decision. Used in calculating ADM and ADA.

calendarGUID Internal database identifier.

alternativeCode System Administration > Calendar > CalendarIf flagged, checkbox indicates a 4 Day School Week. Not used in all states.

title1 System Administration > Resources > SchoolDisplays the selection of the Title 1 funding options. Not used in all states.

legacyKey Used during data conversion.

schoolchoice System Administration > Calendar > CalendarIf flagged, checkbox indicates calendar is labeled as using school choice functionality.

type System Administration > Calendar > CalendarCalendar type is usually (I)nstructional, but can also be (S)ummer School, (R)esidential, etc.

countDate System Administration > Calendar > Calendar_{Testing Count Date. Not used in all states.}

assignmentRequired System Administration > Calendar > CalendarDefines if students enrolling in this calendar are required to follow school boundary assignment logic.

Calendar Assignment Override

calendarOverrideID Internal database identifier.

calendarID Internal database identifier of parent calendar.

overridetype System Administration > Calendar > Calendar > Overrides_{Displays selection of type of override used in school placement.}

  Some areas/fields not currently available in the Report Designer.

Student > School

Filter Field

Mapping and Definition

Student > School

schoolID Internal database identifier. districtID Internal database identifier.

ncesSchoolID System Administration > Resources School_{NCES school number.}

number System Administration > Resources > School_{School location number.}

name System Administration > Resources > School_{Official name of School.}

type System Administration > Resources > School_{Designated type of school (e.g. Elementary, Middle, High, etc.).}

comments System Administration > Resources > School_{User-entered notes about the school.}

address System Administration > Resources > School_{Mailing address of school building.}

city System Administration > Resources > School_{Mailing city of school building.}

state System Administration > Resources > School_{State of school building.}

zip System Administration > Resources > School_{Zip code of school building.}

phone System Administration > Resources > School_{Phone number of school building.}

fax System Administration > Resources > School_{Fax number of school building.}

email System Administration > Resources > School_{Email of school building.}

url System Administration > Resources > School_{Web site address of school.}

dualEnrollment System Administration > Resources > SchoolChecked if school allows students to be enrolled in two buildings at one time.

title1 System Administration > Resources > School_{Displays the selection of the Title 1 funding options.}

principalName System Administration > Resources > School_{Name of principal.}

principalTitle System Administration > Resources > School_{Name of principal’s title.}

principalEmail System Administration > Resources > School_{Email of principal.} schoolGUID Internal database identifier.

catalogID Internal database identifier.

satNumber System Administration > Resources > School_{School number for SAT purposes; varies by state (e.g. CEEB, CBBC).}

standardCode System Administration > Resources > School_{Code related to SIF/DIS information.}

agency System Administration > Resources > SchoolAgency (Education Line Office) associated with school. Not used in all states.

groupNumber District number assigned by and only used in the federal installation to allow tracking of both the state-assigned district number and the federal assigned number.

aypGrouping System Administration > Resources > SchoolAYP Grouping of school (e.g. K-8, 9-12, exclude). Not used in all states.

reportingSchoolID Internal database identifier.

physicalAddress System Administration > Resources > School_{Physical address of school building.}

physicalCity System Administration > Resources > School_{Physical city of school building.}

physicalState System Administration > Resources > School_{Physical state of school building.}

physicalZip System Administration > Resources > School_{Physical zip code of school building.}

county System Administration > Resources > School_{County of school. Not used in all states.}

status System Administration > Resources > School_{Operational Status of school. Not used in all states.}

accreditation System Administration > Resources > School_{Accreditation Status of school. Not used in all states.}

gradeType System Administration > Resources > School_{Grade Type associated with school. Not used in all states.}

sector System Administration > Resources > SchoolSector of education school is related to (e.g. public, non-public). Not used in all states.

locale System Administration > Resources > SchoolLocale Code indicating school size and location. Not used in all states.

locale2 System Administration > Resources > SchoolLocale Old Code indicating school size and location. Not used in all states.

blueRibbon System Administration > Resources > SchoolIf flagged, checkbox indicates school is considered a Blue Ribbon School. Not used in all states.

title1distinguished System Administration > Resources > SchoolIf flagged, checkbox indicates school is considered a Title 1 Distinguished School. Not used in all states.

entityID System Administration > Resources > School_{Reporting entity for the school. Not used in all states.}

aypStatus System Administration > Resources > School_{Indicator of school’s AYP School Status. Not used in all states.}

size System Administration > Resources > School_{The school’s MHSA Designation. Not used in all states.}

sessionType Not applicable to interface_{SIF element.}

  Some areas/fields not currently available in the Report Designer.

Student > District

Filter Field

Mapping and Definition

Student > District

districtID Internal database identifier.

ncesDistrictID System Administration > Resources > District Information_{NCES District internal database identifier.}

number System Administration > Resources > District Information_{State-assigned district number.}

type System Administration > Resources > District Information_{State-defined district type used by some states for state reporting.}

state System Administration > Resources > District Information_{State in which the district exists.}

comments System Administration > Resources > District Information_{User-entered additional information.}

address System Administration > Resources > District Information_{Mailing address of the district office.}

city System Administration > Resources > District Information_{Mailing city of the district office.}

zip System Administration > Resources > District Information_{Mailing zipcode (zip+4 available) of the district office.}

county System Administration > Resources > District Information_{Mailing county of the district office.}

phone System Administration > Resources > District Information_{General information phone number for the district office.}

fax System Administration > Resources > District Information_{General fax number for the district office.}

email System Administration > Resources > District Information_{General information email for the district office.} districtGUID Internal database identifier.

stateLinked System indicator to determine whether district is linked with a state _{or regional installation of Campus.}

url System Administration > Resources > District Information_{General URL for the district.}

contactLastName System Administration > Resources > District Information_{Primary contact last name for the district.}

contactFirstName System Administration > Resources > District Information_{Primary contact first name for the district.}

inactive System indicator to determine if the district is currently active. spedFax System Administration > Resources > District Information_{District Special Ed office fax number.}

spedPhone System Administration > Resources > District Information_{District Special Ed office phone number.}

spedContactFirstName System Administration > Resources > District Information_{District Special Ed contact first name.}

spedContactLastName System Administration > Resources > District Information_{District Special Ed contact last name.}

regionNumber System Administration > Resources > District InformationThe state-defined region that logically or physically groups districts together for reporting purposes.

legacyKey Used during data conversion.

spedAddress System Administration > Resources > District Information_{District Special Ed mailing address.}

spedCity System Administration > Resources > District Information_{District Special Ed mailing city.}

spedState System Administration > Resources > District Information_{District Special Ed mailing state.}

spedZip System Administration > Resources > District Information_{District Special Ed mailing zip code (zip+4 available).}

spedCounty System Administration > Resources > District Information_{District Special Ed mailing county.}

groupNumber District number assigned by and only used in the federal installation to allow tracking of both the state-assigned district number and the federal assigned number.

federalTaxID System Administration > Resources > District Information_{Federal ID for Medicaid billing.}

nationalProviderID System Administration > Resources > District Information_{National Provider ID for Medicaid billing.}

mchpProviderID System Administration > Resources > District Information_{MHCP Provider ID for Medicaid billing.}

districtCode System Administration > Resources > District InformationDistrict Code indicating district type (e.g. Public Schools, Correctional Facilities, Alternative). Not used in all states.

physicalAddress System Administration > Resources > District Information_{Physical address of district.}

physicalCity System Administration > Resources > District Information_{Physical city of district.}

physicalState System Administration > Resources > District Information_{Physical state of district.}

physicalZip System Administration > Resources > District Information_{Physical zip code of district.}

status System Administration > Resources > School_{Operational Status of school. Not used in all states.}

  Some areas/fields not currently available in the Report Designer.

Student > Learner > Active Enrollment

Filter Field

Mapping and Definition

Student > Learner > Active Enrollment

Active Enrollment Internal reference to the student being an actively enrolled student. Elements available in the following Active Enrollment area are also available in the Enrollment History area. Selecting a field from an Active Enrollment will return data from the student’s currently active enrollment, while selecting a field from the Enrollment History area will return data from the student’s enrollment history.

Core Elements

enrollmentID Internal database identifier. personID Internal database identifier.

calendarID Internal database identifier. structureID Internal database identifier.

grade Student Information > General > Enrollments_{Notes the grade level of the student.}

serviceType Student Information > General > EnrollmentsLists the assigned type of enrollment. Options include Primary, Special Education and Partial.

active Internal reference to the student being an actively enrolled student. classRankExclude Student Information > General > Enrollments_{If flagged, student will not be included in class rank determination.}

startDate Student Information > General > EnrollmentsNotes the Start Date of enrollment at the school. This must be the first day the student began receiving instruction.

startStatus Student Information > General > Enrollments_{Lists the enrollment start code for the student.}

startComments Student Information > General > Enrollments_{Lists any comments associated with the start of enrollment.}

endDate Student Information > General > EnrollmentsNotes the end date of enrollment at the school. This must be the last day the student stopped receiving instruction.

endStatus Student Information > General > Enrollments_{Lists the enrollment end code for the student.}

endComments Student Information > General > Enrollments_{Lists user-entered comments associated with the end of enrollment.}

endAction Student Information > General > EnrollmentsUsed in processing enrollments for the next school year. Options are Promote, Demote and Retain.

nextCalendar Student Information > General > EnrollmentsNotes into which calendar the student will be enrolled in the upcoming school year.

nextGrade Student Information > General > Enrollments Notes into which grade level the student will be enrolled in the upcoming school year.

servingDistrict Student Information > General > EnrollmentsDistrict of accountability that serves the student for programming and instruction.

enrollmentGUID Internal database identifier.

State Reporting Elements

stateExclude Student Information > General > EnrollmentsWhen marked, the student will not appear on any state reporting extracts.

residentDistrict Student Information > General > Enrollments_{Notes in which district the student lives.}

mealStatus Student Information > General > Enrollments_{Indicates the economic eligibility of the student.}

englishProficiency Student Information > General > LEP_{Indicates the student becoming proficient in English.}

language Student Information > General > EnrollmentsNotes the language most often spoken at home by the student and family.

transportation Student Information > General > Transportation_{A code indicating the type of transportation the student receives.}

migrant Student Information > General > EnrollmentsDropdown list indicates whether or not student is considered a migrant.

immigrant Student Information > General > Enrollments_{Indicates the student being of immigrant status.}

homeless Student Information > General > Enrollments_{Indicates the student being of homeless status.}

homebound Student Information > General > Enrollments_{Indicates the student is homebound.}

giftedTalented Student Information > General > EnrollmentsIndicates whether the student is Gifted/Talented. Not used in all states.

percentEnrolled Student Information > General > Enrollments_{Indicates the amount of time the student is enrolled.}

section504 Student Information > General > EnrollmentsIndicates the student is receiving and participating in Section 504 Programming.

dropoutCode Student Information > General > Enrollments_{Selected when the student ends enrollment not due to moving away.}

Special Ed Elements

specialEdStatus Student Information > General > EnrollmentsIndicates the type of special education status of the student. Students may have more than one status.

specialEdSetting Student Information > General > Enrollments_{Notes the specific setting of the special education student.}

disability1 Student Information > General > EnrollmentsPrimary disability of Student. Options are based on state designations.

disability2 Student Information > General > Enrollments_{If student has an additional disability.}

spedExitDate Student Information > General > Enrollments_{Date the student was exited from special education programming.}

spedExitReason Student Information > General > Enrollments_{Exit status reason for leaving special education programming.}

Student > Learner > Graduaction Elements

grade9Date Student Information > General > Graduation_{Indicates the date student first started ninth grade.}

cohortYearNGA Student Information > General > Graduation_{Four years after the year in grade9Date.}

cohortYearNCLB Student Information > General > Graduation_{Four years after the year in grade9Date.}

diplomaDate Student Information > General > Graduation_{Lists the date the student received a diploma.}

diplomaType Student Information > General > Graduation_{Describes the type of diploma the student received.}

diplomaPeriod Student Information > General > Graduation_{Indicates the time of year the student received the diploma.}

postGradPlans Student Information > General > Graduation_{The student’s Post Grad Plan. Not used in all states.}

postGradLocation Student Information > General > Graduation_{The student’s Post Grad Intended Location. Not used in all states.}

Student > Learner > State Localized Elements

THIS SECTION VARIES BY STATE. REQUEST ADDITIONAL DOCUMENTATION, AS NECESSARY.

  Some areas/fields not currently available in the Report Designer.

Student > Learner > Enrollment History

Filter Field

Mapping and Definition

Student > Learner > Enrollment History

For a list, mapping and definition of these elements, please refer to the Student > Learner > Active Enrollment section. Selecting a field from the Student > Learner > Active Enrollment area will return data from the student’s current, active enrollment, while selecting a field from the Student > Learner >Enrollment History area will return data from the student’s enrollment history. The Enrollment History area also contains the following, additional fields (not found in the Active Enrollment section):

Core Elements

enrollmentID Internal database identifier. personID Internal database identifier. calendarID Internal database identifier. structureID Internal database identifier.

grade Student Information > General > Enrollments _{Notes the grade level of the student.}

serviceType Student Information > General > Enrollments Lists the assigned type of enrollment. Options include Primary, Special Education and Partial.

active Internal reference to the student being an actively enrolled student. classRankExclude Student Information > General > Enrollments _{If flagged, student will not be included in class rank determination.}

startDate Student Information > General > Enrollments Notes the Start Date of enrollment at the school. This must be the first date the student began receiving instruction.

startStatus Student Information > General > Enrollments _{Lists the enrollment start code for the student.}

startComments Student Information > General > Enrollments _{Lists any comments associated with the start of enrollment.}

endDate Student Information > General > Enrollments Notes the end date of enrollment at the school. This must be the last day the student stopped receiving instruction.

endStatus Student Information > General > Enrollments _{Lists the enrollment end code for the student.}

endComments Student Information > General > Enrollments _{Lists user-entered comments associated with the end of enrollment.}

endAction Student Information > General > Enrollments Used in processing enrollments for the next school year. Options are Promote, Demote and Retain.

nextCalendar Student Information > General > Enrollments Notes into which calendar the student will be enrolled in the upcoming school year.

nextGrade Student Information > General > Enrollments Notes into which grade level the student will be enrolled in the upcoming school year.

servingDistrict Student Information > General > Enrollments District of accountability that serves the student for programming and instruction.

enrollmentGUID Internal database identifier.

State Reporting Elements

stateExclude Student Information > General > Enrollments When marked, the student will not appear on any state reporting extracts.

residentDistrict Student Information > General > Enrollments _{Notes in which district the student lives.}

mealStatus Student Information > General > Enrollments _{Indicates the economic eligibility of the student.}

englishProficiency Student Information > General > LEP_{Indicates the student becoming proficient in English.}

language Student Information > General > Enrollments Notes the language most often spoken at home by the student and family.

transportation Student Information > General > Transportation _{A code indicating the type of transportation the student receives.}

migrant Student Information > General > Enrollments Dropdown list indicating whether or not student is considered a migrant.

immigrant Student Information > General > Enrollments _{Indicates the student being of immigrant status.}

homeless Student Information > General > Enrollments _{Indicates the student being of homeless status.}

homebound Student Information > General > Enrollments _{Indicates the student is homebound.}

giftedTalented Student Information > General > Enrollments Indicates whether the student is Gifted/Talented. Not used in all states.

percentEnrolled Student Information > General > Enrollments _{Indicates the amount of time the student is enrolled.}

section504 Student Information > General > Enrollments Indicates the student is receiving and participating in Section 504 Programming.

dropoutCode Student Information > General > Enrollments _{Selected when the student ends enrollment not due to moving away.}

Special Ed Elements

specialEdStatus Student Information > General > Enrollments Indicates the type of special education status of the student. Students may have more than one status.

specialEdSetting Student Information > General > Enrollments _{Notes the specific setting of the special education student.}

disability1 Student Information > General > Enrollments Primary disability of Student. Options are based on state designations.

disability2 Student Information > General > Enrollments _{If student has an additional disability.}

spedExitDate Student Information > General > Enrollments _{Date the student was exited from special education programming.}

spedExitReason Student Information > General > Enrollments _{Exit status reason for leaving special education programming.}

State Localized Elements

enrollmentID Internal database identifier. personID Internal database identifier. calendarID Internal database identifier.

nativeAmericanLanguage Student Information > General > Enrollments The indication of student’s Native American Language. Not used in all states.

gradeEquivalent Student Information > General > Enrollments _{The student’s Grade Equivalent. Not used in all states.}

refugee Student Information > General > Enrollments _{Checkbox indicates that student is a refugee.}

livingStatus Student Information > General > Enrollments Specifies that type of place where homeless student primarily resides.

dropOutQuestionnaireDate Student Information > General > Enrollments _{Date of dropout questionnaire.}

foreignExchange Student Information > General > Enrollments If flagged, checkbox indicates that student is part of a foreign exchange program.

partCID Student Information > General > Enrollments _{Student’s ID number under Part C.}

outofState Student Information > General > Enrollments _{Checkbox indicates that student is from another state.}

outofDistrict Student Information > General > Enrollments _{Checkbox indicates that student is from another district.}

servingSchool Student Information > General > Enrollments _{The school of accountability that provides services to that student.}

extraYearInPrimary Student Information > General > Enrollments Checkbox indicates that student spent an extra year in primary school.

specialEdEligibleDate Student Information > General > Enrollments Date student became eligible for special education, but refused services.

keesIneligible Student Information > General > Enrollments _{Enrollment override for KEES.}

schoolChoice Student Information > General > Enrollments Code indicating whether student transferred to or from school choice.

perkinsOnly Student Information > General > Enrollments > State Reporting Fields _{Checkbox indicating whether the student is a Perkins-only student.}

spedFullFunding Student Information > General > Enrollments Checkbox indicates student receives full funding for special education services.

underageWaiver

Student Information > General > Enrollments

Checkbox indicates student has an underage waiver that allows him/her to be enrolled in a grade level general offered to students of an older age.

Title 1 Elements

title1ID Internal database identifier. calendarID Internal database identifier. enrollmentID Internal database identifier. personID Internal database identifier. title1GUID Internal database identifier.

startDate Student Information > General > Title 1 Services _{Gifted category starting effective date.}

endDate Student Information > General > Title 1 Services _{Gifted category ending effective date.}

counseling Student Information > General > Title 1 Services _{Checkbox indicates that student received counseling services.}

guidance Student Information > General > Title 1 Services _{Checkbox indicates that student received guidance support services.}

health Student Information > General > Title 1 Services _{Checkbox indicates that student received health support services.}

dental Student Information > General > Title 1 Services _{Checkbox indicates that student received health support services.}

eyeCare Student Information > General > Title 1 Services _{Checkbox indicates that student received eye care support services.}

mathmatics Student Information > General > Title 1 Services Checkbox indicates that student received math instructional services.

readingLanguage Student Information > General > Title 1 Services Checkbox indicates that student received reading and language instructional services.

science Student Information > General > Title 1 Services Checkbox indicates that student received science instructional services.

socialStudies Student Information > General > Title 1 Services Checkbox indicates that student received social studies instructional services.

vocationalCareer Student Information > General > Title 1 Services Checkbox indicates that student received vocational instructional services.

instructionalOther Student Information > General > Title 1 Services Checkbox indicates that student received other instructional services.

otherInstruService Student Information > General > Title 1 Services _{User-entered field specifying type of instructionOther field.}

Pre-School Elements

preSchoolID Internal database identifier. calendarID Internal database identifier. enrollmentID Internal database identifier. personID Internal database identifier. preSchoolGUID Internal database identifier.

startDate Student Information > General > Pre-School Elements _{Starting effective date of pre-school service.}

endDate Student Information > General > Pre-School Elements _{Ending effective date of pre-school service.}

disabledStateFund Student Information > General > Pre-School Elements _{Checkbox indicating if student is in disabled state fund preschool.}

headStart Student Information > General > Pre-School Elements _{Checkbox indicating if student is enrolled in head start preschool.}

federalPoverty Student Information > General > Pre-School Elements Checkbox indicating if student is enrolled in a federal poverty preschool.

headStartEnhanced Student Information > General > Pre-School Elements Checkbox indicating if student is enrolled in an enhanced head start preschool.

overIncomePreschool Student Information > General > Pre-School Elements Checkbox indicating if student is enrolled in an over-income preschool.

otherFlag Student Information > General > Pre-School Elements Checkbox indicating if student is enrolled in another type of preschool, as specified by user in Other field.

other Student Information > General > Pre-School Elements User-entered specifics on the Other field when selected as type of preschool.

receivedParentEd Student Information > General > Pre-School Elements Checkbox indicating if preschool has a received parent education family component.

needAdultEd Student Information > General > Pre-School Elements Checkbox indicating if preschool has a need adult education family component.

enrolledInAdultEd Student Information > General > Pre-School Elements Checkbox indicating if preschool has an enrolled adult education/ literacy family component.

needSocialServices Student Information > General > Pre-School Elements Checkbox indicating if preschool has a need for social services family component.

receivedSocialServices Student Information > General > Pre-School Elements Checkbox indicating if preschool has a received social services family component.

volunteerInClassroom Student Information > General > Pre-School Elements Checkbox indicating if preschool has a volunteer in classroom family component.

otherChildinPreschool Student Information > General > Pre-School Elements Checkbox indicating if preschool has other child in preschool family component.

setting Student Information > General > Pre-School Elements _{Code and description of preschool setting type.}

homeVisit1 Student Information > General > Pre-School Elements _{Date of first home visit.}

homeVisit2 Student Information > General > Pre-School Elements _{Date of second home visit.}

FRYSC Elements

fRYSCID Internal database identifier. calendarID Internal database identifier. personID Internal database identifier. enrollmentID Internal database identifier. fRYSCGUID Internal database identifier.

startDate Student Information > General > FRYSC_{Effective start date of FRYSC program.}

endDate Student Information > General > FRYSC_{Effective end date of FRYSC program.}

interventionForStudent Student Information > General > FRYSC _{Checkbox indicating if this intervention was for the student.}

interventionForParent Student Information > General > FRYSC _{Checkbox indicating if this intervention was for the parent.}

referredBy Student Information > General > FRYSC _{Indicates who referred this student for an intervention.}

mOIInOfficeSchoolGrounds Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOITelephone Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOIHomeVisit Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOIHomeVisitPAT Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOILetter Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOIFTMChair Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOIFTMParticipant Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOIOther Student Information > General > FRYSC_{Checkbox indicating Mode of Intervention.}

mOIOtherComment Student Information > General > FRYSC_{Description of the Mode of Intervention.}

resultOfBehavior Student Information > General > FRYSC Checkbox indicating that intervention was as a result of a behavior issue.

parentGuardianContact Student Information > General > FRYSC _{Checkbox indicating if parent/guardian was contacted.}

referralAgency1 Student Information > General > FRYSC _{Primary referral location.}

referralAgency2 Student Information > General > FRYSC _{Secondary referral location.}

comments Student Information > General > FRYSC _{Description of intervention}

asAdultEducation Student Information > General > FRYSC _{Type of Academic Support}

asEarlyChildhoodCare Student Information > General > FRYSC _{Type of Academic Support}

asECESupport Student Information > General > FRYSC _{Type of Academic Support}

asESLSupport Student Information > General > FRYSC _{Type of Academic Support}

asGED Student Information > General > FRYSC _{Type of Academic Support}

asHomeworkAssistTestingSupport Student Information > General > FRYSC _{Type of Academic Support}

asOrganizationalSkills Student Information > General > FRYSC _{Type of Academic Support}

asParentTeacherConf Student Information > General > FRYSC _{Type of Academic Support}