Sheet 1: DD_HDS_METADATA_VX

	
	
	
	
	
	
	
	
	
	
	
	
	

		
Attribute Name
		
Physical Column Name
		
User Friendly Names
		
Definition
		
Data Restriction
		
Organization
		
Update Frequency
		
Data Type
		
Business Rule / Format
		
HDW Transformation
		
Valid Values
		
Definition Update Date
	
	

		
Geocoding Artifact Object Identification Number
		
OBJECTID
		
Geocoding Artifact Object Identification Number; Object ID; Object Identification Number; Spatial Object Identification Number
		
This attribute represents the table unique, internal feature (record) number as required by ArcGIS. There is no requirement or expectation that a given feature has a “persistent” Object Identification Number value from one table (feature class) to the next as long as the Object Identification Number value is unique in a given spatial table.
		
Public
		
HRSA Data Warehouse
		
As Required
		
int
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are integers. For example, 1; 21; or 3487. Cannot be NULL.
		
2020/08/15
	
	

		
Congressional District Name
		
CONG_DIST_NM
		
Congressional District Name; Cong. District; Congressional District
		
This attribute represents the name of the U.S. Congressional District.
		
Public
		
U.S. House of Representatives
		
As Required
		
varchar(50)
		
None.
		
(1) For states with two or more representatives in the U.S. House of Representatives, the Congressional District Name is created by concatenating the state name, the word "District", and the applicable Congressional District number. (2) For states with a single representative in the U.S. House of Representatives, the Congressional District Name is created by concatenating the state name and the words "At Large". (3) For the District of Columbia where there is special representation in the U.S. House of Representatives, the Congressional District Name is "District of Columbia Delegate". (4) For the U.S. territories where there is special representation in the U.S. House of Representatives, the Congressional District Name is created by concatenating the territory name and either the words "Delegate" or "Resident Commissioner" as appropriate. (5) For the territories where there is no representation in the U.S. House of Representatives the Congressional District Name is only the text "(No Congressional Representation)". (6) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings for Congressional District names. For example, Alabama District 03. Can be NULL.
		
2016/05/27
	
	

		
Geocoding Artifact Feature Geometry
		
SHAPE
		
Geocoding Artifact Feature Geometry; Feature Geometry
		
This attribute represents the geometry of the geographic feature.
		
Public
		
HRSA Data Warehouse
		
As Required
		
geometry
		
None.
		
(1) If the data provided from the original source is in a projection other than the World Geodetic System 1984 (WGS84) coordinate system it is converted to this system, or Web Mercator Auxiliary Sphere as necessary. (2) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are geometry type values. For example, 0xE6100000010C2C6F0ED76A4254C0300C0597C7004140. Cannot be NULL.
		
2018/08/30
	
	

		
State FIPS Code
		
STATE_FIPS_CD
		
State FIPS Code; State Federal Information Processing Standard Code; State FIPS
		
This attribute represents the State Federal Information Processing Standard (FIPS) code identifying the two numeric character string assigned by the National Institute of Standards and Technology (NIST) to states, the District of Columbia, and U.S. territories.
		
Public
		
National Institute of Standards and Technology (NIST)
		
As Required
		
char(2)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are two character numeric text strings representing the state or territory. The valid values are: XX; 01; 02; 04; 05; 06; 08; 09; 10; 11; 12; 13; 15; 16; 17; 18; 19; 20; 21; 22; 23; 24; 25; 26; 27; 28; 29; 30; 31; 32; 33; 34; 35; 36; 37; 38; 39; 40; 41; 42; 44; 45; 46; 47; 48; 49; 50; 51; 53; 54; 55; 56; 60; 64; 66; 68; 69; 72; 70; 74; and 78. Cannot be NULL.
		
2020/08/15
	
	

		
State Name
		
STATE_NM
		
State Name; Component State; Component State Name; Site State; State; State Label; State/Territory
		
This attribute represents the state or territory name.
		
Public
		
National Institute of Standards and Technology (NIST)
		
As Required
		
