| FIPSCountryCode |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSCountryCode |
| Logical Rolename | |
| ColumnName | FIPSCountryCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | A unique two letter alpha code to identify each country. These Country codes are part of the Federal Information Processing Standards (FIPS), an official coding system developed by the National Institute of Standards and Technology (NIST, formerly the Na |
| Note |
| FIPSCountryCode Logical Attribute Properties |
| Logical Attribute Name | FIPSCountryCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSCountryCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSCountryCode Bound Attachments |
| Name | Current Value |
| FIPSCountryCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSCountryCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountryCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountryCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountryCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountyCode |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSCountyCode |
| Logical Rolename | |
| ColumnName | FIPSCountyCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | Code identifying the county. (Designator Code based on Federal Information Processing Standard Publication 6-4) |
| Note |
| FIPSCountyCode Logical Attribute Properties |
| Logical Attribute Name | FIPSCountyCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSCountyCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSCountyCode Bound Attachments |
| Name | Current Value |
| FIPSCountyCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSCountyCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountyCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountyCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountyCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionCode |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSCountySubdivisionCode |
| Logical Rolename | |
| ColumnName | FIPSCountySubdivisionCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | The Federal Information Processing Standards (FIPS) County Subdivision Code identifies all county subdivisions in the 50 states, District of Columbia and Puerto Rico. The Minor Civil Division (MCD) and Census County Division (CCD) are geocodes that are |
| Note |
| FIPSCountySubdivisionCode Logical Attribute Properties |
| Logical Attribute Name | FIPSCountySubdivisionCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSCountySubdivisionCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSCountySubdivisionCode Bound Attachments |
| Name | Current Value |
| FIPSCountySubdivisionCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSCountySubdivisionCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionName |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSCountySubdivisionName |
| Logical Rolename | |
| ColumnName | FIPSCountySubdivisionName |
| RoleName | |
| Domain | MISMOString |
| Definition | The formal name or description for a county subdivision that is referenced by the FIPS County Subdivision Code. For example, Jones Township. |
| Note |
| FIPSCountySubdivisionName Logical Attribute Properties |
| Logical Attribute Name | FIPSCountySubdivisionName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSCountySubdivisionName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSCountySubdivisionName Bound Attachments |
| Name | Current Value |
| FIPSCountySubdivisionName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSCountySubdivisionName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionType |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSCountySubdivisionType |
| Logical Rolename | |
| ColumnName | FIPSCountySubdivisionType |
| RoleName | |
| Domain | FIPSCountySubdivisionEnum |
| Definition | A legal or statistical division of a county recognized as part of the Federal Information Processing Standards (FIPS) 55 system. The two major types of county subdivisions are census county divisions and minor civil divisions. This information is used by the US Census Bureau. |
| Note |
| FIPSCountySubdivisionType Logical Attribute Properties |
| Logical Attribute Name | FIPSCountySubdivisionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FIPSCountySubdivisionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSCountySubdivisionType Reference Value (Bound to Domain) |
| Name | ValidationRule163 |
| Description | |
| Type | By List |
| Value | Value Description |
| CensusCountyDivision | A subdivision of a county that is a relatively permanent statistical area established cooperatively by the Census Bureau and state and local government authorities. Used for presenting decennial census statistics in those states that do not have well-defined and stable minor civil divisions that serve as local governments. |
| MinorCivilDivision | A primary governmental and/or administrative subdivision of a county, such as a township, precinct, or magisterial district. MCDs exist in 28 states and the District of Columbia. In 20 states, all or many MCDs are general-purpose governmental units: Connecticut, Illinois, Indiana, Kansas, Maine, Massachusetts, Michigan, Minnesota, Missouri, Nebraska, New Hampshire, New Jersey, New York, North Dakota, Ohio, Pennsylvania, Rhode Island, South Dakota, Vermont, and Wisconsin. Most of these MCDs are legally designated as towns or townships. |
| FIPSCountySubdivisionType Bound Attachments |
| Name | Current Value |
| FIPSCountySubdivisionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSCountySubdivisionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSCountySubdivisionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceCode |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSPlaceCode |
| Logical Rolename | |
| ColumnName | FIPSPlaceCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | A five-digit numeric code assigned by the National Institute of Standards and Technology (NIST), and maintained by the U.S. Geological Survey (USGS), to identify populated places, primary county divisions, and other locational entities within a State. Th |
| Note |
| FIPSPlaceCode Logical Attribute Properties |
| Logical Attribute Name | FIPSPlaceCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSPlaceCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSPlaceCode Bound Attachments |
| Name | Current Value |
| FIPSPlaceCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSPlaceCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceName |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSPlaceName |
| Logical Rolename | |
| ColumnName | FIPSPlaceName |
| RoleName | |
| Domain | MISMOString |
| Definition | The formal name of a statistical entity as defined by the by the National Institute of Standards and Technology (NIST), and maintained by the U.S. Geological Survey (USGS), that is referenced by the FIPS Place Code. Place includes Census Bureau designat |
| Note |
| FIPSPlaceName Logical Attribute Properties |
| Logical Attribute Name | FIPSPlaceName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSPlaceName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSPlaceName Bound Attachments |
| Name | Current Value |
| FIPSPlaceName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSPlaceName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSPlaceName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateAlphaCode |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSStateAlphaCode |
| Logical Rolename | |
| ColumnName | FIPSStateAlphaCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | A unique two letter alpha code to identify each State and State equivalent entity. These State codes are part of the Federal Information Processing Standards (FIPS), an official coding system developed by the National Institute of Standards and Technolog |
| Note |
| FIPSStateAlphaCode Logical Attribute Properties |
| Logical Attribute Name | FIPSStateAlphaCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSStateAlphaCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSStateAlphaCode Bound Attachments |
| Name | Current Value |
| FIPSStateAlphaCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSStateAlphaCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateAlphaCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateAlphaCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateAlphaCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateNumericCode |
| Base Entity | FIPS_INFORMATION |
| Attribute Name | FIPSStateNumericCode |
| Logical Rolename | |
| ColumnName | FIPSStateNumericCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | A unique two digit numeric code to identify each State and State equivalent entity. These State codes are part of the Federal Information Processing Standards (FIPS), an official coding system developed by the National Institute of Standards and Technolo |
| Note |
| FIPSStateNumericCode Logical Attribute Properties |
| Logical Attribute Name | FIPSStateNumericCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| FIPSStateNumericCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FIPSStateNumericCode Bound Attachments |
| Name | Current Value |
| FIPSStateNumericCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FIPSStateNumericCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateNumericCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateNumericCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FIPSStateNumericCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |