Changes between Version 9 and Version 10 of i2b2 Data Import Pathology Mapping v2

Timestamp:

04/17/13 10:32:29 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 Data Import Pathology Mapping v2

@@ -53 +53 @@
 
 I do not understand the Histology tables.  I have taken a guess that the HISTO_STAINS is the table most similar to test results.  However, I think it is probably more complicated than this.
+
+=== Haematology Fluid Tests
+
+Codes for haematology tests can either be for specific body fluids or generically for any body fluids.  The specific ones can be easily mapped to loinc codes, but the generic ones require more work.
+
+Accompanying a generic test is an test of type assay, whose result is the type of fluid.  The two rows in the haem_tests table appear to be linked by a shared Haem_Results_File field value.  It will therefore be possible to assign a LOINC code to a test code and assay result combination.  However, I suspect some combinations may have to be mapped to generic '... in Body Fluid' LOINC codes.
+
+Here is a complete list of the possible Assay results:
+
+||Result||Result_Expansion||
+||NULL||NULL||
+||===||..||
+||ASCITI||Ascitic fluid||
+||BILE||Bile fluid||
+||BILIAR||Biliary drainage fluid||
+||BLANK||      ||
+||BLANK||..||
+||CLEAR||Clear fluid||
+||GASASP||Gastric aspirate||
+||INSUFF||Insufficient specimen for analysis||
+||JOINT||Joint aspirate||
+||KNEE||Knee aspirate||
+||KNEES||Material from knee fluid||
+||N/A||Assay not available||
+||NASAL||Nasal fluid||
+||NOSAM||No Sample received.||
+||NSR||No sample received in laboratory||
+||OTHER||Other fluid, see diagnosis||
+||PERICA||Pericardail fluid||
+||PERITO||Peritoneal dialysis fluid||
+||PLEURA||Pleural fluid||
+||STRA||Straw colouration||
+||UK||Unknown fluid||
+||UNSUIT||Specimen unsuitable for analysis||
+||WOUND||Wound exudate||