S-tables

The s-tables in CCMDB.mdb 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.mdb and rolled out.

List of S_ tables

• S ADLOptions
• S_AdmitDischarge
• S_AllDiagnoses
• S_AP_AdmitType
• S_AP_Chronic
• S_FIO2
• s_GCS
• S_HospitalPrevious,known as S_HospitalCodes
• S_Locations
• S_Pathogens
• S_Priorities
• S_Provinces
• S_Tmp
• s_RecordStatus
• s_VarNames
• s_varOptions

s table containing reference data

• s charlson dxs

Legacy

• S_Drugs
• S_AllLabs
• S_tmp_moverequired