varchar(50)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are alphabetic text strings representing the name of the state or territory. The valid values are: Foreign Country; Not Available; Alabama; Alaska; American Samoa; Arizona; Arkansas; California; Colorado; Connecticut; Delaware; District of Columbia; Federated States of Micronesia; Florida; Georgia; Guam; Hawaii; Idaho; Illinois; Indiana; Iowa; Kansas; Kentucky; Louisiana; Maine; Marshall Islands; Maryland; Massachusetts; Michigan; Minnesota; Mississippi; Missouri; Montana; Nebraska; Nevada; New Hampshire; New Jersey; New Mexico; New York; North Carolina; North Dakota; Northern Mariana Islands; Ohio; Oklahoma; Oregon; Pennsylvania; Puerto Rico; Republic of Palau; Rhode Island; South Carolina; South Dakota; Tennessee; Texas; U.S. Minor Islands; U.S. Virgin Islands; Utah; Vermont; Virginia; Washington; West Virginia; Wisconsin; and Wyoming. Can be NULL.
		
2020/08/15
	
	

		
HHS Region Number
		
REGION_ROMAN_NUMERAL
		
HHS Region Number; Region; Region Number
		
This attribute represents the Roman numeral portion of the U.S. Department of Health and Human Services (DHHS) Region Name associated with the entity.
		
Public
		
U.S. Department of Health and Human Services (HHS)
		
As Required
		
varchar(4)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are numeric strings consisting of one or two digits. The valid values are: 1; 2; 3; 4; 5; 6; 7; 8; 9; and 10. Can be NULL.
		
2016/05/27
	
	

		
U.S. Congressional Representative Name
		
REPRESENTATIVE_NM
		
U.S. Congressional Representative Name; Congressional District Representative Name; Congressional Representative; Congressional Representative Name; Representative Name
		
This attribute represents the name of the Congressional Representative for the Congressional District associated with the entity.
		
Public
		
U.S. House of Representatives
		
Monthly
		
varchar(100)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings containing the name of the person and the format is First Name Middle Name Last Name, Suffix. For example, John Jacob Jingleheimer-Schmidt, III; Jane Q. Public; Mariel Hamm; or George Edward Pope. Can be NULL.
		
2016/05/27
	
	

		
U.S. Senator Name (2)
		
US_SENATE_NM2
		
U.S. Senator Name (2); Name of U.S. Senator; Name of U.S. Senator Number Two; Senator Name (2 of 2); Senator Name (2); Senator Name(2); U.S. Senate Name (2); U.S. Senator
		
This attribute represents the name of one of the two United States Senators for the state associated with the entity.
		
Public
		
U.S. Senate
		
Monthly
		
varchar(100)
		
The District of Columbia and the U.S. territories and possessions do not have members in the U.S. Senate.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings containing the name of the person and the format is First Name Middle Name Last Name, Suffix. For example, John Jacob Jingleheimer-Schmidt, III; Jane Q. Public; Mariel Hamm; or George Edward Pope. The District of Columbia and the U.S. territories and possessions do not have members in the U.S. Senate. Can be NULL.
		
2018/03/16
	
	

		
Data Warehouse Record Create Date
		
DW_RECORD_CREATE_DT
		
Data Warehouse Record Create Date; Data As-of-Date; DW Record Create Date; HDW Process Date; HRSA Data Warehouse Processing Date; SNAP; Snapshot; Snapshot Date
		
This attribute represents the date on which the data was processed by the HRSA Data Warehouse.
		
Public
		
HRSA Data Warehouse
		
As Required
		
datetime2
		
None.
		
(1) System date on which the data set was refreshed. (2) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are date time where the time is the midnight or the zero hour. For example, 2013-10-15 00:00:00.000. Cannot be NULL.
		
2021/07/29
	
	

		
Geocoding Artifact Feature City
		
CITY
		
Geocoding Artifact Feature City; Geocoding Artifact City; Healthy Start Performance Measure City Synonym; HPSA City; HPSA_CITY; UDS Grantee City; Uniform Data System City
		
This attribute represents the city name, as expressed in the source data at the time of the most recent data refresh date, after address standardization. No verification is made to determine that the output city name data is the proper city name for the entity.
		
Public
		
HRSA Data Warehouse
		
As Required
		
nvarchar(100)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse adress standardization process.
		
Expected values are text strings containing data that represents a city name. For example, Rockville or Springfield. Can be NULL.
		
