RE: Charlson Index in the PCORnet CDM

Nebraska will be glad to share. Where do you think it would be best to post? Jim From: Roush, Steffani Sent: Friday, March 12, 2021 11:20 AM To: Campbell, James R Subject: RE: Charlson Index in the PCORnet CDM Non-UNMC email Wonderful, that sounds like it’s exactly what we need... Would you

CDMV6.1 feedback

I agree with what I understood Alex to say Tuesday, namely that the QUAL valuesets are going to promote confusion rather than interoperation since they are not provided as specific to any particular test code(s) and they have values that are inappropriate out of context. I enclose the feedback

Re: SNOMED in Condition? for Bardet-Biedel Syndrome (BBS) Request [was: gpc-dev July 14 agenda]

on behalf of Campbell, James R Sent: Monday, July 13, 2020 1:20 PM To: Russ Waitman ; Dan Connolly ; Roush, Steffani Cc: gpc-dev@listserv.kumc.edu Subject: Re: SNOMED in Condition? for Bardet-Biedel Syndrome (BBS) Request [was: gpc-dev July 14 agenda] Non-UNMC email Nebraska has records on 18

Re: SNOMED in Condition? for Bardet-Biedel Syndrome (BBS) Request [was: gpc-dev July 14 agenda]

Nebraska has records on 18 patients with problem list/CONDITION entry of 5619004|Bardet-Biedl syndrome (disorder)| Jim Campbell From: Gpc-dev on behalf of Russ Waitman Sent: Monday, July 13, 2020 12:45 PM To: Dan Connolly ; Roush, Steffani Cc: gpc-dev@listserv

Greater Plains Collaborative NAACCR (cancer registry) metadata deployment for i2b2

