Sheet 1: DD_HAB_SITE_DATA_SERV_METADATA_

	
	
	
	
	
	
	
	
	
	
	
	
	

		
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
	
	

		
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
	
	

		
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
	
	

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

		
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
	
	

		
Internet Address
		
URL
		
Internet Address; Report; Website; Website Address
		
This attribute represents the uniform resource locator (URL) referencing a resource that specifies the location of the resource on a computer network and a mechanism for retrieval. The URL may also be referred to as the internet address for your browser.
		
Public
		
HRSA Data Warehouse
		
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.
		
Expected values are text strings that may include punctuation symbols such as periods (.) or slashes (/), (\). For example: http://www.house.gov/rehberg/. Can be NULL.
		
2015/05/15
	
	

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

		
Ryan White HIV/AIDS Medical Provider Site Surrogate Key
		
HAB_SITE_ID
		
Ryan White HIV/AIDS Medical Provider Site Surrogate Key; HIV/AIDS Provider Site ID; Provider Site ID; Site ID
		
This attribute represents the HRSA Data Warehouse system-generated, one-up integer that uniquely identifies records for Ryan White HIV/AIDS Medical Provider sites (facilities).
		
None.
		
HRSA Data Warehouse
		
Annually
		
int
		
None.
		
None.
		
Expected values are integers (the value is unique and required in the fact and detail tables). For example, 1; 21; or 348. Cannot be NULL.
		
2017/10/12
	
	

		
Recipient/Sub-Recipient Address
		
PROVIDER_ADDR
		
Recipient/Sub-Recipient Address; Address; Ryan White HIV/AIDS Medical Provider Site Address
		
This attribute represents the street address in which the Health Resources and Services Administration (HRSA), HIV/AIDS Bureau (HAB) provider entity is located.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(100)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		
Expected values are text strings with the building numbers, street names, and possibly suite numbers (with dashes, parenthesis, or other punctuation) formatted in mixed case. For example, "665 Opelika Rd Ste 100". Cannot be NULL.
		
2017/05/25
	
	

		
Recipient/Sub-Recipient Telephone Number
		
PROVIDER_PHONE_NUM
		
Recipient/Sub-Recipient Telephone Number; Ryan White HIV/AIDS Medical Provider Site Telephone Number; Telephone Number
		
This attribute represents the 10 digit telephone number of the primary contact or the operator associated with a Health Resources and Services Administration (HRSA), Ryan White HIV/AIDS Medical Provider Facility entity.
		
Public
		
HRSA, HIV/AIDS Bureau (HAB)
		
Annually
		
varchar(25)
		
None.
		
Changed, as necessary, as part of the HRSA Data Warehouse phone number standardization process.
		
Expected values are telephone numbers in the HRSA Data Warehouse standard format of 999-999-9999, x9999 (the x9999 represents the telephone extension). For example, 703-555-1212; 808-555-1212 x189; or 202-555-1212. Can be NULL.
		
2017/05/25
	
	

		
Geocoding Web Services Artifact Distance
		
DISTANCE
		
Geocoding Web Services Artifact Distance; Geocoding Artifact Distance
		
This attribute represents the physical distance in miles from a candidate to a specified location. The distance output value is calculated for each candidate when the location input parameter is passed in a request using the Find or Find Address Candidates methods. If the Location parameter is not passed in a request, then the value of DISTANCE is zero.
		
Restricted
		
Esri
		
As Required
		
numeric(38,8)
		
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 non-negative numbers with eight decimals. The valid value is: 0.00000000. Can be NULL.
		
2018/08/29
	
	

		
Geocoding Artifact Matched Location is an Approximation Indicator
		
APPROX_VALUE_CD
		
Geocoding Artifact Matched Location is an Approximation Indicator; Approximate Value Indicator
		
This attribute represents the indication of whether an address was geocoded to an an accurate or approximate location (and approximate location would be a postal code, city, or state centroid).
		
Public
		
Esri
		
As Required
		
char(1)
		
None.
		
The HRSA Data Warehouse set the value as follows: when the loaction is geocoded at the address level producting accurate coordinates then Y; otherwise the address is geocoded at postal code, city, or state level producing approximate coordinates.
		
Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		
2018/08/29
	
	

		
Geocoding Web Services Artifact Object Identification Number
		
ROW_ID
		
Geocoding Web Services Artifact 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
	
	

		
Geocoding Web Services Artifact Distance
		
LAT_LON
		
Geocoding Web Services Artifact Distance
		
This attribute represents the longitude and latitude for the geographic information system (GIS) coordinate information for a location.
		
Public
		
HRSA Data Warehouse
		
As Required
		
varchar(50)
		
None.
		
None.
		
The expected values are numeric text strings coordinates; formatted as latitude, a space, and longitude (with up to 12 decimals of percision). For example, 33.9122454545454 -98.4738090909091 or 33.9038 -98.4816363636364. Cannot be NULL.
		
2018/08/29