S AdmitDischarge

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

to do before de-stubbing

• Location - text(60) - full name of location
• Code (no duplicates) - text(2) - location code used by TMSX *1
• 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

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).