Database Changelog

0.1. 2021-06-18

1. Data affiliation filter

1.0.1. The data with criteria as below:

• node_1_healthbase_id is practitioner and score >= 30.
• node_1_healthbase_id is facility >= 50.
• Delete the particular record if node_1_healthbase_id or node_2_healthbase_id is rogue Entity .
• Take the backup of affiliation tables before performing the filter option.

1.1. 2019-06-18

2. Addition of executives, algorithm improvements and more

2.0.1. NEW

• Added executives to the web app as part of affiliations block
• Included structured titles for executives as VP, C-level, Director and Manager
• Added the ability to search for executives who are also physicians
• Added an executive listing page to search and filter executives by name or facility name
• Added alerts for non-supported browsers (following are supported - Chrome, Firefox and Edge)
• Added segmentation tool link in the IDN analyzer listing page

2.0.2. DATA ENHANCEMENTS

• Scoring enhancements via algorithmic improvements
• Scoring changes to show only strong and very strong relationships in web app for health systems
• Updated ACO data which also gets refreshed much more frequently

2.1. 2018-11-12

3. Enhanced web app with all active facilities

3.0.1. NEW

• Under Healthsystem details page in web app , we show all active facilities owned/affiliated by them and also the practitioners affiliated with them
• Added ability to give feedback on specific data elements

3.0.2. DATA ENHANCEMENTS

• Improved filtering for physicians classification and specialization

3.1. 2018-09-03

4. Detailed information for facilities, Healthsystems and ACOs in web app

4.0.1. FEATURE

• Under Healthsystem details pages, we show all active facilities owned/affiliated by them and also the practitioners affiliated with them
• Health System profile metrics and profile information documents are added to frontend
• ACOs are added to frontend

4.0.2. DATA ENHANCEMENTS

• Parent affiliations enhancements via algorithmic improvements

4.1. 2018-06-08

5. Search and filters in web app

5.0.1. FEATURE

• Added filtering and search functionality to web app at app.gethealthbase.com

5.0.2. DATA ENHANCEMENTS

• Detailed sub IDN structures for all health systems in the database

5.1. 2018-03-21

6. Web app with major facilities and practitioners

6.0.1. NEW

• Released a frontend app (app.gethealthbase.com) which displays all major facilities, physicians with their affiliations

6.0.2. DATA ENHANCEMENTS

• Improved parent roll ups of facilities and practitioners
• Enhancement to affiliation scoring algorithm

6.1. 2017-12-19

7. Geo locations

7.0.1. NEW

All entity tables and entitysummary table now has geo location data. Following tables have two columns geo_latitude and geo_longitude which corresponds to the lat-long co-ordinates of the entity.

1. entitysummary
2. aco
3. asc
4. healthsystem
5. hospital
6. practitioner
7. physiciangroup
8. businessentity
9. rogueentity
10. dialysisfacility
11. federallyqualifiedhealthcenter
12. homehealth
13. hospice
14. intermediatecarefacility
15. mentalhealthcenter
16. nursinghome
17. organprocurementorganization
18. outpatientphysicaltherapy
19. outpatientrehabfacility
20. portablexray
21. psychiatricresidentialtreatmentfacility
22. ruralhealthclinic

7.1. 2017-12-19

8. Parent Affiliations

8.0.1. NEW

This table lists how strongly a Healthcare Professional or Healthcare Organization is connected to a parent. This table includes only details on the final parent and not the intermediaries. Fields are - node_1_healthbase_id - Child healthbase ID node_2_healthbase_id - Final parent healthbase ID score - A score out of 100, denoting the strength of the relationship

8.1. 2017-12-18

9. Diagnosis and Procedure Code for entities

9.0.1. NEW

entitydiagnosiscodemap and entityprocedurecodemap tables added to either give a healthbase_id and get all linked diagnosis_codes and procedure_codes respectively as a result or to give a diagnosis_code/procedure_code and get a list of associated healthbase_ids as a result. Procedure code has an extra filter on procedure_code_type (HCPCS/ICD) available. metadata of claim counts and values are also present.

9.1. 2017-11-08

10. Referral relationships

10.0.1. NEW

Referral relationships between HCOs and HCPs are added to healthbase - affiliationsreferral. The table contains similar structure as affiliations advanced with claims related data in the metadata field.

Fields include:

• id
• node_1_healthbase_id - Child healthbase id
• node_1_label - Child entity type
• node_1_id - Child id on entity table
• node_2_healthbase_id - Parent healthbase id
• node_2_label - Parent entity type
• node_2_id - Parent id on entity table
• metadata - Claim level meta-data related to the referral relationship

10.1. 2017-10-31

11. Improvements to Affiliations advanced

11.0.1. FEATURE

Affiliations advanced table now has practitioner to entity scores available. Each score is on a scale of 0-100. 0 being low affinity and 100 being high affinity.

• score1 column indicates the affinity of a practitioner to work at a specific hospital.
• score2 column indicates the most affiliated practitioners to a specific entity (This column will be available in a future release)

Field primary_relationship is now renamed to relationship_type.

This release also has more granular relationship_types. The current relationship_types are:

11.1. 2017-10-20

12. News alerts (Pulse)

12.0.1. NEW

Healthbase now tracks news alerts on various categories and link them to entities inside the system.

Following news types are available starting today:

• Executive Change - Schema
• Facility News - Schema
• Merger And Acquisition - Schema
• Data Breach - Schema
• Funding - Schema
• Bankruptcy - Schema
• Labour Issue - Schema
• Product Installation - Schema
• Legal Regulatory - Schema

12.1. 2017-09-29

13. Advanced affiliations

13.0.1. NEW

Dynamic affiliations derived from multiple sources with all the available scores is now available on affiliationsadvanced table.

The data fields in the affiliationsadvanced are available here. This has a similar structure to the affiliations table but provides you more details on the type of relationship (primary_relationship) and all the related metadata around the relationships that is derived from various sources including claims and other regulatory filings.

Please note that there will be loops in the relationships as there are billing relationships between some entities that go in either direction.

Referral relationships will be added in an upcoming release.

13.1. 2017-09-20

14. Added is_entity_active flag

14.0.1. NEW

A boolean flag named is_active_entity flag was added to entitysummary table and all other entity tables such as aco, hospital, practitioner, etc. This flag indicates the status (active/inactive) of an entity, based on various attributes including claims and other sources.

14.1. 2017-09-15

15. New cross system identifier for all entities

15.0.1. NEW

A new field which guarantees unique identifier for all the entities inside healthbase called healthbase_id has been added to all the entity tables. This simplifies the queries such as the ones below:

SELECT * from affiliations where node_1_id = 123 and node_1_label = 'hospital';

TO

SELECT * from affiliations where node_1_id = 'HO:452789';

15.1. 2017-09-12

16. Added Entity summary table

16.0.1. NEW

Added a new table entitysummary which has all the entities in the system. This table has a summary including:

• healtbase_id
• name
• state
• address_line_1
• address_line_2

A flag is_active_entity will be added to the table in the next release.