2019/12/26
	
	

		
County or County Equivalent Federal Information Processing Standard Code
		
COUNTY_FIPS_CD
		
County or County Equivalent Federal Information Processing Standard Code; County FIPS; County FIPS Code; CountyFIPS
		
This attribute represents the numeric character string assigned by the National Institute of Standards and Technology to the counties and/or county equivalents for the states, the District of Columbia, and U.S. territories.
		
Public
		
National Institute of Standards and Technology (NIST); HRSA, Bureau of Health Workforce (BHW), Division of Policy and Shortage Designation (DPSD)
		
As Required
		
char(3)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time. The Federal Information Processing Standards (FIPS) code for county and county equivalent entities are unique to the U.S. state or U.S. territory to which it is associated.
		
Expected values are numeric text strings, exactly three digits in length. For example, 010. Can be NULL.
		
2020/08/15
	
	

		
County Equivalent Name
		
COUNTY_NM
		
County Equivalent Name; Component County Name; County; County (Component); County Equivalent; County Name; County or County Equivalent; County or County Equivalent Name; County, County Equivalent; Grantee County Name
		
This attribute represents the name of the county or county equivalent in which the associated address is located, displayed as a text string.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(50)
		
None.
		
(1) For the HRSA Data Warehouse locator tools this attribute is computed on demand and is associated with the spatial feature (to include being assigned no value). (2) For geographic Shortage Areas (i.e., Health Professional Shortage Areas (HPSA), Medically Underserved Areas (MUA), and Medically Underserved Populations (MUP)) which are defined on deleted (non-current or historical) U.S. Census geographical areas this value represents the best matching current county geographical area.
		
Expected values are alphabetic text strings for county names. For example, Not Determined; Arthur; Prince William; Tinian; Western; Winchester City; Winn; Wotje; Yakutat; Yap; Yauco; or Yukon-Koyukuk. Can be NULL.
		
2021/01/07
	
	

		
State FIPS and Congressional District Number Code
		
STATE_FIPS_CD_CONG_DIST_NUM
		
State FIPS and Congressional District Number Code; State Federal Information Processing Standard Code and Congressional District Number Code; State FIPS and Congressional District Number; State FIPS Code and Congressional District Number; State FIPS Code Congressional District Number
		
This attribute represents the concatenation of the State Federal Information Processing Standard (FIPS) and Congressional District Number Code in which the entity is located.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(4)
		
None.
		
(1) Concatenation of the State Federal Information Processing Standard (FIPS) code and the two digit Congressional District Number (could be characterized as a code). (2) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are four digit numeric text strings with leading zeros. For example, 0643. Cannot be NULL.
		
2016/05/27
	
	

		
U.S. - Mexico Border 100 Kilometer Indicator
		
US_MEXICO_BORDER_100KM_IND
		
U.S. - Mexico Border 100 Kilometer Indicator; La Paz Agreement; Primary Care Service Area U.S. - Mexico Border Indicator; U.S. - Mexico Border 100 Kilometer Status Indicator
		
This attribute represents the indication of whether any portion of the geographic entity cited is within 100 kilometers of the U.S. - Mexico border. The HRSA Data Warehouse generates this value by performing a geoprocessing analysis against the 100 kilometer U.S. - Mexico border region as defined by the HRSA Office of Rural Health Policy, Border Health Program.
		
Public
		
HRSA Data Warehouse
		
As Required
		
nvarchar(2)
		
None.
		
This value is determined by geospatial analysis, if the entity location (U.S. entity) is determined to be within 100 Kilometers of the U.S. - Mexico border then Y (Yes), otherwise N (No). If the entity location cannot be determined then N (No).
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2020/08/15
	
	

		
HHS Region Name
		
REGION_NM
		
HHS Region Name; Component HHS Region; HHS Region; Region Name; Site HHS Region
		
This attribute represents the formal name for the U.S. Department of Health and Human Services (HHS) Region associated with the entity location or address.
		
Public
		
U.S. Department of Health and Human Services (HHS)
		
As Required
		
varchar(50)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are alphanumeric, proper case, text strings formatted as “Region ##” where the ## is a valid integer (1 through 10). The valid values are: Region 1; Region 2; Region 3; Region 4; Region 5; Region 6; Region 7; Region 8; Region 9; and Region 10. Can be NULL.
		
