EHI Export Implementation Guide - Local Development build (v0.1.0) built by the FHIR (HL7® FHIR® Standard) Build Tools. 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	Date Time	No	The date and time when the Assessment was created
revision_by	String	No	The EHR User who last updated the Assessment
revision_date	Date Time	No	The date and time when the Assessment was last updated
client_id	Int	No	The key of the facility resident of the Assessment
is_mds	String	No	Yes/No is this an MDS Assessment
assess_type_code	String	No	MDS 3.0 Item Set Code (ISC) for the MDS Assessment
assess_date	Date Time	No	The MDS 3.0 Assessment Reference Date
status	String	No	Assessment completion status code
adl_score	Int	Yes	The RUG Activities of Daily Living (ADL) index score of the Assessment
adl_date	Date Time	Yes	The date and time when the ADL Score was last computed for the Assessment
raps_date	Date Time	Yes	The date and time when the Care Area Triggers (CAT) were last computed for the Comprehensive Assessment
rugs_index	Int	Yes	The Medicare/Insurance RUG Score index for the Assessment
rugs_date	Date Time	Yes	The date and time when the RUG Score was last computed for the Assessment
rugs_error	String	Yes	The error message when the RUG Score was last computed for the Assessment
prov_state	String	Yes	The facility's State abbreviation code assigned when the MDS was created
batch_id	Int	Yes	The key of the submission batch for the Assessment
edited_by	String	No	The EHR User who last edited the Assessment
edited_date	Date Time	No	The date and time when the Assessment was last edited
locked_date	Date Time	Yes	The date and time when the Assessment was last locked
incorrect_assess_id	Int	Yes	The key of Modified or Canceled Assessment
cmi_set_fed	String	Yes	The Federal CMI Weight Set model code used for RUG Score calculation of the Assessment
cmi_set_state	String	Yes	The State CMI Weight Set model code used for RUG Score calculation of the Assessment
rugs_index_state	Int	Yes	The State Medicaid RUG Score index for the Assessment
rugs_error_state	String	Yes	The error message when the state Medicaid RUG Score was last computed for the Assessment
cmi_fed	Double	Yes	The Federal CMI Weight result from RUG Score calculation of the Assessment
cmi_state	Double	Yes	The State CMI Weight result from RUG Score calculation of the Assessment
calc_type_fed	String	Yes	The Federal RUG Score classification method for the Assessment
calc_type_state	String	Yes	The State RUG Score classification method for the Assessment
rugs_date_state	Date Time	Yes	The date and time when the State Medicaid RUG code was last computed for the Assessment
alt_cmi_set_state	String	Yes	The Alternate State CMI Weight Set model code used for RUG Score calculation of the Assessment
alt_calc_type_state	String	Yes	The Alternate State RUG Score classification method for the Assessment
score2	String	Yes	The Alternate State Medicaid RUG HIPPS code for the Assessment
score3	String	Yes	The Alternate State Medicaid RUG index for the Assessment
cmi_code_fed	String	Yes	The Federal RUG HIPPS code for the Assessment
cmi_code_state	String	Yes	The State Medicaid RUG HIPPS code for the Assessment
hipps_modifier	String	Yes	The RUG/PDPM Assessment Indicator (AI) code also known as HIPPS Modifier for the Assessment
submit_by_date	Date Time	Yes	The date by when the MDS Assessment must be submitted
mpaf	String	Yes	Is a MDS 2.0 Medicare Prospective Payment System Assessment Form assessment
assess_ref_date	Date Time	No	The MDS Assessment Reference Date
primary_reason_code	String	Yes	The A0310A Reason for Assessment response value for the MDS 3.0 Assessment
secondary_reason_code	String	Yes	The A0310B Reason for Assessment response value for the MDS 3.0 Assessment
tertiary_reason_code	String	Yes	The A0310C Reason for Assessment response value for the MDS 3.0 Assessment
facesheet	String	Yes	Is a MDS 2.0 Facesheet assessment
doublescore1	Double	Yes	The Alternate State RUG CMI Weight result from RUG Score calculation of the Assessment
cps	Int	Yes	The RUG calualtion Cognitive Performance Scale (CPS) function score for the Assessment
pain_scale	Int	Yes	The RUG calualtion Pain Scale function score for the Assessment
drs	Int	Yes	The RUG calualtion Depression Rating Scale (DRS) function score for the Assessment
communication_scale	Int	Yes	The RUG calualtion Communication Scale function score for the Assessment
adl_short	Int	Yes	The RUG ADL Short function score of the Assessment
adl_long	Int	Yes	The RUG ADL Long function score of the Assessment
adl_hier	Int	Yes	The RUG ADL Hierarchy function score of the Assessment
ise	Int	Yes	The RUG calualtion Index of Social Engagement (ISE) function score for the Assessment
abs	Int	Yes	The RUG calualtion Aggressive Behavior Scale (ABS) function score for the Assessment
chess_score	Int	Yes	The Clinical Hepatic Encephalopathy Staging Scale (CHESS) function score for the Assessment
maple_date	Date Time	Yes	The date when the CIHI Method for Assigning Priority Levels (MAPLe) determination was made
consent_status	String	Yes	MDS 2.0 Assessment Consent status level
consent_reason	String	Yes	MDS 2.0 Assessment Consent status reason
import_process_id	Int	Yes	The key of the MDS Import Assessment batch
import_status	String	Yes	The imported status of the Assessment
verify_id	Int	Yes	The key of the MDS verification log for the Assessment
sub_req	Int	Yes	MDS Submission Required status for the Assessment
prod_assess_id	Int	Yes	The external key of the production Assessment migrated into PointClickCare system
migrate_error	String	Yes	The migration error status description for the Assessment
include_cmi_state_flag	String	Yes	Yes/No to include MDS 2.0 State cmi value
include_cmi_fed_flag	String	Yes	Yes/No to include MDS 2.0 Federal cmi value
raps_type	String	Yes	Comprehensive MDS Section V RAP/CAA Worksheet workflow type code for the Assessment
completed_date	Date Time	Yes	The date and time when the MDS assessment status was set to Complete
effective_cmi_date	Date Time	Yes	The start date and time for the CMI Value of the Assessment
reg_id	Int	Yes	The key of the Facility's Region assignemnt for the Assessment
export_filter_date	Date Time	Yes	The CIHI Consent Export date and time of the Assessment
version_code	String	Yes	MDS 2.0 print eletronic signatures indicator
confirmed_by	String	Yes	The EHR User who validated/confirmed the MDS 2.0 Assessment
confirmed_date	Date Time	Yes	The date and time when the Assessment was validated/confirmed
temp_cmi_fed	Double	Yes	MDS 3.0 RUG 44 to RUG 53 grouper transition CMI value
temp_cmi_code_fed	String	Yes	MDS 3.0 RUG 44 to RUG 53 grouper transition RUG score
temp_rugs_index	Int	Yes	MDS 3.0 RUG 44 to RUG 53 grouper transition RUG index value
inquiry_id	Int	Yes	The key of the Referal Inquiry request for the Assessment
effective_date	Date Time	Yes	The start date and time of the Assessment
ineffective_date	Date Time	Yes	The stop date and time of the Assessment
strikeout_flag	String	Yes	Yes/No indicator denoting the Assessment was struck from the chart
strikeout_desc	String	Yes	The reason the Assessment was struck from the chart
strikeout_by	String	Yes	The EHR User who struct the Assessment from the chart
strikeout_date	Date Time	Yes	The start date and time when struct the Assessment from the chart
used_for_payment	Int	No	Indicator that the Assessment will be used for payment purposes
submission_req	String	Yes	Yes/No indicator that submission is required for the Assessment

