S AdmitDischarge table: Difference between revisions

Line 1:

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

== ~~fields~~ ==

== Data Structure ==

* Location - text(60) - full name of location

{| class="wikitable sortable"

* 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?~~

!| field

* active - boolean - logical delete, yes if field can currently be chosen by collectors; field became necessary when legacy locations were imported

!| type

* old code - text(3) - location code used by [[TMSX]] *1

!| description

* hosp - hospital it is at, if applicable

|-

* ward - ward that we collect that this is, if applicable

| Location || text(60) || full name of location

* inpatient - is an inpatient location; used to validate [[Service Sending to ICU]]

|-

* notes - notes...

| 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 ==

@@ Line 1: / Line 1: @@
 The '''S_AdmitDischarge''' table contains the possible values for the [[Admit From & Discharged To]] fields in [[CCMDB.mdb]].
-== fields ==
+== Data Structure ==
-* Location - text(60) - full name of location
+{| class="wikitable sortable"
-* 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?
+!| field
-* active - boolean - logical delete, yes if field can currently be chosen by collectors; field became necessary when legacy locations were imported
+!| type
-* old code - text(3) - location code used by [[TMSX]] *1
+!| description
-* hosp - hospital it is at, if applicable
+|-
-* ward - ward that we collect that this is, if applicable
+| Location  ||  text(60)  ||  full name of location
-* inpatient - is an inpatient location; used to validate [[Service Sending to ICU]]
+|-
-* notes - notes...
+| 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 ==