Implement an ICDC data dictionary importer

[jiaola]

Description

Need to import ICDC data into our database.

Questions

Tasks

Check here when tasks are adequately answered

• [x] 1. Where is the data dictionary, if it exists, in whatever form it exists?
• [x] 2. What are the limitations to the current data dictionary, if it exists?
• [x] 3. What are the timelines for this data dictionary to be upgrade into something that would be more useful for us?
• [x] 4. Who is primary ICDC contact for this data dict?
• [ ] 5. What work needed on our end to import, given what we know now?

Discussion

1. Where is the data dictionary, if it exists, in whatever form it exists?

So far, this repo dir contains the model in 2 files (though there is a 3rd .mdf schema file):

• Entities (called "categories") and their attributes (called "props")
• Attributes (called "props") and their enumerations (called "types")

2. What are the limitations to the current data dictionary, if it exists?

• Structure: From what I can see so far, structure is a bit different, but that may be about it.
• Completeness: It doesn't seem like a very big model. Is this it?

3. What are the timelines for this data dictionary to be upgrade into something that would be more useful for us?

Enumerations will (a) either be added where localhost:refs appear appears, or (b), more likely, they will publish a server in which these can be resolved via a query.

From what I can gather, this will probably be done in 2022, probably within the first half of the year.

4. Who is primary ICDC contact for this data dict?

Mark Jensen & Philip Musk

5. What work needed on our end to import, given what we know now?

TODO

[joeflack4]

Note to self: when ready to work on this, I have some notes in Workflowy I've saved from my discussion w/ Jim & Phil that will be very useful to go over again.

[joeflack4]

Regarding ICDC terminological codes: i can search NCIT for ICDC codes, they've already worked with NCIT team to put some things in there.