SIS - Student Information System
On this page:
Introduction
This report collects SIS (Student Information System) information and creates an extract file for submission to the state, which includes Demographic (010), Enrollment (040), Perpetrator (091), Actions & Interventions (092), Student Schedule (110), Address (120), Section 504 (130), K-3 Literacy Screening (140) records, and 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.
- If the File Type chosen at report runtime is 1 (Partial File), then the Partial File Indicator field on the Louisiana State Information page must be checked for the student.
Incident Selection
The report selects incidents for the 091 and 092 records that meet the following criteria:
- The incident must be associated with the Incident Type “LA State Reporting”.
- The incident must have an Offender defined, even if the perpetrator is unknown (such as in the case of graffiti).
- The incident must occur within the report date range.
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:
Note: The All Schools option is 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:
Note: If running the report for a single student, or group of students, select the students prior to runningreport. |
Report Start Date | Enter the report start date. |
Report End Date | Enter the report end date. Note: This should be the “snapshot date.” If you generate a SIS report for the October submission, enter the appropriate October snapshot date. If you generate a SIS report for the February submission, enter the February snapshot date. If you generate a SIS report for EOY, enter the last day of school for students. |
Include Student Schedules? | Choose:
|
Include Discipline? | Choose Yes to include discipline records; otherwise, choose No |
Include Enrollments? | Choose:
Note: The Truancy indicator is calculated using the Calculate Truancy report. It is recommended to run the Calculate Truancy 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. Note: 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. Note: 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. Note: Any enrollment record with a Promoted Exit Code will not have an Exit Date nor Exit Code reported. |
Report Output – Demographic Record (010)
Each of the fields displayed in the output of the report are 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”. This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type Code | Always extracted as “010”. This field is required. | “010” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. This field is required. | [Students]Student_Number | 9 | 10 |
5 | Student’s State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Filler | Filler | Spaces | 8 | 29 |
7 | Partial Student Last Name | The first 3 letters of the student’s last name. This field is required. | [Students]Last_Name | 3 | 37 |
8 | Filler | Filler | Spaces | 20 | 40 |
9 | Partial Student First Name | The first letter of the student’s first name. This field is required. | [Students]First_Name | 1 | 60 |
10 | Filler | Filler | Spaces | 31 | 61 |
11 | Day of Birth | The student’s day of birth in DD format. This field is required. | [Students]DOB | 2 | 92 |
12 | Military Affiliation | Indicates whether the student's family is associated with the military. | [S_LA_STU_X]MilitaryAffiliation | 4 | 94 |
13 | Gender Code | The student’s gender. This field is required. | [Students]Gender | 1 | 98 |
14 | Filler | Filler | Spaces | 1 | 99 |
15 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 100 |
16 | Country of Birth Code | The country in which the student was born. This field is required. Note: If country of birth is not U.S or a U.S. territory, "ZZ" is reported. | [S_LA_STU_Demographics_X]BirthCountry | 2 | 108 |
17 | First Entry Date into U.S. | The date the student arrived in the U.S. in order to establish residency. This field is required when Country of Birth is anything other than US. | [Students]DateOfEntryIntoUSA | 8 | 110 |
18 | Hispanic Latino Ethnic Flg | Indicates whether the student’s ethnicity is Hispanic. This field is required. | [Students]FedEthnicity | 1 | 118 |
19 | American Indian Or Alaskan Native Race Flg | Indicates whether the student’s race is American Indian or an Alaskan Native. This field is required. | [StudentRace]RaceCd=AA | 1 | 119 |
20 | Asian Race Flg | Indicates whether the student’s race is Asian. This field is required. | [StudentRace]RaceCd=AS | 1 | 120 |
21 | Black Or African American Race Flg | Indicates whether the student’s race is Black or African American. This field is required. | [StudentRace]RaceCd=BA | 1 | 121 |
22 | Native Hawaiian Or Other Pacific Islander Race Flg | Indicates whether the student’s race is Native Hawaiian or Other Pacific Islander. This field is required. | [StudentRace]RaceCd=NO | 1 | 122 |
23 | White Race Flg | Indicates whether the student’s race is White. This field is required. | [StudentRace]RaceCd=WH | 1 | 123 |
Report Output – Enrollment Record (040)
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
+ | Data Element | Description | [Table]FieldName | Length | Position |
1 | System Indicator | Always extracted as “SIS” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “040” This field is required. | “040” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. This field is required | [Students]Student_Number | 9 | 10 |
5 | Student’s State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | Derived from [Terms]FirstDay and [Terms]LastDay Format: XXXXYYYY | 8 | 29 |
7 | School/Site Code | The school’s site code, reported from the Site Code field entered via Start Page > District Setup > Schools/School Info > Edit School. This field is required. | [S_LA_SCH_X]SiteCode | 6 | 37 |
8 | Entry Date | The date this school enrollment began for the student. This field is required. | [Students]EntryDate [ReEnrollments]EntryDate | 8 | 43 |
9 | Entry Reason Code | The student’s entry code for this school enrollment. This field is required. See Entry Codes for valid values. | [Students]EntryCode [ReEnrollments]EntryCode | 2 | 51 |
10 | Grade Placement | The student’s grade level for this school enrollment. This field is required. The following grade levels are extracted on the report:
| [Students]Grade_Level [ReEnrollments]Grade_Level If [Students]Grade_Level = 9 and [S_LA_STU_TransNinthGrade_X]TransNinthYearID = the current school year ID then T9 | 2 | 53 |
11 | Special Education Indicator | Indicates whether the student is in SER for Special Education. This field is required if applicable. Valid values:
| [S_LA_STU_504SPED_X]SPEDIndicator | 1 | 55 |
12 | Absences | The number of days the student was absent during the report date range. To be considered absent, the student must be marked with an absent attendance code that equates to a full absence for that day. The attendance conversion setup at the school level determines whether the student is absent for the day. Note: If the No Show indicator is selected, the Absences output is four zeros (0000). Review additional information about troubleshooting attendance. This field is required. | [Attendance]Att_Date | 4 | 56 |
13 | Pre-K Funding Source Code | Indicates the primary funding source program for grade 24 (Pre-K) or 20 (Pre-School) students. This field is required for students in grade 24 and optional for students in grade 20. | [S_LA_STU_X]PreKFundingSourceCode | 2 | 60 |
14 | Free or Reduced Lunch Eligibility Code | Indicates whether the student qualifies for free or reduced school lunch or breakfast. This field is required if applicable. Valid values:
| If [Students]LunchStatus = F or FDC set to 1. | 1 | 62 |
15 | Exit Date | The date the student exited this school enrollment. This field should be blank if the student has not yet exited. Note: An exit date is only reported if the student has both an exit date and an exit code entered. This field is required if applicable. | [Students]ExitDate [ReEnrollments]ExitDate | 8 | 63 |
16 | Exit Reason Code | The reason a student exited this school enrollment. Note: An exit date is only reported if the student has both an exit date and an exit code entered. This field is required if applicable. | [Students]ExitCode [ReEnrollments]ExitCode | 2 | 71 |
17 | Dropout Reason Code | Indicates the reason the student dropped out of school. This field is required if Exit Reason Code is 02, 11, or 13. This field is required if applicable. | [S_LA_STU_X]DropoutReasonCode [S_LA_REN_X]DropoutReasonCode | 2 | 73 |
18 | Calendar Code | The code assigned by the LEA to a calendar. This field indicates the calendar that applies to this student for attendance purposes. This field is required. | [S_LA_STU_X]CalendarCode | 3 | 75 |
19 | Language Code | The student’s primary language. This field is required. | [S_LA_STU_Language_X]LanguageCode | 3 | 78 |
20 | English Proficiency Code | Indicates whether the student is fully English proficient. This field is required. Valid values:
| [S_LA_STU_Language_X]EnglishProficiency | 2 | 81 |
21 | LEP Funding Source Code | Indicates the primary supplemental funding source for students with an English Proficiency code of 02 (Not Proficient). This field is required if applicable. | [S_LA_STU_Language_X]LEPFundingSource | 2 | 83 |
22 | Option Code | The student’s value for option code. This field is required if applicable. Valid values:
Note: Enrollments after 7/1/2018 with option code 1 will extract as A. | [S_LA_STU_X]OptionCode [S_LA_REN_X]OptionCode | 1 | 85 |
23 | Truancy Flag | Indicates whether the student has 5 unexcused tardies or 5 unexcused absences in a semester. This total cannot be a combination, such as 2 absences and 3 tardies, the value must be 5 of either to be considered a truancy. This indicator is calculated using the Calculate Truancy report. It is recommended to run the Calculate Truancy report before running the Enrollment portion of the SIS report. A valid unexcused absence occurs when the student is assigned an unexcused absence attendance code for a full school day. A valid unexcused tardy occurs when the student either arrives late at school or leaves school early. The student may only have 1 unexcused tardy instance per day. This field is required. Valid values:
| [S_LA_STU_X]Truant_TF [S_LA_REN_X]Truant_TF | 1 | 86 |
24 | Homeless Indicator | Indicates whether the student is homeless and where they principally sleep at night. This field is required if applicable. Valid values:
| [S_LA_STU_X]HomelessCode [S_LA_REN_X]HomelessCode | 1 | 87 |
25 | Home Based Site Code | The home-based site code is required for alternative school students and options 3 program students. This field is required if applicable. | [S_LA_STU_X]HomeBasedSiteCode [S_LA_REN_X]HomeBasedSiteCode | 6 | 88 |
26 | Unaccompanied Youth Flag | Indicates whether the student is an unaccompanied youth. This field is required if applicable. Valid values:
| [S_LA_STU_X]UnaccompaniedYouth_TF | 1 | 94 |
27 | Homeless Reason Code | Indicates the reason the student is homeless. This field is required if applicable. Valid values:
| [S_LA_STU_X]HomelessReasonCode | 2 | 95 |
28 | Services Provided Flag | Indicates whether services are provided for the homeless student. This field is required if applicable. Valid values:
| [S_LA_STU_X]HomelessServicesProvided_TF | 1 | 97 |
29 | Prior Education Experience to Kindergarten | Code indicating where the student received at least 6 consecutive months of Prekindergarten experience prior to entering kindergarten. This is a required field for kindergarten. See Prior Education Experience to Kindergarten Codes for valid values. | [S_LA_STU_X]PriorEducationExperienceKGCode | 2 | 98 |
30 | Filler | Filler | Spaces | 1 | 100 |
31 | Filler | Filler | Spaces | 1 | 101 |
32 | Filler | Filler | Spaces | 1 | 102 |
33 | Awaiting Foster Care Flag | Indicates that a student is awaiting Foster Care This field is required if applicable. Valid Values:
| [S_LA_STU_X]AwaitingFosterCare_TF | 1 | 103 |
Report Output – Program Records (050)
Each of the fields displayed in the output of the report are 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” | “SIS” | 3 | 1 |
2 | LEA Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type Code | Always extracted as “050” | “050” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. This field is required. | [Students]Student_Number | 9 | 10 |
5 | Student’s Unique State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 29 |
7 | Site Code | The school’s site code, reported from the Site Code field entered via Start Page > District Setup > Schools/School Info > Edit School. | [S_LA_SCH_X]SiteCode | 6 | 37 |
8 | Program Code | Code that uniquely identifies a program or pathway. This field is required. | Derived based on the fields entered on State/Province – LA > Program Info | 6 | 43 |
9 | ProgramStartDate | The calendar date when the student begins program participation This field is required. | [S_LA_STU_StudentPrograms_X](Program)_EntryDate Where (Program) is one of the programs listed on the State/Province – LA > Program Info page. | 8 | 49 |
Report Output – Student Perpetrator and Instance Record (091)
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Length | Start Position |
1 | System Indicator | Always extracted as “SIS” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “091” This field is required. | “091” | 3 | 7 |
4 | Student’s Local ID | The student’s locally assigned identifier. | [Students]Student_Number | 9 | 10 |
5 | Perpetrator Unique ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Event ID | The code used by the state to identify the event. In Incident Management, this is the Incident ID assigned automatically when the incident is saved. This field is required. Zero padded to the left if less than 10 characters. | [Incident]Incident_ID | 10 | 29 |
7 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 39 |
8 | School/Site Code | The school associated with the perpetrator. This field is required. | [S_LA_SCH_X]SiteCode | 6 | 47 |
9 | Perpetrator Type Code | Indicates the type of perpetrator for this student. In Incident Management, this is a Participant Role code. This field is required. | [Incident_Lu_Sub_Code]State_Detail_Report_Code | 2 | 53 |
10 | Primary Reason Code | The most serious offense associated with the perpetrator. In Incident Management, this is a Behavior code. To indicate the primary behavior/reason, select the Primary Behavior checkbox when adding a behavior to the incident. This field is required. Note: If primary reason code is 22 - 29 or 32, the value is reported as 50 to represent the Violence category. See Incident Management: Behavior Codes for valid values. | [PSRW_ParticipantBehavior] State_Aggregate_RPT_Code | 2 | 55 |
11 | Firearms & Explosives | Indicates whether a firearm or explosive was involved in the incident. In Incident Management, this is a Behavior subcode. Required when the Primary Reason code is 13 or 30. Extracted as blank for all other cases. See Incident Management: Behavior Subcodes for valid values. | [PSRW_ParticipantBehavior] State_Detail_Report_Code where primary behavior is 13 or 30 | 2 | 57 |
12 | Other Weapon Code | Indicates whether a weapon other than a firearm or explosive was involved in the incident. In Incident Management, this is a Behavior subcode. Required when the Primary Reason code is 14, 15, or 31. Extracted as blank for all other cases See Incident Management: Behavior: Subcodes for valid values. | [PSRW_ParticipantBehavior] State_Detail_Report_Code where primary behavior is 14, 15, or 31 | 2 | 59 |
13 | Violent | Indicates whether violence was involved in the incident. In Incident Management, this is a Behavior category. Required when the Primary Reason code is 22 to 29 or 32. Extracted as blank for all other cases. See Incident Management: Behavior: Subcodes for valid values. | [PSRW_ParticpantBehavior] State_Detail_Report_Code where the primary behavior is 22 to 29 or 32 | 1 | 61 |
14 | Bullying Code | Indicates whether bullying was involved in the incident. In Incident Management, this is a Behavior subcode. Required when the Primary Behavior code is 35 or 36. Extracted as blank for all other cases. See Incident Management: Behavior: Subcodes for valid values. | [PSRW_ParticpantBehavior] State_Detail_Report_Code where the primary behavior is 35 or 36 | 2 | 62 |
15 | Electronic Aggression | Indicates whether electronic aggression was involved in the incident. In Incident Management, this is a Participant Attribute subcode. Valid values:
Required when the Primary Behavior code is 35 or 36. Extracted as blank for all other cases. | [PSRW_ParticipantAttr]Incident_Category where the primary behavior is 35 or 36 | 1 | 64 |
16 | Emotional Aggression | Indicates whether emotional aggression was involved in the incident. In Incident Management, this is a Participant Attribute subcode. Valid values:
Required when the PrimaryBehavior code is 35 or 36. Extracted as blank for all other cases. | [PSRW_ParticipantAttr]Incident_Category where the primary behavior is 35 or 36 | 1 | 65 |
17 | Physical Aggression | Indicates whether physical aggression was involved in the incident. In Incident Management, this is a Participant Attribute subcode. Valid values:
Required when the PrimaryBehavior code is 35 or 36. Extracted as blank for all other cases. | [PSRW_ParticipantAttr]Incident_Category where the primary behavior is 35 or 36 | 1 | 66 |
18 | Verbal Aggression | Indicates whether verbal aggression was involved in the incident. In Incident Management, this is a Participant Attribute subcode. Valid values:
Required when the Primary Behavior code is 35 or 36. Extracted as blank for all other cases. | [PSRW_ParticipantAttr]Incident_Category where the primary behavior is 35 or 36 | 1 | 67 |
19 | Witness Count | The number of witnesses involved in the incident. The report totals the number of participants with the “Witness” Participant Role code. This field is required if there is at least one witness involved. | [PSRW_IncidentParticpant] = Witness (Count) | 2 | 68 |
20 | Physical Evidence Code | The primary source of physical evidence of the incident. In Incident Management, this is a Participant Attribute subcode. This field is required if applicable. See Incident Management: Participant Attribute Subcodes for valid values. | [PSRW_ParticipantAttr]State_Detail_Report_Code | 2 | 70 |
21 | Filler | Filler | Space | 1 | 72 |
22 | Filler | Filler | Space | 1 | 73 |
23 | Filler | Filler | Spaces | 2 | 74 |
24 | Parent Contacted Flag | Indicates whether the parent of the perpetrator was contacted. In Incident Management, this is a Participant Attribute code. Valid values:
This field is required. | [PSRW_ParticipantAttr]Incident_Category | 1 | 76 |
25 | Reported to Law Enforcement | Indicates whether the incident was reported to law enforcement. In Incident Management, this is a Participant Attribute code. Valid values:
This field is required. | [PSRW_ParticipantAttr]Incident_Category | 1 | 77 |
26 | Arrest Resulted Flag | Indicates whether the incident resulted in an arrest. In Incident Management, this is a Participant Attribute code. Valid values:
This field is required. | [PSRW_ParticipantAttr]Incident_Category | 1 | 78 |
27 | Serious Injury Resulted | Indicates whether the incident resulted in serious injury of the perpetrator. In Incident Management, this is a Participant Attribute code. Valid values:
This field is required. | [PSRW_ParticipantAttr]Incident_Category | 1 | 79 |
28 | Medical Treatment (perpetrator) | Indicates whether the incident resulted in medical treatment for the perpetrator. In Incident Management, this is a Participant Attribute code. Valid values:
This field is required. | [PSRW_ParticipantAttr]Incident_Category | 1 | 80 |
29 | Filler | Filler | Spaces | 2 | 81 |
Report Output – Discipline Actions & Interventions Record (092)
Discipline Date Logic
The Discipline Administered Date (DAD) is only used for discipline actions that occur on a single day, such as corporal punishment, TOR, restraints, student reprimand, etc.The Discipline Start (DSD) and Discipline Return Dates (DRD) are required for discipline actions that span multiple days.
Some action types can only occur on a single day, while other action types can occur on a single day or can apply for multiple days.
Date logic is as follows:
Action Code(s) | Logic Applied |
---|---|
000 | Dates not reported |
001, 008-022, 025, 030, 048, | DAD is reported if present |
002, 004, 006 | DSD is reported if present. |
003, 005, 007, 130 | DSD is reported if present. |
040, 043, 045, 070, 160, 999 | If DAD is not present, DSD and DRD are reported |
Report Output
Item # | Data Element | Description | [Table]FieldName | Length | Start Position |
1 | System Indicator | Always extracted as “SIS” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “092” This field is required. | “092” | 3 | 7 |
4 | Student’s Local ID | The student’s locally assigned identifier. | [Students]Student_Number | 9 | 10 |
5 | Perpetrator Unique ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Event ID | The code used by the state to identify the event. In Incident Management, this is the Incident ID assigned automatically when the incident is saved. This field is required. Zero padded to the left if less than 10 characters. | [Incident]Incident_ID | 10 | 29 |
7 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 39 |
8 | Action/Intervention Code | Indicates the punishment, treatment, intervention or action taken as a result of the incident. In Incident Management, this is the Action code. See Incident Management: Action Codes for valid values. | [PSRW_ParticipantBehaviorAction] State_Detail_Report_Code | 3 | 47 |
9 | Discipline Start Date | The date that the disciplinary action began. In Incident Management, this is the Action Date Range Begin Date. Note: The Discipline Start and Discipline Return Dates are required for discipline actions that span multiple days. See also: Discipline Date Logic. DSD = Discipline Start Date = Action Date Range Begin Date attribute entered into Incident Management - Position 50-57 | [PSRW_ParticipantBehaviorAction] Action_Plan_Begin_DT | 8 | 50 |
10 | Discipline Return Date | The date that the student is allowed to return to school after the disciplinary action occurs. In Incident Management, this is the first in session school day after Action Date Range End Date. Note: The Discipline Start and Discipline Return Dates are required for discipline actions that span multiple days. See also: Discipline Date Logic. DRD = Discipline Return Date = Next in session day after Action Date Range End Date attribute entered into Incident Management - Position 58-65 | [PSRW_ParticipantBehaviorAction] Action_Plan_End_DT if action code in (003, 005, 007) else Action_Plan_End_Date = 1 if action code in (002, 004, 006) else blank. | 8 | 58 |
11 | Discipline Administered Date | The date that the disciplinary action is administered. In Incident Management, this is an Action Attribute. Note: This date is only used for discipline actions that occur on a single day, such as corporal punishment, TOR, restraints, student reprimand, etc. See also: Discipline Date Logic. It is recommended to enter the same day as the Action Date Range Begin Date. DAD = Discipline Administered Date = Discipline Administered Date entered into Incident Management - Position 66-73 | [PSRW_ParticpantActionAttr]Date_Attribute | 8 | 66 |
12 | Corporal Punishment Directly Authorized by Uninvolved 3rd Party Flag | Indicates whether the corporal punishment was reviewed by a third party and warranted. In Incident Management, this is an Action Attribute. Valid values:
| [PSRW_ParticipantActionAttr] Is_yes1_noo_attribute | 1 | 74 |
13 | Corporal Punishment Administrator Type Code | The role of the person administering the corporal punishment. In Incident Management, this is an Action Attribute. See Incident Management: Action Attribute Codes for valid values. | [PSRW_ParticipantActionAttr] State_Detail_Report_Code if Action/Intervention Code = 90, 95, 100 or 180. Otherwise published as blank | 2 | 75 |
14 | Corporal Punishment Administrator Last Name | The last name of the person administering the corporal punishment. In Incident Management, this is an Action Attribute. | [PSRW_ParticipantActionAttr]Text_Attribute if Action/Intervention Code = 90, 95, 100 or 180. Otherwise published as blank | 20 | 77 |
15 | Corporal Punishment Administrator First Name | The first name of the person administering the corporal punishment. In Incident Management, this is an Action Attribute. | [PSRW_ParticipantActionAttr]Text_Attribute if Action/Intervention Code = 90, 95, 100 or 180. Otherwise published as blank | 15 | 97 |
16 | Manifestation Hearing Date | The date the manifestation hearing was held for special education students. In Incident Management, this is an Action Attribute. | [PSRW_ParticipantActionAttr]Date_attribute | 8 | 112 |
17 | Disability-Related Flag | Indicates whether the student’s behavior was determined to be related to a disability. In Incident Management, this is an Action Attribute. Valid values:
| [PSRW_ParticipantActionAttr] Is_yes1_no0_attribute | 1 | 120 |
18 | Minutes Removed | The number of minutes the student was removed from class from their regular setting. | [PSRW_ParticipantActionAttr]Number_Attribute if null calculated from [PS_Memberhip_Default] | 6 | 121 |
19 | Alternate Site Code | Site where the action/intervention was administered if the action was administered at an alternate site (Action code = 006, 007 or 010) | [Incident_Action_Attribute]Text_Attribute | 6 | 127 |
Report Output – Class Schedule Record (110)
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Class Schedule Record Selection Criteria:
The report selects records from the [CC] table that meet the following criteria:
- The section of the Class Enrollment record is not checked to be excluded from state reporting ([Sections]Exclude_State_Rpt_YN not equal to 1)
- The Class Enrollment record has been checked to be included in state reporting on the All Enrollments > edit page ([CC]Period_Obsolete = 1).
- The Class Enrollment record was not dropped before October 1st. ([CC]DateLeft is greater than 10/01 of the current year)
- The Class Enrollment exit date is not before the Class entry date ([CC]DateLeft is greater than [CC]DateEnrolled
- Duplicate class records will not be pulled. (A duplicate is defined as having the same course number, section number, and site code)
Item # | Data Element | Description | [Table]FieldName | Length | Position |
1 | System Indicator | Always extracted as “SIS” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “110” This field is required. | “110” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. | [Students]Student_Number | 9 | 10 |
5 | Student’s State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 29 |
7 | School/Site Code | The site code of the school at which the class is offered. The report extracts the SchoolID from the CC (class enrollment) record, if different from the student’s school of enrollment. Otherwise, the site code for school in which the student was enrolled during the report date range is reported. This field is required. | [CC]SchoolID [S_LA_SCH_X]SiteCode | 6 | 37 |
8 | Class Code | The code that uniquely identifies a class in the CUR record. The report extracts the value in the Non-LEA Class Code field on the Edit Section page, if populated. Otherwise, the report extracts the section number and course number assigned to the section. This field is required. | [S_LA_SEC_X]NonLEASiteCode [Sections]Section_Number [Sections]Course_Number | 20 | 43 |
Report Output – Address Record (120)
Each of the fields displayed in the output of the report are 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” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “120” This field is required. | “120” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. | [Students]Student_Number | 9 | 10 |
5 | Student’s State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 29 |
7 | Filler | Filler | Spaces | 74 | 37 |
8 | Zip Code (Physical) | The student’s residential zip code. Note: Only the first 5 characters are extracted. | [Students]Zip | 5 | 111 |
9 | Filler | Filler | Spaces | 4 | 116 |
10 | State | The student’s residential state. | [Students]State | 2 | 120 |
11 | Residing District Code | The city/district code of the school district in which the student or legal guardian resides. The report extracts the value entered on the District Information page at the district level, or the value entered for Override District Code on the State Province – LA General tab at the student level. | [S_LA_STU_X]ParishOverrideCode or [Prefs]Value where [Prefs]Name=LA_Dist_Cd | 2 | 122 |
12 | Military Reside Flag | Y/N Flag to indicate if this address is on a Military Base | [S_LA_STU_X]MilitaryBaseAddressInd_TF | 1 | 124 |
13 | Non-district Building Flag | Y/N flag to indicate if a student attends school in a building not owned by the district. | [S_LA_STU_X]NonDistrictBldgFlag or [S_LA_SCH_Charter_X]NonDistrictBldgFlag | 1 | 125 |
Report Output – 504 Record (130)
Each of the fields displayed in the output of the report are 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” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “130” This field is required. | “130” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. This field is required | [Students]Student_Number | 9 | 10 |
5 | Student’s State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | Session Year | The year of a school session, such as 20182019. 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. This field is required. | [Terms]FirstDay [Terms]LastDay Format: XXXXYYYY | 8 | 29 |
7 | IAP Review Date | The date when a student’s Individual Accommodation Plan (IAP) is reviewed. | [S_LA_STU_504SPED_X]IAPReviewDate | 8 | 37 |
8 | Last 504 Evaluation Date | The date of the student’s most recent 504 evaluation. | [S_LA_STU_504SPED_X]DateOf504 | 8 | 45 |
9 | Section 504 Disability #1 | The student’s section 504 disability #1. | [S_LA_STU_504SPED_X]Disability1 | 2 | 53 |
10 | Section 504 Disability #2 | The student’s section 504 disability #2. | [S_LA_STU_504SPED_X]Disability2 | 2 | 55 |
11 | Section 504 Disability #3 | The student’s section 504 disability #3. | [S_LA_STU_504SPED_X]Disability3 | 2 | 57 |
12 | Section 504 Disability #4 | The student’s section 504 disability #4. | [S_LA_STU_504SPED_X]Disability4 | 2 | 59 |
13 | Section 504 Disability #5 | The student’s section 504 disability #5. | [S_LA_STU_504SPED_X]Disability5 | 2 | 61 |
14 | Section 504 Disability #6 | The student’s section 504 disability #6. | [S_LA_STU_504SPED_X]Disability6 | 2 | 63 |
15 | Section 504 Disability #7 | The student’s section 504 disability #7. | [S_LA_STU_504SPED_X]Disability7 | 2 | 65 |
16 | Section 504 Services Exit Date | The date the student exited all 504 services. Format: MMDDYYYY | [S_LA_STU_504SPED_X]ExitDate | 8 | 67 |
17 | Section 504 Exit Reason Code | The code indicating why a student no longer receives 504 services. | [S_LA_STU_504SPED_X]ExitReason | 2 | 75 |
18 | Section 504 Braille Accommodation | Indicates a student’s braille requirements for assessments:
| [S_LA_STU_504SPED_X]BrailleAccomm | 1 | 77 |
19 | Section 504 Large Print Accommodation | Indicates whether a student requires large print assessments:
| [S_LA_STU_504SPED_X]LargePrintAccomm | 1 | 78 |
20 | Section 504 Extended Time Accommodation | Indicates whether a student requires extended time for assessments:
| [S_LA_STU_504SPED_X]ExtendedTimeAccomm | 1 | 79 |
21 | Section 504 Answers Recorded Accommodation | Indicates whether a student needs to record the answers for assessments:
| [S_LA_STU_504SPED_X] AnswersRecordedAccomm | 1 | 80 |
22 | Section 504 Transferred Answers Accommodation | Indicates whether a student requires the answers transferred for assessments:
| [S_LA_STU_504SPED_X] TransferredAnswersAccomm | 1 | 81 |
23 | Section 504 Individual Testing Accommodation | Indicates whether a student requires individual testing:
| [S_LA_STU_504SPED_X]IndividualTestingAccomm | 1 | 82 |
24 | Section 504 Small Group Testing Accommodation | Indicates whether a student requires small group testing:
| [S_LA_STU_504SPED_X] SmallGroupTestingAccomm | 1 | 83 |
25 | Filler | Filler | n/a | n/a | 84 |
26 | Section 504 Test Read Aloud for English/Language Arts Accommodation | Indicates whether a student requires that tests for English/Language Arts be read aloud:
| [S_LA_STU_504SPED_X] ReadEnglishLangArtsAccomm | 1 | 85 |
27 | Section 504 Test Read Aloud for Math Accommodation | Indicates whether a student requires that tests for Math be read aloud:
| [S_LA_STU_504SPED_X]ReadMathAccomm | 1 | 86 |
28 | Section 504 Test Read Aloud for Science Accommodation | Indicates whether a student requires that tests for Science be read aloud:
| [S_LA_STU_504SPED_X]ReadScienceAccomm | 1 | 87 |
29 | Section 504 Test Read Aloud for Soc. Studies Accommodation | Indicates whether a student requires that tests for Social Studies be read aloud:
| [S_LA_STU_504SPED_X]ReadSocStudAccomm | 1 | 88 |
Report Output – K-3 Literacy Screening Record (140)
Each of the fields displayed in the output of the report are 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” This field is required. | “SIS” | 3 | 1 |
2 | LEA/Sponsor Code | The sponsor code of the district submitting data. The report extracts the first three digits of the site code. This field is required. | [S_LA_SCH_X]SiteCode | 3 | 4 |
3 | Record Type | Always extracted as “140” This field is required. | “140” | 3 | 7 |
4 | Student’s Local ID Number | The locally assigned student identifier. This field is required | [Students]Student_Number | 9 | 10 |
5 | Student’s State ID Number | The student’s state assigned identifier. This field is required. | [Students]State_StudentNumber | 10 | 19 |
6 | 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. This field is required. | [Terms]FirstDay Format: YYYY | 8 | 29 |
7 | School Site Code | The school site code. The field is required. | [S_LA_SCH_X]SiteCode | 6 | 33 |
8 | Grade Placement | The student's grade level. This field is required Valid values:
| [Students]Grade_Level [ReEnrollments]Grade_Level | 2 | 39 |
9 | Literacy Screener Exception Code | The reason the student did not complete a literacy screening. This field is required. Valid values:
| [S_LA_STU_K3Assessment_X] LiteracyScreenerExceptCode | 2 | 41 |
10 | Literacy Screener Test Type | The literacy screener test that the student took. This field is required. Valid values:
| [S_LA_STU_K3Assessment_X]LiteracyScreenerTestType | 1 | 43 |
11 | Literacy Screener Score | The score the student received on the screener test. This field is required. Valid values: 0-99. Note: Values that are less than ten (10) must have a leading zero. Example '1' extracts as '01'. | [S_LA_STU_K3Assessment_X]LiteracyScreenerScore | 2 | 44 |
12 | 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 | 46 |
13 | 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 | 48 |
14 | 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 | 49 |
15 | 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 | 50 |
16 | 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 | 51 |
17 | 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 | 52 |
18 | 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 | 53 |
19 | 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 | 54 |
20 | 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 | 55 |
21 | 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 | 56 |
22 | 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 | 57 |
23 | 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 | 58 |
24 | 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 | 59 |
25 | 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 | 60 |
26 | 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 | 61 |
27 | 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 | 62 |
28 | 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 | 63 |
29 | 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 | 64 |
30 | 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 | 65 |
31 | 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 | 66 |
32 | 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 | 67 |
33 | 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 | 68 |
34 | 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 | 69 |
35 | 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 | 70 |
36 | 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 | 71 |
37 | 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 | 72 |
38 | 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 | 73 |
39 | 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 | 74 |