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:
|
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:
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:
|
Include Student Schedules? | Choose:
|
Include Discipline? | Choose Yes to include discipline records; otherwise, choose No |
Include Enrollments? | Choose:
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:
| [Students]Grade_Level [ReEnrollments]Grade_Level | 2 | 52 |
19 | Literacy Screener Exception Code | The reason the student did not complete a literacy screening. Required. Valid values:
| [S_LA_STU_K3Assessment_X] LiteracyScreenerExceptCode | 2 | 54 |
20 | Alternate Assessment Reason Code | Required if Literacy Screener Exception Code is 05. Valid values:
| 56 | ||
21 | Virtual Setting Flag | Indicates if the student was assessed virtually. Valid values are Y or N. | [S_LA_STU_K3Assessment_X]VirtualSetting_TF | 1 | 58 |
22 | Literacy Screener Test Type | The literacy screener test that the student took. Required. Valid values:
| [S_LA_STU_K3Assessment_X]LiteracyScreenerTestType | 1 | 59 |
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]LiteracyScreenerScore | 3 | 60 |
24 | K Entry Assessment Exception Code | The reason the student did not take a K Entry assessment. Valid values:
Notes:
| [S_LA_STU_K3Assessment_X]KEntryAssmntExcptnCode | 2 | 63 |
25 | ALT-REG 1: Curiosity | The evaluation of the student's curiosity. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]ALTREG1Curiosity | 1 | 65 |
26 | ALT-REG 2: Self Control | The evaluation of the student's self-control. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]ALTREG2SelfControl | 1 | 66 |
27 | ALT-REG 3: Persistence | The evaluation of the student's level of persistence. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]ALTREG3Persistence | 1 | 67 |
28 | ALT-REG 4: Sharing | The evaluation of the student's ability to share. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]ALTREG4Sharing | 1 | 68 |
29 | SED 1: Self-Identity | The evaluation of the student's self-identity. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]SED1SelfIdentity | 1 | 69 |
30 | SED 2: Feelings | The evaluation of the student's feelings. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]SED2Feelings | 1 | 70 |
31 | SED 3: Interaction with Adults | The evaluation of the student's interaction with adults. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]SED3InteractionWithAdults | 1 | 71 |
32 | SED 4: Interaction with Peers | The evaluation of the student's interaction with peers. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]SED4InteractionWithPeers | 1 | 72 |
33 | SED 5: Sociodramatic Play | The evaluation of the student's sociodramatic play. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]SED5SociodramaticPlay | 1 | 73 |
34 | LLD 1: Understanding of Language | The evaluation of the student's understanding of language. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD1UnderstandingOfLang | 1 | 74 |
35 | LLD 2: Responsiveness to Language | The evaluation of the student's responsiveness to language. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD2ResponsivenessToLang | 1 | 75 |
36 | LLD 3: use of Language | The evaluation of the student's use of language. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD3UseOfLang | 1 | 76 |
37 | LLD 4: Conversation | The evaluation of the student's conversation ability. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD4Conversation | 1 | 77 |
38 | LLD 5: Interest in Literacy | The evaluation of the student's interest in literacy. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD5InterestLiteracy | 1 | 78 |
39 | LLD 6: Comprehension | The evaluation of the student's literacy comprehension. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD6Comprehension | 1 | 79 |
40 | LLD 7: Print Concepts | The evaluation of the student's ability to understand print concepts. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD7PrintConcepts | 1 | 80 |
41 | LLD 8: Phonological Awareness | The evaluation of the student's phonological awareness. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD8PhonologicalAwareness | 1 | 81 |
42 | LLD 9: Letter Knowledge | The evaluation of the student's understanding of letters. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD9LetterKnowledge | 1 | 82 |
43 | LLD 10: Writing | The evaluation of the student's writing ability. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]LLD10Writing | 1 | 83 |
44 | COG-Math 2: Math Operation | The evaluation of the student's understanding of math operations. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]COG2MathOperation | 1 | 84 |
45 | COG-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:
| [S_LA_STU_K3Assessment_X]COG3NoSenseofQuantity | 1 | 85 |
46 | COG-Math 4: Measurement | The evaluation of the student's understanding of measurement. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]COG4Measurement | 1 | 86 |
47 | COG-Math 6: Shapes | The evaluation of the student's understanding of shapes. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]COG6Shapes | 1 | 87 |
48 | PD 1: Perceptual Motor | The evaluation of the student's perceptual-motor skills. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]PD1PerceptualMotor | 1 | 88 |
49 | PD 2: Gross Locomotor | The evaluation of the student's gross locomotor skills. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]PD2GrossLocomotor | 1 | 89 |
50 | PD 3: Gross Motor Manipulative | The evaluation of the student's gross motor manipulation. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]PD3GrossMotorManipulative | 1 | 90 |
51 | PD 4: Fine Motor | The evaluation of the student's fine motor skills. See Kindergarten Entry Assessment Codes for valid values. Notes:
| [S_LA_STU_K3Assessment_X]PD4FineMotor | 1 | 91 |