v1.0.0 Release
Introducing METL, the new healthcare data platform and our 1.0 release!
Prior to this release, METL was being used by My Price Health for our claims pricing workflow. With this release, we teamed up with Health Rosetta to share the codebase and build something amazing together. The main feature of the 1.0 release is that we moved our claims schema to a new repository at https://github.com/mypricehealth/claims.
What does METL stand for?
It can really mean whatever you want it to, but here are the ideas we came up with:
- My Price Health Extract, Transform & Load
- Medical Extract, Transform & Load
What is a data platform?
A data platform is a complete system for data import, management, transactional workflows, and reporting.
For now, METL is primarily focused on ETL, but over time, we expect METL will expand far beyond ETL. We'll add UI's and many more capabilities. We hope many healthcare companies will build capabilities on top of of METL to reduce duplication of work and make it easier to cooperate with other healthcare companies. Our goal is to lower the cost of healthcare care in this country by 50% by eliminating administrative costs and making it easier to be healthy and METL is a key part of that effort.
What's new in this release?
The claims schema
These are the items that are included in the new database we've released.
- Tables
- address_canonical
- address_seen
- claim
- claim_adjustment
- claim_coverage
- claim_diagnosis
- claim_drg
- claim_member
- claim_occurrence
- claim_other_subscriber
- claim_procedure
- claim_provider
- claim_value
- hcpcs
- hcup_diagnosis_crosswalk
- hcup_diagnosis_group
- hcup_hcpcs_crosswalk
- hcup_hcpcs_group
- hcup_procedure_crosswalk
- hcup_procedure_group
- icd_diagnosis
- icd_procedure
- line_item
- line_item_adjudication
- line_item_adjustment
- line_item_diagnosis
- line_item_provider
- login
- member
- member_contact
- member_coverage
- member_match_hash
- member_seen
- member_seen_match
- msdrg
- nanpa_area_code
- npi_affiliate
- npi_authorized_official
- npi_ccn_addition
- npi_country
- npi_endpoint
- npi_license
- npi_location
- npi_location_match_addition
- npi_match_hash
- npi_name
- npi_name_match_addition
- npi_other_identifier
- npi_provider
- npi_state
- npi_tax_id_addition
- npi_taxonomy
- nubc_condition
- nubc_occurrence
- nubc_value
- nucc_taxonomy_lookup
- plan
- plan_hierarchy
- plan_role
- plan_solution
- plan_sponsor
- provider_seen
- provider_seen_match
- release
- role
- snowflake_node
- solution
- sql_metrics
- trading_partner
- trading_partner_extract_ncpdp
- trading_partner_extract_text
- trading_partner_extract_x12
- trading_partner_load
- trading_partner_load_claim
- trading_partner_load_enrollment
- trading_partner_load_rx
- trading_partner_sftp
- trading_partner_sftp_sync
- Views
- npi_provider_view
- Functions
- create_read_schema_role
- create_read_write_execute
- drop_read_schema_role
- drop_read_write_execute_schema_role
- insert_addresses
- setup_address_seen_temp
- type_exists
- Roles
- claims_read
- claims_read_write_execute
- read_only
- read_write_execute
- sqitch_readonly
- Enums
- claim_deny_action
- diagnosis_code_type
- enrollment_error_action
- gender_or_sex_code
- geo_precision_type
- medical_or_surgical
- npi_affiliate_type
- npi_endpoint_type
- npi_endpoint_use
- npi_entity_type
- npi_group_type
- npi_identifier_type
- npi_location_type
- npi_name_type
- plan_status
- plan_type
- provider_type
- residential_delivery_indicator_type
- yes_no_response_code
- Lookup data loads
- npi_country
- npi_state
- nubc_condition
- nubc_occurrence
- nubc_value
- solution
- trading_partner
- trading_partner_extract_text
- trading_partner_extract_x12
Release details
Claims: Pull Request, Commit hash: 6ebcc3f