MDS_RECS

Description:

This table contains data on Minimum Data Set (MDS) assessments. An MDS assessment is represented by a Registry Data (RDI) record with a Registry Type (I RDI 26) value of Minimum Data Set.

Primary Key

Column Name	Ordinal Position
REGISTRY_DATA_ID	1

Column Information

	Name	Type	Discontinued?
1	REGISTRY_DATA_ID	NUMERIC	No
	The unique identifier (.1 item) for the registry data record.
2	RECORD_STATUS_C_NAME	VARCHAR	No
	This column stores the record status (hidden, soft-deleted, etc.). May contain organization-specific values: No Category Entries: Soft Deleted Hidden Hidden and Soft Deleted
3	REGISTRY_TYPE_C_NAME	VARCHAR	No
	This column stores the type of registry. May contain organization-specific values: Yes Category Entries: Core Measures ACC-NCDR CathPCI Version 3 and 4 ACC-NCDR EP Device Implant Meaningful Use Quality Measures ACC-NCDR PINNACLE ACC-NCDR AFib Ablation ACC-NCDR CathPCI ACC-NCDR CathPCI Follow-up ACC-NCDR AFib Ablation Follow-Up UNOS Configuration Vermont Oxford Network Quality Measure - Individual Quality Measure - Patient Details Generic Attribution Generic Attribution - External ID Bundle Physician Quality Reporting Summary - Incremental Meaningful Use Summary - Incremental Internal QM Summary - Incremental Physician Quality Reporting Registry Summary - Full Year Meaningful Use Summary - Final Physician Quality Reporting Registry Summary - Half Year Physician Quality Reporting EHR Summary - Full Year Universal Data System Summary Universal Data System Details QRDA-III XML Run Summary Regulatory Reporting Patient Metadata Regulatory Reporting External ID Bundle Metadata Objective Measures - Run Statistics Objective Measures - EP Fact Objective Measures - Patient Fact Objective Measures - Summary Objective Measures - EH Fact My Panel Metrics - Patient Pulse Information RDI Child Record Health and Care Plan UNOS Kidney Recipient Follow-up UNOS Liver Recipient Follow-up UNOS Pancreas Recipient Follow-up UNOS Kidney/Pancreas Recipient Follow-up UNOS Thoracic Recipient Follow-up UNOS Kidney Living Donor Follow-up UNOS Kidney Pancreas Wait List UNOS Liver Intestine Wait List UNOS Thoracic Wait List UNOS Kidney Candidate Registration UNOS Liver Candidate Registration UNOS Heart/Lung Candidate Registration UNOS Heart Candidate Registration UNOS Lung Candidate Registration UNOS Pancreas and Pancreas Islets Candidate Registration UNOS Kidney/Pancreas Candidate Registration UNOS Kidney Recipient Registration UNOS Liver Recipient Registration UNOS Pancreas Recipient Registration UNOS Kidney/Pancreas Recipient Registration UNOS Thoracic Recipient Registration UNOS Kidney Living Donor Registration UNOS Deceased Donor Registration UNOS Deceased Donor Histocompatibility SRTR Kidney Pre-Transplant Data SRTR Liver Pre-Transplant Data SART CORS SART Configuration ACS NSQIP THL Implant Surgical Care Improvement Project Hoitotahto Elinluovutustahto NHSE Admin Pathway Submission - Diagnostic - Current NHSE Admin Pathway Submission - Diagnostic - Weekly NHSE Admin Pathway Submission - Diagnostic - Monthly NHSE Admin Pathway Submission - RTT - Current NHSE Admin Pathway Submission - RTT - Weekly NHSE Admin Pathway Submission - RTT - Monthly NHSE Diagnostic Activity Submission NHSE Diagnostic Planned Waiting Lists NHSE Admin Pathway Submission - Cancer RTT - Current NHSE Admin Pathway Submission - Cancer RTT - Weekly NHSE Admin Pathway Submission - Cancer RTT - Monthly NHSE Admin Pathway Submission - Cancer Treatment - Current NHSE Admin Pathway Submission - Cancer Treatment - Weekly NHSE Admin Pathway Submission - Cancer Treatment - Monthly HH Outcomes HH Adverse Events National POLST Form Ryan White Services Reporting Ryan White CAREWare Reporting Nationale Intensive Care Evaluatie Pediatrische Intensive Care Evaluatie Australian and New Zealand Pediatric Intensive Care Registry Australian and New Zealand Neonatal Network Swiss MDSi MyChart Federal MCSA-5875 State MCSA-5875 Certificate MCSA-5876 CG719K Form CA-17 Duty Status Report CA-20 Attending Physician's Report MCSA-5870 Insulin-Treated Diabetes Mellitus Assessment Form Federal MCSA-5871 Belgium eBirth - Birth Notification Belgium eBirth - Medical Form Fødselsmelding Skatteetaten Medisinsk fødselsregister (MFR) Labour Birth Postpartum Maternal HBHC Birth Child Postpartum Child NICU Child HBHC Abstraction Subabstraction Minimum Data Set Infection Case NHSN Lab Identified Organism Procedure Abstraction COVID-19 Hospital Infections EQRS Submission CMS Registration Form 2728 CMS Death Form 2746 Nephrology Configuration American Heart Association Get With The Guidelines - Stroke IPFQR Abstraction Registry COVID-19 PUI Case Report Building Blocks Registry Certificate of Death Lung Cancer Screening Registry ASCO-QOPI Cancer Outcomes and Services Dataset Perined: Kernset Aanleverbericht THL: Congenital Malformations Family Planning Annual Report IRF-PAI CMG Data 60% Rule Data CMG Score Config Data Map IGC Data IRF IGC Spotter Risk Adjusted Self Care Change Risk Adjusted Mobility Change Risk Adjusted Self Care Discharge Risk Adjusted Mobility Discharge IRF Risk Adjustment ICD-10 to HCC Mappings Infection Control Regulatory Definitions Infection Control LDA-Based Metric Definition Infection Control Metric Details Infection Control Manual Metric Details Quality Observation SEP-1 Abstraction Configuration Template Infection Control Surveillance Abstraction Infection Control Search Parameters NHSN Antimicrobial Resistance Event Exposure Case Abstraction Outbreak Definition NHSN CLIP Abstraction Scoring System Deferral Configuration Scoring System Deferral User Interface Configuration Reporting Agency Configuration Reportable Condition Configuration Syndromic Surveillance Event Type (OPA Trigger) Syndromic Surveillance Syndrome GIQuIC-Colonoscopy Analytics Registry BH IPFQR Abstraction Details