2020/08/15
	
	

		
State and County Federal Information Processing Standard Code
		
STATE_COUNTY_FIPS_CD
		
State and County Federal Information Processing Standard Code; State and County FIPS Code; State County FIPS Code
		
This attribute represents the concatenation (combination) of the Federal Information Processing Standard (FIPS) state and county codes.
		
Public
		
HRSA Data Warehouse
		
As Required
		
nvarchar(10)
		
None.
		
(1) Concatenation of the state Federal Information Processing Standard (FIPS) code and the county FIPS code. (2) For HRSA, Federal Office of Rural Health Policy (FORHP) Rural Areas there are no transformations to the input data. (3) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are numeric text strings strictly five digits in length. For example, 01001. Cannot be NULL.
		
2020/09/24
	
	

		
County Description
		
COUNTY_DESC
		
County Description
		
This attribute represents the type of county or county equivalent (as listed in Federal Information Processing Standard (FIPS) Pub 6-4 documentation) for a county identified by a state and county FIPS code.
		
Public
		
National Institute of Standards and Technology (NIST)
		
As Required
		
varchar(50)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are character text strings. The valid values are: Borough; Census Area; City; County; District; Island; Municipality; Municipio; Not Determined; Parish; and State. Can be NULL.
		
2020/08/15
	
	

		
HHS Region Code
		
REGION_CD
		
HHS Region Code; Region Code
		
This attribute represents the U.S. Department of Health and Human Services (HHS) Region code.
		
Public
		
U.S. Department of Health and Human Services (HHS)
		
As Required
		
char(2)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are two character numeric text strings representing the region. The valid values are: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10. Can be NULL.
		
2020/08/15
	
	

		
Congress Number Text
		
CONG_NUM
		
Congress Number Text; Congress Number
		
This attribute represents the textual expression of the sequential number used to identify a specific session of Congress.
		
Public
		
U.S. House of Representatives
		
Bi-annual
		
char(3)
		
A new Congress begins at noon January 3 of each odd-numbered year following a general election, unless it designates a different day by law. A Congress lasts for two years, with each year constituting a separate session.
		
This attribute is a common element which may be used in multiple data marts and will be a snapshot of the current state of the data on which the data for any data mart is refreshed. Each data mart refresh is a snapshot in time and the HRSA Data Warehouse will not change historical data.
		
Expected values are integers less than or equal to the number associated with the currently seated Congress. For example, 106; 109; 110; or 113. Cannot be NULL.
		
2018/03/16
	
	

		
Congressional District Number
		
CONG_DIST_NUM
		
Congressional District Number; Congressional District
		
This attribute represents the two (2) character numeric depiction of the Congressional District (if any) in a state or territory in which a geographic feature is located.
		
Public
		
HRSA Data Warehouse
		
As Required
		
char(2)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are two character numeric text strings. For States with more than one Congressional District, the value starts at 01 and increments by 1 for each additional Congressional District in the State. States that comprise only a single (voting) Congressional District have the value 00. Non-voting Districts (such as those in the District of Columbia and some U.S. Territories) have the value 98. Territories that do not have representation have the value 99. Can be NULL.
		
2016/05/27
	
	

		
State Abbreviation
		
STATE_ABBR
		
State Abbreviation; State; State Code; State_Cd
		
This attribute represents the U.S. Postal Service (USPS) two alphabetic character code for a U.S. state or U.S. territory associated with a location where an entity is situated.
		
Public
		
HRSA Data Warehouse
		
As Required
		
char(2)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are two character alphabetic text strings representing the state. The valid values are: XX; AK; AL; AR; AS; AZ; CA; CO; CT; DC; DE; FL; FM; GA; GU; HI; IA; ID; IL; IN; KS; KY; LA; MA; MD; ME; MH; MI; MN; MO; MP; MS; MT; NC; ND; NE; NH; NJ; NM; NV; NY; OH; OK; OR; PA; PR; PW; RI; SC; SD; TN; TX; UM; UT; VA; VI; VT; WA; WI; WV; and WY. Can be NULL.
		
2020/08/15
	
	

		
U.S. - Mexico Border County Indicator
		
US_MEXICO_BORDER_COUNTY_IND
		
