S AdmitDischarge: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →to do before de-stubbing: never mind |
Ttenbergen (talk | contribs) m m |
||
| Line 1: | Line 1: | ||
The '''S_AdmitDischarge''' table contains the possible values for the [[Admit From & Discharged To]] fields in [[CCMDB.mdb]]. | 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 | * Location - text(60) - full name of location | ||
* Code (no duplicates) - text(2) | * Code (no duplicates) - text(2) | ||
* surgical - boolean - is this an admit-from location that indicates a surgical patient? {{discussion}} can't remember what actually uses this... might be apache type on import? | * surgical - boolean - is this an admit-from location that indicates a surgical patient? {{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 | * active - boolean - logical delete, yes if field can currently be chosen by collectors; field became necessary when legacy locations were imported | ||
| Line 9: | Line 9: | ||
* hosp - hospital it is at, if applicable | * hosp - hospital it is at, if applicable | ||
* ward - ward that we collect that this is, 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... | * notes - notes... | ||
Revision as of 14:06, 22 June 2015
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).