Functional Status Assessment for Total Hip Replacement

"Total Hip Arthroplasty Procedure" TotalHip
	with "HOOS Total Assessment Scores" InitialHipAssessmentHOOS
		such that TotalHip.relevantPeriod starts 90 days or less on or after day of InitialHipAssessmentHOOS.authorDatetime
	with "HOOS Total Assessment Scores" FollowupHipAssessmentHOOS
		such that FollowupHipAssessmentHOOS.authorDatetime 270 days or more after day of 
		end of TotalHip.relevantPeriod
			and FollowupHipAssessmentHOOS.authorDatetime 365 days or less after day of 
			end of TotalHip.relevantPeriod

"Total Hip Arthroplasty Procedure" TotalHip
	with "HOOSJr Total Assessment Scores" InitialHipAssessment
		such that TotalHip.relevantPeriod starts 90 days or less on or after day of InitialHipAssessment.authorDatetime
	with "HOOSJr Total Assessment Scores" FollowupHipAssessment
		such that FollowupHipAssessment.authorDatetime 270 days or more after day of 
		end of TotalHip.relevantPeriod
			and FollowupHipAssessment.authorDatetime 365 days or less after day of 
			end of TotalHip.relevantPeriod

"Total Hip Arthroplasty Procedure" TotalHip
	with "PROMIS10 Total Assessment Scores" InitialHipAssessmentPROMIS10
		such that TotalHip.relevantPeriod starts 90 days or less on or after day of InitialHipAssessmentPROMIS10.authorDatetime
	with "PROMIS10 Total Assessment Scores" FollowupHipAssessmentPROMIS10
		such that FollowupHipAssessmentPROMIS10.authorDatetime 270 days or more after day of 
		end of TotalHip.relevantPeriod
			and FollowupHipAssessmentPROMIS10.authorDatetime 365 days or less after day of 
			end of TotalHip.relevantPeriod

"Total Hip Arthroplasty Procedure" TotalHip
	with "VR12 Oblique Total Assessment Scores" InitialHipAssessmentOblique
		such that TotalHip.relevantPeriod starts 90 days or less on or after day of InitialHipAssessmentOblique.authorDatetime
	with "VR12 Oblique Total Assessment Scores" FollowupHipAssessmentOblique
		such that FollowupHipAssessmentOblique.authorDatetime 270 days or more after day of 
		end of TotalHip.relevantPeriod
			and FollowupHipAssessmentOblique.authorDatetime 365 days or less after day of 
			end of TotalHip.relevantPeriod

"Total Hip Arthroplasty Procedure" TotalHip
	with "VR12 Orthogonal Total Assessment Scores" InitialHipAssessmentOrthogonal
		such that TotalHip.relevantPeriod starts 90 days or less on or after day of InitialHipAssessmentOrthogonal.authorDatetime
	with "VR12 Orthogonal Total Assessment Scores" FollowupHipAssessmentOrthogonal
		such that FollowupHipAssessmentOrthogonal.authorDatetime 270 days or more after day of 
		end of TotalHip.relevantPeriod
			and FollowupHipAssessmentOrthogonal.authorDatetime 365 days or less after day of 
			end of TotalHip.relevantPeriod

["Diagnosis": "Severe dementia (disorder)"] Dementia
	where Dementia.prevalencePeriod overlaps "Measurement Period"

"Initial Population"

Hospice."Has Hospice"
	or exists ( "Total Hip Arthroplasty with 2 or More Lower Body Fractures" )
	or exists ( "Dementia Diagnosis" )

["Assessment, Performed": "Quality of life score [HOOS]"] HOOSLifeQuality
	with ["Assessment, Performed": "Sport-recreation score [HOOS]"] HOOSSport
		such that HOOSLifeQuality.authorDatetime same day as HOOSSport.authorDatetime
			and HOOSSport.result is not null
	with ["Assessment, Performed": "Activities of daily living score [HOOS]"] HOOSActivityScore
		such that HOOSLifeQuality.authorDatetime same day as HOOSActivityScore.authorDatetime
			and HOOSActivityScore.result is not null
	with ["Assessment, Performed": "Symptoms score [HOOS]"] HOOSSymptoms
		such that HOOSLifeQuality.authorDatetime same day as HOOSSymptoms.authorDatetime
			and HOOSSymptoms.result is not null
	with ["Assessment, Performed": "Pain score [HOOS]"] HOOSPain
		such that HOOSLifeQuality.authorDatetime same day as HOOSPain.authorDatetime
			and HOOSPain.result is not null
	where HOOSLifeQuality.result is not null

