[Proposal] Add "event_id" and "event_field_concept_id" columns to PROCEDURE_OCCURRENCE
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 28/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Stale
- Domain
- databases
Research direction
Start by comparing the PROCEDURE_OCCURRENCE definition with the MEASUREMENT and OBSERVATION tables, focusing on their event_id and event_field_concept_id columns. Review the issue discussion to determine whether links to physical objects fit the model; done requires an accepted design and corresponding model definitions, but the payload names no specific files or tests.
Written by the indexing model from the issue text.
Description
I think the PROCEDURE_OCCURRENCE table is missing the option to link it to other tables and their primary keys. This would be similar to event_id and event_field_concept_id in tables such as MEASUREMENT or OBSERVATION.
A real-life example would be a procedure performed on a physical object or part of it (e.g. hemodialysis machine).
Let me know, what you think! :-)
- Dominant language
- HTML
- Stars
- 1.1k
- Forks
- 513
- Avg merge
- 8d 3h
- Merged PRs (30d)
- 4
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from OHDSI/CommonDataModel
-
Difficulty 1/5 Under an hour Newbie friendliness 74/100
OHDSI/CommonDataModel#802 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
OHDSI/CommonDataModel#799 ·
-
fix: mark cohort_definition_id as primary key in cohort_definition table for v5.3 and v5.4Possibly taken @rtmalikian claimed this 137 days ago. Open
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
OHDSI/CommonDataModel#787 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
OHDSI/CommonDataModel#784 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 55/100
OHDSI/CommonDataModel#823 ·
All issues in OHDSI/CommonDataModel
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
nopSolutions/nopCommerce#8439 ·
Maintainers usually reply within 1 day
-
bug:new
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
callstackincubator/simlock#1234 · 1 comment ·
Maintainers usually reply within 1 day
-
🐛 Bug: node-sqlite3 example fails on values that contain a quotePossibly taken @RaphaelFakhri claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
mochajs/mocha-examples#130 ·
-
`HandleEmptyInListsPlugin` / `SafeNullComparisonPlugin` skip expressions nested in `eb.selectFrom(...)` subqueriesPossibly taken @superbot-helper claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
kysely-org/kysely#2216 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Maintainers usually reply within 1 day