PowerSchool SIS Maryland
PowerSchool SIS Maryland
Breadcrumbs

Summer EBT

This creates the file for the Summer Electronic Benefit Transfer.

Selection Criteria

  • The student cannot be set to be excluded from State Reporting.

  • The student must have a State Assigned Student ID (SASID).

  • The student is currently active and the student's enrollment must fall between the report start and report end dates provided below. Per MSDE, your file should include currently enrolled students, those expected to graduate from high school this year, and those who have dropped out, transferred, or otherwise left the school during the current academic year.

  • The student's Lunch Status must be specified and is not Full pay (P).

Parent/Guardian Information:

  • If a District is using Student Contacts, Student Contact Adoption Status = Y (Start Page - District Management - Compliance -Student Contact Adoption Status), this information is the Contact with the Custody flag checked and Order of 1.

  • OR the information is extracted from the Online IEP Setup page (Start Page – District Management - Compliance – Online IEP Setup) Parent/Guardian fields

Report Input



Select Schools to Export

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report

  • All Schools – Run the report for the entire district.

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.

Current Selection Students

Click the button to run for the Selected Students or All Students

Use Alternate School Numbers

Select Yes if you would like to use Alternate School Numbers when processing the report.

Report Start Date

Choose the Start Date for enrollments that you want to include.

End Date

Choose the End Date for enrollments that you want to include.

Date of Submission

Choose the Submission date.

Submission Number

Select the Submission Number.

Scheduling Options

Description

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.

Please Select Schedule Settings

Enter the Start Date and Start time. Click the Repeat button.

Please select repeat cycle options.

Choose the applicable option.

Please select end date range option

Enter the appropriate information.

Submit

Click Submit to schedule the report


Report Output

Column Letter

Data Element

Description

[Table]FieldName

Field Type

Field Length

1

LEA Number

The two-digit local education agency code (LEA). Extracted from the District Information page, Start Page > District Setup > District Information.

[Prefs]MD_DistrictLEA

Alpha-numeric

2

2

LEA Name

The LEA Name.

[Prefs]Wherename='districtname'

Alpha-numeric

25

3

School ID

The four-digit code that identifies the school building. Extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.

[Students]SchoolID OR [ReEnrollments]SchoolID OR [Schools]Alternate_School_Number

Alpha-numeric

4

4

School Name

The School Name.

[Schools]Name

Alpha-numeric

55

5

Community Eligibility Provision (CEP) Flag

Indicates a CEP school. Extracted from the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.

[S_MD_SCH_X]CEP_Flag

Alpha-numeric

1

6

State Assigned Student ID

The student identification number assigned by the Maryland State Department of Education. Extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.

[Students]State_StudentNumber

Alpha-numeric

10

7

Local Student ID

The student identification number assigned by the school. Extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Student_Number

Alpha-numeric

10

8

Student Last Name

This field contains the last name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Last_Name OR
[StudentCoreFields]PSCore_Legal_Last_Name

Alpha numeric

25

9

Student First Name

This field contains the first name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]First_Name OR
[StudentCoreFields]PSCore_Legal_First_Name

Alpha numeric

15

10

Student Middle Name

This field contains the middle name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Middle_Name OR
[StudentCoreFields]PSCore_Legal_Middle_Name

Alpha numeric

15

11

Generational Suffix - Optional - Reports as Blank

This field contains the generational suffix of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographic

N/A - Reports as Blank

Alpha numeric

2

12

Student 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. Date Format = YYYYMMDD.

[Students]DOB

Date

8

13

Grade

The grade level of the student. 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

14

Ethnicity

Reported Values:

Y If fedethnicity = 1 OR MD_Hispan_Lat = 1, else N.

Extracted from Start Page > Student Selection > Demographics OR Start Page > Student Selection > Maryland State Information.

[Students]FedEthnicity OR

[S_MD_STU_X]Hispan_Lat_TF

Alpha numeric

1

15

Race

This indicates the student’s race.

Race is determined as follows:

  • If more than one race, then ‘MU’

  • Demo_string.american_indian_alaskan_native = 'AM'

  • Demo_string.black_or_african_american = 'BL'

  • Demo_string.Asian = 'AS'

  • Demo_string.pacific_islander = 'PI'

  • Demo_string.white = 'WH'

  • Else ‘UN’

