Student Personal Report
The Student Personal Report provides demographic data about students who are new to the district or whose demographic data has changed, within a user-specified data range.
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 students based on the following criteria:
The student must not be excluded from state reporting.
The student must be enrolled at least one day between the Report Start Date and the Report End Date.
School Selection
The school must not be excluded from state reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools* | Select the schools to include in the report: If sub-districts are not enabled:
If sub-districts are enabled:
|
Current Selection Students* | Choose which students to include in the report by selecting one of the following options:
If running the report for a single student, or group of students, select the students prior to running the report. |
Report Start Date* | Enter the report start date. |
Report End Date* | Enter the report end date. |
Extract Data for Optional Columns? | Select Yes to display data for optional columns. Select No if you do not want to display data for optional columns. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: The following data elements are required for the report submission except when listed as "blank is allowed".
Data Element | Description | [Table]FieldName | Data Type | Field Length |
SAUID | The NEO Organization ID for the attending SAU. If a sub-district number is enabled and mapped to the selected school, then the sub-district number displays in the SAUID column. Details about Enabling Sub-District Configuration. The district number on import must match the district number tied to the student’s enrollment. If they do not match, the following error message appears: “Student does not have an enrollment in this SAU ID, School ID, and school year.” | [Prefs]Name = ME_SAUID [Prefs]Value If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Int | 4 |
SchoolStudentID | The school's student identification number. Blank is allowed. | [Students]Student_Number | Varchar | 10 |
StateStudentID | The student's state ID. | [Students]State_StudentNumber | String | 9 |
SSN | Student’s social security number. Blank is allowed. | [Students]SSN | Char | 9 |
LastName | Student’s legal last name. | [StudentCoreFields]PSCORE_LEGAL_LAST_NAME [Students]Last_Name | Varchar | 50 |
FirstName | Student’s legal first name. | [StudentCoreFields]PSCORE_LEGAL_FIRST_NAME [Students]First_Name | Varchar | 50 |
MiddleName | Student’s middle name. Blank is allowed. | [StudentCoreFields]PSCORE_LEGAL_MIDDLE_NAME [Students]Middle_Name | Varchar | 50 |
Alias | The student's alias or nickname. Blank is allowed. | [S_ME_STU_X]Alias | Varchar | 50 |
NameSuffixCode | The suffix following the student’s name, such as Jr, III, etc. See Name Suffix Codes for valid codes. Blank is allowed. | [StudentCoreFields]PSCORE_LEGAL_SUFFIX [S_ME_STU_X]NameSuffixCode | Varchar | 10 |
HispanicLatino | Indicates if the student's race is hispanic. See Federal Ethnicity and Race Codes for valid codes. | [Students]Fedethnicity | Char | 1 |
AmericanIndianAlaskaNative | Indicates if the student's race is American Indian/Alaska Native. See Federal Ethnicity and Race Codes for valid codes. | [StudentRace]RaceCd = I | Char | 1 |
Asian | Indicates if the student's race is Asian. See Federal Ethnicity and Race Codes for valid codes. | [StudentRace]RaceCd = A | Char | 1 |
BlackAfricanAmerican | Indicates if the student's race is African American. See Federal Ethnicity and Race Codes for valid codes. | [StudentRace]RaceCd = B | Char | 1 |
NativeHawaiianPacificIslander | Indicates if the student's race is Native Hawaiian/Pacific Islander. See Federal Ethnicity and Race Codes for valid codes. | [StudentRace]RaceCd = P | Char | 1 |
White | Indicates if the student's race is white. See Federal Ethnicity and Race Codes for valid codes. | [StudentRace]RaceCd = W | Char | 1 |
Sex | The student’s Gender. Valid values:
Note: The report displays M for Male and F for Female. If a student's gender is saved as N – Not Selected, then the report displays Not Selected instead of N. | [StudentCoreFields]PSCORE_LEGAL_GENDER [Students]Gender | Char | 1 |
BirthDate | Student’s date of birth. | [Students]DOB | Date | 10 |
PhysicalAddressLine1 | The student’s address of residence (line 1). Blank is allowed. | [Students]Street | Varchar | 50 |
PhysicalAddressLine2 | The student’s address of residence (line 2). Blank is allowed. | [Students]Street | Varchar | 50 |
PhysicalCityTown | The student's city/town of residence. Blank is allowed. | [Students]City | Varchar | 25 |
PhysicalState | The student's state of residence. Blank is allowed. | [Students]State | Varchar | 2 |
PhysicalZipCode | The student's zip code of residence. Blank is allowed. | [Students]Zip | Varchar | 9 |
MailingAddressLine1 | Student's mailing or correspondence address. | [Students]Mailing_Street | Varchar | 50 |
MailingAddressLine2 | Student's mailing or correspondence address. | [Students]Mailing_Street | Varchar | 50 |
MailingCityTown | The city or town for student's mailing or correspondence address. | [Students]Mailing_City | Varchar | 25 |
MailingState | The initials of the state for the student's mailing or correspondence address. | [Students]Mailing_State | Varchar | 2 |
MailingZipCode | The zip code for the student's mailing or correspondence address. | [Students]Mailing_Zip | Varchar | 9 |
HomePhone | The value for this field is extracted from the home phone number specified as part of a student's demographic information. The report displays only numeric values for the student’s home telephone with a maximum of 10 digits. Blank is allowed. | [Students]Home_Phone | Varchar | 10 |
The e-mail address for the parent or guardian of the student. Blank is allowed. | [Students]GuardianEmail | Varchar | 50 | |
ParentGuardian1LastName | Last name of parent or guardian of the student. The "&" sign is not accepted. Required if the ParentGuardian1 FirstName is provided; otherwise, blank is allowed. | [S_ME_STU_X]Guardian1NameLast | Char | 50 |
ParentGuardian1FirstName | First name of parent or guardian of the student. Required if the ParentGuardian1 LastName is provided; otherwise, blank is allowed. | [S_ME_STU_X]Guardian1NameFirst | Char | 50 |
ParentGuardian2LastName | Last name of parent or guardian of the student. Required if the ParentGuardian2 FirstName is provided; otherwise, blank is allowed. | [S_ME_STU_X]Guardian2NameLast | Char | 50 |
ParentGuardian2FirstName | First name of parent or guardian of the student. Required if the ParentGuardian2 LastName is provided; otherwise, blank is allowed. | [S_ME_STU_X]Guardian2NameFirst | Char | 50 |
ImmigrantFlag | Indicates if a student is an immigrant. Valid values:
Required if the student is an immigrant | [S_ME_STU_X]ImmigrantFlag_YN | Char | 1 |
NativeLanguage | The language normally used by students or normally used by parents of students. | [S_ME_STU_X]LanguageCode | Varchar | 3 |
NativeLanguageInterpreter | Indicator that an interpreter in the reported Native Language is needed. | [S_ME_STU_X]NativeLangInterpreter_YN | Varchar | 1 |
NativeLanguage2 | Additional language normally used by students or normally used by parents of students. | [S_ME_STU_X]NativeLanguageCode2 | Varchar | 3 |
NativeLanguage2Interpreter | Indicator that an interpreter in the reported Native Language 2 is needed. | [S_ME_STU_X]NativeLangInterpreter_YN2 | Varchar | 1 |
NativeLanguage3 | Additional language normally used by students or normally used by parents of students. | [S_ME_STU_X]NativeLanguageCode3 | Varchar | 3 |
NativeLanguage3Interpreter | Indicator that an interpreter in the reported Native Language 3 is needed. | [S_ME_STU_X]NativeLangInterpreter_YN3 | Varchar | 1 |
NativeLanguage4 | Additional language normally used by students or normally used by parents of students. | [S_ME_STU_X]NativeLanguageCode4 | Varchar | 3 |
NativeLanguage4Interpreter | Indicator that an interpreter in the reported Native Language 4 is needed. | [S_ME_STU_X]NativeLangInterpreter_YN4 | Varchar | 1 |
NativeLanguage5 | Additional language normally used by students or normally used by parents of students. | [S_ME_STU_X]NativeLanguageCode5 | Varchar | 3 |
NativeLanguage5Interpreter | Indicator that an interpreter in the reported Native Language 5 is needed. | [S_ME_STU_X]NativeLangInterpreter_YN5 | Varchar | 1 |