Page values for "Record definition query in CFE"

"_pageData" values

1 row is stored for this page
FieldField typeValue
_modificationDateDatetime2025-03-18 7:35:56 PM
_categoriesList of String, delimiter: |Centralized data front end.accdb Multiple Encounter linking PatientFollow Project Questions
_pageIDInteger13,312
_pageNamePageRecord definition query in CFE
_pageTitleString

Record definition query in CFE

_pageNamespaceInteger0

"Discussions" values

1 row is stored for this page
FieldField typeValue
whoTextall
questionWikitext
  • 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)