Obsolete - Discipline Extract
Use the Maryland Public Schools Discipline Extract to extract all Log Entry information for students following the state guide lines and format.
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 Schools table based on the following criteria:
- The Log Entry School ID must be included in the schools selected for the extract.
Discipline Incident Records
The report selects records from the Log Entry table based on the following criteria:
- The log type must equal Discipline.
- The Incident Date must be less than the Report End Date and greater than the Report Start Date entered for the report.
- The Include this Entry in the Suspensions, Expulsions, and Health Related Exclusions Report indicator must equal Yes; or the Disposition Code assigned to the incident record must equal In-School Suspension.
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. There may be some additional setup required to run this report. The additional setup required to will be to configure ReportWorks Preferences if you have not already done so.
- If you have already configured ReportWorks Preferences, no additional setup is required.
- If you have not configured ReportWorks Preferences, please refer to the "ReportWorks Preferences" section of the ReportWorks Setup and Administration Guide on PowerSource. This section will provide steps for configuring the scheduler node for the report queue.
Field | Description |
|---|---|
Select Schools | If run at the district level, choose one of the following:
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. |
Report Start Date | Enter the Start Date of the school year. |
End Date | Enter the End Date of the school year. |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Submit | Click Submit to run the report now |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run nightly. Check the weekdays only box |
Please Select Schedule Settings | Enter the Start Date and Start time. Click the Repeat and Daily buttons. |
Please select daily repeat cycle options. | Click the Weekdays only box. |
Please select end date range option | Click the No End date or you may complete the Ends On field with the day after you last day of school. |
Submit | Click Submit to schedule 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 | 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. | [Pref]MD_DistrictLEA | Numeric | 2 |
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. | [Log]SchoolID Or [Students]SchoolID Or [ReEnrollments]SchoolID | Numeric | 4 |
3 | SASID | This field contains the student identification number assigned by the Maryland State Department of Education. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [Students]State_StudentNumber | Numeric | 10 |
4 | Student ID Number | This field contains the student 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 |
5 | 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 |
6 | 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 |
7 | Middle Name | 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 |
8 | 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]PSCore_Legal_Suffix | Alpha numeric | 3 |
| 9 | Preferred Name (optional) | An alternative first name preferred by student | [Students]First_Name | Alpha numeric | 15 |
10 | Date of Birth | This field contains the birth date of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. | Students]DOB | Numeric | 8 |
11 | Grade | This field contains the grade level of the student. This field is extracted from the Edit Demographics page or the Edit Current Enrollment page, Start Page > Student Selection> General Demographics or Start Page > Student Selection > Transfer Info > Edit Current Enrollment. | [Students]Grade_Level Or [ReEnrollments]Grade_Level | Alpha numeric | 2 |
12 | 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]PSCore_Legal_Gender | Alpha numeric | 1 |
13 | Hispanic/Latino Ethnicity | This field contains a Y if the student's ethnicity is Hispanic or Latino or an N if the student's ethnicity is not Hispanic or Latino. This field value is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. If the Ethnicity: Is the student Hispanic or Latino? Field is blank, this field value is extracted from the Hispanic or Latino field on the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. | [S_MD_STU_X]Hispan_Lat_TF OR [StudentRace]RaceCd | Alpha numeric | 1 |
14-18 | Race/Codes | These fields contain the number that identify the applicable race codes for the student. If a check box is not selected, a 0 is assigned to that position. 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. See the Appendix for valid Race Codes | [StudentRace]RaceCd OR [S_MD_STU_X]Race_Amer_Ind_TF [S_MD_STU_X]Race_Asian_TF [S_MD_STU_X]Race_Black_TF [S_MD_STU_X]Race_Hawaiian_TF [S_MD_STU_X]Race_White_TF | Alpha numeric | 1 |
19 | FILLER (Homeless Status) | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
| 20 | Title 1 Indicator | A “Y” or “N” indicator that the student is participating in and served by programs under Title I, Part A of ESEA as amended. | [S_MD_STU_X]Title_One Or [S_MD_LOG_X]Title_One | Alpha numeric | 1 |
21 | Free/Reduced Price Meals Eligibility | This field displays the student FARMS status when a log entry is saved. FARMS status is based on Incident Date. You can change this code if applicable. This field is extracted from the Log Entry page, Student Selection > Log Entries. If the FARMS Indicator field blank on the Log Entry page, it is extracted from the Lunch page, Start Page > Student Selection > Lunch. | [S_MD_LOG_X]FARMS_Expanded Or [Students]LunchStatus Or [Reenrollments]LunchStatus | Alpha numeric | 1 |
22 | Migrant Status | This field defaults to the Migrant indicator for this student. This field is extracted from the Log Entry page, Student Selection > Log Entries. If the Migrant Indicator field blank on the Log Entry page, it is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_STU_X]Migrant OR [S_MD_REN_X]Migrant OR [S_MD_LOG_X]Migrant | Alpha numeric | 1 |
23 | Filler – Foreign Exchange Student | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
24 | Filler – Special Education | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
25 | Filler – Special Education End Date | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 8 |
26 | Filler – Special Education Certification Status | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
27 | English Learner (EL) Status | A student who has a primary or home language other than English and who has been identified as qualifying for ESOL services based on the English language proficiency screener. | [S_MD_LOG_X]LEP Or [S_MD_REN_X]ELL Or [S_MD_STU_X]ELL
| Alpha numeric | 1 |
| 28 | Filler - English Learner Entry into a US School Date | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 8 |
29 | Filler – ELL Begin Date | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 8 |
30 | Filler – ELL End Date | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 8 |
31 | Filler - English Learner ELA Assessment Exempt Status | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
| 32 | Filler - Foster Care Status | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
| 33 | Filler - Military Connected Indicator | This field is not currently collected and will default to a blank. | N/A | Alpha numeric | 1 |
| 34 | Filler | This field is not currently collected and will default to a blank. | N/A | Numeric | 33 |
35 | Submission Date | This field defaults to the current date. Format: YYYYMMDD | Calculated | Numeric | 8 |
36 | 504 Indicator | This field contains the code identifying the student's special education status. This field is extracted from the Log Entry page, Student Selection > Log Entries. If the 504 Indicator field blank on the Log Entry page, it is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_LOG_X]Sec504_Plan | Alpha numeric | 1 |
37 | Disability Code | This field defaults to the disability code identified for this student. This field is extracted from the Log Entry page, Student Selection > Log Entries. If the Disability Code field blank on the Log Entry page, it is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information. | [S_MD_LOG_X]Disability_Code | Alpha numeric | 2 |
38 | Offense Code | This code identifies the disciplinary incident that the student committed. If the incident involves more than one offense, report the most serious offense. This field is extracted from the Log Entry page, Student Selection > Log Entries. | [S_MD_LOG_X]Infraction_Code | Alpha numeric | 3 |
39 | Date of Offense | This field contains the date the discipline offense occurred. | [Log]Discipline_IncidentDate | Numeric | 8 |
40 | Disposition Code | This field contains the code that identifies the disciplinary action for this offense. This field is extracted from the Log Entry page, Student Selection > Log Entries. See the Appendix for valid Disposition Codes. | [S_MD_LOG_X]Disposition_Code | Alpha numeric | 3 |
41 | Length of Removal | This field contains the total number of partial/full days the student served for their offense. This field is extracted from the Log Entry page, Student Selection > Log Entries. | [S_MD_LOG_X]Length_Removal | Alpha numeric | 5 |
42 | Physical Injury | This field indicates if the offense resulted in physical Injury. This field is extracted from the Log Entry page, Student Selection > Log Entries. | [S_MD_LOG_X]Physical_Injury | Alpha numeric | 1 |
43 | Type of Educational Services Provided | This field indicates the type of educational services provided during the suspension/expulsion. This field is extracted from the Log Entry page, Student Selection > Log Entries. | [S_MD_LOG_X]Ed_Services | Numeric | 1 |