Record definition query in CFE

The definitions of a record have changed over time:

• Definition of a Critical Care Program Admission#Definitions relevant for historical data
  • Special:History/Definition of a Critical Care Program Admission
• Definition of a Medicine Program Admission#Definitions relevant for historical data
  • Special:History/Definition of a Medicine Program Admission
  • medicine definition is more strongly affected because of PatientFollow Project

We should set up a Record definition query in CFE to provide a clear way in CFE to treat historical, pre PatientFollow Project, records in a way that is consistent with our current definition. This is a good idea but not trivial, so we should decide how badly we need this, but definitely document the concept. JM email from 2025-03-18: "Perhaps, creating a query to link those records from old definition to become similar to patient follow is needed in ACCESS to generate at least the LOS, first admit date and last discharge date, first previous location and last dispo location. In this way, SAS will not generate it and I just get it from ACCESS query. Is this hard to do? " The query is probably the easiest part, but this would take some analysis to figure out what all is actually affected by this, ie which other queries would need to be updated. Having said that, we should still probably do it. I don't know who would be in a position to prioritize this, I don't have bandwidth for this as a side project right now. Don't think it's a task question because I don't know if anyone there would have anything to add to this. Ttenbergen 14:17, 18 March 2025 (CDT)

• SMW

• Cargo

• Categories