S-tables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The S_  tables are where the content for the standardized drop-downs is stored. S_ stands for "Standardized", in contrast to the [["L" Files]].  
The s-tables in [[CCMDB.accdb]] are where the content for the standardized drop-downs is stored. "S" stands for "Standardized", in contrast to the [[L-tables]].  


The S_ tables are part of the [[CCMDB.mdb]]. All changes to s_ tables need to be made to the Master version of the CCMDB.mdb and [[Rolling out changes|rolled out]].  
All changes to s-tables need to be made to the Master version of the CCMDB.accdb and [[Rolling out changes|rolled out]].  


* See [[Rolling out changes]] for the update process fort he master files.
== List of S_ tables  ==
* See [[Master files for the data collection process]] for further info about the master files.
see "S" section of [[:Category:Data structure]]


== Legacy ==
* [[S_Drugs]]
* [[S_AllLabs]]


== List of S_ tables  ==
* [[S_AdmitDischarge]]
* [[S_AllDiagnoses]]
* [[S_AllLabs]]
* [[S_AP_AdmitType]]
* [[S_AP_Chronic]]
* [[S_CharlsonComorbids]]
* [[S_Counts]]
* [[S_Drugs]]
* [[S_FI02]]
* [[S_FIO2]]
* [[S_Hospitals]]
* [[S_Labs]] (legacy file only, but must be retained for now) (Tina)
* [[S_Locations]]
* [[S_Pathogens]]
* [[S_Priorities]]
* [[S_Provinces]]
* [[S_Tmp]]
* [[S_var1opts]]
* [[S_var2opts]]
* [[S_var3opts]]
* [[S_var4opts]]
* [[S_var5opts]]
* [[S_var6opts]]


[[Category:IT Instructions]]
[[Category:Data structure]]
[[Category:Standards and Conventions]]
[[Category:Standards and Conventions]]

Latest revision as of 11:05, 30 July 2025

The s-tables in CCMDB.accdb are where the content for the standardized drop-downs is stored. "S" stands for "Standardized", in contrast to the L-tables.

All changes to s-tables need to be made to the Master version of the CCMDB.accdb and rolled out.

List of S_ tables

see "S" section of Category:Data structure

Legacy