Census Block Import Tool

On this page:

Introduction

The Student Census Block Import Tool eliminates the need for manual imports and automatically creates records for the PEIMS Fall Submission in the PowerSchool Student Census Block table. The source file is the Student Census Block output CSV file that is generated by the TEA Census Block Group Tool. Follow these instructions to first generate an export file, upload it to the TEA Census Block tool, and then import the resulting census block records into PowerSchool.

Steps

1. First run the PowerSchool Student Census Block Export to generate a CSV file with student addresses. Several options for student selections are supported.

2. Download the TEA Census Block Group Tool from the TSDS website and open the application.

   • Use the File Upload option to select the PowerSchool export file.

   • Click the Process File button.

   • Click the output file hyperlink to download and save the resulting TEA output file.

3. Run the PowerSchool Student Census Block Import Tool to automatically import these records into the PowerSchool Student Census Block table.

   • Select the current School Year and click the Submit button.

   • In the Report Queue, download the confirmation CSV file.

   • This file lists the number of records successfully imported. Any errors due to non-matching Student Numbers are listed. In the case where an invalid file with missing census block records was selected, these errors are also listed.

   • In the imported records, the Effective Date is automatically populated as the PEIMS Fall Snapshot Date for the current year. The Comment field provides the date/time stamp of the record creation or update.

   • If a record already exists with the current year Fall Snapshot date, that record is updated; otherwise, a new record is added.

   • Records can be viewed in State/Province – TX,  Student Census Block Codes.

PowerSchool Student Census Block Table