MDS queries - aavedula/how-to-notes GitHub Wiki

Back

Miscellaneous rails console calls

• Populations with mds assessments

MDSAssessment.where.not(member_id: nil).includes(:member).map{|m| m.member.population_id}

• Patients with mds assessments

MDSAssessment.where.not(member_id: nil).includes(:member).map{|m| m.member.patient_identity.last if m.member.population_id == "menorah-center-for-rehabilitation-and-nursing-care"}.compact.sort.reverse

• HRCP's with mds assessments

HospitalReferredCarePeriod.where(population_id: "menorah-center-for-rehabilitation-and-nursing-care").includes(:member).map { |h| h.member.patient_identity.last if h.mds_assessments.count > 0 }.compact.sort