How copyrights are represented in CSV
2014-10-11 at 01:26 #16360
The User’s Guide is unclear about how LOINC represents copyright information. I do not see my question answered in the FAQ, or searching the forums. An earlier question in the implementor’s forum remains unanswered.
There is a table of copyright information in source_organization.csv.
I expected one of the columns of loinc.csv to reference the the “COPYRIGHT_ID” column of source_organization.csv. Indeed the description of this column (in Table 28c on page 93 of the “LOINC Users’ Guide”) specifies that the “COPYRIGHT_ID” column is referenced by a foreign key in the LOINC table…. but it does not say which column in loinc.csv contains that foreign key.
The only column in loinc.csv that (based on the name) could be a foreign key pointing to a row in source_organization.csv is “EXTERNAL_COPYRIGHT_NOTICE”. However, looking at loinc.csv, “EXTERNAL_COPYRIGHT_NOTICE” actually contains a full, lengthy, copyright statement, not values from any source_organization.csv “COPYRIGHT_ID” column.
Is source_organization.csv actually unused? Or am I just overlooking some foreign key other than “EXTERNAL_COPYRIGHT_NOTICE”?2014-10-15 at 13:41 #16714
The source_organization.csv file and the SOURCE_ORGANIZATION table in the loinc.mdb database are provided to give some basic, limited, information about some of our data sources. You have correctly pointed out that currently there is no “foreign key” identifier in the loinc.csv file or LOINC table to directly link to a record in the source_organization.csv file or SOURCE_ORGANIZATION Table in the loinc.mdb database.
After due consideration, it has been decided to add this field to the loinc.csv file and LOINC table in the loinc.mdb database in the next release currently scheduled for December of this year.
Thank you for your interest in LOINC2014-12-09 at 21:58 #16715
Great! Does that mean the “EXTERNAL_COPYRIGHT_NOTICE” column of loinc.csv will be replaced by the the foreign key, or will there be two (possibly conflicting) sources of copyright information?2014-12-10 at 14:52 #16716
Thank you. You’ve clarified this a lot, and I’m still a bit confused about what to do when both LOINC.EXTERNAL_COPYRIGHT_NOTICE and LOINC.EXTERNAL_COPYRIGHT_LINK are populated.
It sounds like EXTERNAL_COPYRIGHT_NOTICE is the only legally binding copyright information, and EXTERNAL_COPYRIGHT_LINK provides potentially useful additional information that should be ignored in the event of a conflict. Is that correct?2014-12-11 at 13:05 #16718
You must be logged in to reply to this topic.