4	PAT_ID	VARCHAR	No
	This column contains the associated patient's ID (EPT .1).
5	ARD_TARGET_DATE	DATETIME	No
	This column contains the Target Date or Assessment Reference Date.
6	CUR_STAT_C_NAME	VARCHAR	No
	This column indicates the current state of the RDI record. May contain organization-specific values: Yes Category Entries: New Associated Populated In Progress Edited Validated Needs Review Needs Review - Updated Ready for Export Exported Restored Signed Ready to Sign Ready to Submit Submitted Accepted Rejected Done Submit Historical Modified Inactivated Void Saved to EQRS Dialysis Intra-Facility Transfer Manually Submitted End COSD Pathway Investigating Closed Abstracting Completed Ready for Nurse Review Ready for Physician Review Waiting for Signoff Care Planning Complete Will Not Be Exported Accepted with Warnings Unopened Canceled A0410 Correction Requested Wrong FAC_ID Test Record Corrected/Inactivated/Deleted Abandoned Admission Complete Doc Complete Filed Ready for Prospective Reporting Prospective Reporting Complete
7	MDS_REC_TYPE_C_NAME	VARCHAR	No
	This column indicates what type of record (A0050) the MDS represents. May contain organization-specific values: No Category Entries: Add new record Modify existing record Inactivate existing record
8	OBRA_TYPE_C_NAME	VARCHAR	No
	The MDS record's type of OBRA assessment. (RDI 35010) - A0310A. May contain organization-specific values: No Category Entries: None of the above Admission Quarterly Annual Significant change in status Significant correction to prior comprehensive Significant correction to prior quarterly
