Data Fields and Report Example for TX
Data Fields and Report Example for CA
Overview
Navigate to Reports > Student Data > Home Language Survey.
A report is available for printing the Home Language Survey questions that are reported in Online Enrollment. The report is available in all states and can be printed from the Reports page or View All Reports. The report can be printed from District or school.
Security ↑
Table | Permission | Description |
|---|---|---|
| Language Assessment (LAC) | Read | Print Report |
Report Options ↑
The report contains Report Options that can be applied when printing the Home Language Survey Report. The options will vary depending on whether the report is being generated from the District or the individual school site.
A survey is considered digitally signed when it has a valid digital signature from Online Enrollment (LAC.HLH). Only students with a Language Assessment record are included in the report, and students are listed by school, last name, and first name.
Printing from District:
When the report is printed from the District, a KEEP/SKIP query statement is required. The Run Report button will be disabled if the query statement has not been applied.
A query example could be finding students that are tagged with a source of OE in the Language Assessment page. This is auto-populated when records are imported from OE.
LIST STU LAC STU.ID STU.LN STU.FN LAC.L1 LAC.L2 LAC.L3 LAC.L4 LAC.SRC LAC.HCB LAC.HLH LAC.SNM IF LAC.SRC = OE
The Report Options will include the following:
- Include students with digitally signed surveys.
- Include students without digitally signed surveys. If neither option is selected, all students are included.
- Language to Print: Report can be printed in English or Spanish languages and is NOT defined by code values stored STU.HL or STU.CL.
Printing from School:
Select the appropriate options when printing the report for students in the logged in school. A query can be used to limit the students. At a school, a KEEP/SKIP query is recommended for large schools but not required.
A query example could be finding students that are tagged with a source of OE in the Language Assessment page. This is auto-populated when records are imported from OE.
LIST STU LAC STU.ID STU.LN STU.FN LAC.L1 LAC.L2 LAC.L3 LAC.L4 LAC.SRC LAC.HCB LAC.HLH LAC.SNM IF LAC.SRC = OE
The Report Options will include:
- Include students with digitally signed surveys.
- Include students without digitally signed surveys. If neither option is selected, all students are included.
- Language to Print: Report can be printed in English or Spanish languages and is NOT defined by code values stored STU.HL or STU.CL.
- Student Selector: Select 1 or many students. When no student is selected, the report will generate for all students in the school, including inactive students, and will print based on the options selected
- Show all Students (includes inactive students): Displays inactive students in the student selector.
Data Fields and Report Example for TX ↑
The form will contain data from the following fields:
| Table | Field | Description |
| Student Data (STU) | (FN, LN) | First Name and Last Name |
| District Name (LOC) | LOC.NM for Code = 0 | The title of the School District |
| Student Data (STU) | (ID) | Student ID number |
| Campus Name | LOC.NM | The title of the Student's Campus |
| Language Assessment (LAC) | LAC.L2 | 1. Language used at home |
| Language Assessment (LAC) | LAC.L3 | 2. Primary used by Child at home |
| Language Assessment (LAC) | LAC.L5 | 3. Previous Home setting, if populated, otherwise, N/A |
| Language Assessment (LAC) | LAC.SNM or LAC.HCB | Survey Completed By Name. Prints the Online Enrollment signatory name (LAC.SNM), or LAC.HCB if there is no signatory name. Prints only when the survey is digitally signed. |
| Language Assessment (LAC) | LAC.HLD | Survey Completed Date |
The following is an example of the report printed in English for TX.
Language Assessment page.
The report printed in Spanish will display Spanish Version in the upper right corner.
Data Fields and Report Example for CA ↑
The form will contain data from the following fields:
| Table | Field | Description |
| District Name (LOC) | LOC.NM for Code = 0 | The title of the School District will display when printed from District |
| School Name (LOC) | LOC.NM | The title of the School will display when printed from School |
| Student Data (STU) | (ID) | Student ID number |
| Student Data (STU) | (BD) | Birthdate of Student (MM/DD/YYYY) |
| Student Data (STU) | (LN) | Surname/Family Name of Student |
| Student Data (STU) | (FN) | First Given Name of Student |
| Student Data (STU) | (MN) | Second Given Name of Student |
| Student Age | Calculated age based on birthdate and current day. | Age of Student |
| Student Grade (STU) | (GR) | Grade Level of Student |
| Language Assessment (LAC) | LAC.L1 | 1. First Began to Talk |
| Language Assessment (LAC) | LAC.L3 | 2. At Home |
| Language Assessment (LAC) | LAC.L2 | 3. Primary Language |
| Language Assessment (LAC) | LAC.L4 | 4. By Adults |
| Language Assessment (LAC) | LAC.SNM or LAC.HCB | Survey Completed By Name. Prints the Online Enrollment signatory name (LAC.SNM), or LAC.HCB if there is no signatory name. Prints only when the survey is digitally signed. |
| Language Assessment (LAC) | LAC.HLD | Survey Completed Date |
The following is an example of the report printed in English for CA.
Language Assessment page:
The CA version is also available in Spanish:
