SASID Extended Extract

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:

• 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.

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.

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
[Schools]School_Number

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

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

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

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 [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

100-107

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

108-109

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

Alpha numeric

1

110

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

111

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

112-116