9	PPS_TYPE_C_NAME	VARCHAR	No
	The MDS record's type of PPS Assessment (RDI 35011) - MDS A0310B. May contain organization-specific values: No Category Entries: None of the above 5-day 14-day 30-day 60-day 90-day Readmission/return Unscheduled assessment used for PPS Interim Payment Assessment
10	OMRA_TYPE_C_NAME	VARCHAR	No
	The MDS record's type of PPS OMRA reason for assessment (RDI 35012) - A0310C. May contain organization-specific values: No Category Entries: No Start of therapy End of therapy Both Start and End of therapy Change of therapy
11	MDS_REQT_C_NAME	VARCHAR	No
	This column indicates who requires the submission of this assessment (MDS A0410) - whether it is a federal required submission, state but not federal required submission, or neither federal nor state required submission. May contain organization-specific values: No Category Entries: Neither federal nor state required submission State but not federal required submission Federal required submission
12	ENTRY_DISCHRG_C_NAME	VARCHAR	No
	This column indicates the kind of tracking record this MDS record serves as. May contain organization-specific values: No Category Entries: Discharge assessment-return not anticipated Discharge assessment-return anticipated Death in facility tracking record None of the above Entry tracking record
13	PREV_CORR_ARD_DT	DATETIME	No
	This column indicates the ARD of the assessment to be corrected.
14	PART_A_HIPPS	VARCHAR	No
	This column contains the HIPPS code for Medicare Part A.
15	PART_A_RUG_VER	VARCHAR	No
	This column contains the version code used for MDS Z0100A.
16	PART_A_SHORT_STAY_YN	VARCHAR	No
	This column indicates whether or not this is a Medicare Short Stay assessment. May contain organization-specific values: No Category Entries: No Yes
17	PART_A_NT_HIPPS	VARCHAR	No
	This column contains the HIPPS code for Medicare Part A non-therapy.
18	PART_A_NT_RUG_VER	VARCHAR	No
	This column contains the version code used for MDS Z0150A.
19	STATE_RUG_CASE_GRP	VARCHAR	No
	This column contains the RUG Case Mix group for state Medicaid billing.
20	STATE_RUG_VER	VARCHAR	No
	This column contains the Version code used for MDS Z0200A.
21	ALT_STATE_RUG_GRP	VARCHAR	No
	This column contains the RUG Case Mix group for alternate state Medicaid billing on an MDS assessment.
22	ALT_STATE_RUG_VER	VARCHAR	No
	This column contains the version code used for MDS Z0250A.
23	INSURANCE_RUG_CODE	VARCHAR	No
	This column contains the RUG billing code used for a private payor.
24	INSURANCE_RUG_VER	VARCHAR	No
	This column contains the version code used for MDS Z0300A.
25	CAA_SIG_USER_ID	VARCHAR	No
	This column contains the ID of the RN coordinator who signed for the Care Area Assessment process.
26	CAA_SIG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
27	CAA_SIG_DTTM	DATETIME (Attached)	No
	This column contains the date of the signature in MDS V0200B1.
28	CARE_PLAN_SIG_USER_ID	VARCHAR	No
	This column contains the ID of the individual who signed for completing care plan decisions.
29	CARE_PLAN_SIG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
30	CARE_PLAN_SIG_DTTM	DATETIME (Attached)	No
	This column contains the instant of the signature in MDS V0200C1.
31	CORR_RN_AC_SIG_USER_ID	VARCHAR	No
	This column contains the ID of the RN assessment coordinator attesting to the completion of the correction record.
32	CORR_RN_AC_SIG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
33	CORR_RN_AC_SIG_DTTM	DATETIME (Attached)	No
	This column contains the instant of the signature in MDS X1100D.
