User:Ttenbergen

• Also see: Tina Tenbergen

changing mediawiki appearance

• See where all the mediawiki pages are editable: http://ccmdb.kuality.ca/index.php?uselang=qqx
• to edit them: go to http://ccmdb.kuality.ca/index.php?title=MediaWiki:<name listed above>

data fields

by link

Data fields

by list

This is a list of fields in the Critical Care and Medicine Database

	InTable	FieldDataType	ElementDescription
3rd generation cephalosporins	L_Pharm_Flowsheet table	number
ADL Bathing	L_Log table	string
ADL Complete	L_Log table	boolean
ADL Continence	L_Log table	string
ADL Dressing	L_Log table	string
ADL Feeding	L_Log table	string
ADL Toiletting	L_Log table	string
ADL Transfering	L_Log table	string
AP Dias BP Field	L_Log table	number
AP_Eye field	L_Log table	string
AP_Motor field	L_Log table	string
AP Sys BP Field	L_Log table	number
AP_Verbal field	L_Log table	string
ARF (APACHE)	L_Log table	number
AaDO2	N/A	number
Abdominal ultrasound	L_Labs_Flowsheet table	integer
Accept DtTm field	L_Log table	date
Accept DtTm missing field	L_Log table	boolean
Admit Type for APACHE II	L_Log table	string
Age	N/A	number
Albumin 25pct	L_Labs_Flowsheet table	integer
Albumin 5pct	L_Labs_Flowsheet table	integer
Angio coronary field	L_Labs_Flowsheet table	integer
Angio others field	L_Labs_Flowsheet table	integer
Antipseudomonals	L_Pharm_Flowsheet table	number
Ap Complete	L_Log table	boolean
Ap SapsSysBP field	L_Log table	number
Arrive DtTm field	N/A	date
Arterial blood gas (labs)	L_Labs_Flowsheet table	integer
Azoles	L_Pharm_Flowsheet table	number
Benzodiazepines cont inf	L_Pharm_Flowsheet table	number
Blood culture	L_Labs_Flowsheet table	not entered
CBC	L_Labs_Flowsheet table	integer
CCI 1 Code	N/A	number
CCI 2 Code	N/A	number
CCI Picklist Code	L_CCI_Picklist table	string
CT Scan (labs)	L_Labs_Flowsheet table	integer
CXR	L_Labs_Flowsheet table	integer
Carbapenems	L_Pharm_Flowsheet table	number
Ceftazidime	L_Pharm_Flowsheet table	number
Chart number	L_Log table L_PHI table	string
Chronic Health APACHE	L_Log table	string
ClientGUID field	L_Log table	string
ClientVisitGUID field	L_Log table	string
Como Complete	L_Log table	boolean
Creatinine (APACHE)	L_Log table	number
Creatinine (labs)	L_Labs_Flowsheet table	integer
D ID field	L_Log table L_Labs_Flowsheet table L_Pharm_Flowsheet table L_PHI table L_TISS_Form table L_TISS_Item table L TISS76 table L_Labs_DSM table L_ICD10 table L_PCH table L CCI Component table L_CCI_Picklist table L Como table L_Dxs table L_TmpV2 table	string
DC Treatment	L_Log table	string
Date of Birth	L_Log table L_PHI table	date
Diag Complete	L_Log table	boolean
Dispo DtTm field	L_Log table	date
Dispo field	L_Log table	number
Dx Date	L_ICD10 table	date
Dx Date unknown	L_ICD10 table	boolean
Dx Primary	L_ICD10 table	boolean
Dx Priority	L_ICD10 table	number
Dx Type	L_ICD10 table	string
ER Delay	Created Variables Common 2021 table	date
Echocardiogram	L_Labs_Flowsheet table	number
FFP	L_Labs_Flowsheet table	integer
FiO2	L_Log table	number
FirstName field	L_Log table L_PHI table	string
Fluoroquinolones	L_Pharm_Flowsheet table	number
Fungins	L_Pharm_Flowsheet table	number
Furosemide cont inf	L_Pharm_Flowsheet table	number
GCS sedated field	L_Log table	boolean
H2-Blockers	L_Pharm_Flowsheet table	number
HCT	L_Log table	number
HR	L_Log table	number
Heparin SQ	L_Pharm_Flowsheet table	number
Hospitalization ID	L_Log table L_Person table	number
ICD10 code	L_ICD10 table s_ICD10 table	string
Insulin cont inf	L_Pharm_Flowsheet table	number
K	L_Log table	number
L ICD10 ID	L_ICD10 table	number
LMWH	L_Pharm_Flowsheet table	number
Labs Complete	L_Log table	boolean
LastChanged DtTm field	L_Log table	date
LastName field	L_Log table L_PHI table	string
LastOpened DtTm field	L_Log table	date
MRI (labs)	L_Labs_Flowsheet table	integer
Magnesium (labs)	L_Labs_Flowsheet table	integer
Mean BP	Created Variables CC 2021 table	number
Na	L_Log table	number
Notes field	L_Log table	memo
Notes field (L PHI)	L_PHI table	string
Off ward field	L_Log table	number
Opioids cont inf	L_Pharm_Flowsheet table	number
PCO2	L_Log table	number
PH	L_Log table	number
PHIN field	L_Log table L_PHI table	number
PO2	L_Log table	number
PPI	L_Pharm_Flowsheet table	number
PT PTT	L_Labs_Flowsheet table	integer
Pat ID field	L_Log table L_Labs_Flowsheet table L_Pharm_Flowsheet table L_PHI table L_TISS_Form table L_TISS_Item table L_ICD10 table L_PCH table L CCI Component table L_CCI_Picklist table L Como table L_Dxs table L_TmpV2 table	number
Pentaspan	L_Labs_Flowsheet table	integer
Person ID field	L_Log table L_Person table	number
Pharm 1st or 2nd generation cephalosporins	L_Log table	boolean
Pharm 4th generation cephalosporins	L_Log table	boolean
Data fields

Magic words

• abra-cah-dabrah?

e.g. {{CURRENTYEAR}} to get : 2025 see https://www.mediawiki.org/wiki/Help:Magic_words

transcluding category...

Doesn't work.

transcluding subheadings...

Doesn't work, sucks in whole article

wiki testing, syntax and tricks

• Transclusion of an article: {{:articlename}}
• emailing lists: email the CC data collectors (see also Category:Critical Care Data Collectors)
• sorted table: see Drugs Collected
• file/UNC linking doesn't work because browsers disallow it as unsafe
• comments in wiki articles that won't show in normal view, only edit:
  • <!-- This is a comment, too -->
• table generator: File:Wiki_Tables.xls, originally from here

Parser Functions

lowercase works so hopefully so do the others... http://en.wikipedia.org/wiki/Help:Parser_function try this no 1 yes

Transclusion vs Substitution

Transclusion is calling content from a page or template, substitution is copying it.

• http://www.mediawiki.org/wiki/Transclusion - e.g. {{templatename}}
• http://www.mediawiki.org/wiki/Manual:Substitution - e.g. {{subst:templatename}}