Good stuff, Phillip! I just checked it against various details I recorded when we closed issues, and they all match.
And no, procedures (#243<https://informatics.gpcnetwork.org/trac/Project/ticket/243>) is still open. I moved a bunch of obsolete stuff out of the way (put "z-" in front of the name). For audit purposes, I set the update_date to the date of your message and added some details to those decision records; e.g. demographics #67<https://informatics.gpcnetwork.org/trac/Project/ticket/67#comment:33>: select count(*) from gpc_terms where c_fullname like '%Demographics%' ; -- 799 create function h_int(text) returns int as $$ select ('x'||substr(md5($1),1,8))::bit(32)::int; $$ language sql; select sum(h_int(c_fullname)) from gpc_terms where c_fullname like '%Demographics%' ; -- 10961865689 -- ignoring the initial segment (#201): select sum(h_int(replace(c_fullname, '\i2b2', ''))) from gpc_terms where c_fullname like '%Demographics%' ; -- 31946283224 update gpc_terms set update_date = timestamp '2015-04-21 12:40:16' --date of philip's msg to gpc-dev where c_fullname like '%Demographics%' ; -- Dan ________________________________ From: [email protected] [[email protected]] on behalf of Phillip Reeder [[email protected]] Sent: Tuesday, April 21, 2015 12:40 PM To: [email protected] Subject: GPC_TERMS Table I believe the GPC_TERMS table has the most current demographics, diagnosis, medications, and vital signs terminologies. For Diagnosis, I just moved over Hubert’s updated modifiers. I propose that this table become the home for the Approved GPC Terminologies. So, that would take care of Demographics Diagnoses Medications Vital Signs Needing: Encounter — GPC_ENCOUNTER_TERMS, is this the table to use? I don’t have access to the table with my account so I can’t copy it into GPC_TERMS. Procedures — Is there a finalized approved metadata? If so where? Lab Tests — Still no approved lab terminology. Anything else? Does this sound like a reasonable plan? I’ll volunteer to continue to manage this table, but I will need input as to which additional terminologies we are ready to add. Phillip ________________________________ UT Southwestern Medical Center The future of medicine, today.
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