sections.csv

Column	Type	Nullable	Description
section_code	String	No	Primary Key for the MDS Assessment
title	String	No	The MDS Assessment Section name
sequence	Int	No	The Assessment Section order indicator
description	String	Yes	Additional Section name information
complete	String	Yes	Section complete status of the Assessment
created_by	String	No	The EHR User who created the Assessment
created_title	String	Yes	The EHR User's title who created the Assessment
created_date	Date Time	No	The date and time when the Assessment Section was created
notes	String	Yes	Comment and notation for the Assessment section

sectionV.csv

Column	Type	Nullable	Description
code	String	No	The MDS Section V Care Area Assessment (CAA) sequence number
description	String	No	The CAA description name
triggered	String	No	Yes/No indicator of if the CAA Care Area Trigger (CAT) is applicatable for the Assessment
documentation	String	Yes	The location and date of EHR User's triggered CAA evaluation documentation for the Assessment
addressed	String	Yes	Yes/No indicator of EHR User's triggered CAA Care Planning Decision for the Assessment
triggered_by	String	Yes	The CAA's reasoning for triggered status
signed_by	String	Yes	The EHR User who afrimed/signed the CAA as complete
signed_position	String	Yes	The EHR User's title who afrimed/signed the CAA as complete
signed_date	Date Time	Yes	The date and time when the CAA was afrimed/signed as complete

pdpmScores.csv

