i2b2 Data Import Pathology Mapping v1

Tags: i2b2

Version 1 of the pathology import of data into i2b2 is based on the mapping of the top 10 Blood Sciences tests ordered from GGH Cardio Locations July 2010 - June 2011 to Snomed CT codes.

Code	Test		Test Code Grouping	Test Count	Read Code	Snomed CT from PBCL	NH lookup	NHS migration document
CREA	Creatinine 	Measured Tests		47521		44J3.		166713004		365757006	113075003
UREA	Urea		Measured Tests		47120		44J9.		166723008		365755003	273967009
NA	Sodium		Measured Tests		46947		44I5.		166691007		365761000	104934005
K	Potassium	Measured Tests		46376		44I4.		166687002		365760004	271236005
HCT	Haematocrit	Calculated Tests	43983		4258.		165418001		365616005	28317006
MCH	Mean Cell Hb	Calculated Tests	43977		428..		165436001		365611000	54706004
WBC	White Cell Count Measured Tests		43961		42H..		165506007		365630000	767002
MCV	Mean Cell Volume Calculated Tests	43890		42A..		104133003		365615009	104133003
RBC	Red Blood Count	Rest of FBC measured	43884		426..		14089001		365625004	14089001
NRBCAD	Nucleated RBC	Rest of FBC measured	43733		4266.	 	165426009		?		165426009
PLT	Platelet Count	Rest of FBC measured	43554		42P..		61928009		365632008	61928009
MONAB	Monocyte Count	Rest of FBC measured	43409		42N..		67776007		365631001	67776007

Current plan is to use the manually obtained ("NH lookup") SNOMED CT code.

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'