U.S. - Mexico Border County Indicator; Primary Care Service Area U.S. - Mexico Border County Indicator
		
This attribute represents the indication of whether a county or a part of a county is listed in U.S. counties that the U.S. - Mexico Border Health Commission has defined as comprising the Border Health Initiative zone. For counties in the contiguous U.S., this data element may differ from the value of the U.S. - Mexico Border 100 Kilometer Indicator due to the fact that three counties in Arizona fall partially within the defined 100-kilometer boundary area, but are not listed in the list of counties that the U.S. - Mexico Border Health Commission identified as comprising the zone of interest.
		
Public
		
HHS, Office of Global Affairs (OGA), U.S.-Mexico Border Health Commission
		
As Required
		
char(1)
		
None.
		
(1) For the HRSA Data Warehouse County Dimension table the value is Y (Yes) for those counties in the list of counties identified by the U.S. - Mexico Border Health Commission, otherwise the value is N (No). (2) For data sets this value is determined by geospatial analysis, if the entity location (U.S. entity) is determined to be within a U.S. - Mexico Border Health Commission identified county then Y (Yes), otherwise N (No). If the entity location cannot be determined then N (No).
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2020/08/15
	
	

		
Street Address
		
ADDRESS
		
Street Address; Geocoding Artifact Address; Healthy Start Performance Measure Address Synonym; HPSA Facility Address
		
This attribute represents the standardized version of the street address (includes building number, street, and suite) for the specified entity identified in the source data system.
		
Public
		
HRSA Data Warehouse
		
Daily
		
nvarchar(200)
		
None.
		
(1) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time. (2) Changed, as necessary, as part of the HRSA Data Warehouse address standardization process. (3) No validation steps are performed to determine that the address data output by the data standardization process is the proper address data for the entity. (4) If associated with a Health Center Service Delivery Site where the address requires address suppression, then the value is assigned to NULL. (5) The Health Professional Shortage Area (HPSA) Street Address (only for facilities) is the result of taking the primary mailing address, as represented in the incoming HPSA data at the time of the most recent data refresh date, and standardizing the street address information.
		
Expected values are text strings with the building numbers, street names, and possibly suite numbers (with dashes, parenthesis, or other punctuation) formatted in mixed case. For example, "665 Opelika Rd Ste 100". Can be NULL.
		
2019/12/26
	
	

		
Complete County Name
		
LIST_BOX_COUNTY_NM
		
Complete County Name; County; County Name; County, County Name; List Box County Name
		
This attribute represents the proper county name associated with a specified data element.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(100)
		
None.
		
(1) This attribute is formulated by concatenating the County Dimension table element County Name with County Dimension table element County Description and processed to remove sequential duplicated words. (2) For geographic Shortage Areas (i.e., Health Professional Shortage Areas (HPSA), Medically Underserved Areas (MUA), and Medically Underserved Populations (MUP)) which are defined on deleted (non-current or historical) U.S. Census geographical areas this value represents the best matching current county geographical area.
		
Expected values are alphabetic text strings for the proper county name. For example, Not Determined; Arthur; Hawaii County; Prince William County; Tinian Municipality; Western District; Winchester City; Winn Parish; Wotje; Yakutat Borough; Yap State; Yauco Municipio; or Yukon-Koyukuk Census Area. Can be NULL.
		
2021/01/07
	
	

		
Uniform Resource Locator (URL)
		
URL_TXT
		
Uniform Resource Locator (URL); U.S. House of Representatives Member Uniform Resource Locator; U.S. House of Representatives Member Website; Webpage Address; Website
		
This attribute represents the World Wide Web Uniform Resource Locator (URL) which is the web address for the website associated with the entity.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(250)
		
None.
		
(1) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time. (2) Within the HDW this attribute is the website for each current member of the U.S. House of Representatives at the time of the data refresh; however, for the HRSA Data Warehouse locator tools this attribute is computed on demand and is associated with the spatial feature.
		
Expected values are alphanumeric text strings which include special and punctuation characters for web sites. For example, http://en.wikipedia.org/wiki/Uniform_resource_locator. Can be NULL.
		
2017/04/08
	
	

		
U.S. Senator Name (1)
		
US_SENATE_NM1
		
