Skip to main content
Skip table of contents

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:

  1. On the Start Page, click Reports. The Reports page appears.
  2. Click the State tab. The State Reports page appears.
  3. Click Early Childhood. The Report Using Engine page appears.
  4. Enter information in all of the required fields.
  5. 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:

  • Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
  • Current School Only – Includes all records associated with the current school that meet the selection criteria.
  • District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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:

  • The selected x students only – Run the report for students in the current selection.
  • All Students (default) – Run the report for all students in the current school or district that meet the selection criteria.

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:

  • Browser – Open the report results within the internet browser.
  • Save as Local File (default) – Save the report results as a file on your hard drive.

Processing Options

Choose a time to run the report from the pop-up menu:

  • Execute Now – Execute the report immediately.
  • In Background Now (Recommended) – Execute the report immediately in the background.
  • ASAP – Execute the report in the order it is received in the Report Queue.
  • At Night – Execute the report during the next evening.
  • On Weekend – Execute the report during the next weekend.
  • On Specific Time – Execute the report on the date and time specified.

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:

  • 023 Early Childhood Participation
  • 024 Early Childhood Assessments

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:

  • PreSchool Program Type (023 records)
    • 1 – Early Childhood Block Grant
    • 2 – State Family Literacy
    • 3 – Title I Even Start
    • 4 – Migrant Education Even Start
    • 5 – Title I Preschool
    • 6 – Tuition-Based Preschool or Early Childhood
    • 7 – Other Preschool or Early Childhood Program
  • Assessment Code (024 records)
    • Work Sampling
    • Creative Curriculum
    • Child Observation Record (COR)
    • Galileo Plus
    • Peabody Picture Vocabulary Test-III (PPVT-III)
    • Phonological Awareness Literacy Screening Pre-K (PALS Pre-K)

[VirtualTablesData]user_defined_text

Date1

This field contains one of the following values:

  • The date the student entered the early childhood program for the given fiscal year (023 records).
  • The date of the early childhood assessment (024 records).

[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:

  • The CTDS number of the school where the program is provided (023 records).
  • The Responsible District or Charter Holder CTD Number (024 records).

[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:

  • Mother
  • Father
  • Both
  • Neither

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

JavaScript errors detected

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

If this problem persists, please contact our support.