transparency_file

One machine readable transparency in coverage file, as published by a payer under the CMS Transparency in Coverage rule.

Primary Key:

• transparency_file_id

Indexes:

• transparency_file_display_name_last_updated_on_uq (Unique) - display_name, last_updated_on

Column	Data Type	Nullable	Indexed	Description
transparency_file_id	bigint	No	Yes	Snowflake ID of the file
display_name	text	No	Yes	Name the payer lists the file under, which is also the name it is stored on disk as
source_url	text	No	No	URL the file was downloaded from. Payer URLs are often signed and expire, so this is a record of where it came from rather than a way to fetch it again.
category	transparency_category_type	No	No	Which listing the payer published the file under
byte_size	bigint	No	No	Compressed size of the downloaded file in bytes
reporting_entity_name	text	No	No	Entity that published the file, from the file's own header
reporting_entity_type	text	No	No	How the reporting entity describes itself, for example 'Health Insurance Network'
last_updated_on	date	No	Yes	Date the payer states the file's contents were last updated
version	text	No	No	CMS schema version the file declares, for example 2.0.0
loaded_at	timestamp with time zone	No	No	When the load of this file committed. Each file loads in a single transaction, so a row existing means every child row for it is present.