S_TX_STU_CENSUS_BLOCK_C (ver 19.8.2.0)
This table is a child of the Students table and holds records capturing the student's census block code based on the student's address.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 19.8.2.0 | Number(10,0) | Primary key. |
| StudentsDCID | 19.8.2.0 | Number(10,0) | The foreign key to link to the Students table. |
| Block_Group | 22.8.2.0 | Varchar2(1) | Block group for the student's Census Block code. |
| Census_Block | 19.8.2.0 | Varchar2(12) | The 12-digit census Census Block Group code. |
| Census_Block_Comment | 19.8.2.0 | Varchar2(4000) | Optional record comment. |
| City | 19.10.1.0 | Varchar2(50) | The city for the student's address. |
| Confidence | 22.8.2.0 | Double | The Confidence percent for the student's Census Block code. |
| CountyCode | 22.8.2.0 | Varchar2(3) | The County Code for the student's Census Block code. |
| Block_Group | 22.8.2.0 | Varchar2(1) | The Block group for the student's Census Block code. |
| Effective_Date | 19.8.2.0 | Date | The effective date for the record. |
| Funding_Weight | 21.1.2.0 | Number(1,4) | The funding weight for the student based on the assigned Tier (optional). |
| Latitude | 22.8.2.0 | Double | Latitude for the student's Census Block code. |
| Longitude | 22.8.2.0 | Double | Longitude for the for the student's Census Block code. |
| SES_Tier | 21.1.2.0 | Varchar2(7) | The socio-economic status tier assigned to the student based on the Census Block code (optional). |
| State | 19.10.1.0 | Varchar2(2) | The state for the student's address. |
| StateCode | 22.8.2.0 | Varchar2(2) | State Code for the student's Census Block code. |
| Street | 19.10.1.0 | Varchar2(60) | The first line of the student's address. |
| Street2 | 22.8.2 | Varchar2(60) | The second line of the student's address. |
| Tract | 22.8.2.0 | Varchar2(6) | Tract for the student's Census Block Code. |
| Type | 22.8.2.0 | Varchar2(50) | Type for the student's Census Block Code |
| Zip | 19.10.1.0 | Varchar2(5) | The zip code for the student's address. |