S AdmitDischarge table: Difference between revisions

(3 intermediate revisions by the same user not shown)

Line 4:

Legacy Data Only, now uses [[s_dispo ~~table]]. Sites where we collect can be found in [[Site and Location~~ table]].

Legacy Data Only, now uses [[s_dispo table]].

Line 15:

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

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

Line 28:

Line 29:

| Code (no duplicates) || text(2)

|-

| surgical || boolean || is this a surgical location ~~(used by query ''[[Check OR from but not Surgical Type]]'')~~

| 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

Line 46:

Line 47:

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: Legacy Data structure]]

[[Category:Legacy Data structure]]

@@ Line 4: / Line 4: @@
-Legacy Data Only, now uses [[s_dispo table]]. Sites where we collect can be found in [[Site and Location table]].
+Legacy Data Only, now uses [[s_dispo table]].
@@ Line 15: / Line 15: @@
-The '''S_AdmitDischarge''' table contains the possible values for the [[Admit From & Discharged To]] fields in [[CCMDB.mdb]].
+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 ==
@@ Line 28: / Line 29: @@
 | Code (no duplicates)  ||  text(2)
 |-
-| surgical  ||  boolean  ||  is this a surgical location (used by query ''[[Check OR from but not Surgical Type]]'')
+| 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
@@ Line 46: / Line 47: @@
 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: Legacy Data structure]]
+[[Category:Legacy Data structure]]