Sheet 1: DD_HAB_RDR_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
		
nvarchar(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 Side
		
SIDE
		
Geocoding Artifact Side; Side of the Street Determined by Geocoding
		
This attribute represents the side of the street where an address resides relative to the direction of feature digitization (this is a geocoding artifact). This value is not relative to the direction of travel along the street.
		
Public
		
Esri
		
As Required
		
varchar(1)
		
The valid values are: R (for Right) and L (for Left).
		
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, upper case, character text strings. The valid values are: R and L. Can be NULL.
		
2021/04/16
	
	

		
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
		
varchar(50)
		
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
		
nvarchar(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(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 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(5)
		
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
	
	

		
Metadata Attribute Label
		
attrlabl
		
Metadata Attribute Label; Attribute Label; Attribute Physical Name; DE_Identifier; Physical Column Name; Physical Name
		
This attribute represents the metadata database representing the HRSA Data Warehouse physical name of a HRSA Data Warehouse attribute (i.e., column in a database table or view).
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(255)
		
Please refer to https://www.fgdc.gov/metadata for more information about the Federal Geographic Data Committee (FGDC) metadata standard.
		
None.
		
Expected values are unrepresentable, uppercase, alphanumeric, text strings, in compliance with the HRSA Data Warehouse column naming conventions (with a few exceptions). For example, HBP_SITES_CITY_NM; FA_AMT; CONG_DIST_ID; or HCC_FCT_ID. Cannot be NULL.
		
2017/04/21
	
	

		
Metadata Attribute Definition
		
attrdef
		
Metadata Attribute Definition; Attribute Definition; Definition
		
This attribute represents the basic definition (and usage) of the attribute.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(-1)
		
Please refer to https://www.fgdc.gov/metadata for more information about the Federal Geographic Data Committee (FGDC) metadata standard.
		
None.
		
Expected values are free text. The valid values are: unpresentable. Can be NULL.
		
2017/04/21
	
	

		
Formula
		
attrformula
		
Formula; HDW Transformation
		
This attribute represents the specific processes or business rules instituted by the HRSA Data Warehouse to ensure the quality and accuracy of the data.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(-1)
		
None.
		
None.
		
Expected values are free-form descriptive alphanumeric text strings (can include dashes, parenthesis, or other punctuation and cannot include carriage returns). For example, None or (1) The length of ZIP Code cannot be zero. (2) Changed, as necessary, as part of the HRSA Data Warehouse address standardization process. Cannot be NULL.
		
2015/07/13
	
	

		
Update Frequency
		
attrmfrq
		
Update Frequency; Attribute Measurement Frequency; Metadata Attribute Measurement Frequency
		
This attribute represents the description of the frequency at which this attribute is updated (for shared elements this attribute will be set to As Required).
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(255)
		
Please refer to https://www.fgdc.gov/metadata for more information about the Federal Geographic Data Committee (FGDC) metadata standard.
		
None.
		
Expected values are unpresentable free dates which could include a time component. The valid values are: unpresentable. Can be NULL.
		
2017/04/21
	
	

		
Applicability
		
attrrest
		
Applicability; Data Restriction
		
This attribute represents the description of the level of access granted for this attribute.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(-1)
		
None.
		
None.
		
Expected values are alphabetic, title formatted, text strings. The valid values are: Private; Public; and Restricted. Cannot be NULL.
		
2015/07/13
	
	

		
Organization
		
attrdefs
		
Organization; Attribute Definition Source; Metadata Attribute Definition Source
		
This attribute represents the name of the source data owner.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(255)
		
Please refer to https://www.fgdc.gov/metadata for more information about the Federal Geographic Data Committee (FGDC) metadata standard.
		
None.
		
Expected values are free text. The valid values are: unpresentable. Can be NULL.
		
2017/04/21
	
	

		
Business Rules
		
attrburules
		
Business Rules; Business Rule / Format
		
This attribute represents the specific business rules from the source organization (owners of the source data) intended to ensure the quality and accuracy of the data.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(-1)
		
None.
		
None.
		
Expected values are free-form descriptive alphanumeric text strings (can include dashes, parenthesis, or other punctuation). For example, None; Must be a valid date earlier than the current processing date; Must be a valid date that is greater than the PMS Document Start Date; or Must be a valid USPS state abbreviation. Cannot be NULL.
		
2015/07/13
	
	

		
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
		
nvarchar(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
		
nvarchar(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
	
	

		
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
		
nvarchar(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
	
	

		
Part A Grant Number
		
PART_A_GRANT_NUM
		
Part A Grant Number
		
This attribute represents the 10 character concatenation of the activity code, organization code, and serial number that HRSA uses in the HRSA Electronic Handbooks (EHB) to identify the grant from which the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part A program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(20)
		
None.
		
None.
		
Expected values are alphanumeric text strings exactly as provided by HRSA, HIV/AIDS Bureau (HAB) source data system and will be 10 characters in length. For example, H89HA11478. Can be NULL.
		
2017/05/12
	
	

		
Part A Grantee Name
		
PART_A_GRANTEE_NM
		
Part A Grantee Name
		
This attribute represents the HRSA Electronic Handbooks (EHB) grant name associated with the Ryan White HIV/AIDS Program Part A grant from which the recipient or sub-recipient is receiving funding for providing service as recorded in the Ryan White HIV/AIDS Program Annual Data Report (RDR) a management information system for the HRSA, HIV/AIDS Bureau (HAB).
		
Public
		
HRSA Data Warehouse
		
Annually
		
varchar(100)
		
None.
		
(1) The HRSA Data Warehouse populates this attribute by looking up the name of the grantee associated with the grant from which the recipients or sub-recipient is receiving Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part A funds. (2) The data is accurate at the time of product publication.
		
Expected values are text strings for the grantee names as provided by HIV/AIDS Bureau (HAB) source data system. For example, "AIDS Action Coalition". Can be NULL.
		
2017/05/12
	
	

		
Received Part A Funding Indicator
		
PART_A_IND
		
Received Part A Funding Indicator
		
This attribute represents the indicator whether the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part A program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
char(1)
		
None.
		
None.
		
Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Cannot be NULL.
		
2017/05/12
	
	

		
Part B Grant Number
		
PART_B_GRANT_NUM
		
Part B Grant Number
		
This attribute represents the 10 character concatenation of the activity code, organization code, and serial number that HRSA uses in the HRSA Electronic Handbooks (EHB) to identify the grant from which the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part B program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(20)
		
None.
		
None.
		
Expected values are alphanumeric text strings exactly as provided by HRSA, HIV/AIDS Bureau (HAB) source data system and will be 10 characters in length. For example, "H89HA11478". Can be NULL.
		
2017/05/12
	
	

		
Part B Grantee Name
		
PART_B_GRANTEE_NM
		
Part B Grantee Name
		
This attribute represents the HRSA Electronic Handbooks (EHB) grant name associated with the Ryan White HIV/AIDS Program Part B grant from which the recipient or sub-recipient is receiving funding for providing service as recorded in the Ryan White HIV/AIDS Program Annual Data Report (RDR) a management information system for the HRSA, HIV/AIDS Bureau (HAB).
		
Public
		
HRSA Data Warehouse
		
Annually
		
varchar(100)
		
None.
		
(1) The HRSA Data Warehouse populates this attribute by looking up the name of the grantee associated with the grant from which the recipients or sub-recipient is receiving Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part B funds. (2) The data is accurate at the time of product publication.
		
Expected values are text strings for the grantee names as provided by HIV/AIDS Bureau (HAB) source data system. For example, "AIDS Action Coalition". Can be NULL.
		
2017/05/12
	
	

		
Received Part B Funding Indicator
		
PART_B_IND
		
Received Part B Funding Indicator
		
This attribute represents the indicator whether the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part B program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
char(1)
		
None.
		
None.
		
Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Cannot be NULL.
		
2017/05/12
	
	

		
Part C Grant Number
		
PART_C_GRANT_NUM
		
Part C Grant Number
		
This attribute represents the 10 character concatenation of the activity code, organization code, and serial number that HRSA uses in the HRSA Electronic Handbooks (EHB) to identify the grant from which the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part C program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(20)
		
None.
		
None.
		
Expected values are alphanumeric text strings exactly as provided by HRSA, HIV/AIDS Bureau (HAB) source data system and will be 10 characters in length. For example, "H89HA11478". Can be NULL.
		
2017/05/12
	
	

		
Part C Grantee Name
		
PART_C_GRANTEE_NM
		
Part C Grantee Name
		
This attribute represents the HRSA Electronic Handbooks (EHB) grant name associated with the Ryan White HIV/AIDS Program Part C grant from which the recipient or sub-recipient is receiving funding for providing service as recorded in the Ryan White HIV/AIDS Program Annual Data Report (RDR) a management information system for the HRSA, HIV/AIDS Bureau (HAB).
		
Public
		
HRSA Data Warehouse
		
Annually
		
varchar(100)
		
None.
		
(1) The HRSA Data Warehouse populates this attribute by looking up the name of the grantee associated with the grant from which the recipients or sub-recipient is receiving Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part C funds. (2) The data is accurate at the time of product publication.
		
Expected values are text strings for the grantee names as provided by HIV/AIDS Bureau (HAB) source data system. For example, "AIDS Action Coalition". Can be NULL.
		
2017/05/12
	
	

		
Received Part C Funding Indicator
		
PART_C_IND
		
Received Part C Funding Indicator
		
This attribute represents the indicator whether the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part C program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
char(1)
		
None.
		
None.
		
Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Cannot be NULL.
		
2017/05/12
	
	

		
Part D Grant Number
		
PART_D_GRANT_NUM
		
Part D Grant Number
		
This attribute represents the 10 character concatenation of the activity code, organization code, and serial number that HRSA uses in the HRSA Electronic Handbooks (EHB) to identify the grant from which the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part D program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(20)
		
None.
		
None.
		
Expected values are alphanumeric text strings exactly as provided by HRSA, HIV/AIDS Bureau (HAB) source data system and will be 10 characters in length. For example, "H89HA11478". Can be NULL.
		
2017/05/12
	
	

		
Part D Grantee Name
		
PART_D_GRANTEE_NM
		
Part D Grantee Name
		
This attribute represents the HRSA Electronic Handbooks (EHB) grant name associated with the Ryan White HIV/AIDS Program Part D grant from which the recipient or sub-recipient is receiving funding for providing service as recorded in the Ryan White HIV/AIDS Program Annual Data Report (RDR) a management information system for the HRSA, HIV/AIDS Bureau (HAB).
		
Public
		
HRSA Data Warehouse
		
Annually
		
varchar(100)
		
None.
		
(1) The HRSA Data Warehouse populates this attribute by looking up the name of the grantee associated with the grant from which the recipients or sub-recipient is receiving Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part D funds. (2) The data is accurate at the time of product publication.
		
Expected values are text strings for the grantee names as provided by HIV/AIDS Bureau (HAB) source data system. For example, "AIDS Action Coalition". Can be NULL.
		
2017/05/12
	
	

		
Received Part D Funding Indicator
		
PART_D_IND
		
Received Part D Funding Indicator
		
This attribute represents the indicator whether the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider is receiving funding from the Ryan White HIV/AIDS Program Part D program.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
char(1)
		
None.
		
None.
		
Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Cannot be NULL.
		
2017/05/12
	
	

		
Recipient/Sub-Recipient State Abbreviation
		
PROVIDER_STATE_ABBR
		
Recipient/Sub-Recipient State Abbreviation; Ryan White HIV/AIDS Medical Provider Site State Abbreviation; State
		
This attribute represents the U.S. Postal Service two character U.S. State or U.S. Territory abbreviation associated with the address for the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider entity.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
char(2)
		
None.
		
(1) The source address components are assumed to be correct and no validation steps are performed. (2) The HRSA Data Warehouse (HDW) uses an automated process to standardize addresses using the source address components associated with the source entity record to provide the best address for reporting and geoprocessing. (3) If the address cannot be geoprocessed the non-standardized source address is returned.
		
Expected values are two letter character abbreviation string for the states and territories as defined by the U.S. Postal Service. For example, MD; PA; or VA. Cannot be NULL.
		
2017/05/12
	
	

		
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
		
varchar(100)
		
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
	
	

		
Data Update Frequency
		
DATA_UPDATE_FREQUENCY
		
Data Update Frequency; Refresh Cycle
		
This attribute represents the frequency with which the HRSA Data Warehouse data is updated from the source.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(100)
		
None.
		
None.
		
Expected values are mixed-case text strings. The valid values are: Annually; Annually - as available; As Required; Daily; Monthly; Quarterly; Semi-annually; and When Available. Cannot be NULL.
		
2017/05/25
	
	

		
County
		
LIST_BOX_COUNTY_NM_STATE_ABBR
		
County; County and State; County and State Abbreviation; County Equivalent; County Name; County Name and State Abbreviation; County, State; County, State Abbreviation; List Box County Name with State Abbreviation; Proper County Name and State Abbreviation; State; State Abbreviation
		
This attribute represents the proper county name and state abbreviation associated with a specific entity.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(200)
		
None.
		
The List Box County Name is derived from the County or county equivalent names and descriptions as defined in Federal Information Processing Standards (FIPS) Pubs 55-3 and/or 6-4. If the county type is Island or City then the List Box County Name is the County Name field only and does not include the County type description. The District of Columbia, though treated as a county equivalent, is listed as District of Columbia without the county type description added. If the county is not a current county then the county name contains the date the county became effective (i.e., Miami-Dade County (Effective as of 1997)). The U.S. territory of Guam uses only Guam as the List Box County Name and does not include a county type description. If the County Name contains the text CITY and the County Description for the record is CITY the County Description is omitted to avoid redundancy in the field. The state abbreviation is always located after the full county name (if there are any Valid or Effective data ranges, these will follow the state abbreviation).
		
Expected values are text strings, including punctuation. For example, Honolulu County, HI; Montgomery County, MD; or Prince William County, VA. Can be NULL.
		
2016/01/04
	
	

		
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
	
	

		
Provider Address
		
PROVIDER_ADDRESS
		
Provider Address; Address; Recipient/Sub-Recipient Address; Street Address
		
This attribute represents the HRSA, HIV/AIDS Bureau (HAB) service provider street address.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(100)
		
None.
		
(1) The source address components are assumed to be correct and no validation steps are performed. (2) The HRSA Data Warehouse (HDW) uses an automated process to standardize addresses using the source address components associated with the source entity record to provide the best address for reporting and geoprocessing. (3) If the address cannot be geoprocessed the non-standardized source address is returned.
		
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.
		
2017/05/12
	
	

		
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
	
	

		
Reporting Year
		
REPORTING_YR
		
Reporting Year; Reporting Period (Year)
		
This attribute represents the reporting year for the associated entity.
		
Public
		
HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; HRSA, HIV/AIDS Bureau (HAB)
		
As Required
		
varchar(4)
		
Must be earlier than or equal to the latest completed calendar year. The reporting period is a calendar year, January 1 through December 31, and is the time period for which a HRSA-supported organization or HRSA program provides information on the activates that were carried out as a result of that support. For Ryan White HIV/AIDS Program Providers of Ambulatory Services the data are reported to HRSA by the following March 15. All information reported on clients and service delivery should reflect the calendar year reporting period. The reporting period may be shorter than a year if a provider agency did not receive Ryan White HIV/AIDS Program Title funding for an entire calendar year. In this case, the beginning or end dates of the reporting period should reflect the exact time period in the calendar year during which services were delivered to clients. For example, the reporting period for a provider whose contract began on April 1 would be April 1–December 31. Similarly, the reporting period for a provider whose contract was effective on January 1 but discontinued on June 30 would be January 1–June 30. For data from HRSA programs such as the HRSA nursing education programs and Area Health Education Centers the reporting year denotes the calendar year to which the data apply.
		
This is a common attribute name which can have different sources depending on the data mart.
		
Expected values are four digit integers. For example, "2012". Cannot be NULL.
		
2018/09/01
	
	

		
Ryan White HIV/AIDS Program Provider or Service Provider Type
		
HAB_PROVIDER_TYP_DESC
		
Ryan White HIV/AIDS Program Provider or Service Provider Type; HAB Provider Type; HAB Provider Type Description; Type
		
This attribute represents the description of the Ryan White HIV/AIDS Program provider or service provider type associated with the entity.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(100)
		
(1) This attribute came from the Ryan White Comprehensive AIDS Resources Emergency (CARE) Act Data Report (CADR) until August 2011. (2) After August 2011, this attribute came from the Ryan White HIV/AIDS Program Data Report (RDR). (3) Since 2015, this attribute came from the Ryan White HIV/AIDS Program Services Report (RSR).
		
None.
		
Expected values are title case, alphanumeric text strings. The valid values are: Hospital or University-based clinic; Community Health Center; Community Mental Health Center; Health Department; Substance Abuse Treatment Ctr.; Solo/Group Private Medical Practice; Agency reporting for multiple Fee-for-Service Providers; PLWHA coalition; VA Facility; Other provider type; and Other Community-based Service Organization. Cannot be NULL.
		
2019/04/08
	
	

		
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(2)
		
(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
	
	

		
Ryan White HIV/AIDS Program Provider or Service Provider Name
		
PROVIDER_NM
		
Ryan White HIV/AIDS Program Provider or Service Provider Name; HAB Provider Site Name; Program Name; Provider; Provider Name; Recipient/Sub-Recipient Name; Ryan White HIV/AIDS Medical Provider Site Name
		
This attribute represents the name of a provider receiving funding via a HRSA, HIV/AIDS Bureau (HAB) Ryan White HIV/AIDS Program grant.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(100)
		
None.
		
None.
		
Expected values are title case, alphanumeric text stringss. For example, Horizon Health Center or Park West Health System, Inc. Cannot be NULL.
		
2019/04/08
	
	

		
Dataset Name
		
DATASET_NM
		
Dataset Name
		
This attribute represents the name of a data mart or data set included in the HRSA Data Warehouse.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(100)
		
None.
		
None.
		
Expected values are title-case text strings. For example, 340B Drug Pricing Program Covered Entities; Health Center Controlled Network; Ryan White HIV/AIDS Recipients and Sub-Recipients; or ZIP Code Polygons. Cannot be NULL.
		
2017/05/25
	
	

		
Data Extract Date
		
DATA_EXTRACT_DT
		
Data Extract Date; Date of Data; Date Of Source Data
		
This attribute represents the date on which data were extracted from the source system.
		
Public
		
HRSA Data Warehouse
		
As Required
		
smalldatetime
		
None.
		
This attribute is either (a) the date on which the HRSA Data Warehouse (HDW) extract, transform, load (ETL) processes retrieves the data from the source system or (b) the date of the data supplied to the HDW (this date is documented in a data source analysis and/or documentation accompanying the data).
		
Expected values are date time where the time is the midnight or the zero hour. For example, 2013-10-15 00:00:00.000. Can be NULL.
		
2017/05/25
	
	

		
Recipient/Sub-Recipient City
		
PROVIDER_CITY
		
Recipient/Sub-Recipient City; City; Ryan White HIV/AIDS Medical Provider Site City
		
This attribute represents the city in which the HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider entity is located.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(50)
		
None.
		
(1) The source address components are assumed to be correct and no validation steps are performed. (2) The HRSA Data Warehouse (HDW) uses an automated process to standardize addresses using the source address components associated with the source entity record to provide the best address for reporting and geoprocessing. (3) If the address cannot be geoprocessed the non-standardized source address is returned.
		
Expected values are city names formatted in mixed case. For example, Birmingham. Cannot be NULL.
		
2017/05/12
	
	

		
Tabular Data Refresh
		
DATA_AS_OF_DT
		
Tabular Data Refresh; Fact Sheet Data as of Date; HRSA Data Warehouse Data Mart Create Date; Spatial Data Refresh
		
This attribute represents the date on which the data was processed by the HRSA Data Warehouse for any data mart or data set.
		
Public
		
HRSA Data Warehouse
		
As Required
		
smalldatetime
		
None.
		
This date represents the HRSA Data Warehouse (HDW) create or refresh date; the date on which the HDW processed the data and repopulated the data mart.
		
Expected values are date time where the time is the midnight or the zero hour. For example, 2013-10-15 00:00:00.000. Can be NULL.
		
2021/07/29
	
	

		
Recipient/Sub-Recipient ZIP Code
		
PROVIDER_ZIP_CD
		
Recipient/Sub-Recipient ZIP Code; Ryan White HIV/AIDS Medical Provider Site Postal Code; ZIP; ZIP Code
		
This attribute represents the postal code associated with a HRSA, HIV/AIDS Bureau (HAB) recipient or sub-recipient service provider entity. For the purposes of the HRSA Data Warehouse this value is normally a 5 or 10 character U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) Code.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(10)
		
None.
		
(1) The source address components are assumed to be correct and no validation steps are performed. (2) The HRSA Data Warehouse (HDW) uses an automated process to standardize addresses using the source address components associated with the source entity record to provide the best address for reporting and geoprocessing. (3) If the address cannot be geoprocessed the non-standardized source address is returned.
		
Expected values are either 5 or 10 character numeric text strings with a single dash in the ZIP Code formats of ##### or #####-####. For example, 20852 or 20852-1204. Can be NULL.
		
2017/05/12
	
	

		
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
	
	

		
Dataset Type
		
DATASET_TYP
		
Dataset Type
		
This attribute represents the indication of whether a data mart or data set in the HRSA Data Warehouse contains business (tabular) or spatial data.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(20)
		
None.
		
None.
		
Expected values are uppercase text strings. The valid values are: BUSINESS and SPATIAL. Cannot be NULL.
		
2017/05/25
	
	

		
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
		
varchar(50)
		
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
		
varchar(5)
		
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
	
	

		
Five Digit ZIP Code
		
ZIP_5_DIGIT_CD
		
Five Digit ZIP Code
		
This attribute represents the five digit Zone Improvement Plan (ZIP) Code which is the postal code used by the U.S. Postal Service (USPS).
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(5)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are five character numeric text strings. For example, 20852 or 96780. Can be NULL.
		
2016/01/04
	
	

		
State / Territory
		
STATE_TERR_DESC
		
State / Territory; State Description; State or Territory
		
This attribute represents the formal indicator of whether the given geographic entity is a U.S. state, or a U.S. territory, possession, or other affiliated entity.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(10)
		
None.
		
(1) When the State Indicator is Y, then value is set to state; when the State Indicator is N then the value is set to territory, otherwise the value is set to N/A. (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. (3) HRSA Data Warehouse convention is to assign the District of Columbia as the equivalent of a state (i.e., the state indicator is Yes).
		
Expected values are alphabetic text strings. The valid values are: State, Territory, N/A. Cannot be NULL.
		
2016/01/04
	
	

		
In U.S. - Mexico Border 100 Kilometer Area
		
US_MEXICO_BORDER_100KM_DESC
		
In U.S. - Mexico Border 100 Kilometer Area; In U.S. Mexico Border 100 Kilometer Area; In U.S./Mex. Border 100 KM Area; La Paz Agreement; U.S. - Mexico Border 100 Kilometer Indicator; U.S. - Mexico Border 100 Kilometer Status
		
This attribute represents the decoded description of the U.S. - Mexico 100 kilometer border region status indicator (Yes or No) for the entity.
		
Public
		
HRSA Data Warehouse
		
Daily
		
varchar(5)
		
None.
		
This attribute is the decoding of the associated U.S. - Mexico Border 100 Kilometer Area in or out status indicator, Y is set to Yes and N is set to No.
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2016/05/01
	
	

		
City and State
		
CITY_STATE_ABBR
		
City and State; City; City and State Abbreviation; City Name; City, State; HPSA Facility City and State; State
		
This attribute represents the standardized combination of city name and the state abbreviation.
		
Public
		
HRSA Data Warehouse
		
Daily
		
varchar(54)
		
None.
		
(1) The concatenation of the following: city name, a comma, a space, and the entity state abbreviation. (2) Changed, as necessary, as part of the HRSA Data Warehouse address standardization process. (3) This attribute provide a "nearly unique" identifier for the city, since many states may have a city with the same name. It is described as "nearly unique" because there are a few instances where there is more than one city or town with the same name in a given State.
		
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.
		
2016/01/04
	
	

		
County
		
LIST_BOX_COUNTY_NM_ONLY
		
County; County Equivalent; County Name; Full County Name; Site County
		
This attribute represents the proper county name associated with a specified data element.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(200)
		
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 text strings for the proper (complete) county or county equivalent names. For example, Not Determined; Arthur County; Abbeville County; Aleutians East Borough; Baker Island; Bethel Census Area; Caddo Parish; Eastern District; Fajardo Municipio; Hampton City; Jemo Municipality; or Kayangel State. Can be NULL.
		
2021/01/07
	
	

		
Faith Based Organization
		
FAITH_DESC
		
Faith Based Organization; Faith Based Org.
		
This attribute represents the faith based organization status for the entity (Yes or No).
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
On Demand
		
varchar(5)
		
None.
		
This value is the decoded faith based organization status (Y decoded to Yes and N decoded to No) and must agree with the corresponding value in the related indicator field.
		
Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Can be NULL.
		
2017/05/12
	
	

		
Geocoding Artifact Matched Street Address Location
		
MATCH_ADDR
		
Geocoding Artifact Matched Street Address Location; Match Address
		
This attribute represents the geocoding artifact that indicates where the address that the matched location actually resides based on the information of the matched candidate.
		
Public
		
Esri
		
As Required
		
varchar(250)
		
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. This is a complete address returned for the geocode request. The format is based on address standards for the country within which the address is located. 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.
		
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.
		
2016/05/27
	
	

		
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
	
	

		
Application Artifact Data Type
		
DATA_TYPE
		
Application Artifact Data Type
		
This attribute represents the data type for a physical database attribute.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(11)
		
None.
		
The HRSA Data Warehouse (HDW) retrieves this information from the database and standardizes the result for public distribution.
		
This is a technical attribute used by the HRSA Data Warehouse (HDW) website application software.
		
2018/08/31
	
	

		
U.S. - Mexico Border County Description
		
US_MEXICO_BORDER_COUNTY_DESC
		
U.S. - Mexico Border County Description; In U.S. - Mexico Border County; In U.S./Mex. Border County; U.S. - Mexico Border County
		
This attribute represents the decoded description of the U.S. - Mexico border county status indicator (Yes or No) for the entity.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(5)
		
For counties in the contiguous U.S., this data element may differ from the value of the US - Mexico Border 100 Kilometer Indicator due to the fact that three counties in Arizona fall partially within the defined 100-km boundary area, but are not included in the U.S. - Mexico Border Health Commissions list of counties that comprise the zone of interest.
		
This attribute is the decoding of the associated U.S. - Mexico Border County status indicator, Y is set to Yes and N is set to No.
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2016/05/01
	
	

		
RWCA Part A - Emergency Relief Status
		
PART_A_DESC
		
RWCA Part A - Emergency Relief Status
		
This attribute represents the decode of the Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part A, Emergency Relief Status, indicator attribute that identifies the Part A funding source status for the Ryan White HIV/AIDS recipient or sub-recipient.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(5)
		
Ryan White HIV/AIDS recipients and sub-recipients can receive funds from multiple grants associated with different Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) parts.
		
This value is the decoded Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part A - Emergency Relief indicator value (Y decoded to Yes and N decoded to No) and must agree with the corresponding value in the related indicator field.
		
Expected values are three, character, alphabetic text strings. The valid values are: Yes and No. Can be NULL.
		
2017/05/12
	
	

		
RWCA Part B - HIV Care Status
		
PART_B_DESC
		
RWCA Part B - HIV Care Status
		
This attribute represents the decode of the Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part B, HIV Care Status, indicator attribute that identifies the Part B funding source status for the Ryan White HIV/AIDS recipient or sub-recipient.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(5)
		
Ryan White HIV/AIDS recipients and sub-recipients can receive funds from multiple grants associated with different Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) parts.
		
This value is the decoded Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part B - HIV Care indicator value (Y decoded to Yes and N decoded to No) and must agree with the corresponding value in the related indicator field.
		
Expected values are three, character, alphabetic text strings. The valid values are: Yes and No. Can be NULL.
		
2017/05/12
	
	

		
RWCA Part C - Early Intervention Status
		
PART_C_DESC
		
RWCA Part C - Early Intervention Status
		
This attribute represents the decode of the Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part C, Early Intervention Status, indicator attribute that identifies the Part C funding source status for the Ryan White HIV/AIDS recipient or sub-recipient.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(5)
		
Ryan White HIV/AIDS recipients and sub-recipients can receive funds from multiple grants associated with different Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) parts.
		
This value is the decoded Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part C - Early Intervention indicator value (Y decoded to Yes and N decoded to No) and must agree with the corresponding value in the related indicator field.
		
Expected values are three, character, alphabetic text strings. The valid values are: Yes and No. Can be NULL.
		
2017/05/12
	
	

		
RWCA Part D -  Women, Infants, Children & Youth Status
		
PART_D_DESC
		
RWCA Part D -  Women, Infants, Children & Youth Status
		
This attribute represents the decode of the Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part D,  Women, Infants, Children & Youth Status, indicator attribute that identifies the Part D funding source status for the Ryan White HIV/AIDS recipient or sub-recipient.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(5)
		
Ryan White HIV/AIDS recipients and sub-recipients can receive funds from multiple grants associated with different Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) parts.
		
This value is the decoded Ryan White Comprehensive AIDS Resources Emergency (CARE) Act (RWCA) Part D -  Women, Infants, Children & Youth indicator value (Y decoded to Yes and N decoded to No) and must agree with the corresponding value in the related indicator field.
		
Expected values are three, character, alphabetic text strings. The valid values are: Yes and No. Can be NULL.
		
2017/05/12
	
	

		
SiteRuralIndicator
		
RURAL_IND
		
SiteRuralIndicator; Geocoding Artifact Rural Status Indicator; Rural Indicator; Rural Status; Rural Status Indicator
		
This attribute represents the indicator value identifying whether an entity is in a rural area as defined by HRSA.
		
Public
		
HRSA Data Warehouse
		
As Required
		
char(1)
		
None.
		
If the entity address is in an area Federal Office of Rural Health Policy (FORHP) has designated as rural then Y (Yes) else N (No). This value is determined by geospatial analysis.
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2020/09/06
	
	

		
Program Grant Numbers Responsible for Funding Provider
		
HAB_GRANT_NUM_LIST
		
Program Grant Numbers Responsible for Funding Provider; Grants Funding Provider
		
This attribute represents the list of HRSA Electronic Handbooks (EHB) grant numbers for the Ryan White HIV/AIDS Program Part A, Part B, Part C, and Part D grants for which the recipient or sub-recipient is receiving funding for providing service.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
On Demand
		
varchar(50)
		
None.
		
Concatenate the HRSA Electronic Handbooks (EHB) grant numbers for the Ryan White HIV/AIDS Program Part A, Part B, Part C, and Part D grants for which the provider is receiving funding for providing service. If a provider is not receiving funding for a Part, then that value is skipped in the process of concatenating the components; therefore, the list could have one to four components.
		
Expected values are alphanumeric text strings representing the comma delimited list of HRSA Electronic Handbooks (EHB) grant numbers for the Ryan White HIV/AIDS programs. The list can have one to four component grant numbers. For example, "H89HA00010"; "H89HA00010, H76HA07886"; "H89HA00009, H76HA00047, H12HA24857"; or "H89HA00011, X07HA00003, H76HA00812, H12HA24881". Cannot be NULL.
		
2017/05/12
	
	

		
Program Parts Responsible for Funding Provider
		
HAB_GRANT_PART_LIST
		
Program Parts Responsible for Funding Provider; Funding; Program Parts Funding Provider
		
This attribute represents the list of Ryan White HIV/AIDS Program Parts (Part A, Part B, Part C, and Part D) for which the recipient or sub-recipient is receiving funding for providing service.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
On Demand
		
varchar(30)
		
None.
		
Concatenate the Ryan White HIV/AIDS Program Parts (Part A, Part B, Part C, and Part D) associated with the HRSA Electronic Handbooks (EHB) grant numbers for which the provider is receiving funding for providing service. If a provider is not receiving funding for a Part, then that value is skipped in the process of concatenating the components; therefore, the list could have one to four components.
		
Expected values are alphanumeric text strings representing the comma delimited list Ryan White HIV/AIDS programs. The list can have one to four component grant numbers. For example, "Part A"; "Part B, Part C"; "Part A, Part C, Part D"; or " Part A, Part B, Part C, Part D ". Cannot be NULL.
		
2017/05/12
	
	

		
Rural Status
		
RURAL_DESC
		
Rural Status
		
This attribute represents the description of the rural status (Yes or No) for the entity.
		
Public
		
HRSA Data Warehouse
		
On Demand
		
varchar(5)
		
None.
		
This attribute is the decoding of the rural status indicator, Y is set to Yes and N is set to No.
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2016/05/01
	
	

		
Refresh Cycle
		
REFRESH_CYCLE
		
Refresh Cycle; Update Frequency
		
This attribute represents the short description (title) of the frequency at which the data is refreshed.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(100)
		
None.
		
None.
		
Expected values are alphanumeric, title formatted, text strings. The valid values are: Annually; Daily; Monthly; Quarterly; Semi-annually; and When Available. Cannot be NULL.
		
2017/01/27
	
	

		
Date of Source Data
		
SOURCE_DATE
		
Date of Source Data; Extract Date; Source Date
		
This attribute represents the date on which the data was either extracted from the source data system, produced by the source data owner, or provided by the source data owner.
		
Public
		
HRSA Data Warehouse
		
As Required
		
smalldatetime
		
None.
		
None.
		
Expected values are dates where there is no time component (essentially midnight or the zero hour). For example, 2014-01-10 00:00:00.000 or 2013-09-17 00:00:00.000. Cannot be NULL.
		
2017/01/27
	
	

		
Common County Name
		
CMN_COUNTY_NM_STATE_ABBR
		
Common County Name; Common County Name with State Abbreviation; County; County Name; Proper County Name and State Abbreviation
		
This attribute represents the HRSA Data Warehouse (HDW) concatenation of the complete county name and the state abbreviation.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(100)
		
None.
		
(1) The value is the concatenation of the county proper name, a comma, a space, and the state abbreviation. (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 text strings for county name, comma, and state abbreviation. For example, Arthur County, NE; Fairfax County, VA; Honolulu County, HI; Winn Parish, LA; or Yauco Municipio, PR. Can be NULL.
		
2021/01/07
	
	

		
Common Region Name
		
CMN_REGION_NM
		
Common Region Name; Common HHS Region Name; HHS Region; HHS Region Name; Region Name
		
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
		
HRSA Data Warehouse
		
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
	
	

		
Common Region Code
		
CMN_REGION_CD
		
Common Region Code; Common HHS Region Code; HHS Region Code
		
This attribute represents the U.S. Department of Health and Human Services (HHS) region code.
		
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 representing the region. The valid values are: 01; 02; 03; 04; 05; 06; 07; 08; 09; and 10. Can be NULL.
		
2020/08/15
	
	

		
Common State Abbreviation
		
CMN_STATE_ABBR
		
Common State Abbreviation; Common State Name; State; State Abbreviation
		
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
	
	

		
Common State County FIPS Code
		
CMN_STATE_COUNTY_FIPS_CD
		
Common State County FIPS Code; State County FIPS; State County FIPS Code
		
This attribute represents the combination of the state and county Federal Information Processing Standard (FIPS) codes.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(5)
		
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 five digit numeric text strings. For example, 01001. Cannot be NULL.
		
2020/08/15
	
	

		
Common State FIPS Code
		
CMN_STATE_FIPS_CD
		
Common State FIPS Code; State CD; State FIPS Code
		
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
	
	

		
Common State Name
		
CMN_STATE_NM
		
Common State Name; SiteCongressionalDistrictState; State; State (Component); State Name
		
This attribute represents the state or territory name.
		
Public
		
HRSA Data Warehouse
		
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
	
	

		
Common Postal Code
		
CMN_ZIP_CD
		
Common Postal Code; Common ZIP Code; Postal Code; ZIP Code
		
This attribute represents the postal code associated with an entity address. For the purposes of the HRSA Data Warehouse this value is a five character U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) code.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(5)
		
None.
		
(1) The HRSA Data Warehouse (HDW) derives this text as the first five digits of the U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) code associated with the entity (record). (1) This attribute identifies the specific legal or administrative geographic area to which the entity (record) is located or associated. (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 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/03/16
	
	

		
Common City Name with State Abbreviation
		
CMN_CITY_NM
		
Common City Name with State Abbreviation; City; City Name with State Abbreviation; Common City Name
		
This attribute represents the city name in which the entity is physically located.
		
Public
		
HRSA Data Warehouse
		
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.
		
2017/04/21
	
	

		
Common Congressional District Name
		
CMN_CONG_DIST_NM
		
Common Congressional District Name; Cong. District; Cong. District Name; Congressional District; Congressional District Name; SiteCongressionalDistrictName
		
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.
		
2018/03/16
	
	

		
Common Congress Number Text
		
CMN_CONG_NUM
		
Common Congress Number Text; Cong. Number; Congress Number; Congress Number Text
		
This attribute represents the textual expression of the sequential number used to identify a specific session of Congress.
		
Public
		
U.S. House of Representatives
		
As Required
		
char(3)
		
None.
		
(1) This attribute identifies the specific legal or administrative geographic area to which the entity (record) is located or associated. (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. (3) Identifies the congress which was in session at the time when the program office data was refreshed.
		
Expected values are integers less than or equal to the number associated with the currently seated Congress. For example, 106; 109; 110; or 113. Can be NULL.
		
2018/03/16
	
	

		
Common State FIPS Code Congressional District Number
		
CMN_STATE_FIPS_CONG_DIST_NUM
		
Common State FIPS Code Congressional District Number; State FIPS and Congressional District Number Code; 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) This attribute identifies the specific legal or administrative geographic area to which the entity (record) is located or associated. (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. Can be NULL.
		
2016/05/01
	
	

		
Attribute Valid Values Description
		
ATTR_VALID_VAL
		
Attribute Valid Values Description; Valid Values
		
This attribute represents the description of the valid values an attribute could contain.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(-1)
		
None.
		
(1) This description is comprised of three declarative statements, for example, “Expected values are …. For example, aaa; bbb; or ccc. Cannot be NULL.” (2) The first statement describes the type of data in the attribute, for example “Expected values are positive integers.” (3) The second statement is either a list of examples or the list of valid values (the items in the lists are separated by semicolons and the conjunction for the examples list is OR (in lower case) and for the valid values list is AND (in lower case). (4) The third statement identifies if the attribute can have NULL values. (5) The word NULL is always in all capital letters.
		
Expected values are free-form descriptive alphanumeric text strings; can include dashes, parenthesis, or other punctuation; and is comprised of three declarative statements. For example: "Expected values are positive integers. For example, 1; 21; or 3487. Cannot be NULL." Cannot be NULL.
		
2015/07/13
	
	

		
Metadata Attribute Name
		
ATTR_DEFAULT_NM
		
Metadata Attribute Name; Attribute Name
		
This attribute represents the specific user friendly name (UFN) that is the administrative or official name associated with the physical attribute.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(8000)
		
None.
		
Populated from the user friendly names (UFN) associated with the physical attribute where the default flag is true.
		
Expected values are alphabetic text strings representing a name (this is an unrepresentable domain). For example, State Name; First Name; or FNAME. Cannot be NULL.
		
2018/09/01
	
	

		
Definition Update Date
		
ATTR_METADATA_LAST_UPDATE_DT
		
Definition Update Date
		
This attribute represents the date on which the attribute record was last updated.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(25)
		
None.
		
Retrieved last updated date from the attribute table for the physical attribute, converted to a string and formatted as yyyy/mm/dd.
		
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.
		
2018/09/01
	
	

		
User Friendly Names
		
ATTR_UFN_LIST
		
User Friendly Names
		
This attribute represents the concatenated list of alphabetically sorted user friendly names (UFN) associated with the physical attribute.
		
Public
		
HRSA Data Warehouse
		
Dynamic
		
varchar(8000)
		
The HRSA programs and users supply the commonly used names for an attribute.
		
Concatenated list of alphabetically sorted user friendly names (UFN) associated with the physical attribute where the default flag is true.
		
Expected values are alphabetic text strings representing one or more names separated by semicolons (this is an unrepresentable domain). For example, First Name; Name; User. Can be NULL.
		
2020/04/24
	
	

		
Data Type
		
DATA_TYP
		
Data Type
		
This attribute represents the classification of data from the HRSA Data Warehouse databases.
		
Public
		
HRSA Data Warehouse
		
As Required
		
nvarchar(151)
		
None.
		
Retrieved from the database system tables and formatted to properly represent the data type (number of characters or numeric precision).
		
Expected values are alphabetic text strings representing a data type name and in parentheses the size and precision. For example, float; int; numeric(9,2); or varchar(200). Cannot be NULL.
		
2018/09/01
	
	

		
Application Artifact Metadata
		
METADATA
		
Application Artifact Metadata
		
This attribute represents the metadata.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(1023)
		
None.
		
This attribute is the name of the metadata file.
		
This is a technical attribute used by the HRSA Data Warehouse (HDW) website application software.
		
2018/08/31
	
	

		
Metadata Attribute Definition
		
ATTR_DEF
		
Metadata Attribute Definition; Column Definition; Definition
		
This attribute represents the basic definition (and usage) of the attribute.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(-1)
		
Please refer to https://www.fgdc.gov/metadata for more information about the Federal Geographic Data Committee (FGDC) metadata standard.
		
None.
		
Expected values are free text. The valid values are: unpresentable. Can be NULL.
		
2017/04/21
	
	

		
Dynamic Metadata Data Type
		
DATA_TYPE_DESC
		
Dynamic Metadata Data Type
		
This attribute represents the classification of data from the HRSA Data Warehouse databases.
		
Public
		
HRSA Data Warehouse
		
As Required
		
nvarchar(151)
		
None.
		
Retrieved from the database system tables and formatted to properly represent the data type (number of characters or numeric precision).
		
Expected values are alphabetic text strings representing a data type name and in parentheses the size and precision. For example, float; int; numeric(9,2); or varchar(200). Cannot be NULL.
		
2018/09/01
	
	

		
User Friendly Names
		
ATTR_LABL_UFN_LIST
		
User Friendly Names; UFN List
		
This attribute represents the set of user friendly names (UFN) associated with the physical attribute.
		
Public
		
HRSA Data Warehouse
		
Dynamic
		
nvarchar(4000)
		
The HRSA programs and users supply the commonly used names for an attribute.
		
HRSA Data Warehouse (HDW) prepares concatenated list of physical name and user friendly names (UFN); the first item is the physical name and second item is the default UFN.
		
Expected values are alphabetic text strings representing a name (this is an unrepresentable domain). For example, “State Name; State” or “Telephone Number; Pnone”. Cannot be NULL.
		
2020/04/24
	
	

		
Extract, Transform, Load Document User Friendly Names
		
ETL_DOC_UFN_LIST
		
Extract, Transform, Load Document User Friendly Names
		
This attribute represents the set of user friendly names (UFN) associated with the physical attribute.
		
Public
		
HRSA Data Warehouse
		
Dynamic
		
nvarchar(4000)
		
The HRSA programs and users supply the commnoly used names for an attribute.
		
HRSA Data Warehouse (HDW) prepares concatenated list of physical name and user friendly names (UFN); the first item is the physical name and second item is the default UFN.
		
Expected values are alphabetic text strings representing a name (this is an unrepresentable domain). For example, “State Name; State” or “Telephone Number; Pnone”. Cannot be NULL.
		
2020/04/24
	
	

		
Attribute Schema and Table Name for Extract, Transform, Load Document
		
SCHEMA_TABLE_NM
		
Attribute Schema and Table Name for Extract, Transform, Load Document
		
This attribute represents the physical name for a database entity.
		
Public
		
HRSA Data Warehouse
		
Dynamic
		
nvarchar(257)
		
None.
		
HRSA Data Warehouse (HDW) concatenates the extracted physical schema a period, and physical table from the system tables.
		
Expected values are alphanumeric text strings which include underscore and period characters. For example, dbo.CMN_GEOGRAPHY_TYP_DIM or gisapp.GEO_STATE_CUR_TX. Cannot be NULL.
		
2020/04/24
	
	

		
User Friendly Name List
		
UFN_LIST
		
User Friendly Name List
		
This attribute represents the concatenated list of alphabetically sorted user friendly names (UFN) associated with the physical attribute.
		
Public
		
HRSA Data Warehouse
		
Dynamic
		
varchar(8000)
		
The HRSA programs and users supply the commonly used names for an attribute.
		
Concatenated list of alphabetically sorted user friendly names (UFN) associated with the physical attribute where the default flag is true.
		
Expected values are alphabetic text strings representing one or more names separated by semicolons (this is an unrepresentable domain). For example, First Name; Name; User. Can be NULL.
		
2020/04/24
	
	

		
RWHAP Funded Services
		
RWHAP_SERVICE_DESC
		
RWHAP Funded Services
		
This attribute represents the description of RWHAP Funded Services.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(2000)
		
None.
		
None.
		
Expected values are text strings. For example, "Medical case management (including treatment adherence); Case management (non-medical); Housing services". Can be NULL.
		
2020/08/21