Commits

Branch selector

 master

User selector

All users

Datepicker

All time

Commit History

Commits on Mar 6, 2019

• pcornet_popcodelist too short

  jklann

  committed
  1e7a0a1

  Copy full SHA for 1e7a0a1

• pcornet_codelist too short

  jklann

  committed
  52e664b

  Copy full SHA for 52e664b

Commits on Dec 12, 2018

• Removed many unnecessary pmnencounter joins on temp tables, which ultimately slowed down the transform significantly.

  jklann

  committed
  5fc388c

  Copy full SHA for 5fc388c

Commits on Oct 16, 2018

• Do not include nulls in PCORnet Provider

  jklann

  committed
  220f244

  Copy full SHA for 220f244

• Finishing reinstatement of speedups

  jklann

  committed
  ccb4190

  Copy full SHA for ccb4190

• Re-added a few index optimizations to a few stored procs.

  

  matthewjoss

  authored and

  jklann

  committed
  69e47bf

  Copy full SHA for 69e47bf

• TABLOCK optimizations return!

  jklann

  committed
  8f518b9

  Copy full SHA for 8f518b9

Commits on Sep 13, 2018

• Merge branch 'master' of https://github.com/SCILHS/i2p-transform

  Show description for 136c23f
  matthewjoss

  committed
  136c23f

  Copy full SHA for 136c23f

• hardcoded Result_unit to 'OT', and moved m.UNits_CD to RAW_UNIT field. Updated and tested in both MSSQL and Oracle

  matthewjoss

  committed
  577bfe0

  Copy full SHA for 577bfe0

Commits on Aug 15, 2018

• Fixed duplicates in lab tables and and reinstated normal ranges.

  jklann

  committed
  ffa6fe2

  Copy full SHA for ffa6fe2

Commits on Aug 3, 2018

• Fixed bug in harvest: conversion of refresh dates to SAS dates

  matthewjoss

  committed
  30b6125

  Copy full SHA for 30b6125

• updated harvest table in MSSQL and Oracle: All refresh dates now use current_date or getdate() funcitons. 3 previously null MGMT fields now asssigned '01'

  matthewjoss

  committed
  f3788ca

  Copy full SHA for f3788ca

• ported fixes from MSSQl in encounter and labs

  matthewjoss

  committed
  2d47f56

  Copy full SHA for 2d47f56

Commits on Aug 2, 2018

• SPECIMEN_SOURCE case now takes '%SR_PLS' to 'SER_PLAS'

  matthewjoss

  committed
  3b84d5b

  Copy full SHA for 3b84d5b

• Fixed an issue in which Aetna codes need to be excluded because the CDM does not recognize them.

  jklann

  committed
  e31ed79

  Copy full SHA for e31ed79

Commits on Jul 31, 2018

• finished temporary fix in labs proc. Inserting empty string into LAB_NAME field in pcornet_lab2 temp table. Tested and runs on demo data.

  matthewjoss

  committed
  570a900

  Copy full SHA for 570a900

Commits on Jul 27, 2018

• Temporary bug fix in lebresultCM procedure in MSSQL transform. Tested and works with demo data. Ported fix to oracle but nor successfully tested yet. Oracle may require another update

  matthewjoss

  committed
  081f17d

  Copy full SHA for 081f17d

• bug fix in labresult_cm procedure regarding the pcornet_lab2 temp table and hardcoding NORM fields temporarily.

  matthewjoss

  committed
  9009046

  Copy full SHA for 9009046

Commits on Jul 26, 2018

• Oracle ETL: forgot to fix 3 misspelled fields in the DDL. Fixed.

  matthewjoss

  committed
  9900ce0

  Copy full SHA for 9900ce0

• updated loader to CDM v4.1 specs. Also included all of the bugfixes that we already implemented in MSSQL. Tested on old demo data with success.

  matthewjoss

  committed
  ab92d09

  Copy full SHA for ab92d09

Commits on Jul 25, 2018

• removed payer_type from group by statement in encounter.

  matthewjoss

  committed
  42ae4b3

  Copy full SHA for 42ae4b3

Commits on Jul 24, 2018

• fixed a few misspelled fields, and converted the new time fields from varchar to SAS time.

  matthewjoss

  committed
  42692cb

  Copy full SHA for 42692cb

• fixed a few spelling typos in the DDL portion for the new v4 tables.

  matthewjoss

  committed
  7066dd4

  Copy full SHA for 7066dd4

Commits on Jul 23, 2018

• A specimen_source of '' in the lab ontology now puts a valid value in pmnlabresultcm

  jklann

  committed
  c346afa

  Copy full SHA for c346afa

• MSSQL Provider script now simply pulls providerid from the existing data tables.

  jklann

  committed
  b504770

  Copy full SHA for b504770

Commits on Jul 20, 2018

• Merge pull request #65 from Zabeus/master

  Show description for de3df29
  jklann

  authored
  de3df29

  Copy full SHA for de3df29

• Fix payer join. Move sub-query to indexed temp table.

  uthealth-rja

  committed
  ca4fc57

  Copy full SHA for ca4fc57

• Merge pull request #1 from ARCH-commons/master

  Show description for a1f4319
  Zabeus

  authored
  a1f4319

  Copy full SHA for a1f4319

• updated synonyms for the 4 new CDM v4 tables, also updated foreign keys for encounter and demographics

  matthewjoss

  committed
  faa0bf0

  Copy full SHA for faa0bf0

Commits on Jul 18, 2018

• Merge branch 'master' of https://github.com/SCILHS/i2p-transform

  matthewjoss

  committed
  debae5a

  Copy full SHA for debae5a

• need to have this line in labresult_cm commented out for labs to work

  matthewjoss

  committed
  3a5244b

  Copy full SHA for 3a5244b

• Merge branch 'master' of https://github.com/SCILHS/i2p-transform

  jklann

  committed
  5933d87

  Copy full SHA for 5933d87

• put lab_name back into DDL for now

  matthewjoss

  committed
  8fd3982

  Copy full SHA for 8fd3982

Commits on Jul 16, 2018

• Untested primary payor transform added to encounter.

  jklann

  committed
  ff92b4a

  Copy full SHA for ff92b4a

• added last parts of 4.1 updgrade (4 new tables here I think)?

  matthewjoss

  committed
  d111b8f

  Copy full SHA for d111b8f

Pagination

Previous

Next