Changes between Version 8 and Version 9 of Ticket #525, comment 6
- Timestamp:
- Feb 19, 2016, 11:19:10 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #525, comment 6
v8 v9 14 14 j. The files contained data for all patients in the requested time interval, but only personal numbers for patients, for which data had been requested in the csv file sent to INCA (other entries had a local unique patient ID). 15 15 16 || '''INCA example file [s]''' || '''# Column headers''' || '''# Value lines''' || '''# Value lines for requested patients''' ||16 || '''INCA example file''' || '''# Column headers''' || '''# Value lines''' || '''# Value lines for requested patients''' || 17 17 || INCA_file_a || 145 || 9425 || 6522 || 18 18 || INCA_file_b || 146 || 9425 || 6522 || … … 21 21 22 22 The first version of INCA data import should only import data for patients, for which data had been requested in the csv file sent to INCA, i.e., those with personal numbers in the INCA export files. 23 24 No database schema for the INCA data was available. Inspection of data in the two example export files gave the following result: 25 26 || '''INCA example file''' || '''# Column headers''' || '''# Date columns''' || '''# String columns''' || '''# Integer columns''' || '''# Float columns''' || '''# Unknown type columns''' || 27 || INCA_file_a || 145 || 5 || 59 || 81 || 0 || 0 || 28 || INCA_file_b || 146 || 23 || 37 || 77 || 4 || 5 || 29 || Both files (all columns) || 291 || 28 || 96 || 158 || 4 || 5 || 30 || Both files (unique columns) || 286 || 28 || 94 || 155 || 4 || 5 ||