Colleagues At the last call, there was a a request for access for GPC network code for i2b2 ontology (metadata) for cancer registries. The authors of this work are University of Kansas (Dan Connolly(dconno...@kumc.edu) in Russ Waitman's (rwait...@kumc.edu) shop). Dan was good enough to provid

RE: SAS data sets

Nebraska maintains two past copies of CDM as SQL tables. Jim Campbell From: Gpc-dev On Behalf Of Gryzlak, Brian M Sent: Monday, February 17, 2020 2:04 PM To: gpc-dev@listserv.kumc.edu Subject: SAS data sets Non-UNMC email Hi everyone, We all know that sites are required to maintain copies of S

CPT4/HCPCS metadata for i2b2

Colleagues We find our current deployment of CPT4/HCPCS metadata (ontology) for i2b2 woefully out of date. Does anyone in GPC have resources with current procedures codes that they are willing to share with us? I am concurrently looking into ACT metadata in that regard to see how timely the on

RE: i2b2 on CDM, ACT integration

The i2b2/TranSmart foundation ontology workgroup has been negotiating support for standard releases of ONC terminologies as an integral part of the ACT i2b2 metadata. Nebraska plans to join ACT as a non-CTSA member and we have agreed with Michelle Morris of University of Pittsburgh on metadata

DCQA results

Keith I have been spending substantial time on updating the lab_normals ranges in CDMV51.LAB_RESULT_CM, specifically populating fields NORM_RANGE_LOW NORM_MODIFIER_LOW NORM_RANGE_HIGH NORM_MODIFIER_HIGH which I have fully populated in 51% of our lab test results and DCQA data check 3.10 came back

Re: [External] Re: Populating the CDM

It is not required, but compliance with PCORnet data quality constraints was a lot easier once we took the steps on post-processing Jim From: Gryzlak, Brian M Sent: Monday, October 7, 2019 9:56 AM To: Campbell, James R ; gpc-dev@listserv.kumc.edu Subject: RE

Re: Populating the CDM

In our final post-processing run, Nebraska removes all patients who have no data in LAB, PROCEDURES, MED_ADMIN, PRESCRIBING, DISPENSING, DIAGNOSIS, CONDITION ie clinical information. ENCOUNTERS is not our primary concern. Jim From: Gpc-dev on behalf of Gryzlak,

Re: CDMV5.1 implementation is different!

y, October 1, 2019 11:53 AM To: Campbell, James R Cc: GPC STANDARDS Subject: Re: CDMV5 implementation Non-UNMC email I think the main change is just to align the hashing Russ Waitman On Oct 1, 2019, at 12:24 PM, Campbell, James R mailto:campb...@unmc.edu>> wrote: I assume bas

CDMV5 implementation

I assume based upon Datavant presentation that we must be in compliance with CDMV5.1 for our next CDM refresh? Checking the PCORnet desktop, I find the 5.1 documentation but no new valueset documentrs. I assume what they published as CDMV5.0 valuesets are to be employed? Jim The information i

Re: CDM V5 - OBS_GEN and OBS_CLIN tables

Absolutely. The primary barrier for KU however will be building the LOINC mapping from flowsheets in Epic Jim From: Dan Connolly Sent: Tuesday, July 30, 2019 10:17 AM To: Campbell, James R ; Sravani Chandaka ; 'gpc-dev' Subject: RE: CDM V5 - O

Re: CDM V5 - OBS_GEN and OBS_CLIN tables

Nebraska has deployed both but we are not compliant with v5 yet, I believe it will not be required until later in the year? Jim Campbell From: Gpc-dev on behalf of Sravani Chandaka Sent: Monday, July 29, 2019 8:29 AM To: 'gpc-dev' Subject: CDM V5 - OBS_GEN and

HELP on Loading MS SQL dates to SAS datasets for CDMV41 tables

We are struggling to format our SAS datasets from the CDMV41 tables we have built and recently converted to MS SQL. The inbound dates from MS SQL end up as SAS Numeric 'DATE9' format which does not match the format we had employed before. Our date formatting code converts everything to '196001

When is cycle 6 submission due?

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. __

Re: SNOMED CT mapping to ICD-9, ICD-10, LOINC

Keith SNOMED CT(Clinical findings, Events and Situations) to ICD-10-CM rule-based map is supported and published by NLM through UMLS Knowledge Server. SNOMED CT(Clinical findings, Events and Situations) to ICD-10 rules-based map is supported by the IHTSDO and published in RF2 format available fr

RE: Question from Mark Weiner of PaTH regarding LOINC coding in OBS_CLIN and PRO_CM

Mark The list you have is apparently older. Here is a frequency analysis from Nebraska of LOINC coding in OBS_CLIN PRO_CM and OBS_GEN as we have currently deployed it. I will be adding 75-100 new data items soon. Jim From: Gpc-dev On Behalf Of Campbell, James R Sent: Friday, March 15, 2019

Question from Mark Weiner of PaTH regarding LOINC coding in OBS_CLIN and PRO_CM

ively." From: Weiner, Mark Sent: Friday, March 15, 2019 7:50 AM To: Campbell, James R; 'GPC STANDARDS'; Research Informatics Group, UNMC Subject: RE: PCORI OBS_CLIN Non-UNMC email Hello again! While some in our PaTH network have already incorporated many of the flowshe

Fw: IMPORTANT -- (for tomorrow demo, + for Transmart documentation) -- RxNORM metadata -- in GITHUB, documentation

From: Pedersen, Jay G Sent: Monday, January 14, 2019 4:26 PM To: Campbell, James R; Pedersen, Jay G; McClay, James C; Narayana, Yeshwanth R Subject: IMPORTANT -- (for tomorrow demo, + for Transmart documentation) -- RxNORM metadata -- in GITHUB, documentation

Re: [gpc-informatics] #715: NextD request on mapping payer_type variable

From: GPC Informatics Sent: Tuesday, November 20, 2018 7:27 AM To: furmanc...@icnanotox.org; nicholas-c-sm...@uiowa.edu; dconno...@kumc.edu; mei...@kumc.edu; Campbell, James R; astodd...@mcw.edu; michael-wrigh...@uiowa.edu; verhagen.lau...@mcrf.mfldclin.edu; xs...@kumc.edu Cc

LOINC CLASS and CLASSTYPE

Phillip Assuming that he lab results reported at SW are LOINC coded you can join the release table from Regenstrief and use the LOINC.System coded data to map the specimen requirement for CDM. I also used the LOINC.ExampleUCUM units to jump start the CDMV4.RESULT_UNIT mapping. The LOINC.CLASST

Fw: AMIA workshop with U Missouri

KU will not allow transfer of 25MB files. The slides for the workshop can be found here: https://symposium2018.zerista.com/event/member/507924 <https://symposium2018.zerista.com/event/member/507924>Jim From: Campbell, James R Sent: Tuesday, November 13

Re: gpc-dev October 30 agenda and meeting notes

In response to MU query, we reviewed our LAB_RESULT_CM table. We have UCUM units mapped for ~5000 tests but normals ranges only for 40-50. We also have the investigative exception flagged on the EDC report for too few normals ranges reported. If anyone can benefit from a copy of those mappin

Re: DCQ Reminder

Nebraska submitted today Jim C From: Gpc-dev on behalf of Verhagen, Laurel A Sent: Thursday, October 25, 2018 3:47:03 PM To: gpc-dev@listserv.kumc.edu Subject: DCQ Reminder Non-UNMC email Hi everyone, Just a reminder to go through the Cycle 5 Data Curat

Proposal for notes deidentification project

George Here is the abstract of the proposal for use of deidentified pathology notes. I observe that it would not require running through all the IRB approval for general deployment of the software in i2b2. Perhaps we should call for proposals from other GPC sites as well? Jim "It is our vi

Fw: C4UN - death table records data curation

AM To: Campbell, James R Subject: C4UN - death table records data curation Non-UNMC email Hi James, I apologize for following up w/ this after the approval of Nebraska’s data curation submission – but we noticed something in the code that was changed between last cycle and this cycle th

Re: CDM Counts for Refresh

Every count between CDMV41 and DCQA on the money at Nebraska: SAS_REFRESH_20180729CDMV41_DCQA CDM_TABLE_NAME 3012162630121626MED_ADMIN 4469372 4469372 CONDITION 242330 242330 DEATH 0 0 DEATH_CAUSE 1249440 1249440 DEMOGRAPHIC 1263794612637946DI

Sharing RXNORM_NDC history files

I need the email of Ryan from Iowa and anyone else that wants access to the Medication history files we have compiled for our metadata build Jim Campbell The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use

CDMV41.OBS_CLIN

i know that OBS_CLIN is considered optional for data load this round but I just wanted to relay Nebraska experience with the new data tables. I followed advice in the CDMV4.1 documentation which suggested that LOINC CLASS = 1 observations should be loaded in LAB_RESULT_CM, CLASS = 2 in OBS_CLIN

CDMV41.PROVIDER .PROVIDER_NPI_FLAG

Does anyone have a read on what the PROVIDER_NPI_FLAG is supposed to mean? Are they talking about whether we have data or another site can use the info? Jim "Flag to indicate whether partner has access to the National Provider Identifier (NPI) of the provider." The information in this e-mail

Re: SNOW SHRINE metadata

From: Klann, Jeffrey G. Sent: Tuesday, April 3, 2018 8:16 PM To: Campbell, James R; Murphy, Shawn N. Cc: Campbell, Walter S; Pedersen, Jay G; Narayana, Yeshwanth R; Estiri, Hossein; Joss, Matthew A. H. Subject: Re: SNOW SHRINE metadata Non-UNMC email This is great

RE: MED_ADMIN route and units codes

] Sent: Friday, March 23, 2018 7:11 AM To: Campbell, James R Cc: allison.hauf...@duke.edu; Pedersen, Jay G ; gpc-dev@listserv.kumc.edu; Campbell, Walter S ; Vreeman, Daniel J ; michelle.sme...@duke.edu; Katie Arnold Subject: Re: MED_ADMIN route and units codes Non-UNMC email Jim, These are

