Hospital Data Dictionary

Output Column	Description	Methodology
row_id	A unique identifier for each row. This value in combination with the hospital_id should uniquely identify a record.
_row_number	The row number (or object number in the context of JSON formatted MRFs) that the record was created from. Note that a single source row from the raw MRF can result in multiple records created in the instance when multiple codes or multiple payer/plans are specified.
_source_file_name	The internal S3 path where the raw hospital MRF is stored.
created_on	The date and time that the MRF was extracted.
location_id	A UUID for a particular hospital that is unique for a particular year that the MRF is posted for. The same physical hospital will have 2 different hospital_id values for 2 different calendar years.
location_year_month	The year and month (in YYYYMD format e.g. 202412) that the MRF file was last updated. It uses the last_updated_on field if it is present within the file, otherwise it uses the date Serif Health processed the file.
location_template_id	A persistent UUID for a particular hospital. Each year when a hospital posts a new MRF, this ID remains constant and allows for connecting the data extracted from MRFs over time.
health_system_id	A UUID that allows tying together different hospitals belonging to the same health system.
health_system_name	The name of the health system that the hospital belongs to.
indexer_hospital_name	The legal business name of the licensee. This value is the hospital_name obtained from the CMS-HPT.txt file rather than the value found within the MRF file.
location_name	The legal business name of the licensee. This value is the hospital_name obtained from within the MRF file.
last_updated_on	Date on which the MRF was last updated.
hospital_location	The unique name of the hospital location absent any acronyms.
location_address	The geographic address of the corresponding hospital location.
location_state	The state which the hospital location appears under on the CMS-HPT.txt file.
license_number	The hospital license number.
license_state	The licensing state's 2-letter abbreviation.
raw_payer_name	The name of the third-party payer that is, by statute, contract, or agreement, legally responsible for payment of a claim for a healthcare item or service.
cleaned_payer_name	A standardized version of the payer name. For example "UHC" will get standardized to "UnitedHealthcare".
payer_name		The "cleaned_payer_name" if present. Otherwise the "raw_payer_name".
plan_name	The name of the payer's specific plan associated with the standard charge.
payer_product	Valid values: HMO, EPO, PPO, POS, Medicare, Medicaid	Inferred from the payer_name or plan_name that appears on the MRF record.
payer_class	Valid values: Commericial, Exchange, Military, Medicare, Medicaid	Inferred from the payer_name or plan_name that appears on the MRF record.
code_type	The corresponding coding type for the code data element. Example values: CPT, HCPCS, MS-DRG, APR-DRG, APC, RC, etc.
code	A standardized version of the "code" column available in the raw MRF. This value is cleaned using the code_type column.
raw_code	Any code used by the hospital for purposes of billing or accounting for the item or service. This value corresponds with the "code" column from the raw MRF.
description	Description of each item or service provided by the hospital that corresponds to the standard charge the hospital has established.
setting	Indicates whether the item or service is provided in connection with an inpatient admission or an outpatient department visit. Valid values: "inpatient", "outpatient", "both".
modifiers	Include any modifier(s) that may change the standard charge that corresponds to hospital items or services.
drug_unit_of_measurement	If the item or service is a drug, indicate the unit value that corresponds to the established standard charge.
drug_type_of_measurement	The measurement type that corresponds to the established standard charge for drugs as defined by either the National Drug Code or the National Council for Prescription Drug Programs.
standard_charge_gross	Gross charge is the charge for an individual item or service that is reflected on a hospital's chargemaster, absent any discounts.
standard_charge_discounted_cash	Discounted cash price is defined as the charge that applies to an individual who pays cash (or cash equivalent) for a hospital item or service.
standard_charge_negotiated_dollar	Payer-specific negotiated charge (expressed as a dollar amount) that a hospital has negotiated with a third-party payer for the corresponding item or service.
standard_charge_negotiated_percentage	Payer-specific negotiated charge (expressed as a percentage) that a hospital has negotiated with a third-party payer for an item or service.
standard_charge_negotiated_algorithm	Payer-specific negotiated charge (expressed as an algorithm) that a hospital has negotiated with a third-party payer for the corresponding item or service.
estimated_amount	Estimated allowed amount means the average dollar amount that the hospital has historically received from a third party payer for an item or service. If the standard charge is based on a percentage or algorithm, the MRF must also specify the estimated allowed amount for that item or service.
standard_charge_min	De-identified minimum negotiated charge is the lowest charge that a hospital has negotiated with all third-party payers for an item or service. This is determined from the set of negotiated standard charge dollar amounts.
standard_charge_max	De-identified maximum negotiated charge is the highest charge that a hospital has negotiated with all third-party payers for an item or service. This is determined from the set of negotiated standard charge dollar amounts.
standard_charge_methodology	Method used to establish the payer-specific negotiated charge. The valid value corresponds to the contract arrangement.
additional_payer_notes	A free text data element used to help explain data in the file that is related to a payer-specific negotiated charge.
additional_generic_notes	A free text data element that is used to help explain any of the data including, for example, blanks due to no applicable data, charity care policies, or other contextual information that aids in the public's understanding of the standard charges.

No results found