6 January 2025
- Add table attestation_report to store data for Developer Attestation Power BI report
- Add 2025 CQM bundle
- Add INVITATION type of activity
18 December 2024
- Add report metadata for the Service Base URL Listing report
9 December 2024
- Add Criteria Attributes report metadata
25 November 2024
- Add table for Report Metadata
- Add column to Activity table to store Cognito guid
- Use correct regtext for 170.213 v4 SVAP value
28 October 2024
- Add tables to store complaint type mappings to complaints
14 October 2024
- Add fields to listing_search view for CAP counts
- Clean up multiple spaces in user-entered data
30 September 2024
- Add ONC-ACBs with withdrawn/suspended listings to developer_search view
- Add friendly_id fields for test tasks and participants
3 September 2024
- Backfill 170.210(g) standard on certain listings
19 August 2024
- Add table to store forgot password token
- Create view for subscription notifications
- Add column for time user was notified of subscribed item change
- Backfill notification timestamp for subscription observations
5 August 2024
- Remove tables related to cures update statistics
22 July 2024
- Add criteria in 'Requirement' dropdown for 'Requirement Type' = Inherited Certified Status
- Create view for inactive products
8 July 2024
- Add tables to support Criteria Migration Report definition and data
- Remove 'statuses' field from old developer activity
- Set start/end days for all developer status entries
- Delete duplicate developer status change data
24 June 2024
- Remove incorrectly added listing 15.04.04.3195.Prom.07.00.0.240604
- Convert 170.210(a)(2) from Standard to Optional Standard
10 June 2024
- Remove certification id activity
28 May 2024
- Do not require P&S for b11
- Add 3 new subscription subjects to existing subscriptions
- Add new subscription types for URL updates on listing
- Update some optional standards, add some new ones
14 May 2024
- Add new column user_group_name and populate it
- Create developer_search view
29 April 2024
- Add additional columns to support inviting users with other roles
- Update Activity and Questionable Activity to incorporate Cognito users
- Update Companion Guide URL for 170.315 (a)(5)
- Add activity types for SVAP, Standards, and Functionality Tested activity
1 April 2024
- Add new user invitation table to support invited Cognito users
- Add table to support updated criteria status report
- Drop table that was never used for quarterly report exclusions
- Migrate surveillance process type to many-to-many relationship
- Insert a questionable activity trigger for removed code set(s)
- Add 170.315(f)(5)(i) standard to any listing with (f)(5)
- Change surveillance process type 'Other - [Please Describe]' to 'Other'
5 March 2024
- Add Code Set functionality to selected criteria
- Change certification status calculation for many views
- Remove three views our API is no longer using
- Delete standards 170.204(a)(1) and 170.204(a)(2)
- Add questionable activity trigger for future cert status
20 February 2024
- Allow SED for b11 criterion
5 February 2024
- Create new report table for listings that need to be updated for HTI-1
- Populate all historical listings with Standards
- Add column group_name to standard table
- Set b11 start date to March 11, 2024
- Remove d14 criterion
8 January 2024
- Add last_modified_sso_user column to all tables
- Add views for RWT urls by developer
- Create subscription_search_results view
- Create view for listing subscriptions to get CHPL Prod Nbr
- Backfill Certification Results for 2014 Listings
- Add Certification Criterion URL type for url report
- Add companion guide link to criteria where available
11 December 2023
- Create tables for Standards
- Update eCQM numbers and versions for 2024 reporting bundle - CMS 314
- Add new types of questionable activity
- Remove Cures Update from all criteria titles
27 November 2023
- Add risk management summary information to certification result table
- Update eCQM numbers and versions for 2024 reporting bundle
- Include requirement/non-conformity types with null edition
- Insert allowed conformance methods for b11, d14
- Add two new criteria that become active in the future
`
13 November 2023
- Remove "unattested criteria" from Listings in data
16 October 2023
- Remove certification_criterion 'removed' column
- Set empty string values for certified products to null
2 October 2023
- Data cleanup for Functionality Tested
18 September 2023
- Add columns to Functionality Tested to support HTI-1
- remove test_tool.required_day column
- Remove 'XX' code from CHPL Prod Number calculated in view
- DEV->ACB Map excludes edition; only considers status
- Add criteria start and end dates
5 September 2023
- Drop tables related to unused portion of Cures Statistics Report
- Add start day, end day, and rule to criterion table
- Mark GAP Medicaid g1/g2 measures as Removed
- No 2015 criteria may have test procedures
21 August 2023
- Allow subscriber role to be null
7 August 2023
- Update tables to support Test Tools and HTI-1
- Add future Attestation Periods
24 July 2023
- Track and analyze (g)(10) Service Base URL List availability
- Add test standards to certification_criterion_attribute table
- Add SED to certification_criterion_attribute table
- Add additional software to certification_criterion_attribute tbl
- Add attestation answer to certification_criterion_attribute table
- Add G2 Success to certification_criterion_attribute table
- Add G1 Success to certification_criterion_attribute table
- Add Use Cases to certification_criterion_attribute table
- Add Documentation URL to certification_criterion_attribute table
- Add export documentation to certification_criterion_attribute tbl
- Add API Documentation to certification_criterion_attribute table
- Add GAP to certification_criterion_attribute table
3 July 2023
- Store Change Request message with attestation responses
26 June 2023
- Drop accredidation_number column for ONC-ATLs
- Convert retirement_date columns from timestamp to date
- Create tables to support public user subscriptions
12 June 2023
- Add tables for storing url monitoring data
- Remove ROLE_ONC_STAFF and related users
- Soft-delete ROLE_ATL role, ONC-ATL mappings, and users with the ROLE_ATL role
30 May 2023
- Create combined questionable activity view
- Remove activity that has no real changes
15 May 2023
- Add SVAP data to listing_search view
- Clean up questionable activity
1 May 2023
- Remove listing_modified_date from listing validation report table
19 April 2023
- Add reason column to activity table
- Add activity_id column to all questionable activity tables
i* Rename Current Certification Date Changed Questionable Activity trigger
3 April 2023
- Remove duplicate attestation submission data
- Add Functionalities Tested as an option for 170.315 (b)(3) Cures Update criterion
20 March 2023
- Insert privacy_security_framework as criteria attribute
- Remove existing P&S Framework values for b10
6 March 2023
- Remove developers that have no listings
21 February 2023
- Delete columns from ICS Errors Report that could be derived
6 February 2023
- Remove edition relationship from functionality tested
- Rename test_functionality tables functionality_tested
- Set up Attestation data for Period 3 attestations
- Add functionality tested to criterion_attribute table
23 January 2023
- Remove legacy measure mapping tables
- Remove fuzzy_choices table
- Remove incorrectly uploaded Listing
- Add "Inherited Certified Status" surveillance requirement type
- Add Questionable Activity type for cures update removal
- Create ROLE_STARTUP to have permission to tomcat startup apis
- Stop including deleted ics relationships in views
9 January 2023
- Stop prepending NQF- to listing_search view CQM data
- Modify Surveillance Requirement and Non-conformity values
12 December 2022
- Remove unused view aggregated_nonconformity_statistics
- Drop "pending" surveillance tables
- Drop table nonconformity_documents
- Remove "key" column from ehr_certification_id table
- Remove extra space in complainant type name
- Update complainant type to simply be 'Other'
- Correct (c)(3) attested criteria vs CQM criteria mismatch
28 November 2022
- Add column for Test Data Criteria attribute and populate it
- Update ucd_process name to be 'text' instead of 200 chars
- Convert sed_testing_end from timestamp to date
- Remove unsent notifications for removed properties and endpoints
14 November 2022
- Add new views for Surveillance Requirement & Non-Conformity Types
- Alter product ownership transfer date from timestamp to date
- Add new Questionable Activity Trigger for non-active Certificate edits
- Add and modify Surveillance Requirement and Non-Conformity Types
- Include Withdrawn by Developer Under Surveillance in decertified date calculations
31 October 2022
- Delete developer, product and version activity events without meaningful changes
17 October 2022
- Add 2023 eCQM versions and measures
3 October 2022
- Remove tables related to old Attestation format
- Delete orphaned version and related activity
- Append b10, d12, d13, and g10 with "(Cures Update)" title
19 September 2022
- Add new Questionable Activity triggers for Real World Testing updates
6 September 2022
- Drop old deprecated usage tables and create new deprecated usage tracking table
- Drop all pending certified product tables that are no longer used
- Add table to support associating ONC-ACBs to change requests based on the type of change request
- Add column to attestation form table to include submission instructions
- Allow SVAP to be connected to h1 and h2
- Set Attestation Period dates for Periods 2 and 3
22 August 2022
- Add tables to support Attestation Optional Responses and migrate data from original tables
- Allow SVAP to be associated with correct criteria
8 August 2022
- Add script to truncate the shared_store.shared_store table
25 July 2022
- Remove API endpoints with no more deprecated fields as of 5/15/22
- Remove deprecated response fields eligible as of 5/15/22.
- Add deprecated endpoints related to modifying attestations from previous periods
11 July 2022
- Add deprecated field mappings for surveillance requirementName and nonconformityTypeName. Add deprecated endpoints for nonConformity document upload and delete.
6 July 2022
- Add/Remove "Touchstone" related testing options
- Remove invalid g10 measure mapping to EC measure
27 June 2022
- Mark /change-requests endpoint as deprecated and remove it from the deprecated_response_field_api table
- Update conformance method name from "Touchstone" to "Drummond G10+ FHIR API powered by Touchstone"
13 June 2022
- Add removal date to Conformance Method table and give a removal date for 'NCQA eCQM Test Method'
- Add "Touchstone" as an available Conformance Method
- Add deprecated response fields for developerId, productId, and versionId
6 June 2022
- Combine Developer Details and Website Change Request to Developer Demographics Change Request
31 May 2022
- Remove deprecated endpoint and response fields eligible for deletion
- Remove deprecated endpoint that has always been behind a flag
16 May 2022
- Add schema and table to support 'shared-data'
- Repair erroneous Cures update events
2 May 2022
- Remove deprecated APIs and Response Fields that had a removal date of 4/15/22.
- Indicate deprecated Announcement API & field data
13 April 2022
- Add previous CHPL Product Numbers into search view
- Create table to store CHPL Product Number changes over time for each Listing
1 April 2022
- Add Attestations Requirement value for Surveillance
- Deprecate bulk reject of pending Listings
22 March 2022
- Add table to support attestation period exceptions for developers
- Add listing_search view to support /search/v2 endpoint
- Update developer_certification_body_map view to filter for 2015 and active certificates
7 March 2022
- Remove transparency attestation from tables and columns
22 February 2022
- Add tables to support new Attestation change request submission process
- Deprecate original upload/confirm/reject endpoints; remove some endpoints with deprecated response fields where the endpoint itself is now deprecated
24 January 2022
- Add data to support notifying users of deprecated Transparency Attestation response field
10 January 2022
- Update unique constraint on deprecated api usage tables
9 December 2021
- Update Test Standard to 2015 version on 2 Listings
29 November 2021
- Add Real World Testing Plans Url and Real World Testing Results Url to certified_product_search view
- Update Optional Standards mapping and values
- Add deprecated API for /collections/certified-products
15 November 2021
- Remove authority/user_permission_id field from tables and views
- Add new surveillance requirement type and questionable activity triggers
- Add deprecated fields to table data for authority / user permission changes
1 November 2021
- Add tables to support improved Cures Reporting reports new charts
- Add deprecated response field usage tables and data
- Remove the unused nonconformity_status table and related columns from the database
- Add structures to support Conformance Method
- Update additional eCQM numbers and versions for 2022 reporting bundle
18 October 2021
- Store "estimated removal date" of deprecated API endpoints
- Add Promoting Interoperability Updated by ONC-ACB as a type of Questionable Activity
- Insert approved "Optional Standards" as per ONC guidance
5 October 2021
- Revise list of test tools to select for a 2015 Edition listing
7 September 2021
- Use consistent names for Quarterly Surveillance table
31 August 2021
- Remove Real World Testing Eligibility Year and view references
- Rename "Transparency Attestation URL" as "Mandatory Disclosures"
23 August 2021
- Add new NON_CONFORMITY_CLOSE_DATE field
- Add new eCQM versions for 2022 reporting bundle
- Restrict Surescripts from being used as a Test Procedure for 170.315 (b)(3) Cures Update
9 August 2021
- Add Attestation change request table
- Add tables to track deprecated API usage
- Add status column to listing upload table
2 August 2021
- Add table for Pending Optional Standards
- Rename meaningful_user_user to promoting_interoperability_user
- Add Questionable Activity Trigger for Real World Testing without Eligibility
28 June 2021
- Remove requirement for Phone Number for users
- Add support for Optional Standards
- Remove leftover reference to openchpl.job in soft delete triggers
- Ignore deleted developer status history entries in a view
2 June 2021
- Update README documentation
- Add certification status event history to certified_product_search view
- Add tables to store cures-related statistics
17 May 2021
- Remove tables related to background jobs
- Add chpl product number to surveillance_basic view
- Allow criteria to have Service Base URL List data
4 May 2021
- Add table for holding new api key requests
- Add processing column to pending_certified_product table
- Do not soft delete test participants if test task references multiple criteria
19 April 2021
- Remove erroneously uploaded Listings
5 April 2021
- Remove the v18 upload template
22 March 2021
- Undelete Summary Statistics data for use in the attached pdf
- Allow saving of ONC-ATL report filter
8 March 2021
- Remove Spring 'acl_' tables
- Allow saving of HTTP METHOD in API Key activity table
- Add column to support SVAP Notice URL
- Add v20 upload template (includes old b3 criterion)
- Remove export surveillance report background job types
22 February 2021
- Remove references to unused g1/g2 macra measure tables
- Add new table to support certification criterion attributes
- Add developer ID to certified_product_search view
- Add new table to support Listing Validation Report
- Add missing mappings between g1/g2 measures and cures criteria
- Add missing removed measures for cures criteria
8 February 2021
- Add table to support flexible upload processing of Listings
- Add missing measure mappings for Cures Updated criteria
- Remove erroneously added Listing 15.04.04.2964.Inte.18.01.1.200828
25 January 2021
- Add tables to support SVAP
- Add missing soft delete triggers for developer-related tables
11 January 2021
- Change column type of audit.logged_actions activity date
28 December 2020
- Add Clinical Quality Measure for CMS 529
14 December 2020
- Move G1/G2 measures from criteria to listing level
- Make "username" optional for users
- Enable ROLE_ONC_STAFF user type
16 November 2020
- Remove friendly name from product and developer points of contact
19 October 2020
- Add new data elements for Real World Testing
21 September 2020
- Add Stage 3 macra measures for (a)(1), (a)(2), and (a)(3)
- Add new CQM version and add new versions to existing CQMs for 2021 reporting bundle
18 August 2020
- Rename 'whitelisted' column to 'unrestricted' in api_key table
10 August 2020
- Add Real World Testing Eligibility Year to table and views
- Convert columns from ACB name to ACB Id
27 July 2020
- Update certified_product_summary view to handle status events correctly
13 July 2020
- Fix typo in Macra Measure Description fields
- Add ability to save ONC-ACB Activity Report filter
24 June 2020
- Remove invalid constraint for cert result and macra measures
15 June 2020
- Mark some Questionable Activity concepts as removed
- Add Filter Type for Complaints search
- Remove length limit from pending CP Source Grouping
18 May 2020
- Add missing audit triggers
- Make pending fields 'text' type
20 April 2020
- Add table for developer details change request
- Add Developer Details change request type
8 April 2020
- Add table to store Listing Cures Update status
- Add new questionable activity trigger type for d2, d3, and d10 activity
23 March 2020
- Join criterion id into pending surveillance and nonconformity statistics
- Add self-developer column to pending listings
9 March 2020
- Change views to use ID instead of Number for Certification Criteria
20 February 2020
- Add new data types for URL check job
11 February 2020
- Add new Test Tool
- Mark the v17 2015 upload template as removed.
- Add Self-Developer element to Developer information
27 January 2020
- Support four new types of criterion data points
2 January 2020
- Remove Complaint Status Type data
20 December 2019
- Add questionable activity triggers for adding b3 criteria
16 December 2019
- Unretire CDC's NHSN CDA Validator and retire HL7 CDA National Health Care Surveys Validator
- Prevent duplicate rows for listing when duplicate status event exists
2 December 2019
- Add 2020 CQM reporting bundle data
- Add removed column for macra measures; remove 'RT13 EH/CAH Stage 3'
- Add removed column to criteria table
18 November 2019
- Add mapping view between developers and acbs
- Add user permission to change request status
- Add new filter type for API Key Management
4 November 2019
- Add "ONC Test Method - Surescripts (Alternative)" as available Test Procedure
- Make "Not Applicable" an option for Test Tool and Test Data
- Restricted to 170.315 (b)(3) for Data and Procedure
21 October 2019
- Add ROLE_DEVELOPER User type
- Allow ROLE_DEVELOPER to create "Change Requests" to change their Organization's website
- Add 2014 Listing Edit as questionable activity type
7 October 2019
- Add tables and views to support reporting on questionable urls
- Add url_check_result table to store all the results of all urls that have been checked
- Add url_type table as a lookup table of places urls can be found in the system
- Update certified_product_summary view to have developer contact info and certification date
- Add new RT 13, 14, and 15 Macra Measures
23 September 2019
- Add tables to support persisting Website Change Requests
10 September 2019
- Support storing the last logged in date with the user
- Add surveillance basic view to include open/closed nonconformity count
- Add new filter type for API Key Usage report
26 August 2019
- Add ROLE_DEVELOPER
- Create new address for addresses that are re-used by orgs
12 August 2019
- Add privileged surveillance data
- Add lookup tables for surveillance_process_type and surveillance_outcome values
- Add mapping table for privileged data associated with surveillance and quarterly report
- Remove mistakenly uploaded listings
- Add quarterly report and annual report activity type
- Update db_version to be correct
29 July 2019
- Add COMPLAINT as type of activity
- Remove obsolete ACL entries
22 July 2019
- Add open surveillance count, closed surveillance count, and aggregated surveillance dates to the collections view
- Create table complaint_listing_map for storing listings associated with a complaint
- Create table complaint_surveillance_map for storing surveillances associated with a complaint
- Added table quarterly_report_excluded_listing_map to associate an excluded listing with the quarterly report
- Create table complaint_criterion_map for storing criteria associated with a complaint
- Added two background job types: export quarterly surveillance and export annual surveillance
- Add Announcement Report to the filter_type table
17 June 2019
- Create table complaint for storing quarterly surveillance report complaints
- Create table complaint_type for indicating type of complaint
- Create table complaint_status_type for indicating the status of complaints
- Add tables to support quarterly surveillance reporting
- Add user and user action reports to the filter_type table
3 June 2019
- Add tables to support FF4j (feature flags)
- Removed some obsolete tables
20 May 2019
- Create table 'filter' to handle storing user's filters
- Create table 'filter_type' to indicate the type of filter
- Changed user permissions tables so users can have only one role. Old table will be removed in a future release
- Added column user_permission_id to user table
- No longer using global_user_permission_map table
- Changed invitation tables so users can only be invited to have one role. Old table will be removed in a future release
- Added column user_permission_id to invited_user table
- No longer using invited_user_permission table
- Migrated user permission and invitation permission data to new structure. Some users who previously had two roles may notice that their role has changed
- Changed activity concept ATL to TESTING_LAB
- Add listing, developer, product, and version reports to the filter_type table
8 May 2019
- Updated "acb_is_deleted" field in certified_product_details view to be "acb_is_retired"
- Created view "listings_from_banned_developers" to query when constructing the Banned Developers API response
22 April 2019
- Fixed views to handle multiple MUU records with the same effective timestamp
- certified_products_detail
- certified_products_search
8 April 2019
- Add error and warning count to pending listing table
- Update activity concept 'PENDING SURVEIALLNCE' to 'PENDING_SURVEILLANCE'
1 April 2019
- Remove the certification status id reference from the pending_certified_product table
- Mark the Pending certification status as deleted (again)
28 March 2019
- Mark "Pending" Certification Status as deleted
27 March 2019
- Remove obsolete corrective_action_plan tables
- Remove unused certification_event & event_type tables
- Removed unused compliance column from user table
- Removed unused muu_accurate_as_of_date table
- Remove backup ACL tables
- Modify certified_product_summary view to improve perfomance of certification status join
- Add table user_testing_lab_map to store relationship between users and ATLs
- Create temporary backup tables for ACL data
- Mark "Pending" ACB as deleted
- Populate user_testing_lab_map based on ACL tables
- Backup ACL tables and delete those that have ATL related information
11 March 2019
- Add table user_certification_body_map to store relationship between users and ACBs
- Create temporary backup tables for ACL data
- Populate user_certification_body_map based on ACL tables
- Backup ACL tables and delete that have ACB related information
- Changed type of columns in two "pending list" tables to support more generous upload parsing ability
- Retired Test Tool "CDC's NHSN CDA Validator"
- Added Test Tools: "NHCS IG Release 1 Validator" and "NHCS IG Release 1.2 Validator"
25 February 2019
- Add user_permission_id column to pending_surveillance table to track the authority that owns the pending surveillance
- Updated ehr certification id with products view to not include unused columns; speeded things up
- Changed type of columns in two "pending list" tables to support more generous upload parsing ability
- Change Title & Descriptions for some G1/G2 Macra measures
11 February 2019
- Add "retirement date" for ACB and ATL tables
- Restore missing targeted user data
- Change InfoGard => UL LLC in preload data, but not in live data
28 January 2019
- Restrict participant unique id and test task id to be 20 characters
- Add ROLE_ONC to the user_permission table and convert all existing users except Ai's admin account from ROLE_ADMIN to ROLE_ONC
- Update soft delete triggers to include recently added references to certified products
- Remove ROLE_ONC_STAFF permission and convert existing ROLE_ONC_STAFF user accounts to be ROLE_ONC
14 January 2019
- Remove unused Contact fields
- Remove obsolete MUU table; MUU value from certified product
- Remove unused ATL references due to change to multiple ATL capability
- Remove old test functionality reference
- Change type of test task id and test participant id to be text
- Change targeted user name type to be text
- Add and populate Data-Model Version table
- Change a variety of test functionalities to correct values
17 December 2018
- Removed the following tables: notification_type_recipient_map, notification_recipient, notification_type_permission, and notification_type
- Add retired column for certification bodies and testing labs
- Retire ACBs and ATLs currently marked as deleted. Do not mark any as deleted
3 December 2018
- Rename column test_functionality.certification_criterion_id to certification_criterion_id_deleted
- Create new table test_functionality_criteria_map table allowing for many-2-many between test_functionality and certification_criterion tables
- Add column 'reason' to questionable_activity_developer table
- Add user_reset_token table to use with user reset of their password
- Add column to user table to indicate if a password change is required
- Add file_type table to inidcate the type/purpose of a saved file_type
- Add chpl_file table to store files in a byte array format
- Migrate data from test_functionality.certification_criterion_id column to new table test_functionality_criteria_map
- Add data to test_functionality_criteria_map to restrict available functinality tests based on criterion
20 November 2018
- Marked incorrectly uploaded Listing as deleted
19 November 2018
- CQM Criterion table
- Add new versions to 70 existing CQMs
- Add 2 new CQMs
5 November 2018
- Properly handle developer status history in certified_product_details view
- When there was a deleted developer status history that occured at the exact same time, a duplicate row was in the view
24 October 2018
- Include listings without MUU counts in certified_product_summary view
22 October 2018
- Add meaningful_use_user table to capture current and historical muu counts per listing
- Modified all views that calculate meaningful_use_users
- Migrated data from certified_product meaningful_use_users column into new meaningful_use_user table
8 October 2018
- API Key table
- Add column delete_warning_sent_date
- Add column last_used_date
- Add trigger to set delete_warning_sent_date = null when last_used_date is updated
- Add Developer status to search results view
24 September 2018
- Test Standards
- Consolidated some duplicates
- Expanded some multi-rows
- Removed invalid one
- Criteria modifications
- Added Privacy & Security Framework values for missing 170.315 (a)(7) criteria
- Added Test Tools for missing 170.314 (c)(1) criteria
10 September 2018
- Add whitelist column to api key table
- Use "full name" and "friendly name" for users/contacts
- Add reason for developer ban
- Updated UI display values for select G1G2 Macra Measures
- Added new G1G2 Macra Measures
27 August 2018
- Add table for inherited certification status errors report
- Add table for broken surveillance rules report data
16 August 2018
- Add new nonconformity statistics table
- Add new summary statistics table
- Add new view for certified products summary
16 July 2018
- Marked 269 Listings as "Withdrawn by Developer"
5 July 2018
- Added column to relate test functionality to practice type
- Added column to relate test functionality to certification criteria
- Updated 2014 test functionalities to have appropriate practice types and certification criterion
18 June 2018
- Create new schema for Quartz Scheduler
- Remove "cache status age app" notification type; replaced by Quartz trigger
4 June 2018
- Create table to hold "new" vs "incumbent" Developer statistics
- Create table to hold number of products and developers with active listings by edition
- Consolidation/rename of test tools
- "Direct Certificate Discovery Tool" + "2015 Direct Certificate Discovery Tool" = "Direct Certificate Discovery Tool"
- "HL7 v2 Electronic Laboratory Reporting (ELR) Validation Tool" + "HL7 v2 Electronic Laboratory Reporting Validation Tool" = "HL7 v2 Electronic Laboratory Reporting (ELR) Validation Tool"
- "Electronic Prescribing" + "ePrescribing Validation Tool" = "Electronic Prescribing"
- "Transport Test Tool" + "Transport Testing Tool" = "Transport Testing Tool"
- "Healthcare Associated Infections (HAI) Validator" -> CDC's NHSN CDA Validator
- "Edge Test Tool" -> "Edge Testing Tool"
- Add activity concept for legacy corrective action plans to distinguish from certified product activities
- Update InfoGard listings Public Test Summary Report and UCD URLs
21 May 2018
- Added table to support criterion/product chart statistics
- Update
certified_product_searchto respect deleted certification_status_events when getting "latest" status name - Update
certified_product_detailsto respect deleted certification_status_events when calculating certification_date and decertification_date columns
- Update g1 and g2 macra measures to their new mappings
- Add two "lost" Listings from legacy CHPL
7 May 2018
- Add 2 new testing tools
23 April 2018
- Added indexes to listing_to_listing_map for improved performance
- Added tables to support multiple ATLs
- Added functions to retrieve CHPL ID
- Added mapping tables
- Migrated data to fill mapping table
- Added Questionable Activity trigger
- Added indexes to listing_to_listing_map for improved performance
- Modified certified_product_details view to respect certification_status_event deleted flag
- Modified certified_product_details view for improved performance
- Modified certified_product_search view for improved performance
- Mark ~1300 Listings as "Withdrawn by Developer"
- Add "Cache Status Age Warning" notification type
- dump.sh - Changed to not include logged_actions table by default. Can use the -i options if you want the table included
- load.sh - Changed to kill existing processes in the DB before DROPing the schema
9 April 2018
- Mark one Listing as deleted. Duplicate due to bug in upload process
26 March 2018
- Added tables to support statistics related to SED Participant demographics:
- Gender
- Age
- Education Type
- Experience Levels
12 March 2018
- Add sed_participant_statistics_count table
- Mark three Listings as deleted
26 February 2018
- Modified certified product questionable activity trigger description
- Added two new types of certified product questionable activity trigger descriptions
- Mark 2015 v11 upload template as deleted
12 February 2018
- Add reason column to some questionable activity tables that can result from listing update
- Add fuzzy_choices table
- Add FK from pending_certified_product to certified_product table to track listings from pending to confirmed
- Add reason for status change column to questionable activity listing table
- Cleanup of QMS Standards, Accessibility Standards, UCD Processes
- Add 3 "duplicate" missing CMS IDs
29 January 2018
- Insert some CMS IDs that were lost due to database issues
17 January 2018
- Add reason column to certification status event table
- Add has qms column to to pendingCertifiedProduct table
- Remove certification status column from certified product table and related references in views. Certification status is now inferred from the most recent entry in the certification status event table for any listing
- Add new surveillance upload job type
- Deprecate 2015 v11 Upload Template
- Added new grouping of CQMs
2 January 2018
- Add 'deleted' column to 'ehr_certification_id_product_map' table
- Add triggers to cascade soft-deletes (and un-deletes)
- Marked deprecated upload templates as deleted
- Make some changes to Listings related to improper uploads
- Set Transparency URLs
- Delete improperly uploaded Listings
18 December 2017
- Rename all test_procedure_temp tables and keys to their final state
- ROLE consolidation
- Change ROLE_ACB_ADMIN to ROLE_ACB
- Change ROLE_ATL_ADMIN to ROLE_ATL
- Remove ROLE_ACB_STAFF
- Remove ROLE_ATL_STAFF
- Mark duplicate ucd processes and qms standards as deleted; point criteria and listings to the appropriate non-deleted record
5 December 2017
- Add test_data and test_procedure_temp tables along with criteria mapping tables for each
- Change test data version and test procedure version character limits to 50
- Point certification result tables to new test data and test procedure foreign keys
- Add v12 2015 upload template
20 November 2017
- Update "new" 2014 upload template to have correct "available_as_of_date"
- Add new view to use for faster API searches
- Remove users.sql file. It is now in Bamboo for anyone who wants a copy
6 November 2017
- Add tables for questionable activity records
- Add New 2014 CHPL Upload Template v2 to upload_template_version
23 October 2017
- Add tables for upload version templates and pending ICS family data
- Update allowable 2015 'Measures Successfully Tested for G1/G2 values
10 October 2017
- Added
openchpl_devuser to role-template - Change ownership of openchpl database to openchpl_dev user
25 September 2017
- Add child and parent column to certified_product_search view
- Remove tables not referenced by API, and with no data
acb_contact_mapatl_contact_mapexperience_typenewer_standards_metstandards_mettest_event_detailstest_result_summary_versiontest_task_resultutilized_test_tool
- Add background job processing tables
11 September 2017
- Migrate participants to be linked to a test task only rather than a test task+certification result. This includes a new table and next time will result in the removal of the old table
- Add "NOT NULL" to all values of Test Tasks & Participants
- Remove unused "Age" column from Test Participants
- Fill in null values of Test Tasks and Test Participants
- Added ocd-1754.sql as optional report that can be run to get phantom criteria associations
- Added ocd-1755.sql as optional file to delete phantom criteria associations (report should be empty after this is run)
14 August 2017
- Increased ICS Code length from 1 to 2; prepended '0' in front of any codes that were previously 1 character
- Add columns to save the user-entered age range and education level of test participants
- Add ONC report types Weekly Statistics and Questionable Activity
31 July 2017
- Update db field lengths to match spec
- Add constraints to db fields for unique CHPL id codes for length and content
- Added file to remove PROD notifications and insert QA ones
17 July 2017
- Create new view for developers collections; combines all developers, transparency attestation urls and acb attestations
- Create new table for pending surveillance validation messages
- Fix typo / extra spaces in G1/G2 Macra measures
3 July 2017
- Add activity concept for pending surveillance
3 July 2017
- Alter ICS column to be an integer instead of varchar
- Added two new report types for ICS inconsistencies
19 June 2017
- Bulk change ICSA Listings Disclosure URLs
19 June 2017
- Add columns to the search view: decertification date, number of meaningful use users, mandatory disclosure url (aka transparency attestation url), and api documentation
22 May 2017
- Add certification_edition_id column to test standards
- Update existing test standards to fix 2014 numbers/descriptions from spreadsheet and remove existing user-entered duplicates
8 May 2017
- Add a required certification edition column to test functionality
- Add tables for recipients and subscriptions to different types of notifications
- Find any current products that have bad values for their criterions' Privacy and Security Framework
- Update values for CQMs with typos
- Find and fix any criteria pointing to test functionality from the wrong edition
24 April 2017
- Add optional contact column to the product table
- Make surveillance requirement and surveillance nonconformity as deleted when parent surveillance is deleted
- Make surveillance requirement have a result of "Nonconformity" when there are nonconformities
10 April 2017
- Add a new table to capture history of vendor status changes
- Replace four surveillance boolean values in the certified_product_search_view with three values listing the counts of:
- surveillance
- open nonconformities, and
- closed nonconformities
27 March 2017
- Add column to surveillance for "role" of creator
- Updated text for G1/G2 Macra measures
13 March 2017
- Remove ACLs for pending certified products
- Added scripts for backup/load of database
27 February 2017
- Added basic search view
21 February 2017
- Add new EH/CAH macra measures for 170.315 (a)(1), (2), and (3)
7 February 2017
- Add tables for macra g1/g2 measures for lookup, certification results, and pending certification results
- Add Meaningful Use User Accurate table, triggers, and row of data with accurate as of date = '11/30/2016'
23 January 2017
- Add new certification status for products
- Add indexes to improve performance
- Set retired to true for Transport Test Tool and Transport Testing Tool
10 January 2017
- Update surveillance migration script to include top-level developer explanation and resolution fields. Change the field start date is pulled from
9 January 2017
- Update surveillance migration script to include top-level summary field
6 January 2017
- Add surveillance tables to the database
- Add pending surveillance tables to the database
- Add meaningful_use_users column to certified_product & certified_product_details
- Add 'Suspended by ONC' and 'Terminated by ONC' to certification_status table
- Replace corrective action plan with surveillance in details view for searching
- Add certification_body deleted column to certified_product_details view
- Add certification_status_event table to store certification status change history. Eliminate use of certification_event and event_type
- Add decertification_date to certified product details view
- Create v-next.sql since some of the update files require a certain order of execution
15 November 2016
- Added script to remove three specific duplicate certified products
- Added product owner history relationship
21 October 2016
- Added vendor_status table and new status foreign key in the vendor table
- Changed testing tool name from 'HL7 v2 Immunization Information System (IIS) Reporting Validation' to 'HL7 v2 Immunization Information System (IIS) Reporting Validation Tool'
- Added ONC Staff role to user_permission table
4 October 2016
- Updated version file to only have one 'modification' to certified_product_details view
4 October 2016
- Modified certification status names previously known as Terminated, Suspended, and Withdrawn. Changed views as necessary
- Added view to merge certification_id, date created, and columns necessary to formulate the CHPL product id
- Remove terms_of_use_url from data model and views
- Added script to find Certified Products with improper CHPL Product Number Code components
- Add retired boolean to test_tool tables and retired Transport Test[ing] Tool
- Added creation_date to certifiedProductDetails view for OCD-897
19 September 2016
- Add two new views: product_certification_statuses and developer_certification_statuses
- Added view for faster /developers call
30 August 2016
- Add ROLE_CMS_STAFF as an available role in the system
- Update legacy CMS IDs with CreationDate
10 August 2016
- Remove visible on chpl (breaks bakcwards compatibility)
- Might need to re-run dev/openchpl_grant-all.sql
2 August 2016
- Bulk update of certification statuses of ICSA products (already loaded)
- Re-populate test functionality table since some values have been edited
- Change many of the description values for test functionality and standards
25 July 2016
- Changed available education types
- Added SED Task Rating Standard Deviation
16 June 2016
- Add
SuspendedCertification Status - Change Certification Status
DecertifiedtoTerminated - Add task rating standard deviation to pending and regular tables
- Do not re-use test procedure versions
13 June 2016
- Add vendor address and contact to certified product view
24 May 2016
- Allowed SED Test Participants to have age ranges
- Drummond transparency updates as of 19 May
- ICSA Labs transparency updates as of 19 May
16 May 2016
- Added ehr_certification_id table and associated triggers, sequences
- Added ehr_certification_id_product_map table and associated triggers, sequences
- Added new CQM CMS Versions IAW
- eCQMs for Eligible Professionals Table April 2016
- eCQMs for Eligible Hospitals Table April 2016
- Remove errant space from a test functionality row
27 April 2016
- Added new columns to corrective action plans for non-certification criteria based nonconformities
20 April 2016
- Added ACLs for system user to ACB/ATL
- Uploaded ICSA k1/k2 attestations
12 April 2016
- Removed non-admin accounts
- Moved & chmod -x all scripts / sql files to avoid resetting database
- Added audit/timestamp triggers to tables missing them
- Updated data model diagram
30 March 2016
- Removed smart quotes from the preloaded education types
- Changed gender column to accommodate 100 characters instead of 1 character
- Added items to preload script
- Allowed
nullfor first names of contacts in ACB
25 March 2016
- Updated to conform with 2015 upload rules
- Additional software grouping
- API Documentation, Privacy & Security
- SED Tasks & Participants
- Added SQL file for k1/k2 transparency insert/updates
- Added CCHIT as ATL
14 March 2016
- Cleaned up unused Certified Product fields
- Changed Transparency Attestation to ENUM / URL to per product
- Added "Targeted Users"
29 February 2016
- Updated data model to support new 2014 upload fields
18 February 2016
- Added vendor website to vendor information
- Combined surveillance and corrective action plans
- Allowed search on corrective action plan statuses
- Removed Additional Software from CQMs
- Updated data model with respect to new 2014 upload
3 February 2016
No significant data model changes
12 January 2016
No significant data model changes
5 January 2016
New and improved features
- Added terms of use and api documentation to the certified product data model
- Added ATL information
- Added vendor-to-ACB mapping to store transparancyAttestation field
New and improved features
- Added terms of use and api documentation to the certified product data model
- Added ATL information
- Added vendor-to-ACB mapping to store transparancyAttestation field
7 December 2015
New and improved features
- Updated data model to reflect required changes in API
Bugs Fixed
- Fixed bug where incorrect CQM counts were reported
13 November 2015
First release