S AdmitDischarge table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,607 edits
for consistent naming of articles about tables
 
m Text replacement - "[[Category: " to "[[Category:"
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
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? {{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
Legacy Data Only, now uses [[s_dispo table]].
* 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...
 
 
 
 
 
 
The '''S_AdmitDischarge''' table contained the possible values for the [[Admit From & Discharged To]] fields in [[CCMDB.mdb]].
Removed from [[CCMDB.mdb]] in [[CCMDB.mdb_Change_Log_2017#2017-12-07-3]].
 
== 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
|-
| 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 ==
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]]).  
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]]).  


[[Category: Data structure]]
[[Category:Legacy Data structure]]

Latest revision as of 12:00, 30 July 2025



Legacy Data Only, now uses s_dispo table.






The S_AdmitDischarge table contained the possible values for the Admit From & Discharged To fields in CCMDB.mdb. Removed from CCMDB.mdb in CCMDB.mdb_Change_Log_2017#2017-12-07-3.

Data Structure

field type description
Location text(60) full name of location
Code (no duplicates) text(2)
surgical boolean is this a surgical location
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).

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