Skip to main content
Skip table of contents

SIS - K-3 Assessment Record (Type 141)

Contents

Introduction

This report collects SIS (Student Information System) information and creates an extract file for submission to the state for K-3 Assessment (141) records.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table that meet the following criteria:

  • The student’s school exit date must occur after the report start date.
  • The student’s school entry date must occur on or before the report end date.
  • The student’s school exit date must occur after their school entry date.
  • The student, the student’s school, and the student’s school enrollment must not be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Only available when running the report from the District Office.

Select District (Optional)

If this option appears, select the District for which to run the report.

Select Students

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.

If you are running the report for a single student, or a group of students, select the students before running the report.

Report Start Date

Enter the report start date.

Report End Date

Enter the report end date.

This date should be the snapshot date:

  • If you generate the K-3 Assessment report for the October submission, enter the appropriate October snapshot date.
  • If you generate the report for the February submission, enter the February snapshot date.
  • If you generate the report for EOY, enter the last day of school for students.

Include Student Schedules?

Choose:

  • No - No schedules will output in the report
  • October - October schedules will output in the report
  • March - March schedules will output in the report

Include Discipline?

Choose Yes to include discipline records; otherwise, choose No

Include Enrollments?

Choose:

  • No - No enrollment records will output in the report
  • Enrollments with Attendance
  • Enrollments without Attendance.
The Truancy indicator is calculated using the Calculate Truancy report. PowerSchool recommends running the Calculate Truancy - Legacy report before running the Enrollment portion of the SIS report.

Include 504?

Choose Yes to include 504 records; otherwise, choose No.

Include K-3 Entry Assessment Data?Choose Yes to include K-3 assessment records; otherwise, choose No.

Include Address?

Choose Yes to include student addresses; otherwise, choose No. Addresses are required for LEA A02 and Type 2 charter schools.

Include Program Information?

Choose Yes to include program records; otherwise, choose No.

Include Override Class code(rarely used)?

Choose Yes to include the override class code in the student schedule records; otherwise, choose No.

This option increases processing time.

Promoted Exit Codes (ctrl-click for multiple)

If applicable, choose the Exit Code(s) used to designate a student promoted to a higher grade level and/or retained within the district.

Any enrollment record with a Promoted Exit Code will not have an Exit Date nor Exit Code reported.


Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Length

Position

1

System Indicator

Always extracted as “SIS”. Required.

N/A

3

1

2

LEA Code

The LEA code assigned by LDOE. Required.

[S_LA_SCH_X]SiteCode

3

4

3

Record Type

Always extracted as “141”. Required.

N/A

3

7

4

Student’s Local ID Number

The locally assigned student identifier. Required.

[Students]Student_Number

9

10

5

Student’s State ID Number

The student’s state-assigned identifier. Required.

[Students]State_StudentNumber

10

19

6

Partial Student Last Name

The first three letters of the student’s last name. Required.

[Students]Last_Name

3

29

7

Partial Student First Name

The first letter of the student’s last name. Required.

[Students]Last_Name

1

32

8

Day of Birth

The student’s day of birth in DD format. Required.

[Students]DOB

2

33

9

Sex Code

The student’s gender. Required.

[Students]Gender

1

35

10

Hispanic Latino Ethnic Flg

Indicates whether the student’s ethnicity is Hispanic. Required.

[Students]FedEthnicity

1

36

11

American Indian Or Alaskan Native Race Flg

Indicates whether the student’s race is American Indian or an Alaskan Native. Required.

[StudentRace]RaceCd=AA

1

37

12

Asian Race Flg

Indicates whether the student’s race is Asian. Required.

[StudentRace]RaceCd=AS

1

38

13

Black Or African American Race Flg

Indicates whether the student’s race is Black or African American. Required.

[StudentRace]RaceCd=BA

1

39

14

Native Hawaiian Or Other Pacific Islander Race Flg

Indicates whether the student’s race is Native Hawaiian or Other Pacific Islander. Required.

[StudentRace]RaceCd=NO

1

40

15

White Race Flg

Indicates whether the student’s race is White. Required.

[StudentRace]RaceCd=WH

1

41

16

Beginning School Session Year

The first year of a school session, such as 2018. This is the school year selected at report runtime. To change this value, click Term at the top of the page, choose the correct term, and re-run the report.

Required.

[Terms]FirstDay

Format: YYYY

4

42

17

School Site Code

The school site code.

The field is required.

[S_LA_SCH_X]SiteCode

6

46

18

Grade Placement

The student's grade level.

This field is required

Valid values:

  • 01 First
  • 02 – Second
  • 03 – Third
  • 25 – Kindergarten

[Students]Grade_Level

[ReEnrollments]Grade_Level

252

19

Literacy Screener Exception Code

The reason the student did not complete a literacy screening.

Required.

Valid values:

  • [Blank/NULL] - Literacy Screening completed
  • 01 - Student was enrolled within the first 30 days of school, but was not in attendance to be assessed
  • 03 - Student assessed in another LEA
  • 05 - Assessed with alternate assessment
    • Note: If 05 is selected, an Alternate Reason Code is required.
