Happy new year, commnunity! I am not sure whether this topic should be under this category. Please let me know if it should not.
I am currently working on a project to get a REDCap survey data into OMOP CDMs by using CDM 5.4. The survey data is about Epilepsy. Besides the patient’s basic info, the survey consist of quite a few yes/no and multiple questions. Some questions are from standard questionnaires such as ‘QOLIE-10’, ‘EQ-5D-5L’, ‘NDDI-E’, ‘GAD-7’ and ‘Livepool adverse event’ some are non-standard. They look like this:
Q: Taking into account all aspects of your epilepsy or seizure disorder, how disabling is it? (please check one)
* Extremely disabling
* Very disabling
* Quite disabling
* Moderately disabling
* Somewhat disabling
* A little disabling
* Not at all disabling
Q: Do you take anti-seizure medication(s)?
* Yes
* No
Q: Do you currently dirve?
* Yes
* No
Q: Who is completing this form?
* Patient
* Caregiver
Q: What had do you primarily use?
* Right
* Left
* Both
Q: What is your primary source of income? Please check all that apply. View data history
* View comment log
* Employment
* Spouse/Family Support
* Investment/Savings
* Retirement Pension
* Social Services
* AISH
* Disability Insurance
* None
I come across problems. The problems are many options are not in ‘Athena’. I read some discussions posted back a while ago. The way to do would be:
For multiple questions, make one question for each of its options and save the target data into ‘Observation’ table (I am using CDM 5.4). But what if an option item say ‘AISH’ is not in the ‘concept’ table, how should you do it? Just add new item for it straight into ‘Concept’ table?
Can I make my own set of survey option concept_ids for this purpose? If I do in this way, what vocabulary tables involved? Is ‘Concept’ table the only one? What is the best practice?
Any suggestions are highly appreciated. Thank you in advance.
Zohdsi - Ray