User Tools

Site Tools


projects:workgroups:cdm-wg:add_survey_data

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
projects:workgroups:cdm-wg:add_survey_data [2017/05/29 16:45]
cmkerr
projects:workgroups:cdm-wg:add_survey_data [2017/05/29 16:52]
cmkerr [Proposal]
Line 18: Line 18:
   - The patient responses are stored as key-value pairs in the OBSERVATION table, but we need to be able to group responses together according to the survey they belong to. We propose adding a new column - SURVEY_ID - to the OBSERVATION table.   - The patient responses are stored as key-value pairs in the OBSERVATION table, but we need to be able to group responses together according to the survey they belong to. We propose adding a new column - SURVEY_ID - to the OBSERVATION table.
   ​   ​
-===== SURVEY table =====+=== SURVEY table ===
 ^ Field                ^ Required ​ ^ Type         ^ Description ^ ^ Field                ^ Required ​ ^ Type         ^ Description ^
 | SURVEY_ID ​           | Yes       | integer ​     | Unique identifer for each completed survey | | SURVEY_ID ​           | Yes       | integer ​     | Unique identifer for each completed survey |
Line 38: Line 38:
  
  
-===== OBSERVATION table - new columns ​=====+=== OBSERVATION table - new columns ===
 ^ Field                ^ Required ​ ^ Type         ^ Description ^ ^ Field                ^ Required ​ ^ Type         ^ Description ^
 | SURVEY_ID  ​          | No        | integer ​     | A foreign key to the survey in the SURVEY table to which the observation belongs |  | SURVEY_ID  ​          | No        | integer ​     | A foreign key to the survey in the SURVEY table to which the observation belongs |
-ADMIN_CODE  ​      | No        | varchar(255) ​ +TIMING_CONCEPT_ID ​   ​| No        | integer ​     ​A foreign key that refers to a timing Concept identifier in the Standardized Vocabularies ​
-ADMIN_CODE_VOCAB  ​  | No        | varchar(100) |  |  +TIMING_SOURCE_VALUE ​ | No        | varchar(100) | Text string representing the timing of the survey ​|
-| TIMING  ​          | No        | varchar(100) |  |+
  
 ==== Use Cases ====  ==== Use Cases ==== 
projects/workgroups/cdm-wg/add_survey_data.txt · Last modified: 2017/05/30 14:23 by cmkerr