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

	FieldName	InTable	FieldDataType	ElementDescription
3rd generation cephalosporins	3rd generation cephalosporins	L_Pharm_Flowsheet table	number
ADL Bathing	ADL_Bathing	L_Log table	string
ADL Complete	ADL Complete	L_Log table	boolean
ADL Continence	ADL Continence	L_Log table	string
ADL Dressing	ADL_Dressing	L_Log table	string
ADL Feeding	ADL_Feeding	L_Log table	string
ADL Toiletting	ADL_Toiletting	L_Log table	string
ADL Transfering	ADL_Transfering	L_Log table	string
AP Dias BP Field	Ap_APDiasBP	L_Log table	number
AP_Eye field	AP_Eye	L_Log table	string
AP_Motor field	AP_Motor	L_Log table	string
AP Sys BP Field	Ap_APSysBP	L_Log table	number
AP_Verbal field	AP_Verbal	L_Log table	string
ARF (APACHE)	Ap_ARF	L_Log table	number
AaDO2	AaDO2	N/A	number
Abdominal ultrasound	US_Abd	L_Labs_Flowsheet table	integer
Accept DtTm field	Accept DtTm	L_Log table	date
Accept DtTm missing field	Accept_DtTm_missing	L_Log table	boolean
Admit Type for APACHE II	Ap_AdmitType	L_Log table	string
Age	age	N/A	number
Albumin 25pct	Albumin_25pct	L_Labs_Flowsheet table	integer
Albumin 5pct	Albumin_5pct	L_Labs_Flowsheet table	integer
Angio coronary field	Angio_coronary	L_Labs_Flowsheet table	integer
Angio others field	Angio_others	L_Labs_Flowsheet table	integer
Antipseudomonals	antipseudomonals	L_Pharm_Flowsheet table	number
Ap Complete	Ap Complete	L_Log table	boolean
Ap SapsSysBP field	Ap_SapsSysBP	L_Log table	number
Arrive DtTm field	Arrive_DtTm	N/A	date
Arterial blood gas (labs)	ABG	L_Labs_Flowsheet table	integer
Azoles	azoles	L_Pharm_Flowsheet table	number
Benzodiazepines cont inf	benzodiazepines cont inf	L_Pharm_Flowsheet table	number
Blood culture	Blood_CS	L_Labs_Flowsheet table	not entered
CBC	CBC	L_Labs_Flowsheet table	integer
CCI 1 Code	not stated	N/A	number
CCI 2 Code	not stated	N/A	number
CCI Picklist Code	not stated	L_CCI_Picklist table	string
CT Scan (labs)	CT_Scan	L_Labs_Flowsheet table	integer
CXR	CXR	L_Labs_Flowsheet table	integer
Carbapenems	carbapenems	L_Pharm_Flowsheet table	number
Ceftazidime	ceftazidime	L_Pharm_Flowsheet table	number
Chart number	Chart	L_Log table L_PHI table	string
Chronic Health APACHE	Ap_Chronic	L_Log table	string
ClientGUID field	ClientGUID	L_Log table	string
ClientVisitGUID field	ClientVisitGUID	L_Log table	string
Como Complete	Como_Complete	L_Log table	boolean
Creatinine (APACHE)	Ap_Creat	L_Log table	number
Creatinine (labs)	Creatinine	L_Labs_Flowsheet table	integer
D ID field	D_ID	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	R_dc_treat	L_Log table	string
Date of Birth	Birth	L_Log table L_PHI table	date
Diag Complete	Diag_Complete	L_Log table	boolean
Dispo DtTm field	Dispo_DtTm	L_Log table	date
Dispo field	dispo	L_Log table	number
Dx Date	Dx_Date	L_ICD10 table	date
Dx Date unknown	Dx_Date_unknown	L_ICD10 table	boolean
Dx Primary	Dx primary	L_ICD10 table	boolean
Dx Priority	Dx Priority	L_ICD10 table	number
Dx Type	Dx Type	L_ICD10 table	string
ER Delay	ER Delay	Created Variables Common 2021 table	date
Echocardiogram	US_Echo	L_Labs_Flowsheet table	number
FFP	FFP	L_Labs_Flowsheet table	integer
FiO2	Ap_FIO2	L_Log table	number
FirstName field	FirstName	L_Log table L_PHI table	string
Fluoroquinolones	fluoroquinolones	L_Pharm_Flowsheet table	number
Fungins	fungins	L_Pharm_Flowsheet table	number
Furosemide cont inf	furosemide cont inf	L_Pharm_Flowsheet table	number
GCS sedated field	GCS_sedated	L_Log table	boolean
H2-Blockers	H2-Blockers	L_Pharm_Flowsheet table	number
HCT	Ap_Hemat	L_Log table	number
HR	Ap_HeartRate	L_Log table	number
Heparin SQ	Heparin SQ	L_Pharm_Flowsheet table	number
Hospitalization ID	Person_ID	L_Log table L_Person table	number
ICD10 code	ICD10 code	L_ICD10 table s_ICD10 table	string
Insulin cont inf	insulin cont inf	L_Pharm_Flowsheet table	number
K	Ap_K	L_Log table	number
L ICD10 ID	L ICD10 ID	L_ICD10 table	number
LMWH	LMWH	L_Pharm_Flowsheet table	number
Labs Complete	Labs_Complete	L_Log table	boolean
LastChanged DtTm field	LastChanged_DtTm	L_Log table	date
LastName field	LastName	L_Log table L_PHI table	string
LastOpened DtTm field	LastOpened DtTm	L_Log table	date
MRI (labs)	MRI	L_Labs_Flowsheet table	integer
Magnesium (labs)	Magnesium	L_Labs_Flowsheet table	integer
Mean BP	MBP	Created Variables CC 2021 table	number
Na	Ap_Na	L_Log table	number
Notes field	Notes	L_Log table	memo
Notes field (L PHI)	Notes	L_PHI table	string
Off ward field	off_ward	L_Log table	number
Opioids cont inf	opioids cont inf	L_Pharm_Flowsheet table	number
PCO2	Ap_CO2	L_Log table	number
PH	Ap_pH	L_Log table	number
PHIN field	PHIN	L_Log table L_PHI table	number
PO2	Ap_PO2	L_Log table	number
PPI	PPI	L_Pharm_Flowsheet table	number
PT PTT	PT_PTT	L_Labs_Flowsheet table	integer
Pat ID field	Pat_ID	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	Pentaspan	L_Labs_Flowsheet table	integer
Person ID field	Person_ID	L_Log table L_Person table	number
Pharm 1st or 2nd generation cephalosporins	pharm_1st or 2nd generation cephalosporins	L_Log table	boolean
Pharm 4th generation cephalosporins	pharm_4th generation cephalosporins	L_Log table	boolean
Data fields

Magic words

• abra-cah-dabrah?

e.g. {{CURRENTYEAR}} to get : 2026 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}}