Student Discipline Extract

Field

Description

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.

• Current School Only – Includes all records associated with the current school that meet the selection criteria.

• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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.

Use Alternate School Numbers

If you require the use of the Alternate School number select Yes.

Use Current Selection

Indicate which students to include in the report by selecting one of the following options:

• Use Current Selection – Run the report for students in the current selection.

• Don’t Use Current Selection – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Records to Include

Indicate which incident records to include in the report by selecting one of the following options:

• The selected [number] records only – Run the report for incident records in the current selection.

• All records – Run the report for all incident records in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) – Execute the report immediately in the background.

• ASAP – Execute the report in the order it is received in the Report Queue.

• At Night – Execute the report during the next evening.

• On Weekend – Execute the report during the next weekend.

• On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10 AM : 05.

Report Start Date

Enter the first date in the report date range to select incident records with an incident date greater than the date entered.

End Start Date

Enter the last date in the report date range to select incident records with an incident date less than the date entered.

Run From the Extract Viewer

Select Yes to create an extract file from the records in the Extract viewer. The default is No.

If No is selected, the records that currently exist in the Extract Viewer are replaced.

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

1

LEA Number

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.

[Students]SchoolID

Or

[ReEnrollments]SchoolID

[Schools]School_Number

Numeric

4

3

State Assigned Student ID (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

Local 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
[StudentCoreFields]PSCore_Legal_Last_Name

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
[StudentCoreFields]PSCore_Legal_First_Name

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
[StudentCoreFields]PSCore_Legal_Middle_Name

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 [StudentCoreFields]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. 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 - Male

2 - Female

X - Non-Binary

[Students]Gender OR [StudentCoreFields]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 [Students]FedEthnicity

Alpha numeric

1

14

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

15

Filler - Homeless Status

This field is not currently collected. It will default to a blank.

N/A

Numeric

1

16

Title I Indicator

If this field contains a Y, the student is eligible to receive Title I services. This field is extracted from the Log Entry page, Student Selection > Log Entries.

If the Title I Indicator field is No Override 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]Title_One_YN

Or

[S_MD_STU_X]Title_One

Alpha numeric

1

17

Free Reduced Price Meals

If this field contains a Y, this student was eligible for the free or reduced lunch program at the time the incident occurred. This field is extracted from the Log Entry page, Student Selection > Log Entries.

If the FARMS Indicator field is No Override 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

[Reenrollments]LunchStatus

Alpha numeric

1

18

Migrant Indicator

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 is No Override 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]Migrant_YN

Or

[Students]Migrant

Alpha numeric

1

19

Filler – Foreign Exchange Student

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

20

Filler – Special Education

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

21

Filler – Special Education End Date

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

8

22

Filler – Special Education Certificate Status

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

23

Multilingual Learner (ML) Status

This field contains the student’s ELL status if the student is currently enrolled in an ELL program. This field is extracted from the Log Entry page, Student Selection > Log Entries.

If the LEP 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]ELL

Or

[S_MD_STU_X]ELL

Alpha numeric

1

24

Filler – Multilingual Learner Entry into U.S. School Date

This field is not currently collected. It will default to a blank.

N/A

Numeric

8

25

Filler – Multilingual Learner Service Begin Date

This field is not currently collected. It will default to a blank.

N/A

Numeric

8

26

Filler - Multilingual Learner Service End Date

This field is not currently collected. It will default to a blank.

N/A

Numeric

8

27

Filler - Multilingual Learner ELA Assessment Exempt Status

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

28

Filler - Foster Care Status

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

29

Filler - Military Connected Status

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

30

Filler - Gifted and Talented Student Indicator

This field is not currently collected. It will default to a blank.

N/A

Alpha numeric

1

31

Submission Date

This field defaults to the current date.

Format: YYYYMMDD

Calculated

Numeric

8

32

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 is No Override 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_YN

Or

[S_MD_STU_X]Special_Education AND

Value = '3' or '4'

Alpha numeric

1

33

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 is 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 or

[S_MD_STU_X]Primary_Disability

Alpha numeric

2

34

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

35

Date of Offense

This field contains the date the discipline offense occurred.

Format: YYYYMMDD

[Log]Discipline_IncidentDate

Numeric

8

36

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.

[S_MD_LOG_X]Disposition_Code

Alpha numeric

3

37

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

38

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

39

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