drug_era, observation_period, cost column mismatch about etl-cms HOT 5 CLOSED

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.