Column	Type	Nullable	Description
model_id	Int	No	The key of the Federal PDPM CMI Weight Set model for the Assessment
hipps	String	Yes	The Federal PDPM HIPPS score for the Assessment
clinical_category	String	Yes	The Diagnosis Clinical Category assigned to the Assessment based upon I0020B response
pt_cmi	Double	Yes	The PDPM calculation Phyiscal Therapy (PT) CMI weight set value result for the Assessment
ot_cmi	Double	Yes	The PDPM calculation Occupational Therapy (OT) CMI weight set value result for the Assessment
pt_ot_group	String	Yes	The PDPM calculation PT/OT Component Group score for the Assessment
pt_ot_clinical_category	String	Yes	The PT/OT Clinical Category assigned to the Assessment
pt_ot_function_score	Int	Yes	The PDPM calculation PT/OT function score for the Assessment
slp_cmi	Double	Yes	The PDPM calculation Speech Language Pathology (SLP) CMI weight set value result for the Assessment
slp_group	String	Yes	The PDPM calculation SLP Component Group score for the Assessment
slp_cognitive_level	String	Yes	The PDPM calculation SLP Cognitive Level for the Assessment
slp_clinical_category	String	Yes	The SLP Clinical Category assigned to the Assessment
slp_bims_score	Double	Yes	The PDPM calculation Brief Interview for Mental Status (BIMS) score for the Assessment
nta_cmi	Double	Yes	The PDPM calculation Non-Therapy Ancillary (NTA) CMI weight set value result for the Assessment
nta_group	String	Yes	The PDPM calculation NTA Component Group score for the Assessment
nta_function_score	Int	Yes	The PDPM calculation NTA function score for the Assessment
nta_cmi_hiv	Double	Yes	The PDPM calculation HIV NTA CMI weight set value result for the Assessment
nursing_cmi	Double	Yes	The PDPM calculation Nursing CMI weight set value result for the Assessment
nursing_group	String	Yes	The PDPM calculation Nursing Component Group score for the Assessment
nursing_category	String	Yes	The PDPM calculation Nursing Category level for the Assessment
nursing_function_score	Int	Yes	The PDPM calculation Nursing function score for the Assessment
conditions_services	String	Yes	The PDPM calculation Nursing Condition description for the Assessment
conditions_services_present	String	Yes	The PDPM calculation Nursing Condition present for the Assessment
acute_neuro_flag	Int	Yes	The Yes/No of PDPM Acute Neurologic is effective for the Assessment
swallowing_dis_flag	Int	Yes	The Yes/No of PDPM Swallowing Disorder is effective for the Assessment
mech_alt_diet_flag	Int	Yes	The Yes/No of PDPM Mechanically Altered Diet is effective for the Assessment
depression_flag	Int	Yes	The Yes/No of PDPM Depression is effective for the Assessment
STATE_PDPM_OBRA_CD	Int	Yes	The Yes/No of the State's participation in PDPM results for the Assessment
state_cmi_model_id	Int	Yes	The key of the State PDPM CMI Weight Set model for the Assessment
state_hipps	String	Yes	The State PDPM HIPPS score for the Assessment
state_pt_cmi	Double	Yes	The PDPM calculation State PT CMI weight set value result for the Assessment
state_ot_cmi	Double	Yes	The PDPM calculation State OT CMI weight set value result for the Assessment
state_slp_cmi	Double	Yes	The PDPM calculation State SLP CMI weight set value result for the Assessment
state_nta_cmi	Double	Yes	The PDPM calculation State NTA CMI weight set value result for the Assessment
state_nursing_cmi	Double	Yes	The PDPM calculation State Nursing CMI weight set value result for the Assessment

score.csv

Column	Type	Nullable	Description
description	String	No	The RUG or PDPM calculation score type title
score	String	Yes	The RUG or PDPM calculation score value

sectionVRapProfile.csv

Column	Type	Nullable	Description
code	String	No	The MDS Section V Care Area Assessment (CAA) sequence number
description	String	No	The CAA description name
response_code	String	No	The CAA Question Code
response	String	No	The CAA Question response description
revision_date	Date Time	No	The date and time when the the CAA question response was last edited
revision_by	String	No	The EHR User who last edited the CAA question response

responses.csv

Column	Type	Nullable	Description
assess_response_id	Int	No	Primary Key for the MDS Assessment Response
question_key	String	No	The MDS Question Key assigned to the response value
control_type	String	No	The MDS Question Key user interface data entry control assigned to the response value
title	String	Yes	The MDS Question Title assigned to the MDS Question Key
question_text	String	No	The MDS Question Text assigned to the MDS Question Key
item_value	String	Yes	The last entered MDS Response value assigned to the Question Key
item_description	String	Yes	The text description assigned to the MDS Question Key Response value
revision_by	String	No	The EHR User who last edited the MDS question key response value
revision_date	Date Time	No	The date and time when the MDS question response was last updated
collection_date	Date Time	Yes	The date when the MDS question response was gathered/determined
created_by	String	Yes	The EHR User who first entered an alternate Collection Date for the MDS question
created_date	Date Time	Yes	The date and time when a Collection Date for the MDS question was first entered
long_username	String	Yes	The EHR User Full Name who last updated the Collection Date
revision_by	String	Yes	The EHR User who last updated the Collection Date
revision_date	Date Time	Yes	The date and time when the Collection Date was last updated