Alpha numeric

2

16

Gender

Reported Values:

  • F = Female

  • M = Male

  • X = Non-binary

This field contains the gender of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Gender

Alpha numeric

1

17

FARMS

This indicates a student’s FARMS status.

WHEN [Students]LunchStatus IN ('F’, ‘R' THEN ‘Y’ ELSE 'N’.

Alpha-numeric

1

18

Migrant

This indicates the student’s migrant status.

demo_string.migrant_status

Alpha-numeric

1

19

Homeless Student

The student's homeless status. Extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.

Y = Yes OR N = No

[S_MD_STU_X].Homeless OR [S_MD_REN_X]Homeless

Alpha-numeric

1

20

Foster Care Status

Indicates that the student is in foster care. Extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.

Y = Yes OR N = No

[S_MD_STU_X]Foster_Care_TF OR [S_MD_REN_X]Foster_Care_TF

Alpha-numeric

1

21

Directly Certified Student

This indicates a direct certified student.

WHEN [Students]LunchStatus IN ('FDC’, ‘RDC' THEN ‘Y’ ELSE 'N’.

Alpha-numeric

1

22

Student FARMs/Direct-Cert Eligible

Reports 'Y' for all students.

N/A

Alpha-numeric

1

23

Student Street Address 1 (Line 1)

This field contains the address of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_Street or [Students]Street

Alpha numeric

100

24

Student Street Address 1 (Line 2)

This field contains the address of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_Street or [Students]Street

Alpha numeric

20

25

Student City 1

This field contains the city of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_City or [Students]City

Alpha numeric

45

26

Student State 1

This field contains the state of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_State or [Students]State

Alpha

2

27

Student Zip Code 1

This field contains the zip code of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_Zip or [Students]zip

Numeric

5

28

Student Street Address 2 (Line 1) (Optional)

This field contains the address of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_Street or [Students]Street

Alpha numeric

100

29

Student Street Address 2 (Line 2)

(Optional)

This field contains the address of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_Street or [Students]Street

Alpha numeric

20

30

Student City 2

(Optional)

This field contains the city of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_City or [Students]City

Alpha numeric

45

31

Student State 2

(Optional)

This field contains the state of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_State or [Students]State

Alpha

2

32

Student Zip Code 2

(Optional)

This field contains the zip code of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.

[Students]Mailing_Zip or [Students]zip

Numeric

5

33

Student’s Primary Language

(Optional)

Null

N/A

N/A

8

34

Parent/Guardian 1 Last Name

This field is extracted from the Online IEP Setup page, Start Page > District Setup> Online IEP Setup.

If a District is using Student Contacts this information is the Contact with the Custody flag checked and Order of 1.

[Prefs] MD_p1_first_name

Alpha-numeric

15

35

Parent/Guardian 1 First Name

This field is extracted from the Online IEP Setup page, Start Page > District Setup> Online IEP Setup.

If a District is using Student Contacts this information is the Contact with the Custody flag checked and Order of 1.

[Prefs] MD_p1_last_name

Alpha-numeric

10

36

Parent/Guardian 1 Phone

(Optional - Extracted if provided)

This field is extracted from the Online IEP Setup page, Start Page > District Setup> Online IEP Setup.

If a District is using Student Contacts this information is the Contact with the Custody flag checked and Order of 1.

[Prefs] MD_p1_wphone

Numeric

15

37

Parent/Guardian 1 Email

(Optional - Extracted if provided)

This field is extracted from the Online IEP Setup page, Start Page > District Setup> Online IEP Setup.

If a District is using Student Contacts this information is the Contact with the Custody flag checked and Order of 1.

[Prefs] MD_p1_email

Numeric

25

38

Parent/Guardian 2 Last Name

(Optional)

Null

N/A

N/A

15

39

Parent/Guardian 2 First Name

(Optional)

Null

N/A

N/A

10

40

Parent/Guardian 2 Phone

(Optional)

Null

N/A

N/A

15

41

Parent/Guardian 2 Email

(Optional)

Null

N/A

N/A

1

42

Submission Date

The date of the submission from the Report Parameter page.

N/A

Date

25