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

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.