Excel Sheet Download 6298 | Org Opo Datamart Metadata

Partial file snippet.
Sheet 1: DD_ORG_OPO_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
		nvarchar(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
		nvarchar(-1)
		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
	
	
		Number of Heart Transplant Centers
		TOT_HEART_CTR_CT
		Number of Heart Transplant Centers; # of Heart Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing heart transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Heart Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		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
	
	
		Number of Intestine Transplant Centers
		TOT_INTESTINE_CTR_CT
		Number of Intestine Transplant Centers; # of Intestine Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing intestine transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Intestine Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		Number of Kidney Transplant Centers
		TOT_KIDNEY_CTR_CT
		Number of Kidney Transplant Centers; # of Kidney Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing kidney transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Kidney Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		Number of Liver Transplant Centers
		TOT_LIVER_CTR_CT
		Number of Liver Transplant Centers; # of Liver Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing liver transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Liver Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		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
	
	
		Number of Lung Transplant Centers
		TOT_LUNG_CTR_CT
		Number of Lung Transplant Centers; # of Lung Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing lung transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Lung Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		Number of Pancreas Transplant Centers
		TOT_PANCREAS_CTR_CT
		Number of Pancreas Transplant Centers; # of Pancreas Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing pancreas transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Pancreas Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		Number of Pancreas Islet Transplant Centers
		TOT_PANCREAS_ISLET_CTR_CT
		Number of Pancreas Islet Transplant Centers; # of Pancreas Islet Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing pancreas islet transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Pancreas Islet Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2017/08/04
	
	
		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
		smalldatetime
		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
	
	
		Service Areas (Counties)
		SERVICE_COUNTY_LIST
		Service Areas (Counties); County Service Areas
		This attribute represents the list of county names which comprise a Organ Procurement Organizations (OPO) service area.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(8000)
		The Organ Procurement Organization (OPO) service area counties within a state are only associated to a single OPO.
		The Organ Procurement Organization (OPO) fact records identify the individual county components which comprise service area for each the OPO. For each OPO, the associated county names are collected in a comma separated list of alphabetically sorted county names (strictly the name, does not include the type).
		Expected values are alphabetic text strings representing the names (only the name) of the various counties which constitute the service area. The county names are delimited with commas. For example, "Allegany, Cattaraugus, Chautauqua, Erie, Genesee, Niagara, Orleans, Wyoming". Cannot be NULL.
		2017/08/04
	
	
		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
		nvarchar(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
	
	
		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
	
	
		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
	
	
		State Abbreviation
		STATE_ABBR
		State Abbreviation; State; State Code; State_Cd
		This attribute represents the U.S. Postal Service (USPS) two alphabetic character code for a U.S. state or U.S. territory associated with a location where an entity is situated.
		Public
		HRSA Data Warehouse
		As Required
		char(2)
		None.
		This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		Expected values are two character alphabetic text strings representing the state. The valid values are: XX; AK; AL; AR; AS; AZ; CA; CO; CT; DC; DE; FL; FM; GA; GU; HI; IA; ID; IL; IN; KS; KY; LA; MA; MD; ME; MH; MI; MN; MO; MP; MS; MT; NC; ND; NE; NH; NJ; NM; NV; NY; OH; OK; OR; PA; PR; PW; RI; SC; SD; TN; TX; UM; UT; VA; VI; VT; WA; WI; WV; and WY. Can be NULL.
		2020/08/15
	
	
		U.S. - Mexico Border County Indicator
		US_MEXICO_BORDER_COUNTY_IND
		U.S. - Mexico Border County Indicator; Primary Care Service Area U.S. - Mexico Border County Indicator
		This attribute represents the indication of whether a county or a part of a county is listed in U.S. counties that the U.S. - Mexico Border Health Commission has defined as comprising the Border Health Initiative zone. For counties in the contiguous U.S., this data element may differ from the value of the U.S. - Mexico Border 100 Kilometer Indicator due to the fact that three counties in Arizona fall partially within the defined 100-kilometer boundary area, but are not listed in the list of counties that the U.S. - Mexico Border Health Commission identified as comprising the zone of interest.
		Public
		HHS, Office of Global Affairs (OGA), U.S.-Mexico Border Health Commission
		As Required
		char(1)
		None.
		(1) For the HRSA Data Warehouse County Dimension table the value is Y (Yes) for those counties in the list of counties identified by the U.S. - Mexico Border Health Commission, otherwise the value is N (No). (2) For data sets this value is determined by geospatial analysis, if the entity location (U.S. entity) is determined to be within a U.S. - Mexico Border Health Commission identified county then Y (Yes), otherwise N (No). If the entity location cannot be determined then N (No).
		Expected values are single character text strings. The valid values are: Y and N. Can be NULL.
		2020/08/15
	
	
		Geography Code
		Geography_Cd
		Geography Code; Census Tract Code; CSD FIPS Code; State County FIPS Code; State FIPS Code; ZCTA Code
		This attribute represents the code that uniquely identifies a geographic area. The range of values that populate the Geography code change depending on the type of geography that is being identified (for example, a geography type 1, state, is uniquely identified by the state Federal Information Processing System (FIPS) code).
		Public
		HRSA Data Warehouse
		As Required
		varchar(50)
		None.
		(1) The geography codes have leading zeroes and represent specific area. (2) The length of the geography code does not unique identify the type of area. For example, a State is represented by a 2 digit code; a Congressional District or MSA/CMSA is represented by a 4 digit code; a County, U.S. Postal Service Zone Improvement Plan (ZIP) Code, ZIP Code Tabulation Area, Core Based Statistical Area, MSA/CMSA, PMSA (CSA) or CSD is represented by a 5 digit code; a CSD or PMSA is represented by a 10 digit code; a Census Tract is represented by a 11 digit code; and a Block Group is represented by a 12 digit code. (3) Geography Codes are only unique when compared to codes of the same type and time period (ZIP codes and state county FIPS codes could have the same values).
		Expected values are 2, 4, 5, 10, 11, or 12 character numeric text strings with leading zeroes. For example, Block Group 010010201001 or 780309615006; Census Tract 01001020100 or 78030961500; Congressional District 0101 or 7298; Core Based Statistical Area 10020 or 49780; County 01001 or 78030; CSD 0100190171 or 7803082900; MSA/CMSA 0040 or 9360; PMSA (CSA) 01122 or 72490; PMSA 0644724480 or 7274427440; Primary Care Service Area 01002 or 99929; State 01 or 78; ZIP Code 00001 or 99950; and ZIP Code Tabulation Area 00601 or 99950. Cannot be NULL.
		2021/07/29
	
	
		Geography Type
		Geography_Typ
		Geography Type
		This attribute represents the geography type numeric code, which is a numeric identifier created by the HRSA Data Warehouse (HDW) that is used to identify the various geographic entity types that are used in the HDW statistical data.
		Public
		HRSA Data Warehouse
		As Required
		varchar(25)
		None.
		None.
		Expected values are positive integers between 1 and 13. The valid values are: 1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12; and 13. Cannot be NULL.
		2021/07/29
	
	
		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
	
	
		Technical Data Source
		Data_Source
		Technical Data Source; Data Source
		This attribute represents the textual description used for identifying where the displayed data were obtained.
		Public
		HRSA Data Warehouse
		As Required
		varchar(200)
		(1) Datasets obtained by the Primary Care Service Area (PCSA) Project Team for use in the definition and characterization of Primary Care Service Areas. (2) Datasets from Healthcare Systems Bureau must be either: Participating 340B Covered Entities - Sites by State; Office of Pharmacy Affairs Covered Entity Daily Report 09/16/2013 or Number of Transplant Recipients by State/Territory, 2009; HRSA Office of Communications; February 2011.
		Updated as required depending on the dataset.
		Expected values are free-form alphanumeric text strings which could include special and punctuation characters. For example, CENSUS; Claritas; PCSA; ACS 5-year (2007-2011); CENSUS SF1; BMISS; DMG; EHB; HPSA; ORG; Number of Transplant Recipients by State/Territory, 2015; Based on OPTN data as of July 14, 2017; or Participating 340B Covered Entities - Sites by State; 340B Database Covered Entity Daily Report 9/16/2013. Cannot be NULL.
		2018/09/06
	
	
		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(200)
		None.
		(1) This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time. (2) 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
	
	
		Time Period
		TIME_PERIOD
		Time Period; Fact Sheet Fiscal Year Value
		This attribute represents the time period to associated with the entity record.
		Public
		HRSA Data Warehouse
		As Required
		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) For the Healthcare Systems Bureau dataset, must be listed in the Healthcare Systems Bureau Time Period Dimension table. (3) For the Minority Data Initiatives (MDI) data mart this value is a year, such as 2004.
		Expected values are alphanumeric text strings which generally include a four digit year or year range. For example, 2000; 2014; 2002-2006 IMN; or 2006-2010. Cannot be NULL.
		2021/07/29
	
	
		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
		nvarchar(10)
		None.
		This attribute is a common element which may be used in multiple data marts. At the time of a data mart refresh, this attribute is entered as a snapshot of the current state of the data and is not refreshed until the data mart is refreshed. Each data mart refresh is a snapshot in time.
		Expected values are single letter text strings. The valid values are: D (Democratic); R (Republican); or I (Independent). Can be NULL.
		2016/05/27
	
	
		Geocoding Artifact Feature State Abbreviation
		STATE
		Geocoding Artifact Feature State Abbreviation; Healthy Start Performance Measure State Synonym; State Abbreviation; UDS Mapper Spatial Artifact State Abbreviation; Uniform Data System Web Report State
		This attribute represents the U.S. Postal Service (USPS) U.S. state or territory postal code (also referred to as the abbreviation) in which the entity is located.
		Public
		HRSA, Bureau of Primary Health Care (BPHC), Office of Policy and Program Development (OPPD)
		As Required
		nvarchar(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
	
	
		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
	
	
		Organ Procurement Organization Address
		OPO_ADDRESS
		Organ Procurement Organization Address; Address; OPO Address
		This attribute represents the street address where the Organ Procurement Organization (OPO) entity is physically located.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-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). For example, "665 Opelika Rd Ste 100". Can be NULL.
		2017/08/04
	
	
		Organ Procurement Organization City
		OPO_CITY
		Organ Procurement Organization City; City; OPO City
		This attribute represents the city where the Organ Procurement Organization (OPO) entity is physically located.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(50)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		Expected values are alphabetic text strings representing city names formatted in title case. For example, Black River Falls; Kahului; or Stockton. Can be NULL.
		2017/08/04
	
	
		Organ Procurement Organization Telephone Number
		OPO_PHONE_NUM
		Organ Procurement Organization Telephone Number; OPO Telephone #; OPO Telephone Number; Phone; Phone Number; Telephone Number
		This attribute represents the main telephone number for the Organ Procurement Organization (OPO).
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(25)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse phone number standardization process. All non-numeric characters are deleted.
		Expected values are telephone numbers 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/08/04
	
	
		Organ Procurement Organization Name
		OPO_PROVIDER_NM
		Organ Procurement Organization Name; Name; OPO Name; OPO Org. Name; Org. Name
		This attribute represents the organization name for the Organ Procurement Organization (OPO) entity.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(100)
		None.
		None.
		Expected values are text strings containing the name of the organization. For example, Alabama Organ Center; Indiana Organ Procurement Organization; New Jersey Organ and Tissue Sharing Network OPO; or Wisconsin Donor Network. Cannot be NULL.
		2017/08/04
	
	
		Organ Procurement Organization Provider Number
		OPO_PROVIDER_NUM
		Organ Procurement Organization Provider Number; OPO Provider #; OPO Provider Number; Provider Number
		This attribute represents the organization identifying provider number the Organ Procurement Organization (OPO) entity.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(10)
		None.
		None.
		Expected values are alphanumeric strings containing formatted as ##P###. For example, 01P001; 11P002; 25P001; or 52P002. Cannot be NULL.
		2017/08/04
	
	
		Organ Procurement Organization State Abbreviation
		OPO_STATE_ABBR
		Organ Procurement Organization State Abbreviation; OPO State Abbreviation; State; State Abbreviation; State Code; State_Cd; U.S. Postal Service State Code
		This attribute represents the state abbreviation of the state where the Organ Procurement Organization (OPO) entity is physically located.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		nvarchar(2)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		Expected values are two character alphabetic text strings representing the 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.
		2017/08/04
	
	
		Organ Procurement Organization Postal Code
		OPO_ZIP_CD
		Organ Procurement Organization Postal Code; OPO ZIP Code; Organ Procurement Organization ZIP Code; ZIP; ZIP Code
		This attribute represents the postal code where the Organ Procurement Organization (OPO) entity is physically located. For the purposes of the HRSA Data Warehouse this value is a U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) code.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(25)
		None.
		(1) HRSA Data Warehouse (HDW) address data are standardized to provide a mechanism for obtaining the best estimate for the five or nine digit U.S. Postal Service Zone Improvement Plan (ZIP) Code for the input address. (2) The source address components are assumed to be correct and no validation steps are performed. (3) The 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. (4) If the address cannot be geoprocessed the non-standardized source address is returned.
		Expected values are 5 or 10 character numeric text strings in the HRSA Data Warehouse postal code format (either #####-#### or #####). For example, 20852 or 96780-1357. Can be NULL.
		2017/08/04
	
	
		Organ Procurement Organization State Name
		OPO_STATE_NM
		Organ Procurement Organization State Name; OPO State; State; State Name
		This attribute represents the state or territory name where the Organ Procurement Organization (OPO) entity is physically located.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(50)
		None.
		None.
		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. Cannot be NULL.
		2017/08/04
	
	
		Organ Procurement Organization URL
		OPO_URL
		Organ Procurement Organization URL; Internet Address; OPO Website Address; OPO Website Address Hyperlink; Website; Website Address
		This attribute represents the World Wide Web address for the Organ Procurement Organization (OPO) entity.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(200)
		None.
		None.
		Expected values are alphanumeric text strings which include special and punctuation characters for web sites, generally a HTTP URL consists of the following: scheme name (commonly called protocol), a colon, two slashes, a host (normally given as a domain name but sometimes as a literal IP address), optionally a port number, and full path of the resource. For example, http://en.wikipedia.org/wiki/Uniform_resource_locator. Cannot be NULL.
		2017/08/04
	
	
		Organ Procurement Organization US - Mexico Border 100 Kilometer Indicator
		OPO_US_MEXICO_BORDER_100KM_IND
		Organ Procurement Organization US - Mexico Border 100 Kilometer Indicator; La Paz Agreement; U.S. - Mexico Border 100 Kilometer Indicator
		This attribute represents the U.S. - Mexico Border 100 Kilometer Indicator is a HRSA Data Warehouse (HDW) generated value that indicates whether any portion of the geographic entity cited is within 100 kilometers of the U.S. - Mexico border.
		Public
		HRSA Data Warehouse
		Quarterly
		char(1)
		None.
		The U.S. - Mexico Border 100 Kilometer Indicator flag is determined using a point-in-polygon or polygon intersection spatial analysis. For counties in the contiguous U.S., the valid values are: N : indicates that no part of the entity is within 100 km of the U.S. - Mexico border Y : indicates that at least some portion of the entity is within 100 km of the U.S. - Mexico border All counties and county equivalents outside of the contiguous U.S. have a null value for this data element. For HRSA grants data the location is the grantee address as designated in the HRSA Electronic Handbook at the time of the most recent data refresh. For HPSA, MUA, and NHSC data the location is either a county, County Subdivision (CSD), Census Tract, or Point (site address). If any piece of the location is within 100 kilometer of the U.S. Mexico border then by HDW convention the entire location is said to be within the 100 kilometer border.
		Expected values are one, character, alphabetic text strings. The valid values are: Y and N. Can be NULL.
		2020/04/24
	
	
		Service Area US - Mexico Border 100 Kilometer Indicator
		SA_US_MEXICO_BORDER_100KM_IND
		Service Area US - Mexico Border 100 Kilometer Indicator; La Paz Agreement; Service Area U.S. - Mexico Border 100 Kilometer Indicator; U.S. - Mexico Border 100 Kilometer Indicator
		This attribute represents the HRSA Data Warehouse (HDW) generated value that indicates whether any portion of the geographic entity cited is within 100 kilometers of the U.S. - Mexico border.
		Public
		HRSA Data Warehouse
		Semi-annually
		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.
		2018/09/06
	
	
		Transplant Service List
		Service_Lst
		Transplant Service List
		This attribute represents the transplant service list of all the organ transplant types performed by a given organ transplantation center.
		Public
		HRSA Data Warehouse
		As Required
		varchar(200)
		None.
		Concatenation of all transplantation services offered at a transplantation center, separated by commas.
		Expected values are either lists of title case, alphabetic text strings that are delimited with commas or the empty string. For example, "Kidney, Liver"; "Heart, Kidney, Liver, Lung, Pancreas"; "Kidney"; or "Heart, Intestine, Kidney, Liver". Cannot be NULL.
		2016/05/27
	
	
		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
	
	
		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
	
	
		Site Web Address
		SITE_URL
		Site Web Address; Site URL; Site Website; Website
		This attribute represents the Uniform Resource Locator (URL) or internet address for the organization or entity associated with the specified record.
		Public
		HRSA, Bureau of Primary Health Care (BPHC)
		Daily
		varchar(200)
		None.
		None.
		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.
		2016/05/01
	
	
		Center City
		CTR_CITY
		Center City; City
		This attribute represents the city name in which the entity is physically located.
		Public
		HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		As Required
		varchar(50)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		Expected values are city names formatted in mixed case. For example, Birmingham. Cannot be NULL.
		2018/09/01
	
	
		Center Postal Code
		CTR_ZIP_CD
		Center Postal Code; Center ZIP Code; Center Zone Improvement Plan Code; ZIP Code
		This attribute represents the portion of the address identifying the primary postal code in which the entity is physically located. The postal codes which the HRSA Data Warehouse uses are the U.S. Postal Service (USPS) Zone Improvement Plan (ZIP) postal code as defined by the USPS. The center ZIP code consists of five or nine numerical digits.
		Public
		HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		As Required
		varchar(25)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		Expected values are 5 or 10 character numeric text strings in the HRSA Data Warehouse postal code format (either #####-#### or #####). For example, 20852 or 96780-1357. Can be NULL.
		2018/09/01
	
	
		Center State Abbreviation
		CTR_STATE_ABBR
		Center State Abbreviation; State
		This attribute represents the U.S. Postal Service two-character abbreviation that identifies the U.S. state or U.S. territory in which the center is located.
		Public
		HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		As Required
		char(2)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		Expected values are two character alphabetic text strings representing the U.S. states and territories as defined by the U.S. Postal Service. The valid values are: XX; AK; AL; AR; AS; AZ; CA; CO; CT; DC; DE; FL; FM; GA; GU; HI; IA; ID; IL; IN; KS; KY; LA; MA; MD; ME; MH; MI; MN; MO; MP; MS; MT; NC; ND; NE; NH; NJ; NM; NV; NY; OH; OK; OR; PA; PR; PW; RI; SC; SD; TN; TX; UM; UT; VA; VI; VT; WA; WI; WV; and WY. Can be NULL.
		2018/09/01
	
	
		Center Address
		CTR_ADDRESS
		Center Address; Street Address
		This attribute represents the street address where the entity is physically located.
		Public
		HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		As Required
		varchar(100)
		None.
		Changed, as necessary, as part of the HRSA Data Warehouse address standardization process.
		Expected values are text strings with the building numbers, street names, and possibly suite numbers (with dashes, parenthesis, or other punctuation) formatted in mixed case. For example, 665 Opelika Rd Ste 100. Cannot be NULL.
		2018/09/01
	
	
		Center Telephone Number
		CTR_PHONE_NUM
		Center Telephone Number; Center Telephone; Phone Telephone
		This attribute represents the main telephone number for a center.
		Public
		HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		As Required
		varchar(25)
		None.
		(1) This is a common attribute name which can have different sources depending on the data mart. (2) Changed, as necessary, as part of the HRSA Data Warehouse phone number standardization process. All non-numeric characters are deleted.
		Expected values are telephone numbers with a the HRSA Data Warehouse standard format of 999-999-9999, x9999 (the x9999 represents the telephone extension). For example, 703-555-1212; 808-555-1212 x189; or 202-555-1212. Can be NULL.
		2018/09/01
	
	
		Center Name
		CTR_NM
		Center Name
		This attribute represents the center name of the entity.
		Public
		HRSA, Bureau of Health Workforce (BHW), Office of Health Careers; National Migrant & Seasonal Head Start Collaboration Office (NMSHSCO)
		As Required
		varchar(100)
		None.
		This is a common attribute name which can have different sources depending on the data mart.
		Expected values are text strings, exactly as provided by source. Cannot be NULL.
		2018/09/01
	
	
		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
	
	
		Organ Procurement Organization State Registry Uniform Resource Locator
		ORG_STATE_REGISTRY_URL
		Organ Procurement Organization State Registry Uniform Resource Locator; Organ Procurement Organization State Registry Uniform Resource Locator; State Registry Uniform Resource Locator; State Registry Website Address; State Registry Uniform Resource Locator; State Registry Website Address
		This attribute represents the Uniform Resource Locator (URL) or website address for the State Registry where users could sign up to become an organ, eye, and tissue donor.
		Public
		Organ Procurement and Transplantation Network (OPTN)
		Monthly
		varchar(200)
		None.
		None.
		Expected values are alphanumeric text strings which include special and punctuation characters for web sites, generally a HTTP URL consists of the following: scheme name (commonly called protocol), a colon, two slashes, a host (normally given as a domain name but sometimes as a literal IP address), optionally a port number, and full path of the resource. For example, http://en.wikipedia.org/wiki/Uniform_resource_locator. Cannot be NULL.
		2018/09/01
	
	
		Organ Procurement State Registry Unique Record Identification Number
		ORG_STATE_REGISTRY_ID
		Organ Procurement State Registry Unique Record Identification Number
		This attribute represents the unique identification number used by the HRSA Data Warehouse to identify a specific State Registry. This unique identification number is a system generated number for the internal and system uses by the HRSA Data Warehouse.
		Public
		HRSA Data Warehouse
		Monthly
		int
		None.
		This attribute is a surrogate key and is a HRSA Data Warehouse (HDW) generated integer (a one up counter) which uniquely identifies a distinct state registry entity.
		Expected values are non-negative integers. For example, 0, 1; 27; 341; or 3222. Cannot be NULL.
		2018/09/06
	
	
		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
	
	
		Statistic Description
		ORG_STATISTIC_DESC
		Statistic Description
		This attribute represents the textual description of the statistic value being displayed.
		Public
		HRSA Data Warehouse
		As Required
		varchar(50)
		None.
		Determined by the HRSA Data Warehouse extract, transform, and load (ETL) process to be either: Participating 340B Covered Entities (Sites) or Number of Transplant Recipients.
		Expected values are alphabetic, mixed case, title formatted, text strings. The valid values are: Number of Transplant Recipients and Participating 340B Covered Entities (Sites). Cannot be NULL.
		2018/09/06
	
	
		Healthcare Systems Bureau Statistic Value
		ORG_STATISTIC
		Healthcare Systems Bureau Statistic Value; Count
		This attribute represents the actual statistic value (i.e., a count, sum, or average) for the data source and summary level.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation
		As Required
		int
		(1) The data represents the total for the state. (2) For Organ Transplant Statistics, the geographic summary level is the reported state of residence for the transplant recipient (in addition to U.S. states and territories the source data includes records for Not Reported, Foreign Country, Unknown, and Total). (3) Providing state counts of Participating 340B Covered Entities was discontinued in the thrid quarter of fiscal year 2015.
		(1) For Organ Transplant Statistics, there is no transformation to the value when the reported state of residence for the transplant recipient is a U.S. state, U.S. territory, or Foreign Country; however, when residence for the transplant recipient is Not Reported or Unknown the values are summed and that sum is assigned to Not Determined summary record. The record to Total is not loaded but used to validate the loaded data. (2) Participating 340B Covered Entities (Sites): count the number of distinct participating sites at the specific aggregation level. (3) Populating Participating 340B Covered Entities was discontinued in the thrid quarter of fiscal year 2015.
		Expected values are non-negative integers. For example, 0, 1; 27; 341; or 3222. Cannot be NULL.
		2018/09/06
	
	
		Count of Transplant Recipients for Organ Procurement
		ORG_TPLNT_RESP_CT
		Count of Transplant Recipients for Organ Procurement
		This attribute represents the number of transplant recipients for organ procurement.
		Public
		HRSA Data Warehouse
		As Required
		int
		None.
		Count of transplant recipients for organ procurement based upon the summary criteria.
		Expected values are non-negative integers. For example, 0; 1; 21; or 5991. Cannot be NULL.
		2018/09/06
	
	
		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
	
	
		Number of Vascularized Composite Allograft (VCA) Transplant Centers
		TOT_VCA_CTR_CT
		Number of Vascularized Composite Allograft (VCA) Transplant Centers
		This attribute represents the total number of Organ Transplant Centers (OTC) performing Vascularized Composite Allograft (VCA) transplants.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		int
		None.
		Count of the active Organ Transplant Centers which are associated with the Vascularized Composite Allograft (VCA) Program.
		Expected values are non-negative integers. For example, 0; 1; 3; or 27. Cannot be NULL.
		2018/09/06
	
	
		Organ Transplantation Center Program URL
		OTC_PROG_URL
		Organ Transplantation Center Program URL
		This attribute represents the World Wide Web address for the Organ Transplant Center (OTC) program.
		Public
		HRSA, Healthcare Systems Bureau (HSB), Division of Transplantation; Organ Procurement and Transplantation Network (OPTN)
		Semi-annually
		varchar(200)
		None.
		The HRSA Data Warehouse (HDW) uses the Organ Transplant Center (OTC) Code, OTC Type, and Organ Program associated with the OTC record to create the report web page link. The base string for the web page link is https://report.srtr.org/psr/. The pattern for the web page link is the concatenation of [Base URL], /, [Code], [OTC Type], /, and [Organ Program Code]. The Organ Program codes are hl (Heart-Lung); he (Heart); ki (Kidney); kp (Kidney-Pancreas); li (Liver); lu (Lung); pa (Pancreas); and in (Intestine). HDW would use the base page for the OTC without an organ or for Vascularized Composite Allograft (VCA) and Pancreas for Pancreas Islet.
		Expected values are alphanumeric text strings which include special and punctuation characters for web sites, generally a HTTP URL consists of the following: scheme name (commonly called protocol), a colon, two slashes, a host (normally given as a domain name but sometimes as a literal IP address), optionally a port number, and full path of the resource. For example, http://en.wikipedia.org/wiki/Uniform_resource_locator. Can be NULL.
		2021/05/27
The words contained in this file might help you see if this file matches what you are looking for:

...Sheet dd org opo metadata vx attribute name physical column user friendly names definition data restriction organization update frequency type business rule format hdw transformation valid values date geocoding artifact object identification number objectid id spatial this represents the table unique internal feature record as required by arcgis there is no requirement or expectation that a given has ldquo persistent rdquo value from one class to next long in public hrsa warehouse int none common element which may be used multiple marts at time of mart refresh entered snapshot current state and not refreshed until each expected are integers for example cannot null congressional district cong dist nm us house representatives nvarchar states with two more created concatenating word quot applicable single representative words large columbia where special representation delegate territories territory either resident commissioner appropriate only text strings alabama can geometry shape geog...
Related files

Share

Help

Related files

Share

Share to social media

Help

Login Area
