Hi,
SUMMARY I am looking for insight on making modifiers work in SHRINE. I believe there are a list of 41 modifier metadata rows for DIAGNOSIS ... but I don't see them in the SHRINE client. I believe I have successfully installed the non-modifier portion of the DIAGNOSIS metadata. I can successfully query on ICD9 and ICD10 metadata. But I see no modifiers in the client. DETAILS I am working on installing DIAGNOSIS metadata for the UNMC SHRINE Spoke, which is installed into the PCORNET_DIAG_2_1_2 table and referenced by the public.TABLE_ACCESS table in the i2b2metadata database. I obtained the current pcornet_diag_metadata.txt file published by Harvard at https://github.com/ARCH-commons/arch-ontology/tree/master/MetadataLoader/MetadataFiles After installing that table, and modifying C_BASECODE values to match UNMC, I was able to perform queries involving ICD9 and ICD10 codes. However, I don't see any modifiers displayed in the SHRINE client. In the PCORNET_DIAG_2_1_2 table, there are 41 rows that appear to be modifier metadata. If I install these to the i2b2metadata.modifier_dimension, and set C_BASECODE appropriately, is that all I need to do? Is there something that needs to be done int he shrine_ont schema? EVEN MORE DETAILS The 41 modifier rows have the following c_fullname, c_basecode and m_applied_path c_fullname c_basecode m_applied_path \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\FI\ DX_SOURCE:FI \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\HC\ CONDITION_SOURCE:HC \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\NI\ CONDITION_SOURCE:NI \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\ \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\OT\ CONDITION_SOURCE:OT \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\PC\ CONDITION_SOURCE:PC \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\PR\ CONDITION_SOURCE:PR \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\UN\ CONDITION_SOURCE:UN \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\ \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\NI\ DX_SOURCE:NI \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\OT\ DX_SOURCE:OT \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\UN\ DX_SOURCE:UN \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\IN\ DX_SOURCE:IN \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_STATUS\AC\ CONDITION_STATUS:AC \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_STATUS\IN\ CONDITION_STATUS:IN \PCORI\DIAGNOSIS\% \PCORI_MOD\ORIGDX\ \PCORI\DIAGNOSIS\ \PCORI_MOD\ORIGDX\ \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\UN\ PDX:UN \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\ \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\OT\ PDX:OT \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\ \PCORI\DIAGNOSIS\ \PCORI_MOD\PDX\S\ 2 \PCORI\DIAGNOSIS\% \PCORI_MOD\ORIGDX\Mapped\ ORIGDX:MAPPED \PCORI\DIAGNOSIS\% \PCORI_MOD\ORIGDX\Unmapped\ ORIGDX:UNMAPPED \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\ \PCORI\DIAGNOSIS\ \PCORI_MOD\CONDITION_STATUS\RS\ CONDITION_STATUS:RS \PCORI\DIAGNOSIS\% \PCORI_MOD\ORIGDX\OT\ ORIGDX:OT \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\NI\ PDX:NI \PCORI\DIAGNOSIS\% \PCORI_MOD\ORIGDX\UN\ ORIGDX:UN \PCORI\DIAGNOSIS\% \PCORI_MOD\ORIGDX\NI\ ORIGDX:NI \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\ \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\X\ 0 \PCORI\DIAGNOSIS\% \PCORI_MOD\PDX\P\ 1 \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_STATUS\OT\ CONDITION_STATUS:OT \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_STATUS\UN\ CONDITION_STATUS:UN \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_STATUS\ \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_STATUS\ \PCORI\DIAGNOSIS\ \PCORI_MOD\CONDITION_STATUS\NI\ CONDITION_STATUS:NI \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\CONDITION_SOURCE\RG\ CONDITION_SOURCE:RG \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\AD\ DX_SOURCE:AD \PCORI\DIAGNOSIS\% \PCORI_MOD\CONDITION_OR_DX\DX_SOURCE\DI\ DX_SOURCE:DI \PCORI\DIAGNOSIS\% Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
