CensusBlockGroupIdentifier |
Base Entity | CENSUS_INFORMATION |
Attribute Name | CensusBlockGroupIdentifier |
Logical Rolename | |
ColumnName | CensusBlockGroupIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | A single digit number which is the first digit of all the blocks which comprise the block group. A statistical subdivision of a census tract, a block group is the smallest geographic unit for which the Census Bureau tabulates sample data. Example: block g |
Note |
CensusBlockGroupIdentifier Logical Attribute Properties |
Logical Attribute Name | CensusBlockGroupIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
CensusBlockGroupIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CensusBlockGroupIdentifier Bound Attachments |
Name | Current Value |
CensusBlockGroupIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CensusBlockGroupIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockGroupIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockGroupIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockGroupIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockIdentifier |
Base Entity | CENSUS_INFORMATION |
Attribute Name | CensusBlockIdentifier |
Logical Rolename | |
ColumnName | CensusBlockIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | A four-digit number to identify a census block. A subdivision of a census tract, a block is the smallest geographic unit for which the Census Bureau tabulates 100-percent data. Many blocks correspond to individual city blocks bounded by streets, but block |
Note |
CensusBlockIdentifier Logical Attribute Properties |
Logical Attribute Name | CensusBlockIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
CensusBlockIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CensusBlockIdentifier Bound Attachments |
Name | Current Value |
CensusBlockIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CensusBlockIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusBlockIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractBaseIdentifier |
Base Entity | CENSUS_INFORMATION |
Attribute Name | CensusTractBaseIdentifier |
Logical Rolename | |
ColumnName | CensusTractBaseIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | A four-digit number used to identify a census tract. A census tract is a small, relatively permanent statistical subdivision of a county delineated by a local committee of census data users for the purpose of presenting data.Census tract numbers are alway |
Note |
CensusTractBaseIdentifier Logical Attribute Properties |
Logical Attribute Name | CensusTractBaseIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
CensusTractBaseIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CensusTractBaseIdentifier Bound Attachments |
Name | Current Value |
CensusTractBaseIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CensusTractBaseIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractBaseIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractBaseIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractBaseIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractIdentifier |
Base Entity | CENSUS_INFORMATION |
Attribute Name | CensusTractIdentifier |
Logical Rolename | |
ColumnName | CensusTractIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | Identifies census tract as defined by the U.S. Census Bureau where subject property is located. |
Note |
CensusTractIdentifier Logical Attribute Properties |
Logical Attribute Name | CensusTractIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
CensusTractIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CensusTractIdentifier Bound Attachments |
Name | Current Value |
CensusTractIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CensusTractIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractSuffixIdentifier |
Base Entity | CENSUS_INFORMATION |
Attribute Name | CensusTractSuffixIdentifier |
Logical Rolename | |
ColumnName | CensusTractSuffixIdentifier |
RoleName | |
Domain | MISMOIdentifier |
Definition | Census tract suffixes may range from 01 to 98. Many census tracts do not have a suffix; in such cases, the suffix field is either left blank or is zero-filled. The decimal point separating the four-digit basic tract number from the two-digit suffix is sho |
Note |
CensusTractSuffixIdentifier Logical Attribute Properties |
Logical Attribute Name | CensusTractSuffixIdentifier |
Datatype | VARCHAR(0) |
Nullable | NO |
CensusTractSuffixIdentifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CensusTractSuffixIdentifier Bound Attachments |
Name | Current Value |
CensusTractSuffixIdentifier User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
CensusTractSuffixIdentifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractSuffixIdentifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractSuffixIdentifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CensusTractSuffixIdentifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |