Montana AIM Student Demographic Record

Contents

Introduction

This report provides a demographic record for each student enrolled at a school between the report start and report end dates. The demographic information included in the report is gender, date of birth, ethnicity and race.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables for any student who was enrolled in the school between the report start date and the report end date.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Process Current School Only*	Select “Yes” to include only records from the currently selected school or select “No” to include records from all schools that meet the selection criteria.
Start Date (MM/DD/YYYY)*	Enter the start date for the report.
End Date (MM/DD/YYYY)*	Enter the end date for the report.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Record Type	The file type abbreviation. Set to “SD”	Always set to “SD”	String	2
2	District Number	The unique system number assigned by the OPI. This is not the Legal Entity (LE) Number. This is the district number in PowerSchool. See the AIM website to identify your District Number, Reporting Entity Number, and School Number: http://opi.mt.gov/Reports-Data/AIM/	[Prefs]Value where [Prefs]Name=districtnumber	String	4
3	Student’s State ID	The unique nine-digit state assigned student ID.	[Students]State_StudentNumber	String	9
4	Student’s Local ID	The locally assigned student number. This field is not required.	[Students]Student_Number	String	15
5	Last Name	The student’s legal last name.	[Students]Last_Name	String	50
6	First Name	The student’s legal first name.	[Students]First_Name	String	50
7	Middle Name	The student’s legal middle name.	[Students]Middle_Name	String	30
8	Suffix	The student’s name suffix if applicable. This field is not required.	[S_MT_STU_Demographics_X] NameSuffix	String	4
9	Gender	The student’s gender. Valid values are “M” or “F”	[Students]Gender	String	1
10	Birth Date	The student’s date of birth in mm/dd/yyyy format.	[Students]DOB	Date	10
11	Filler	Filler	N/A	String	N/A
12	Hispanic/Latino	Indicates if the student is Hispanic or Latino. Valid values are “Y” or “N”.	[Students]FedEthnicity	String	1
13	American Indian or Alaska Native	Indicates if the student is of the specified race. Valid values are “Y” or “N”.	Set to “Y” if [StudentRace]RaceCd = I otherwise set to “N”	String	1
14	Asian	Indicates if the student is of the specified race. Valid values are “Y” or “N”.	Set to “Y” if [StudentRace]RaceCd = A otherwise set to “N”	String	1
15	Black or African American	Indicates if the student is of the specified race. Valid values are “Y” or “N”.	Set to “Y” if [StudentRace]RaceCd = B otherwise set to “N”	String	1
16	Native Hawaiian or Other Pacific Islander	Indicates if the student is of the specified race. Valid values are “Y” or “N”.	Set to “Y” if [StudentRace]RaceCd = P otherwise set to “N”	String	1
17	White	Indicates if the student is of the specified race. Valid values are “Y” or “N”.	Set to “Y” if [StudentRace]RaceCd = W otherwise set to “N”	String	1
18	Race/Ethnicity Determination	How was the student's Race/Ethnicity determined? 01: Parent Identified 02: Self Identified (student) 03: Observer Determined 04: Unknown	[S_MT_STU_Demographics_X] RaceEthnicityDetermination	String	2
19	Nickname	The student’s nickname, if any. This field is not required.	N/A	N/A	N/A
20	End Year	The school calendar year. This value is reported from the last day of the full year term on the Years & Terms page.	Year portion of [Terms]LastDay where [Terms]IsYear = 1	String	4

Back to Top