RE: MED_ADMIN route and units codes

= VOLUME{ampule} Puff = VOLUME{puff} Spray = VOLUME{spray} Each = NUMBER Units = [IU] Jim Campbell From: Gpc-dev [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Campbell, James R Sent: Tuesday, March 20, 2018 9:53 AM To: Keith Marsolo ; allison.hauf...@duke.edu Cc: Pedersen, Jay G ; gpc-dev

MED_ADMIN route and units codes

Keith Allison For routes, I cannot code 'Dialysis', 'Infiltration' and 'Injection' and must use OT? I cannot locate UCUM for these units: CASE WHEN O.HV_DOSE_UNIT_C = 5002 THEN 'tablet' WHEN O.HV_DOSE_UNIT_C = 5006 THEN 'puff' WHEN O.HV_DOSE_UNIT_C = 5004 THEN 'drop'

Re: [gpc-informatics] #201: Align c_table_cd in table_access (item_key) across sites

I got a copy of ACT from Debbie Yoshihara at Madison.Jim From: GPC Informatics Sent: Wednesday, February 28, 2018 1:36 PM To: lpa...@kumc.edu; ngra...@kumc.edu; dconno...@kumc.edu; Campbell, James R Cc: rwait...@kumc.edu; Campbell, Walter S; rachel.h

RE: [gpc-informatics] #667: CDM: Determine CDM code list (e.g. ICD/HCPCS/RXCUI/NDC) to create analysis variables for each patient

Correct. Do you want an IN-SCD-NDC table for the ingredients of interest? Jim -Original Message- From: GPC Informatics [mailto:d...@madmode.com] Sent: Monday, February 26, 2018 9:19 AM To: brian-gryz...@uiowa.edu; Campbell, James R ; dconno...@kumc.edu Cc: ryan-carna...@uiowa.edu

AMIA workshop

I would like to propose a workshop to fall AMIA:"Populating your i2b2 data warehouse from your EHR with ONC terminology standards" I think it would have much greater value and be more likely accepted if one of our colleagues from a Cerner institution would like to do it with me. I presume we

Re: [gpc-informatics] #651: Load infusion data to CDM v 4.0 med_admin table and submit

The only modifiers we use for med_admin at UNMC are: 'RX_BASIS:AD\INPT\' with all CONCEPT_CDs as NDC. Jim From: GPC Informatics Sent: Friday, February 23, 2018 4:44:29 PM To: brian-gryz...@uiowa.edu; rwait...@kumc.edu; dconno...@kumc.edu; Campbell

Re: [gpc-informatics] #651: Load infusion data to CDM v 4.0 med_admin table and submit

, James R; astodd...@mcw.edu; verhagen.lau...@mcrf.mfldclin.edu; catec...@kumc.edu Cc: ryan-carna...@uiowa.edu; phillip.ree...@utsouthwestern.edu; tchis...@ufl.edu Subject: Re: [gpc-informatics] #651: Load infusion data to CDM v 4.0 med_admin table and submit Non-UNMC email #651: Load infusion

SHRINE\SCILHS metadata enhancements and maintenance plan proposed by Nebraska

Jeff >From our call 10 days ago, we are proceeding with the plan below for support >of i2b2 metadata for our SNOW SHRINE network. Relative to the INITIAL release >and to support SCILHS sites that want to use our metadata expansions, we >propose to add the following metadata sets to SCILHS 2.20

Hackathon 5

Dan I have scoured the GPC site but cannot find where I might register for hackathon 5 and submit material for agenda proposal Jim 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

RE: gpc-dev / RCR 31 Oct agenda

I can’t seem to activate GoToMeeting…did you change the meeting number? Jim Campbell From: Gpc-dev [mailto:gpc-dev-boun...@listserv.kumc.edu] On Behalf Of Gryzlak, Brian M Sent: Monday, October 30, 2017 3:48 PM To: gpc-...@listserv.kumc.edu; , Subject: gpc-dev / RCR 31 Oct agenda Non-UNMC email

RE: GPC c003, Initial Refresh Feedback

I raised the issue of NDC codes for PROCEDURES with DRN-OC months ago since it was clearly specified in the CDV31 documentation but made no sense to me. Keith Marsolo and the data curation people indicated this was included in the specification for MED ADMINISTRATION events. PRESCRIBING and DI

Re: PCORI CDM Lab Issue

The 11000+common labs we are setting up for our SNOW-SHRINE node are planned to have common lab names derived from LOINC and we also plan to put together our result ranges into metadataxml that can support result checking and query by value. We presume that those with quantitative results can h

Re: LOINC alpha release of LOINC groups\Building a LOINC ontology

Russ I haven't discussed this personally with Dan Vreeman but I suspect that this is paralleling some of the work that Regenstrief-IHTSDO are doing to harmonize (and ontologize) Observable entities. (Both LOINC and SNOMED CT have concepts pertinent to Observeable entities) The groups codes t

RE: [gpc-informatics] #596: targeted cancer therapy study - Query 1, 2, 3

; Campbell, James R ; McClay, James C ; schand...@kumc.edu; btay...@mcw.edu; mcneele...@health.missouri.edu; verhagen.lau...@mcrf.mfldclin.edu; tmcma...@kumc.edu; danh...@regenstrief.org; gkowal...@mcw.edu Cc: e-chrischil...@uiowa.edu; phillip.ree...@utsouthwestern.edu; gpc-dev@listserv.kumc.edu

Re: Question on CDMv3.1 Run

At Nebraska we had to include a comparable constraint due to numeric overflow, primarily on some RNA copy counts on viral tests. We ended up witholding several hundred test results from our CDM tables while we employ conversion factors and unit changes on the associated tests. Jim ___

RE: CDM refresh PRES_L3_RXCUI_TIER

Debbie I suspect that this reflects upon how your extract from Epic chooses RXNORM codes. When choosing the RXNORM code for a certain MEDICATION_ID in your medication orders, The RXNORM_CODES mapping table provided in our case by FDB allows choice of different levels of RXCUIs based upon RXNOR

RE: DROC Breast Cancer CRG Request (#596)

Nicholas So I reformatted our data to include SSF15 and tried to reload the spreadsheet but I no longer have access to the Data Import Tool probably because I did it already and then you changed file format. Please reset Query3 status so I can import or I can forward directly to you to manage

#601 Oracle maintenance

; Campbell, James R ; adfre...@regenstrief.org; gpc-dev@listserv.kumc.edu Subject: Re: [gpc-informatics] #335: DataBuilder VM deployment outdated by migration of middle tier to jboss #335: DataBuilder VM deployment outdated by migration of middle tier to jboss

Re: [gpc-informatics] #280: Medication ontology orgainzed by ingredient

We are doing so this refresh for the first time based upon dialogue with Keith Marsolo James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 > On May 22, 2017, at 11:04 AM, GPC Informatics wrote: > > #280: Medication ontology orgainzed by ingred

RE: [gpc-informatics] #280: Medication ontology orgainzed by ingredient

Jay In followup to our discussion yesterday, post the i2b2 metadata to the website of Jeff’s choosing for his analysis Jim From: Klann, Jeffrey G. [mailto:jeff.kl...@mgh.harvard.edu] Sent: Thursday, May 11, 2017 3:39 PM To: Pedersen, Jay G ; Campbell, James R ; gpc-dev@listserv.kumc.edu; huhick

RE: Medication orders, dispense and admin events; Ticket GPC #280

documentation of treatment exposure, CDMV31.PROCEDURES is less than optimal. Jim From: Marsolo, Keith [mailto:keith.mars...@cchmc.org] Sent: Tuesday, April 18, 2017 10:51 AM To: Campbell, James R Cc: Laura Qualls Subject: Re: Medication orders, dispense and admin events Jim, We may not have been

Nebraska ETL architecture

We just refreshed our load documentation to Epic with updated procedures and new datatypes. In a week or so, it can be accessed on the Userweb at : https://datahandbook.epic.com/Reports/Details/9000400 Recently Phillip and Mei needed some individual code sets we had to share and if anyone who

RE: future dates table in CDM refresh Table IIIA

Debbie We were running at 3.1% future dates for prescription end dates and I agree that the data check seems inappropriate. Prescription Start dates however, would seem more reasonable as a data quality indicator from a clinical viewpoint at least. Jim From: Gpc-dev [mailto:gpc-dev-boun...@lis

RE: [gpc-informatics] #280: Medication ontology orgainzed by ingredient

From: Klann, Jeffrey G. [mailto:jeff.kl...@mgh.harvard.edu] Sent: Tuesday, April 11, 2017 10:37 PM To: gpc-dev@listserv.kumc.edu; Pedersen, Jay G ; Campbell, James R ; huhick...@nebraskamed.com; dconno...@kumc.edu; rwait...@kumc.edu Cc: mprit...@kumc.edu Subject: Re: [gpc-informatics] #280: Medic

Re: gpc-dev 11 Apr agenda/meeting notes (incl. next-d)

We filed an update on #280 today and posted expanded medication metadata to BABEL Jim James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 On Apr 10, 2017, at 2:45 PM, Dan Connolly mailto:dconno...@kumc.edu>> wrote: W

RE: NextD - question about data reported in EDC to PCORnet

I retrieved our ETL for encounters and summarize the classification of AV and OA visit types based upon our visit categorization code in our instance of Epic: AV(we used ambulatory face-to-face clinical) Type codes 51,104-Ambulatory surgery visits; 101-Office visits; 1003-Ambulat

RE: [gpc-informatics] #280: Medication ontology orgainzed by ingredient

ihara [mailto:dlyos...@wisc.edu] Sent: Monday, March 20, 2017 10:56 AM To: Dan Connolly ; gpc-dev@listserv.kumc.edu; Thomas Mish ; Campbell, James R ; huhick...@nebraskamed.com; Russ Waitman Cc: jeff.kl...@mgh.harvard.edu Subject: RE: [gpc-informatics] #280: Medication ontology orgainzed by ingre

Re: [gpc-informatics] #573: de-identified text notes for on a cohort-by-cohort basis

Betsy Probably should add ICD-10-PCS for hospital procedures since 10/1/2015. Given the patients with procedures off-site, do you want to add procedure history (SNOMED CT) as well? James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 > On Mar

Re: Epic ERX->RxNorm mappings

Jeff Your organization has to purchase the contract with your medication terminology manager. We use FDB and they offer an interoperability module which supplies the maps for Meaningful Use compliance. If you are using FDB, check the Nebraska ETLs for medications (prescriptions and Surescript

Re: [gpc-informatics] #551: next-D labs for cohort selection: fasting glucose, HbA1c

I agree with Phillip. Clinically, the date/time reported for a lab test is always when the patient had blood drawn or gave the sample. THAT is when the patient was 'tested'. Nebraska records all lab test observation_facts with START_DATE as date/time specimen was taken. We record order time

Re: hackathon 4

Dan Do we have the GoToMeeting ID for today Jim From: Gpc-dev on behalf of Campbell, James R Sent: Monday, January 16, 2017 2:36:32 PM To: Dan Connolly; Russ Waitman Cc: gpc-dev@listserv.kumc.edu Subject: Re: hackathon 4 Dan I was specifically thinking of

Re: hackathon 4

that you could easily provide inbound audio for KC participants with a local amplifier and one machine at the podium. Thanks for considering solutions Jim From: Dan Connolly Sent: Monday, January 16, 2017 1:29:03 PM To: Campbell, James R; Russ Waitman Cc: gpc

RE: hackathon 4

in the room. A cellphone is the only alternative they thought of. I'm not sure how well it's going to work. -- Dan From: Gpc-dev [gpc-dev-boun...@listserv.kumc.edu] on behalf of Campbell, James R [campb...@unmc.edu] Sent: Monday, January 16, 2017 1

Re: hackathon 4

participate tomorrow by GoTomeeting if you can support that. Jim McClay tells me he will try at some point because he has airline tickets from KC on Wednesday Jim Campbell From: Russ Waitman Sent: Monday, January 16, 2017 11:48:52 AM To: Campbell, James R Cc: gpc-dev

Re: hackathon 4

Thanks for the update Russ. We are icing in Omaha with ground temperatures in the 20's and air temp hovering at freezing. We will check with you in the morning Jim James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230

hackathon 4

We among others plan to drive to Kansas City. Can our colleagues at KU please provide regular weather and driving condition updates for the interstates inbound? Jim The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unau

Proposal for discussion at hackathon4

Proposal for discussion at hackathon4 added to ticket #459 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, p

Re: PCORNet ETL ADD Data Providence for SSDMF

Nebraska reported it as 'OTHER' since it was clearly not on the list; the rest of our death statistics reside in the EHR. Jim James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 > On Dec 4, 2016, at 12:09 PM, Nathan Graham wrote: > > All, > >

RE: Mapping Medication Mixtures

Following Russ' question on the call today, while it may be that cancer chemotherapy would be some of the highest cost admixtures, reviewing stats from our database shows that of the 1500 custom admixtures prepared by UNMC pharmacy, frequent cases reflect antibiotics, hormones and fluid/electrol

RE: Mapping Medication Mixtures

Phillip In reviewing the policy of pharmacy in preparing custom admixtures, for a given order_med_id for an admixture, they expand the record to enumerate the ingredients as you describe, each of which points to a unique medication_id. They should never reuse the order record and change the ing

Re: CDM Death Table and SSDI

Debbie We have that documented in our procedures on Epic Userweb including the SQL for vital status load. https://datahandbook.epic.com/Reports/Details/9000400 A snippet from the documentation follows. PrProcess SSN death record updates (if new information) This is performed when new SSN dea

RE: UNMC -- BC survey -- issue with rxcui values for importing per-medication into RedCap, rxcui values

>From the looks of the medications that fail, I suspect the version of RXNORM >may need updating. Jim From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Pedersen, Jay G [jay.peder...@unmc.edu] Sent: Wednesday, October 12, 20

RE: [Data.pcornet] Confirming medications sources for Antibiotic obesity study question

Phillip No, because prescriptions are outpatient and so are orders placed in clinic for direct administration of a drug or immunologic. Both may be part of an outpatient encounter- to respond to Russ's proposal. I do believe it is possible however to separate the two types of orders in Epic,

Re: [gpc-informatics] #528: Documentation of UNMC i2b2 ETLs for Epic

George, When I access, they are listed as 87KB Jim James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 > On Sep 7, 2016, at 5:06 PM, Kowalski, George wrote: > > Is it my mac or are these files in this 7zip file all 0 bytes long ? > > [cid:image

RE: SCILHS i2b2 ontology [was: 8.24.16 GPC Site PM Notes]

c.edu] Sent: Friday, August 26, 2016 3:08 PM To: McClay, James C; Campbell, James R Cc: gpc-dev@listserv.kumc.edu; Brittany Zschoche Subject: SCILHS i2b2 ontology [was: 8.24.16 GPC Site PM Notes] What about the ontology, Dr. Campbell? Reminder from March 4<http://listserv.kumc.edu/pipermail

Re: Tuesday GPC-DEV meeting

I would also like to question the version of SCILHS we are agreeing as our standard Jim C Jim Campbell On Aug 21, 2016, at 5:24 PM, McClay, James C mailto:jmcc...@unmc.edu>> wrote: GPC-DEV’ers I see Dan canceled this week’s Tuesday meeting as we agreed last week. Over the weekend Jane Anau f

Re: DataBuilder installation instructions

haps); I'm not interested to persue it. I don't invest in proprietary > technology unless I am compelled to. > > -- > Dan > > > From: Campbell, James R [campb...@unmc.edu] > Sent: Friday, July 08, 2016 3:07 PM > To:

Re: DataBuilder installation instructions

I may misunderstand the current DataBuilder functionality but I would rejuvenate the proposal that Alex tried to present at hackathon 2 that was sidelined. I would also try to align our data extraction utilities with PCORI procedures and ask for development that would allow for extraction of SA

Fwd: VHA Plans to Transition NDF-RT to MED-RT

9-7505 Secretary: 402-559-7299 Pager: 402-888-1230 Begin forwarded message: From: Olivier Bodenreider mailto:obodenrei...@mail.nih.gov>> Date: July 7, 2016 at 3:22:38 PM CDT To: "Campbell, James R" mailto:campb...@unmc.edu>> Cc: "McClay, James C" mailto:jmcc...@unm

Re: DataBuilder installation instructions

UNMC would participate James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 On Jul 7, 2016, at 2:55 PM, Dan Connolly mailto:dconno...@kumc.edu>> wrote: Yes, I'd like that. Interested sites, please do chime in. I'll tr

Re: GPC DEID Data Request: Immunoglobulin G Levels and the pattern of infection

6 1:31 PM To: Tamara McMahon mailto:tmcma...@kumc.edu>>; 'Verhagen, Laurel A' mailto:verhagen.lau...@mcrf.mfldclin.edu>>; Campbell, Walter S mailto:wcamp...@unmc.edu>>; Campbell, James R mailto:campb...@unmc.edu>> Cc: gpc-dev@listserv.kumc.edu<mailto:gpc-

Re: GPC DEID Data Request: Immunoglobulin G Levels and the pattern of infection

rhagen, Laurel A mailto:verhagen.lau...@mcrf.mfldclin.edu>> wrote: Jim, Thanks for your expertise! Is it possible to share the LOINC codes used at UNMC for this request? Laurel From: Campbell, James R [mailto:campb...@unmc.edu] Sent: Wednesday, July 06, 2016 12:01 PM To: Verhagen, Laurel A

Re: GPC DEID Data Request: Immunoglobulin G Levels and the pattern of infection

Laurel The LOINC parts code (LP14672-2) is only valid as a defining 'atom' in LOINC and should be ignored for retrieving valid IgG levels from your lab data. I assume this was a simple misinterpretation of the meaning of the LOINC part. Jim James R. Campbell MD campb...@unmc.edu

RE: clarity latency period

That is true of all Epic sites. When we inventoried GPC at the start of our project, every Epic site was using Clarity in some way (not necessarily exclusively) for their i2b2 load. We are now planning on testing out weekly Clarity incremental loads. Of the 4 sites you mention, only UTSW is E

#473 Response from DRN OC. Fwd: GPC C4UN response to data characterization issues

James R. Campbell MD campb...@unmc.edu<mailto:campb...@unmc.edu> Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 Begin forwarded message: From: PCORnet DRN OC mailto:dr...@pcornet.org>> Date: May 20, 2016 at 3:18:44 PM CDT To: "Campbell, James R" mailto:

Re: [gpc-informatics] #473: PCORnet CDMv3 SAS prep-to-research Readiness

We submitted to DRN OC today. Does KUMC want an updated copy? Jim James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 > On May 11, 2016, at 5:48 PM, GPC Informatics wrote: > > #473: PCORnet CDMv3 SAS prep-to-research Readiness > --

Re: #455: SCILHS CDM compliant with ONC standard coding?

I have it on my schedule. Trial metadata changes to you in two weeks Jim James R. Campbell MD campb...@unmc.edu Office: 402-559-7505 Secretary: 402-559-7299 Pager: 402-888-1230 > On May 2, 2016, at 3:50 PM, Klann, Jeffrey G. > wrote: > > (Meeting details being handled separately.) > > I spoke

RE: CDMv3 ADMITTING_SOURCE

With Hubert leaving, Jay and I had to slog through a reload of our system which we have now completed. I have further created CDMV3 extracts from our i2b2 deid version and it looks like data quality is good except in LAB_PRO_CM where I have to extract some more lab order data to meet all CDMV3

RE: SAS views for CDM v3 data characterization query

It appears we are passing data characterization and the data looks correct. For our Oracle platform these are the transforms we use to convert Oracle Datetime to SAS dates and times CAST(TO_CHAR(CAST(E2.START_DATE AS DATE), 'MMDD' ) AS INTEGER) AS BIRTH_DATE, CAST(TO_CHAR (CAST(E2.START_DA

RE: SCILHS metadata

Jeff Klann tells me this is the current release... https://github.com/SCILHS/scilhs-ontology/releases From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Campbell, James R [campb...@unmc.edu] Sent: Wednesday, April 13, 2016

RE: SCILHS metadata

13, 2016 11:53 AM To: Campbell, James R; gpc-dev@listserv.kumc.edu Subject: RE: SCILHS metadata Which table(s) are you having trouble with in particular? I count 8 in https://github.com/SCILHS/scilhs-ontology/tree/master/MetadataLoader/MetadataFiles There are 9 files listed there, but two of

SCILHS metadata

Can anyone tell me where to get a copy of SCILHS metadata that is up to date in support of CDMV3? The 1.52 copy on the SCILHS site only has 7 tables supported. Jim James R. Campbell MD campb...@unmc.edu Office 402-559-7505 Secretary 402-559-7299 Fax 402-559-8396 Pager 4

AMIA meeting SFO

Anyone here for in Frisco for the AMIA meeting? Looking for company at dinner Jim Campbell 402-290-5154 campb...@unmc.edu 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 informati

RE: PCORnet Common Data Model HARVEST reference table

Laura Is there some reason Regenstrief (University of Indiana) is listed as being in Iowa? Jim Campbell From: gpc-dev-boun...@listserv.kumc.edu [gpc-dev-boun...@listserv.kumc.edu] on behalf of Kowalski, George [gkowal...@mcw.edu] Sent: Wednesday, March 16, 2016

RE: Recruiting via MyChart for PCORI Study Participation

Thanks for the heads up Tom; I am looking forward to it. For our GPC colleagues, Jim M and I will be talking the next day... RAC21: An Interoperable Research Data Model for Longitudinal Clinical Data Room: History of the Future James Campbell, MD, Nebraska Medicine James McClay, MD, Nebraska

Tickets 439 441

Tom I realize that I d0onot recall where to submit this table? We have some discrepancy in totals for the for the spreadsheet, but I understood this was NLT Monday Jim The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any

  1   2   3   >