34	MDS_ASSESS_INDIC_C_NAME	VARCHAR	No
	This column contains the assessment indicator. May contain organization-specific values: No Category Entries: Interim Payment Assessment 5-day assessment Not used for PPS 5-day or readmission return 5-day or readm with Unscheduled OBRA/CCA 5-day or readm with Start of Therapy OMRA 5-day with SOT & Unscheduled OBRA/CCA 5-day or readm with EOT OMRA without Resumption 5-day or readm with SOT & EOT without Resumption 5-day & Unscheduled OBRA/CCA & SOT/EOT w/o Resumption 5-day or readmission with Medicare Short Stay Assessment 14-day assessment 14-day with Unscheduled OBRA/CCA 14-day with Start of Therapy OMRA 14-day with SOT & Unscheduled OBRA/CCA 14-day with EOT OMRA without Resumption 14-day with SOT & EOT without Resumption 14-day & Unscheduled OBRA/CCA & SOT/EOT w/o Resumption 30-day assessment 30-day with Unscheduled OBRA/CCA 30-day with Start of Therapy OMRA 30-day with SOT & Unscheduled OBRA/CCA 30-day with EOT OMRA without Resumption 30-day with SOT & EOT without Resumption 30-day & Unscheduled OBRA/CCA & SOT/EOT w/o Resumption 60-day assessment 60-day with Unscheduled OBRA/CCA 60-day with Start of Therapy OMRA 60-day with SOT & Unscheduled OBRA/CCA 60-day with EOT OMRA without Resumption 60-day with SOT & EOT without Resumption 60-day & Unscheduled OBRA/CCA & SOT/EOT w/o Resumption 90-day assessment 90-day with Unscheduled OBRA/CCA 90-day with Start of Therapy OMRA 90-day with SOT & Unscheduled OBRA/CCA 90-day with EOT OMRA without Resumption 90-day with SOT & EOT without Resumption 90-day & Unscheduled OBRA/CCA & SOT/EOT w/o Resumption Uncombined OBRA Tracking record (no valid RUG) Default code due to missed assessment Unscheduled OBRA or Swing Bed CCA Start of Therapy OMRA SOT OMRA with Unscheduled OBRA/CCA End of Therapy OMRA without Resumption SOT with EOT without Resumption SOT/EOT without Resumption with Unscheduled OBRA/CCA Medicare Short Stay Assessment End of Therapy with Resumption Start of Therapy with End of Therapy Reporting Resumption SOT/EOT-R with Unscheduled OBRA or Swing Bed CCA Change of Therapy OMRA 5-day or readmission with EOT with Resumption 5-day or readmission with SOT & EOT-R 5-day or readm with SOT/EOT-R & OBRA/CCA 14-day with EOT with Resumption 14-day with SOT & EOT-R 14-day with SOT/EOT-R & OBRA/CCA 14-day with Change of Therapy 30-day with EOT with Resumption 30-day with SOT & EOT-R 30-day with SOT/EOT-R & OBRA/CCA 30-day with Change of Therapy 60-day with EOT with Resumption 60-day with SOT & EOT-R 60-day with SOT/EOT-R & OBRA/CCA 60-day with Change of Therapy 90-day with EOT with Resumption 90-day with SOT & EOT-R 90-day with SOT/EOT-R & OBRA/CCA 90-day with Change of Therapy PDPM Default
35	RN_AC_COMP_SIG_DTTM	DATETIME (Attached)	No
	This column contains the date of the signature in MDS Z0500A.
36	RN_AC_COMP_SIG_USER_ID	VARCHAR	No
	This column contains the ID of the RN assessment coordinator verifying assessment completion.
37	RN_AC_COMP_SIG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
38	MDS_REGION_C_NAME	VARCHAR	No
	Stores which region the MDS applies to as documented in the Resident's State field in Section S. May contain organization-specific values: No Category Entries: Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Puerto Rico Virgin Islands
39	PPS_DISCHRG_YN	VARCHAR	No
	Stores the value of MDS item A0310H which indicates whether the MDS is a SNF PPS Part A Discharge (End of Stay) assessment May contain organization-specific values: No Category Entries: No Yes
40	MDS_OPT_STATE_ASMT_YN	VARCHAR	No
	A0300A The category values for this column were already listed for column: PPS_DISCHRG_YN
41	MDS_STATE_ASMT_TYPE_C_NAME	VARCHAR	No
	Current value of MDS A0300B - State Payment Assessment Type May contain organization-specific values: No Category Entries: Start of Therapy assessment End of Therapy assessment Both Start and End of Therapy assessment Change of Therapy assessment Other payment assessment