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
-
First run the PowerSchool Student Census Block Export to generate a CSV file with student addresses. Several options for student selections are supported.
-
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.
-
-
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
|
Data Element |
Description |
[Table] Field Name |
Data Type |
|---|---|---|---|
|
Block Group |
Block group for the student's Census Block code. |
[S_TX_CENSUS_IMPORT_TOOL_S]Block_Group |
Varchar2(1) |
|
Census Block |
The 12-digit census Census Block Group code. |
[S_TX_CENSUS_IMPORT_TOOL_S]Census_Block |
Varchar2(12) |
|
City |
The city for the student's address. |
[S_TX_CENSUS_IMPORT_TOOL_S]City |
Varchar2(50) |
|
Confidence |
The Confidence percent for the student's Census Block code. |
[S_TX_CENSUS_IMPORT_TOOL_S]Confidence |
Double |
|
County Code |
The County Code for the student's Census Block code. |
[S_TX_CENSUS_IMPORT_TOOL_S]CountyCode |
Varchar2(3) |
|
Effective Date |
The effective date for the record. |
[S_TX_CENSUS_IMPORT_TOOL_S]Effective_Date |
Date |
|
Import File Row Number |
The Import Row Number |
[S_TX_CENSUS_IMPORT_TOOL_S]Import_File_Row_Number Internal field for record processing; not part of the student census block record. |
Integer |
|
Import FileName |
The Import FIle name |
[S_TX_CENSUS_IMPORT_TOOL_S]Import_FileName Internal field for record processing; not part of the student census block record. |
Varchar2(260) |
|
Import Status |
Status of the imported records |
[S_TX_CENSUS_IMPORT_TOOL_S]Import_Status Internal field for record processing; not part of the student census block record. |
Varchar2(50) |
|
Latitude |
Latitude for the student's Census Block code. |
[S_TX_CENSUS_IMPORT_TOOL_S]Latitude |
Double |
|
Longitude |
Longitude for the for the student's Census Block code. |
[S_TX_CENSUS_IMPORT_TOOL_S]Longitude |
Double |
|
SchoolYear |
SchoolYear to be selected |
[S_TX_CENSUS_IMPORT_TOOL_S]SchoolYear |
Integer |
|
StateCode |
State Code for the student's Census Block code. |
[S_TX_CENSUS_IMPORT_TOOL_S]StateCode |
Varchar2(2) |
|
Street |
The first line of the student's address. |
[S_TX_CENSUS_IMPORT_TOOL_S]Street |
Varchar2(60) |
|
Street2 |
The second line of the student's address. |
[S_TX_CENSUS_IMPORT_TOOL_S]Street2 |
Varchar2(60) |
|
State |
The state for the student's address. |
[S_TX_CENSUS_IMPORT_TOOL_S]State |
Varchar2(2) |
|
Student_Number |
Student Number of imported student |
[S_TX_CENSUS_IMPORT_TOOL_S]Student_Number |
Integer |
|
Tract |
Tract for the student's Census Block Code. |
[S_TX_CENSUS_IMPORT_TOOL_S]Tract |
Varchar2(6) |
|
Type |
Type for the student's Census Block Code |
[S_TX_CENSUS_IMPORT_TOOL_S]Type |
Varchar2(50) |
|
Zip |
The zip code for the student's address. |
[S_TX_CENSUS_IMPORT_TOOL_S]Zip |
Varchar2(5) |