csv needs

[Righolt]

Just some thoughts, may come up with more in the future, and some are less relevant at this point.

• persons
  • Address/region/zip-postal with start/end date
• clinic
  • clinician id
  • clinic id
  • should allow for multiple codes per date
  • code can be diagnosis and procedure
• hosp
  • code can be diag and proc
  • hosp id (possibly transfers)
  • service date =? admission date, may be separate from diagnosis and procedure dates
  • did not check code, but date checking is relevant here for readmissions/no overlap etc (even if that does occur in real data)
• rx
  • needs dose/duration
  • assuming code includes method of administration and other less relevant chars
  • code should include some reasonable refill times etc. at some point
  • possible pharmacy-id, but haven't had a project this is relevant for
• Need to think about vaccine administration (clinic v rx)

Of course coding systems/names etc. should be modifiable in the future (including having multiple), but aimed to get content right.

[DrGo]

@Righolt @zhanggeng218 Added postal-code (or whatever geolocator is needed). See the config.json for options. Can someone add a small test to exercise one of our geocoding macros?

[Righolt]

I nominate @zhanggeng218

[zhanggeng218]

There are not many macros of ours directly related to geo info. Maybe I can see if it works with the risk-set matching macro.

[Righolt]

Most/all postal->region is from MCHP, but we have the postal code conversion files if needed.