SASID Extract - 111 Byte
On this page:
Introduction
This extract collects all the student information following the state guidelines and format. You can include only student records with a missing SASID or all students that meet the search criteria in the extract.
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.
School Selection
The report selects records from the School table based on the following criteria:
- The student's School ID must be in the selected schools to run.
Student Selection
The report selects records from the Student table based on the following criteria:
- Student's Entry Date must be less than the Report End Date entered.
- Student's Exit Date must be greater than the Report Start Date entered.
- Student cannot be set to be excluded from State Reporting.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
This report uses the State reporting Platform to generate results.
You will need to install and setup a night transfer via an FTP program to automatically transfer this file from your server to the specified server given by MSDE.
Field | Description |
|---|---|
Report Parameters | Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file. |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Start Date | Enter the Start Date for which you would like to run this report. |
End Date | Enter the End Date for which you would like to run this report. |
Current Selection | Select to run for the Current Selection of students or for All Students. |
Run only for students with blank SASID | Select Yes if you want to run the report only for students with no SASID. |
Use Alternate School Numbers | Select Yes if you want to use the Alternate School number when processing the report |
Scheduling – Please Select When to run (Optional) | Click the Schedule button to schedule this report to run nightly. Check the weekdays only box |
Please Select Schedule Settings (Optional) | Enter the Start Date and Start time. Click the Repeat and Daily buttons. |
Please select daily repeat cycle options (Optional) | Click the Weekdays only box. |
Please select end date range option (Optional) | Click the No End date or you may complete the Ends On field with the day after you last day of school. |
Submit | Click the submit button. You will be taken to the Report Queue. Once your file is complete, click on the complete button and you will have a PDF file to assist you in compiling your spreadsheet for the State. |
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.
Data Element | Description | [Table]FieldName | Field Type | Field Length | Begin / End Position |
|---|---|---|---|---|---|
Student Demographic Data | |||||
LEA | This field contains the two-digit local education agency code (LEA). This field is extracted from the District Information page, Start Page > District Setup > District Information. | [Prefs]MD_DistrictLEA | Alpha-numeric | 2 | 1–2 |
School Number | This field contains the four-digit code that identifies the school building. This field is extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. | [Students]SchoolID Or [ReEnrollments]SchoolID | Alpha-numeric | 4 | 3–6 |
SASID | This field may contain the student identification number assigned by the Maryland State Department of Education to this student. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. This field may be blank if the student is not yet assigned a SASID. | [Students]State_StudentNumber | Numeric | 10 | 7–16 |
Student ID Number | This field contains the student's identification number assigned by the school. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. | [Students]Student_Number | Numeric | 10 | 17–26 |
Last Name | This field contains the last name of the student. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal last name is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]Last_Name OR | Alpha numeric | 25 | 27–51 |
First Name | This field contains the first name of the student. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal first name is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]First_Name OR | Alpha numeric | 15 | 52–66 |
Middle Initial | This field contains the middle initial of the student. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal middle initial is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [Students]Middle_Name OR | Alpha numeric | 15 | 67-81 |
Generation Suffix | This field contains the generational code or suffix of the student, if applicable. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal suffix is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. | [S_MD_STU_X]Generation OR [Students.StudentCoreFields]PSCore_Legal_Suffix | Alpha numeric | 3 | 82-84 |
Date of Birth | This field contains the student's date of birth. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. Format: YYYYMMDD | [Students]DOB | Numeric | 8 | 85-92 |
Grade | This field contains the student's grade level during the enrollment period. This field value is extracted from the General Demographics page, Start Page > Student Selection > General Demographics. | [Students]Grade_Level Or [ReEnrollments]Grade_Level | Alpha numeric | 2 | 93-94 |
Gender | This field contains the student's gender code. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics, or if the legal gender is populated on the Maryland State Information page, Start Page>Student Selection>Maryland State Information. The alpha character is converted to a one-digit numeric code when the report is run: 1 for male and 2 for female. | [Students]Gender OR [Students.StudentCoreFields]PSCore_Legal_Gender | Alpha numeric | 1 | 95 |
Hispanic/Latino Ethnicity | A value of Y in this field indicates that this student is Hispanic or Latino. A value of N in this field indicates that this student is not Hispanic or Latino. This field value is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If the Hispanic or Latino field is blank on the Maryland State Reporting page, this field value is extracted from Edit Demographics page, Start Page > Student Selection> General Demographics. | [S_MD_STU_X]Hispan_Lat-TF OR [Students]FedEthnicity | Alpha numeric | 1 | 96 |
Race/Codes (New) | This field contains the five-digit number identifying each race code that applies to this student. Race is reported as a five position field, with each code assigned a value from 1 through 5. If a check box is not selected, a 0 is assigned to that position. For example, a student record with the Asian and African American race check boxes selected is 02300. The race code values are extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. If the race code check boxes are not populated on the Edit Demographics page, the values are extracted from the race code check boxes on the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. | [StudentRace]RaceCd OR [Students]MD_Eth_Amer_Ind [Students]MD_Eth_Asian [Students]MD_Eth_Black [Students]MD_Eth_Hawaiian [Students]MD_Eth_White | Alpha numeric | 5 | 97-101 |
Filler | Blank | [Students]SSN | Numeric | 10 | 102-111 |