Skip to main content
Skip table of contents

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.

Report Output

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

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.