U.S. Senator Name (1); Name of U.S. Senator; Name of U.S. Senator Number One; Senator Name (1 of 2); Senator Name (1); Senator Name(1); U.S. Senate Name (1); U.S. Senator
		
This attribute represents the name of one of the two United States Senators for the state associated with the entity.
		
Public
		
U.S. Senate
		
Monthly
		
varchar(100)
		
The District of Columbia and the U.S. territories and possessions do not have members in the U.S. Senate.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings containing the name of the person and the format is First Name Middle Name Last Name, Suffix. For example, John Jacob Jingleheimer-Schmidt, III; Jane Q. Public; Mariel Hamm; or George Edward Pope. The District of Columbia and the U.S. territories and possessions do not have members in the U.S. Senate. Can be NULL.
		
2018/03/16
	
	

		
U.S. Representative Party Code
		
REPRESENTATIVE_PARTY_CD
		
U.S. Representative Party Code; Representative Party; Representative Party Code
		
This attribute represents the alphabetic code identifying the political party to which a member of the U.S. House of Representatives is associated.
		
Public
		
U.S. House of Representatives
		
As Required
		
varchar(10)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are single letter text strings. The valid values are: D (Democratic); R (Republican); or I (Independent). Can be NULL.
		
2016/05/27
	
	

		
Geocoding Artifact Feature State Abbreviation
		
STATE
		
Geocoding Artifact Feature State Abbreviation; Healthy Start Performance Measure State Synonym; State Abbreviation; UDS Mapper Spatial Artifact State Abbreviation; Uniform Data System Web Report State
		
This attribute represents the U.S. Postal Service (USPS) U.S. state or territory postal code (also referred to as the abbreviation) in which the entity is located.
		
Public
		
HRSA, Bureau of Primary Health Care (BPHC), Office of Policy and Program Development (OPPD)
		
As Required
		
nvarchar(4)
		
(1) The state code must be a valid U.S. Postal Service (USPS) state code (the two character abbreviation for the U.S. state or U.S. territory). (2) The two character values are always capitalized. (3) The HRSA Grants data, HPSA data, and NHSC data determine the state and county for an address by a geospatial analysis performed on the address data.
		
None.
		
Expected values are two character alphabetic text strings representing the state. The valid values are: XX; AK; AL; AR; AS; AZ; CA; CO; CT; DC; DE; FL; FM; GA; GU; HI; IA; ID; IL; IN; KS; KY; LA; MA; MD; ME; MH; MI; MN; MO; MP; MS; MT; NC; ND; NE; NH; NJ; NM; NV; NY; OH; OK; OR; PA; PR; PW; RI; SC; SD; TN; TX; UM; UT; VA; VI; VT; WA; WI; WV; and WY. Cannot be NULL.
		
2021/09/02
	
	

		
U.S. Congress End Date
		
END_DT
		
U.S. Congress End Date; Congress End Date; End Date; Term of the Congress Expiration Date
		
This attribute represents the date on which the specific Term of the Congress is expired.
		
Public
		
HRSA Data Warehouse
		
Bi-annual
		
datetime
		
The term of a Congress is two years. The annual series of meetings of a Congress is called a session. Each Congress generally has two sessions, based on the constitutional mandate that Congress assemble at least once a year.
		
(1) A NULL value represents a record associated with the current Congress. (2) This attribute is a common element which may be used in multiple data marts and will be a snapshot of the current state of the data on which the data for any data mart is refreshed. Each data mart refresh is a snapshot in time and the HRSA Data Warehouse will not change historical data. A new Congress begins at noon January 3 of each odd-numbered year following a general election, unless it designates a different day by law. A Congress lasts for two years, with each year constituting a separate session.
		
Expected values are date time where the time is the midnight or the zero hour. For example, 2017-01-03 00:00:00.000. Can be NULL.
		
2017/12/08
	
	

		
U.S. Congressional Representative Title
		
REPRESENTATIVE_TITLE
		
U.S. Congressional Representative Title; Representative Title
		
This attribute represents the title given to the member of the U.S. House of Representatives representing the district in which the entity is located.
		
Public
		
U.S. House of Representatives
		
As Required
		
varchar(50)
		
