S-tables: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "[[Category: " to "[[Category:"
 
(23 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The S_ files and 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]].  


== Management of Master List ==
All changes to s-tables need to be made to the Master version of the CCMDB.accdb and [[Rolling out changes|rolled out]].  
The s_files are centrally managed and should not be changed locally. Local changes would be wiped out next time a centralized update is applied. Usually changes are made by [[Trish Ostryzniuk | Trish]].
See [[Master files for the data collection process]] for further info about the master files.


== File Locations ==
== List of S_ tables  ==
* for [[CCMDB.mdb]], see [[File Locations]]
see "S" section of [[:Category:Data structure]]
* for [[HanDBase]]/[[PDA]], see [[File Locations]]


== List of S_ files  ==
== Legacy ==
* [[S_AdmitDischarge]]
* [[S_Drugs]]
* [[S_AllDiagnoses]]
* [[S_AllLabs]]
* [[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]]




{{stub}}
[[Category:Data structure]]
[[Category:IT Instructions]]
[[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