DataSet Release Note 21 July 2002 - National-Clinical-Cohort-Collaborative/Data-Ingestion-and-Harmonization GitHub Wiki

  • Site:- Asked sites to
  1. address the multi mapped concept ids for a given term.
  2. about the negative visit duration.
  • Site: - Fixed multi concept id map issue within domain map table
  • Site: - Categorical result qual not set properly in the measurement domain as result qual as value as concept id
  • Site: - Contains Encounter data with future dates : 58 records.
  • Site: - Need to decide the official unit of measure for a given lab results ( both numerical and categorical )

Need to verify - following question regarding units for T3 pending question. There are many other cases to consider.

  • Name: plausibleValueLow Description: For the combination of CONCEPT_ID 3010340 (Triiodothyronine (T3) [Mass/volume] in Serum or Plasma) and UNIT_CONCEPT_ID 8842 (nanogram per milliliter), the number and percent of records that have a value less than 6.00e+01. (Threshold=5%).
  • Level: CONCEPT
  • Table: MEASUREMENT
  • Field: MEASUREMENT_CONCEPT_ID
  • Concept Id: 3010340
  • Unit Concept Id: 8842
  • *# Rows Violated: 1247
  • *% Rows Violated: 99.68%
  • *# Denominator Rows: 1251