None.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings for representative titles. The valid values are: Representative (only for members from U.S. States); Delegate (members from District of Columbia, American Samoa, Guam, Northern Mariana Islands, and U.S. Virgin Islands); Resident Commissioner (member from Puerto Rico); or NULL (no members from Republic of Palau and U.S. Minor Islands). Can be NULL.
		
2016/05/27
	
	

		
Data Warehouse Record Create Date Text
		
DW_RECORD_CREATE_DT_TXT
		
Data Warehouse Record Create Date Text; DW Record Create Date Text; HDW Process Date Text; HDW Processing Date; HRSA Data Warehouse Processing Date; SNAP; Snapshot Date; Snapshot Date String; Snapshot Date Text
		
This attribute represents the date on which the data was processed by the HRSA Data Warehouse.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(25)
		
None.
		
(1) System date on which the data set was refreshed converted to a character string formatted as yyyy/mm/dd (four digit year slash two digit month slash two digit day). (2) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings representing a date value in the format yyyy/mm/dd. For example, 2014/01/10 or 2013/09/17. Cannot be NULL.
		
2021/07/29
	
	

		
Geocoding Artifact Location Name
		
LOC_NAME
		
Geocoding Artifact Location Name; Location Name
		
This attribute represents the name of the component locator used to return a particular match result during geocoding. This value is a geocoding artifact returned for geoprocessed street address results.
		
Public
		
Esri
		
As Required
		
nvarchar(28)
		
This Geocoding Artifact Location Name is used internally by ArcGIS software and is not intended for use by client applications. For further information about Esri ArcGIS Resources and the ArcGIS REST API refer to the http://resources.arcgis.com/en/help/arcgis-rest-api/index.html#//02r300000017000000 website.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are text strings. The valid values are: SMP_CityState; SMP_Zip; SMP_StAddr; SMP_AddrPt; SMP_ZipPlus4; SMP_StName; USGS_PopPL; and the empty string. Can be NULL.
		
2018/03/16
	
	

		
Geocoding Artifact Address Primary X Coordinate
		
X
		
Geocoding Artifact Address Primary X Coordinate; Address Primary X Coordinate; Longitude; Organ Transplantation Center Longitude; SiteLon; X Coordinate
		
This attribute represents the primary longitude in decimal degrees (x coordinate) of an entity based on its address.
		
Public
		
Esri
		
As Required
		
numeric(38,8)
		
For further information about Esri ArcGIS Resources and the ArcGIS REST API refer to the http://resources.arcgis.com/en/help/arcgis-rest-api/index.html#//02r300000017000000 website.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are negative numbers with eight decimals of precision. For example, -178.30602700 or -66.94988200. Can be NULL.
		
2018/03/16
	
	

		
Geocoding Artifact Address Primary Y Coordinate
		
Y
		
Geocoding Artifact Address Primary Y Coordinate; Address Primary Y Coordinate; Latitude; Organ Transplantation Center Latitude; SiteLat; Y Coordinate
		
This attribute represents the primary latitude in decimal degrees (y coordinate) of an entity based on its address.
		
Public
		
Esri
		
As Required
		
numeric(38,8)
		
For further information about Esri ArcGIS Resources and the ArcGIS REST API refer to the http://resources.arcgis.com/en/help/arcgis-rest-api/index.html#//02r300000017000000 website.
		
This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		
Expected values are positive numbers with eight decimals of precision. For example, 18.91747300 or 71.32993600. Can be NULL.
		
2018/03/16
	
	

		
ZIP Code
		
ZIP
		
ZIP Code; Geocoding Artifact Postal Code (Geocoder); Geocoding Artifact ZIP Code; Geocoding Artifact Zone Improvement Plan Code
		
This attribute represents the portion of the address defining the primary postal code. The postal codes which the HRSA Data Warehouse uses are the U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) postal code as defined by the USPS. The ZIP consists of five numerical digits. This value is a geocoding artifact returned for geoprocessed street address results.
		
Public
		
HRSA Data Warehouse
		
As Required
		
