#144: ETL Annotated Data Dictionary form required by PCORI
---------------------------------+-----------------------------
Reporter: campbell | Owner: dconnolly
Type: task | Status: new
Priority: major | Milestone: data-stds-plan
Component: data-stds | Resolution:
Keywords: ETL Data Dictionary | Blocked By: 145
Blocking: |
---------------------------------+-----------------------------
Old description:
> Note to DSSNI from Jenny Ibarra:
> >>>>>
> Attached is the PCORnet Extract, Transform, and Load (ETL) Annotated Data
> Dictionary. The purpose of this form is to provide a mechanism for
> PCORnet data partners to communicate information about how they
> transformed their local data into the PCORnet Common Data Model (CDM)
> Version 1.0. The information will be used to help the PCORnet
> Coordinating Center better understand the transformation process,
> appropriate uses of the PCORnet data, and the comparability of data
> sources. Please review the instructions found on the Overview tab before
> proceeding.
>
> You may contact the DSSNI Task force at [email protected] for questions
> regarding completion of this form.
>
> We would like to identify a contact (organization/site, name, email) at
> each data source who will be coordinating the ETL process. Please send
> this contact information to [email protected] by August 1.
> >>>>>
New description:
Note to DSSNI from Jenny Ibarra:
> Attached is the PCORnet Extract, Transform, and Load (ETL) Annotated
Data Dictionary. The purpose of this form is to provide a mechanism for
PCORnet data partners to communicate information about how they
transformed their local data into the PCORnet Common Data Model (CDM)
Version 1.0. The information will be used to help the PCORnet Coordinating
Center better understand the transformation process, appropriate uses of
the PCORnet data, and the comparability of data sources. Please review the
instructions found on the Overview tab before proceeding.
>
> You may contact the DSSNI Task force at [email protected] for questions
regarding completion of this form.
>
> We would like to identify a contact (organization/site, name, email) at
each data source who will be coordinating the ETL process. Please send
this contact information to [email protected] by August 1.
--
Comment (by dconnolly):
Russ, we should talk about who should be our point person. I'm leaning
towards Nathan (Graham).
Meanwhile, it looks like each site will have to fill this out.
It asks questions such as how many Unique PATIDs for a whole site, max
ADMIT_DATE and so on. While we weren't planning to transform our whole
datamart to CDM format, I can imagine, as part of work on #145 (transform
i2b2 query results to PCORNet CDM), building views that would work for
this purpose.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/144#comment:2>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
