S AdmitDischarge table

From CCMDB Wiki
Revision as of 09:28, 17 August 2015 by Ttenbergen (talk | contribs) (for consistent naming of articles about tables)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The S_AdmitDischarge table contains the possible values for the Admit From & Discharged To fields in CCMDB.mdb.

fields

  • Location - text(60) - full name of location
  • Code (no duplicates) - text(2)
  • surgical - boolean - is this an admit-from location that indicates a surgical patient? Template:Discussion can't remember what actually uses this... might be apache type on import?
  • active - boolean - logical delete, yes if field can currently be chosen by collectors; field became necessary when legacy locations were imported
  • old code - text(3) - location code used by TMSX *1
  • hosp - hospital it is at, if applicable
  • ward - ward that we collect that this is, if applicable
  • inpatient - is an inpatient location; used to validate Service Sending to ICU
  • notes - notes...

location code used by TMSX - *1

TMSX used one 3-letter variable, "oth"; current system could not accomodate that so added a column that can. Used by TMSX import into Centralized (Centralized import from Ed.mdb).

Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_AdmitDischarge_table&oldid=45424"