Student Achievement Module (SAM) Report

Introduction

The Student Achievement Module (SAM) Report is a detailed document that captures various credentials and achievements earned by students.

Report Input

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.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – 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.
Attempt (Test) Start Date ( Credential Date)	Enter the start date for which the test was taken.
Attempt (Test)End Date	Enter the end date for which the test was taken.
Include Inactive Student	option to include inactive students. Default not checked. Inactive student means no active enrollment between the Attempt Start and End Date else Active
Display Header	Choose Yes or No from the pop-up menu to determine whether to display header fields in the extract. Headers display the name of each data element for each record extracted. Use headers for troubleshooting purposes.
File Format	Choose whether to extract the records in comma-delimited format for troubleshooting purposes or in fixed length format for submission to the state.

Records Excluded

Data in SAM report does not include FAFSA data if import FAFSA data option is used or the data contain FAFSA Master data

Report Output

Note: The SAM report selects the code instead of the name for Credential/Test Vendor, Credential Category/Series, and Credential Specialization.

Item #	Data Element	Description	[Table]FieldName	Field Length	Begin / End Position
1	State Assigned Student ID (SASID)	The student’s state-assigned student ID number.	[Students] State_StudentNumber [S_CT_STU_X]State_Student_ID	10	1–10
2	Reporting District	The three-digit code for the reporting school district.	[Prefs]Value where [Prefs]Name=districtnumber	3	11–13
3	District Student ID	The student’s district or locally assigned ID number.	[Students]Student_Number	20	14–33
4	Date of Birth ( MMDDYYYY)	The student’s date of birth.	[Students]DOB	8	34–41
5	Credential/Test Vendor	The language proficiency test used to Leave blank or used to determining the attainment of the Seal of Biliteracy.	[S_CT_STU_X]Program	5	42-46
6	Credential Category/Series	The credential category.	[S_CT_STU_X]Credential Type	5	47-51
7	Credential Specialization	The credential specialization	[S_CT_STU_X]Credentials	8	52-59
8	Attempt Date	Student’s test date in the format MMDDYYYY	[S_CT_STU_X]Test Date	8	60-67
9	Test Passed	The test score is not collected. Enter “Y” = Yes or “N” = to report the outcome of the test	Passed	1	68
10	Placeholder1			50	69-118
11	Placeholder2			50	119-168
12	Placeholder3			200	169-268
13	End of Record Indicator	X is automatically included at the end of the record.	N/A	1