( ["Assessment, Performed": "Hip Dysfunction and Osteoarthritis Outcome Score for Joint Replacement [HOOSJR]"] HOOSJr
		where HOOSJr.result is not null
)

exists ( ["Encounter, Performed": "Encounter Inpatient"] DischargeHospice
		where ( DischargeHospice.dischargeDisposition as Code ~ "Discharge to home for hospice care (procedure)"
				or DischargeHospice.dischargeDisposition as Code ~ "Discharge to healthcare facility for hospice care (procedure)"
		)
			and DischargeHospice.relevantPeriod ends during "Measurement Period"
)
	or exists ( ["Intervention, Order": "Hospice care ambulatory"] HospiceOrder
			where HospiceOrder.authorDatetime during "Measurement Period"
	)
	or exists ( ["Intervention, Performed": "Hospice care ambulatory"] HospicePerformed
			where HospicePerformed.relevantPeriod overlaps "Measurement Period"
	)

exists ( "Total Hip Arthroplasty Procedure" )
	and exists ( "Qualifying Encounter" )
	and exists ["Patient Characteristic Birthdate": "Birth date"] BirthDate
		where Global."CalendarAgeInYearsAt"(BirthDate.birthDatetime, start of "Measurement Period")>= 19

exists ( "Assessed Initial and Followup HOOS with THA" )
	or exists ( "Assessed Initial and Followup HOOSJr with THA" )
	or exists ( "Assessed Initial and Followup PROMIS10 with THA" )
	or exists ( "Assessed Initial and Followup VR12 Oblique with THA" )
	or exists ( "Assessed Initial and Followup VR12 Orthogonal with THA" )

["Assessment, Performed": "PROMIS-10 Global Mental Health (GMH) score T-score"] Promis10MentalScore
	with ["Assessment, Performed": "PROMIS-10 Global Physical Health (GPH) score T-score"] Promis10PhysicalScore
		such that Promis10MentalScore.authorDatetime same day as Promis10PhysicalScore.authorDatetime
			and Promis10PhysicalScore.result is not null
	where Promis10MentalScore.result is not null

( ["Encounter, Performed": "Outpatient Consultation"]
	union ["Encounter, Performed": "Office Visit"]
	union ["Encounter, Performed": "Postoperative follow-up visit, normally included in the surgical package, to indicate that an evaluation and management service was performed during a postoperative period for a reason(s) related to the original procedure"] ) ValidEncounters
	where ValidEncounters.relevantPeriod during "Measurement Period"

["Patient Characteristic Ethnicity": "Ethnicity"]

["Patient Characteristic Payer": "Payer"]

["Patient Characteristic Race": "Race"]

["Patient Characteristic Sex": "ONC Administrative Sex"] 

( ["Procedure, Performed": "Primary THA Procedure"] THAProcedure
		where THAProcedure.relevantPeriod starts 12 months or less before start of "Measurement Period"
)

"Total Hip Arthroplasty Procedure" THAProcedure
	where Count(["Diagnosis": "Fracture - Lower Body"] LowerBodyFracture
			where LowerBodyFracture.prevalencePeriod starts less than 1 day on or before THAProcedure.relevantPeriod
	)>= 2

( ["Assessment, Performed": "VR-12 Mental component summary (MCS) score - oblique method T-score"] VR12MentalAssessment
	where VR12MentalAssessment.result is not null ) VR12MentalScore
	with ( ["Assessment, Performed": "VR-12 Physical component summary (PCS) score - oblique method T-score"] VR12PhysicalAssessment
		where VR12PhysicalAssessment.result is not null ) VR12PhysicalScore
		such that VR12MentalScore.authorDatetime same day as VR12PhysicalScore.authorDatetime

( ["Assessment, Performed": "VR-12 Mental component summary (MCS) score - orthogonal method T-score"] VR12MentalOrthogonal
	where VR12MentalOrthogonal.result is not null ) VR12MentalScore
	with ( ["Assessment, Performed": "VR-12 Physical component summary (PCS) score - orthogonal method T-score"] VR12PhysicalOrthogonal
		where VR12PhysicalOrthogonal.result is not null ) VR12PhysicalScore
		such that VR12MentalScore.authorDatetime same day as VR12PhysicalScore.authorDatetime

years between ToDate(BirthDateTime)and ToDate(AsOf)

DateTime(year from Value, month from Value, day from Value, 0, 0, 0, 0, timezone from Value)