Early Childhood Export
Use this report to export early childhood related data by school/district for a selected school year.
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 and a virtual table based on the following criteria:
- The student must be enrolled in the school during the school year selected at report runtime.
- The student must have a 023 Early Childhood Participation or 024 Early Childhood Assessment record during the school year selected at report runtime.
Report Input
To generate the Early Childhood Export report, do the following:
- On the Start Page, click Reports. The Reports page appears.
- Click the State tab. The State Reports page appears.
- Click Early Childhood. The Report Using Engine page appears.
- Enter information in all of the required fields.
- Click Submit to generate the report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
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 | Choose one of the following from the pop-up menu:
Note: If running the report for a single student, or group of students, select the students prior to runningreport. |
Destination | Choose one of the following from the pop-up menu:
|
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05. |
Data to be Filled | Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All. |
Select District | If this option is displayed, select a District from the pop-up menu. |
School Yearterm | Choose the school year from the pop-up menu. |
Include Student Demographic Detail | Select the checkbox to include student demographic data in the extract, including date of birth, gender, and ethnicity. |
Check to include 023 Early Childhood Participation | Select the checkbox to include 023 Early Childhood Participation records in the extract. |
Restrict 023 by this program codes | Enter program code(s), comma-separated (without spaces), to limit the type of 023 Early Childhood Participation records included in the extract. |
Check to include 024 Early Childhood Assessments | Select the checkbox to include 024 Early Childhood Assessment records in the extract. |
Restrict 024 to this assessment code(s) | Enterassessmentcode(s), comma-separated (without spaces), to limit the type of 024 Early Childhood Assessment records included in the extract. |
Report Output
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 |
Record Type Code | The type of transaction. Valid values:
| N/A |
SAIS Student Number | The student’s SAIS ID. | [Students]State_StudentNumber |
Student Number | The student’s locally assigned identifier. | [Students]Student_Number |
Last Name | The student’s last name. | [Students]Last_Name |
First Name | The student’s first name. | [Students]First_Name |
DOB | The student’s date of birth. Note: This field is included in the extract if the checkbox for “Include Student Demographic Detail” is selected at report runtime. | [Students]DOB |
Gender | The student’s gender. Note: This field is included in the extract if the checkbox for “Include Student Demographic Detail” is selected at report runtime. | [Students]Gender |
Ethnicity | The student’s ethnicity. Note: This field is included in the extract if the checkbox for “Include Student Demographic Detail” is selected at report runtime. | [Students]Ethnicity |
Program/Assessment Code | This field contains one of the following values:
| [VirtualTablesData]user_defined_text |
Date1 | This field contains one of the following values:
| [VirtualTablesData]user_defined_date |
Date2 | The date the student exited the early childhood program for the given fiscal year (023 records only). Note: This field is not required. | [VirtualTablesData]user_defined_date2 |
Entity/Partner ID | This field contains one of the following values:
| [VirtualTablesData]user_defined_text2 |
Family Income Indicator | Indicates whether the student’s family is at or below the poverty level (023 records). Note: This field is required for the Title I Even Start program and State Family Literacy program. | [VirtualTablesData]AZ_FamilyIncomeIndicator |
Living in Household Indicator | Indicates which parents live in the student’s household (023 records). Valid values:
Note: This field is required for the Early Childhood Block Grant program. | [VirtualTablesData]AZ_LivingInHouseholdIndicator |
Mother Employment Status | The employment status of the student’s mother (023 records). Note: This field is required if the Living in Household Indicator is Mother or Both. | [VirtualTablesData]AZ_MotherEmploymentStatus |
Father Employment Status | The employment status of the student’s father (023 records). Note: This field is required if the Living in Household Indicator is Father or Both. | [VirtualTablesData]AZ_FatherEmploymentStatus |
Test Score 1 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore1 |
Test Score 2 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore2 |
Test Score 3 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore3 |
Test Score 4 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore4 |
Test Score 5 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore5 |
Test Score 6 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore6 |
Test Score 7 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore7 |
Test Score 8 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore8 |
Test Score 9 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore9 |
Test Score 10 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore10 |
Test Score 11 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore11 |
Test Score 12 | The student’s assessment test score (024 records). | [VirtualTablesData]AZ_TestScore12 |