Changes between Version 12 and Version 13 of Ticket #525, comment 6


Ignore:
Timestamp:
Feb 22, 2016, 11:36:21 AM (8 years ago)
Author:
olle

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #525, comment 6

    v12 v13  
    1212 h. The files together contained 75 (45 + 30) column pairs, where the column header names in each pair consisted of a common unique identifier plus suffix "_Beskrivning" and "_Värde", respectively, corresponding to "_Description" and "_Value" in English. The value column contained an integer value, that was presumably stored in the database, while the description column contained a Swedish description of the property encoded by that particular value. The columns in a pair did not always come in the same order. File "INCA_file_b" contained two "_Description" columns, without a corresponding "_Value" column, where the contents in both cases consisted of either "Höger", "Vänster", or no value, corresponding to English "Right", "Left", or no value.
    1313 i. Each line contained data for a single patient, but data for one patient might appear in more than one line.
    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).
     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. However, all data lines had a temporary unique patient ID, in order to identify entries related to the same patient.
    1515
    1616|| '''INCA example file''' || '''# Column headers''' || '''# Value lines''' || '''# Value lines for requested patients''' ||
    … …  
    3232Types of the columns represented in both example files:
    3333
    34 || '''Column headers in both example files''' || '''Value type''' ||
    35 || PATID || Integer ||
    36 || !PersonalNo || String ||
    37 || A030Sida_Beskrivning || String ||
    38 || A030Sida_Värde || Integer ||
    39 || KON_VALUE || Integer ||
     34|| '''Column headers in both example files''' || '''Value type''' || '''Comment''' ||
     35|| PATID || Integer || Temporary patient id ||
     36|| !PersonalNo || String || Personal number (for requested patients only) ||
     37|| A030Sida_Beskrivning || String || Laterality "Höger" (Right), "Vänster" (Left) ||
     38|| A030Sida_Värde || Integer || Laterality 1 = Right, 2 = Left ||
     39|| KON_VALUE || Integer || "Kön" (Sex) 1 = Male, 2 = Female ||
    4040
    4141Inspection of the example files indicated that Boolean variables related to check boxes (checked = true), were coded as 1 for checked = true, and `null` (blank) for unchecked = false.