Changelog
Back to All
improved

Sept 13: Updates to data mart schema to reflect lens improvements

September 12th, 2025 by Nicolas Luzarraga

To reflect recent improvements in lens logic, the following changes have been made to the data mart schemas for the LENS_TRANSITION_OF_CARE and LENS_ENCOUNTER tables:

  • LENS_TRANSITION_OF_CARE

    • Added the following fields to the LENS_TRANSITION_OF_CARE table:
      • admitting_location_start
      • emergency_location_id
      • emergency_location_end
      • current_location_id
      • current_location_start
      • behavioral_health
      • non_elective_admission
      • discharge_disposition_code
      • discharge_disposition_display
    • Added new child tables:
      • LENS_TRANSITION_OF_CARE_REASON
      • LENS_TRANSITION_OF_CARE_PARTICIPANT
    • Added lens_encounter_id to LENS_TRANSITION_OF_CARE_AGGREGATED_FROM table


  • LENS_ENCOUNTER

    • Added admit_source_code and admit_source_display values to LENS_ENCOUNTER table
    • Added discharge_disposition_code and discharge_disposition_display values to LENS_ENCOUNTER table (rather than only include in child tables)
    • Added LENS_ENCOUNTER_ADT_MESSAGE child table
    • Added rank and use_code to LENS_ENCOUNTER_DIAGNOSIS

These updates are now live in all customer data marts. Details on these new fields and tables are available in our schema diagrams and data dictionary.