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. |