S AdmitDischarge table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) for consistent naming of articles about tables |
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]]. | ||
== | == Data Structure == | ||
{| class="wikitable sortable" | |||
|- | |||
!| field | |||
!| type | |||
!| description | |||
|- | |||
| Location || text(60) || full name of location | |||
|- | |||
| Code (no duplicates) || text(2) | |||
|- | |||
| surgical || boolean || is this a surgical location (used by query ''[[Check OR from but not Surgical Type]]'') | |||
|- | |||
| 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 || text(3) || hospital it is at, if applicable | |||
|- | |||
| ward || text(5) || ward that we collect that this is, if applicable | |||
|- | |||
| inpatient || yes/no ||is an inpatient location; used to validate [[Service Sending to ICU]] | |||
|- | |||
| notes || text(255) || notes... | |||
|} | |||
== location code used by TMSX - *1 == | == location code used by TMSX - *1 == | ||
Revision as of 08:57, 17 August 2015
The S_AdmitDischarge table contains the possible values for the Admit From & Discharged To fields in CCMDB.mdb.
Data Structure
| field | type | description |
|---|---|---|
| Location | text(60) | full name of location |
| Code (no duplicates) | text(2) | |
| surgical | boolean | is this a surgical location (used by query Check OR from but not Surgical Type) |
| 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 | text(3) | hospital it is at, if applicable |
| ward | text(5) | ward that we collect that this is, if applicable |
| inpatient | yes/no | is an inpatient location; used to validate Service Sending to ICU |
| notes | text(255) | 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).