v1.7.0 Release

We're excited to announce version 1.7 of METL!

This release adds several new lookup tables that assist in reporting, data analysis, and even typical transactional claims processing, a bunch of foundational features that will be enabled in future releases, and some other data improvements surrounding EDI 837 claim storage.

What's new?

New lookup data

1. Horizon Blue Cross Case Management trigger list.
2. CPT hierarchy.
3. ICD diagnosis hierarchy.
4. ICD procedure hierarchy.
5. JHU wasteful drugs lookup.
6. Bill Type to Place of Service crosswalk.
7. Place of Service groups.
8. Stop loss trigger diagnosis codes.

Other table changes

1. Remove deprecated name, contact_seen, name_given, provider_identification, member_identification, member_member_eligibility, and claim_member_match tables.
2. Updates to the claim table to align the database and the EDI 837 parsing.

New tables to support upcoming features

1. member_canonical table. This replaces the member table and represents a canonical human represented ideally by a unique SSN number.
2. name_given_alias, claim_member_to_member_seen_match and member_seen_to_member_seen_match. These tables are used for patient matching between eligibility loads and from claim to eligibility data. They are used for both manual and automated patient matching.

Release details

Claims: Pull Request: N/A, Commit hash: 1598e50

METL-deploy (no change since 1.6): Pull Request, Commit hash: 3b9ed72

Monorepo (Not public, but added here for documentation. We expect to open source extractor and csvloader in the future): Pull Request