nvarchar(10)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are numeric text strings in the HRSA Data Warehouse postal code format (#####) which are exactly five characters in length, or when the value cannot be determined, either the text string XXXXX or a NULL value. For example, 20852; 96780; or XXXXX. Can be NULL.
		
2018/09/01
	
	

		
Center City
		
CTR_CITY
		
Center City; City
		
This attribute represents the city name in which the entity is physically located.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		
As Required
		
varchar(50)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are city names formatted in mixed case. For example, Birmingham. Cannot be NULL.
		
2018/09/01
	
	

		
Center Postal Code
		
CTR_ZIP_CD
		
Center Postal Code; Center ZIP Code; Center Zone Improvement Plan Code; ZIP Code
		
This attribute represents the portion of the address identifying the primary postal code in which the entity is physically located. The postal codes which the HRSA Data Warehouse uses are the U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) postal code as defined by the USPS. The center ZIP code consists of five or nine numerical digits.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		
As Required
		
varchar(10)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are 5 or 10 character numeric text strings in the HRSA Data Warehouse postal code format (either #####-#### or #####). For example, 20852 or 96780-1357. Can be NULL.
		
2018/09/01
	
	

		
Center State Abbreviation
		
CTR_STATE_ABBR
		
Center State Abbreviation; State
		
This attribute represents the U.S. Postal Service two-character abbreviation that identifies the U.S. state or U.S. territory in which the center is located.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		
As Required
		
char(2)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are two character alphabetic text strings representing the U.S. states and territories as defined by the U.S. Postal Service. The valid values are: XX; AK; AL; AR; AS; AZ; CA; CO; CT; DC; DE; FL; FM; GA; GU; HI; IA; ID; IL; IN; KS; KY; LA; MA; MD; ME; MH; MI; MN; MO; MP; MS; MT; NC; ND; NE; NH; NJ; NM; NV; NY; OH; OK; OR; PA; PR; PW; RI; SC; SD; TN; TX; UM; UT; VA; VI; VT; WA; WI; WV; and WY. Can be NULL.
		
2018/09/01
	
	

		
Center Address
		
CTR_ADDRESS
		
Center Address; Street Address
		
This attribute represents the street address where the entity is physically located.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		
As Required
		
varchar(100)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are text strings with the building numbers, street names, and possibly suite numbers (with dashes, parenthesis, or other punctuation) formatted in mixed case. For example, 665 Opelika Rd Ste 100. Cannot be NULL.
		
2018/09/01
	
	

		
Center Telephone Number
		
CTR_PHONE_NUM
		
Center Telephone Number; Center Telephone; Phone Telephone
		
This attribute represents the main telephone number for a center.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		
As Required
		
varchar(25)
		
None.
		
(1) This is a common attribute name which can have different sources depending on the data mart. (2) Changed, as necessary, as part of the HRSA Data Warehouse phone number standardization process. All non-numeric characters are deleted.
		
Expected values are telephone numbers with a the HRSA Data Warehouse standard format of 999-999-9999, x9999 (the x9999 represents the telephone extension). For example, 703-555-1212; 808-555-1212 x189; or 202-555-1212. Can be NULL.
		
2018/09/01
	
	

		
Center Name
		
CTR_NM
		
Center Name
		
This attribute represents the center name of the entity.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		
As Required
		
varchar(100)
		
None.
		
This is a common attribute name which can have different sources depending on the data mart.
		
Expected values are text strings, exactly as provided by source. Cannot be NULL.
		
2018/09/01
	
	

		
County within 100 Kilometers of U.S. - Mexico Border Indicator
		
CNT_US_MEXICO_BORDER_100KM_IND
		
County within 100 Kilometers of U.S. - Mexico Border Indicator; Part of County within 100 Kilometers of U.S. - Mexico Border Indicator
		
This attribute represents the indication of whether any portion of the geographic entity cited is within 100 kilometers of the U.S. - Mexico border. The HRSA Data Warehouse generates this value by performing a geoprocessing analysis against the 100 kilometer U.S. - Mexico border region as defined by the HRSA Office of Rural Health Policy, Border Health Program.
		
Public
		
HRSA Data Warehouse
		
As Required
		
char(1)
		
None.
		
This value is determined by geospatial analysis, if the entity location (U.S. entity) is determined to be within 100 Kilometers of the U.S. - Mexico border then Y (Yes), otherwise N (No). If the entity location cannot be determined then N (No).
		
Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Can be NULL.
		
2015/07/17