539930792c
Merge pull request #39 from rwpark99/patch-1
...
Update OMOP CDM indexes required - SQL Server.sql
2017-06-09 08:27:12 -04:00
c6ec5eed93
Merge pull request #45 from mi-erasmusmc/master
...
Fixed constraints referring to old event cost tables in favor of the singular cost table
2017-06-09 08:23:46 -04:00
948a8e833a
Merge pull request #46 from tomwhite/impala-timestamp-parquet
...
Add a step to transform data into Parquet, and use TIMESTAMP type for dates
2017-06-09 08:21:55 -04:00
802a43267a
Updated formatting in Readme file
2017-06-04 22:28:15 -04:00
7bba78ac08
Removed references to OMOP CDM v4. Updated Readme to include changes from v5 to v5.1
2017-06-04 22:25:52 -04:00
5f276b46fe
Impala v5.1
2017-04-20 11:05:21 +01:00
7d2c9f3081
Add a step to transform data into Parquet, and use TIMESTAMP type for dates.
2017-04-18 11:05:47 +01:00
eca889af53
Fixed Constraints
...
Constraints referred to old cost tables.
2017-03-08 15:59:33 +01:00
bf39b90e3b
Added Version logic
2017-02-07 14:02:42 -05:00
5643fc5107
Merge branch 'v5.1' of https://github.com/OHDSI/CommonDataModel into v5.1
2017-01-12 16:15:00 -05:00
230a1b0961
Made changes to adhere to the new CDM changes for version 5.1 for Oracle, Postgres, and SQL Server. Added death_datetime to the death table
2017-01-12 16:10:00 -05:00
c412304d22
Changed the column name from datetime_of_birth to birth_datetime to stick with the new naming convention.
2017-01-03 21:37:59 -05:00
183e42b552
Changed the column name from datetime_of_birth to birth_datetime to stick with the new naming convention.
2017-01-03 21:37:38 -05:00
b7b98c6c95
Changed the column name from datetime_of_birth to birth_datetime to stick with the new naming convention.
2017-01-03 21:37:06 -05:00
20a6f4a04f
Made changes to adhere to the new CDM changes for version 5.1 for Oracle
2017-01-02 19:27:35 -05:00
866c8c666b
Made changes to adhere to the new CDM changes for version 5.1 for Postgres
2017-01-02 19:22:13 -05:00
aef6a3a550
Made changes to adhere to the new CDM changes for version 5.1
2017-01-02 19:08:27 -05:00
d489f002a3
Update OMOP CDM indexes required - SQL Server.sql
...
We added some more required indexes, which were identified by running the 'Estimated Execution Plan' in the Microsoft SQL Management Studio.
Some related discussions are here: http://forums.ohdsi.org/t/incremental-achilles/1847
2016-11-06 23:18:54 +09:00
a8d6557a56
Merge pull request #29 from rstarr7/master
...
added denominator_value to oracle drug-strength load file.
2016-10-26 17:26:27 -04:00
d99820c5e2
Merge pull request #37 from tomwhite/impala
...
Add scripts for creating a schema and importing data into Impala.
2016-10-26 17:25:59 -04:00
d5a1a8e43b
Add scripts for creating a schema and importing data into Impala.
2016-10-12 11:36:40 +01:00
ec3fdc2f1e
Merge pull request #33 from anthonysena/master
...
Adding box_size to the DDL
2016-09-06 15:16:54 -04:00
d4a4d175fd
Resolves OHDSI/CommonDataModel#32 box_size issue
2016-09-01 13:56:50 -04:00
8bb3f64c97
Merge pull request #26 from anthonysena/master
...
Inclusion of Type Concept
2016-08-29 13:37:30 -04:00
2ab4be78c4
New cost table instead of individual cost tables
2016-05-02 10:04:22 -04:00
387dc184ec
Merge pull request #1 from rstarr7/rstarr7-patch-1
...
added denominator_value to oracle drug-strength load file.
2016-04-29 17:00:01 -04:00
c2df5351f4
added denominator_value to oracle drug-strength load file.
2016-04-29 14:32:51 -04:00
28fddb85bd
Merge pull request #27 from arestenko/drug_strength_fix
...
Add denominator_value to DRUG_STRENGTH
2016-03-29 12:02:59 +02:00
fa61c2ba7e
Add denominator_value to DRUG_STRENGTH
2016-02-05 22:02:53 +03:00
021c9f5a14
Including the 'Type Concept' domain_id from the latest version of the vocabulary
2015-12-15 10:08:59 -05:00
11188fee37
Including the 'Type Concept' domain_id from the latest version of the vocabulary.
2015-12-15 10:03:41 -05:00
8badc57395
Resolving issue where unit_concept_id was not mapped to the Measurement table properly
2015-09-24 13:40:25 -04:00
101c632072
Merge pull request #22 from anthonysena/V5ConversionImprovement
...
Adding Redshift & SQL Server PDW translations and fixing era logic bug
2015-09-01 13:21:58 -04:00
cb116a29a0
Adding in Redshift and SQL Server PDW translations along with a bug fix to the era logic
2015-09-01 13:18:42 -04:00
69a9555b50
Update README.md
2015-08-18 22:21:57 -04:00
2caea197eb
Merge pull request #20 from anthonysena/V5ConversionImprovement
...
Improvements to conversion scripts, documentation and DRG conversion.
2015-08-09 16:25:59 -04:00
bac9cebf33
Improvements to scripts, documentation and inclusion of DRG conversion.
2015-08-05 15:07:59 -04:00
af2e823059
Merge pull request #19 from anthonysena/V4toV5Conversion
...
V4to v5 conversion cross platform tested
2015-07-09 20:44:11 -04:00
04fd25a73d
One more edit to the README.md
2015-07-09 10:06:20 -04:00
3af8f2e76b
README.md updates
2015-07-09 09:53:40 -04:00
c3e7bb7eea
Final commit before push
2015-07-09 08:47:18 -04:00
0fd4f7ebe1
Saving progress before I rewrite the source_concept_map_occurrence table to remove the need for an UPDATE statement in this script.
2015-07-07 14:32:08 -04:00
386793b101
Addressing bugs from PostgreSQL/Oracle testing
2015-07-06 08:44:31 -04:00
21cf148715
Merge pull request #18 from anthonysena/V4toV5Conversion
...
Initial commit for the CDM v4 to v5 conversion scripts.
2015-07-01 11:18:00 -04:00
4cb7558572
Initial commit for the CDM v4 to v5 conversion scripts.
2015-07-01 11:11:15 -04:00
d23321a00b
Merge pull request #10 from leeevans/other-dbms-ddl-control-files
...
V4 control files and DDL
2015-03-22 11:21:47 -04:00
8b478ae7a0
changes after V4 testing
2015-03-20 14:08:48 -04:00
00434c3dde
created CDM version 4 Oracle ctl files and batch file
2015-03-19 19:26:39 -04:00
ecf3307ecc
Add readme files
2015-03-19 00:37:16 -04:00
ae4a6289fc
DLL V4
2015-03-19 00:33:07 -04:00
clairblacketer
Karthik
Tom White
Peter Rijnbeek
Christian Reich
Karthik Natarajan
kan7003
Rae Woong Park
Patrick Ryan
Anthony Sena
rstarr7
Martijn Schuemie
Alexey Arestenko
Jon Duke
leeevans