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