release

The list of releases that have been loaded into the database

Checks:

• release_data_check - ((release_version IS NOT NULL) OR ((release_year IS NOT NULL) AND (release_date IS NOT NULL)))

Indexes:

• release_release_name_release_version_release_date_idx (Unique) - release_name, release_version, release_date

Column	Data Type	Nullable	Indexed	Description
release_name	text	No	Yes	The unique name given to each data source such as 'hcpcs'. We do not allow the same release name to be loaded more than once for the same release date and/or version. Generated through expression:
source_filename	text	No	No	The name of the file that was loaded. Generated through expression:
load_timestamp	timestamp with time zone	Yes	No	The time the data was loaded. Generated through expression:
release_version	text	No	Yes	Files may have a date and/or version associated. Note that if only a version is captured (without a date) that lookup by date is impossible. Hence, we usually also supply a date, even if we have to modify the original filename to provide it. Generated through expression:
release_year	integer	Yes	No	Year of data loaded (e.g. 2025). Generated through expression:
release_month	integer	Yes	No	Month of data loaded (e.g. 12 for December). Generated through expression:
release_day	integer	Yes	No	Day of data loaded (e.g. 6 for the 6th day of the month). Generated through expression:
release_date	date	Yes	Yes	Complete date of data loaded. Generated through expression: