EHI Export Implementation Guide - Local Development build (v0.1.0). See the Directory of published versions

Minimum Data Set (MDS) Export

As part of the Electronic Health Information (EHI) Bulk Data Export, the Minimum Data Set (MDS) is included. The MDS data is exported in tabular Comma Separated Value (CSV) files. These files are generated in the following directory structure:

• [Patient ID]
  • [Patient ID].json
  • [Patient ID]-manifest.json
    • assessments
      • [Assessment ID]
        • assessment.csv
        • sections.csv
        • sectionV.csv
        • pdpmScores.csv
        • score.csv
        • sectionVRapProfile.csv
        • responses.csv

All MDS Assessments are contained within the “assessments” directory for the corresponding patient.

File	Description
assessment.csv	Generated one file per MDS Assessment. Contains type and description of the MDS Assessment and other top-level information. All other files generated in the folder pertain to the assessment referenced in this file.
sections.csv	References and identifiers pertaining to individual sections of the MDS Assessment. The sections depend on the assessment type.
sectionV.csv	Additional metadata pertaining to Section V of the MDS Assessment.
pdpmScores.csv	PDPM Scores for the assessment.
score.csv	Additional scoring for the assessment
sectionVRapProfile.csv	RAP Profile for the MDS Assessment
responses.csv	Individual responses were captured per question.

CSV Schema

assessment.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date

sections.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date

sectionV.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date

pdpmScores.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date

score.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date

sectionVRapProfile.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date

responses.csv

Column	Type	Nullable	Description
assess_id	Int	No	Primary Key for the MDS Assessment
name	String	No	Name of the facility where Patient’s MDS was captured
std_assess_id	Int	No	The key of the Assessment Type
description	String	No	The MDS Assessment Type name
created_by	String	No	The EHR User who created the Assessment
created_date