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)))
• release_load_time_check - ((csvloader_succeeded IS NULL) OR ((load_start IS NOT NULL) AND (load_end IS NOT NULL)))
• release_status_check - (extractor_succeeded OR (csvloader_succeeded IS NULL))

Indexes:

• release_extract_start_release_id_idx - extract_start, release_id
• release_release_name_release_version_release_date_deletion_time (Unique) - release_name, release_version, release_date, deletion_time

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	Name of the original input file. 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:
release_id	bigint	No	Yes	Snowflake ID for the release. Generated through expression:
extracted_filename	text	No	No	Name of the output file produced by extractor and loaded. Generated through expression:
extract_start	timestamp with time zone	No	Yes	Time extractor started extracting the file. Generated through expression:
extract_end	timestamp with time zone	No	No	Time extractor finished extracting the file. Generated through expression:
load_start	timestamp with time zone	Yes	No	Time csvloader started loading the file. Generated through expression:
load_end	timestamp with time zone	Yes	No	Time csvloader finished loading the file. Generated through expression:
extractor_succeeded	boolean	No	No	Whether extractor successfully extracted the file. Generated through expression:
csvloader_succeeded	boolean	Yes	No	Whether csvloader successfully loaded the file. Generated through expression:
extractor_log	text	No	No	Logs from extractor. Generated through expression:
csvloader_log	text	No	No	Logs from csvloader. Generated through expression:
deletion_time	timestamp with time zone	Yes	Yes	When the release was deleted. Generated through expression: