Comments (5)
Is cost in the Dev branch format? This CDM definition is approved, but waiting 2018 ohdsi symposium for release as v6.0
https://github.com/OHDSI/CommonDataModel/tree/Dev/COST
from etl-cms.
No, I only use the release versions (tagged 5.2, 5.0, ...)
See line 598:
https://github.com/OHDSI/CommonDataModel/blob/v5.2.0/PostgreSQL/OMOP%20CDM%20ddl%20-%20PostgreSQL.sql
Even in the dev-branch, the columns would not fit ...
CREATE TABLE cost
(
cost_id INTEGER NOT NULL ,
person_id INTEGER NOT NULL,
cost_event_id INTEGER NOT NULL ,
cost_domain_id VARCHAR(20) NOT NULL ,
from etl-cms.
@leenadR where did you download this? Just want to make sure I know which copy you are working with. I'm assuming it is the new one.
I think we have seen this problem before, the COST_ID is the last column in this export of SYNPUF. :(
Tagging @leeevans
from etl-cms.
@leenadR this is an issue with the file format of the Synpuf 100k export file. It's been corrected in a replacement Synpuf 5% sample file that is now available for download.
You can use the 'CMS SynPUF 5% Sample' link at the bottom of the below web page to download the new file:
https://www.ohdsi.org/data-standardization/
from etl-cms.
Many thanks, the 5% sample works just fine.
=> issue can be closed
from etl-cms.
Related Issues (20)
- Column mismatch in create_CDMv5_tables.sql and load_CDMv5_vocabulary.sql HOT 1
- Error on Step 5 of Python ETL process HOT 2
- Person ID as integer, CMS's synthetic data has string IDs HOT 1
- CMS RIF to OMOP ETL? HOT 2
- CMS ACO CCLF --> OMOP V5 HOT 1
- md5 sums don't match files - https://github.com/OHDSI/ETL-CMS/blob/master/python_etl/README.md HOT 4
- Issue while running python code to get the claims data HOT 6
- Memory issue of steps 5 in ETL Script HOT 9
- Update ETL logic to support CDM 6.X HOT 5
- CDMv5.2 is not accessible HOT 2
- KeyError: 'Place of Service' HOT 3
- location_id is null for all care_site records HOT 3
- missing 'DE1_0_2010_Beneficiary_Summary_File_Sample_1.zip' HOT 5
- FTP server down? HOT 1
- Downloading final data HOT 1
- Incorrect URL to one source Synpuf file HOT 5
- Updating to newer CDM versions + upload R script available HOT 1
- key error '40213148'
- Convert CMS SynPUF to OMOP v5.4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from etl-cms.