[S_LA_STU_K3Assessment_X] LiteracyScreenerExceptCode254
20Alternate Assessment Reason Code

Required if Literacy Screener Exception Code is 05.

Valid values:

  • 01 - Hearing Disabled
  • 02 - Visually Disabled
  • 03 - Verbally Disabled


56
21Virtual Setting Flag

Indicates if the student was assessed virtually.

Valid values are Y or N.

[S_LA_STU_K3Assessment_X]VirtualSetting_TF158

22

Literacy Screener Test Type

The literacy screener test that the student took. Required.

Valid values:

  • 1 - Dibels Next
  • 2 - STEEP
  • 3 - STEP
  • 4 - Dibles 8
[S_LA_STU_K3Assessment_X]LiteracyScreenerTestType159

23

Literacy Screener Score

The score the student received on the screener test.

Required.

Valid values: 0-999.

Note: Values that are less than ten (10) will be reported with two leading blanks. Values between ten and ninety nine will have one leading blank. Example '1' extracts as ' 1'.

[S_LA_STU_K3Assessment_X]LiteracyScreenerScore360

24

K Entry Assessment Exception Code

The reason the student did not take a K Entry assessment.

Valid values:

  • [Blank/NULL] – K Entry assessment completed
  • 1 - Student was enrolled within the first 30 days of school, but was not in attendance to be assessed

  • 02 - Not first time Kindergartener

  • 03 - Student assessed in another LEA

  • 04 - Student assessed with TSGOLD

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-3, this field is NULL.
[S_LA_STU_K3Assessment_X]KEntryAssmntExcptnCode263

25

ALT-REG 1: Curiosity

The evaluation of the student's curiosity.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]ALTREG1Curiosity165

26

ALT-REG 2: Self Control

The evaluation of the student's self-control.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]ALTREG2SelfControl166

27

ALT-REG 3: Persistence

The evaluation of the student's level of persistence.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]ALTREG3Persistence167

28

ALT-REG 4: Sharing

The evaluation of the student's ability to share.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]ALTREG4Sharing168

29

SED 1: Self-Identity

The evaluation of the student's self-identity.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]SED1SelfIdentity169

30

SED 2: Feelings

The evaluation of the student's feelings.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]SED2Feelings170

31

SED 3: Interaction with Adults

The evaluation of the student's interaction with adults.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]SED3InteractionWithAdults171

32

SED 4: Interaction with Peers

The evaluation of the student's interaction with peers.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]SED4InteractionWithPeers172

33

SED 5: Sociodramatic Play

The evaluation of the student's sociodramatic play.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]SED5SociodramaticPlay173

34

LLD 1: Understanding of Language

The evaluation of the student's understanding of language.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD1UnderstandingOfLang174

35

LLD 2: Responsiveness to Language

The evaluation of the student's responsiveness to language.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD2ResponsivenessToLang175

36

LLD 3: use of Language

The evaluation of the student's use of language.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD3UseOfLang176
37LLD 4: Conversation

The evaluation of the student's conversation ability.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD4Conversation177

38

LLD 5: Interest in Literacy

The evaluation of the student's interest in literacy.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD5InterestLiteracy178

39

LLD 6: Comprehension

The evaluation of the student's literacy comprehension.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD6Comprehension179
40LLD 7: Print Concepts

The evaluation of the student's ability to understand print concepts.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD7PrintConcepts180
41LLD 8: Phonological Awareness

The evaluation of the student's phonological awareness.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD8PhonologicalAwareness181
42LLD 9: Letter Knowledge

The evaluation of the student's understanding of letters.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD9LetterKnowledge182
43LLD 10: Writing

The evaluation of the student's writing ability.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]LLD10Writing183
44COG-Math 2: Math Operation

The evaluation of the student's understanding of math operations.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]COG2MathOperation184
45COG-Math 3: Number Sense of Quantity

The evaluation of the student's sense of numeric quantity.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]COG3NoSenseofQuantity185
46COG-Math 4: Measurement

The evaluation of the student's understanding of measurement.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]COG4Measurement186
47COG-Math 6: Shapes

The evaluation of the student's understanding of shapes.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]COG6Shapes187
48PD 1: Perceptual Motor

The evaluation of the student's perceptual-motor skills.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]PD1PerceptualMotor188
49PD 2: Gross Locomotor

The evaluation of the student's gross locomotor skills.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]PD2GrossLocomotor189
50PD 3: Gross Motor Manipulative

The evaluation of the student's gross motor manipulation.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]PD3GrossMotorManipulative190
51PD 4: Fine Motor

The evaluation of the student's fine motor skills.

See Kindergarten Entry Assessment Codes for valid values.

Notes:

  • If the student's Grade Level is K, this field is required.
  • If the student's Grade Level is 1-2, this field is NULL.
[S_LA_STU_K3Assessment_X]PD4FineMotor191
JavaScript errors detected

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

If this problem persists, please contact our support.