S_TX_CENSUS_IMPORT_TOOL_S(ver 22.9.1)
This is a stand-alone table used by the Texas Student Census Block Import tool.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| Block_Group | 22.9.1 | Varchar2(1) | Block group for the student's Census Block code. |
| Census_Block | 22.9.1 | Varchar2(12) | The 12-digit census Census Block Group code. |
| City | 22.9.1 | Varchar2(50) | The city for the student's address. |
| Confidence | 22.9.1 | Double | The Confidence percent for the student's Census Block code. |
| CountyCode | 22.9.1 | Varchar2(3) | The County Code for the student's Census Block code. |
| Effective_Date | 22.9.1 | Date | The effective date for the record. |
| Import_File_Row_Number | 22.9.1 | Integer | The Import Row Number |
| Import_FileName | 22.9.1 | Varchar2(260) | The Import FIle name |
| Import_Status | 22.9.1 | Varchar2(50) | Status of the imported records |
| Latitude | 22.9.1 | Double | Latitude for the student's Census Block code. |
| Longitude | 22.9.1 | Double | Longitude for the for the student's Census Block code. |
| SchoolYear | 22.9.1 | Integer | SchoolYear to be selected |
| StateCode | 22.9.1 | Varchar2(2) | State Code for the student's Census Block code. |
| Street | 22.9.1 | Varchar2(60) | The first line of the student's address. |
| Street2 | 22.9.1 | Varchar2(60) | The second line of the student's address. |
| State | 22.9.1 | Varchar2(2) | The state for the student's address. |
| Student_Number | 22.9.1 | Integer | Student Number of imported student |
| Tract | 22.9.1 | Varchar2(6) | Tract for the student's Census Block Code. |
| Type | 22.9.1 | Varchar2(50) | Type for the student's Census Block Code |
| Zip | 22.9.1 | Varchar2(5) | The zip code for the student's address. |