search

National-Clinical-Cohort-Collaborative / Data-Ingestion-and-Harmonization

Data Ingestion and Harmonization
41 stars 12 forks source link

Field length in DI&H target data base causing clipping / truncation #44

Closed DaveraGabriel closed 4 years ago

DaveraGabriel commented 4 years ago

Processing of a site data set reveals length of some fields shorter than the source data causing data loading to "clip" site data

DaveraGabriel commented 4 years ago

@stephanieshong this has been resolved through extending the length of the fields in Oracle to 255? is this correct?

stephanieshong commented 4 years ago

Which issue number is this ?

From: Davera Gabriel notifications@github.com Sent: Thursday, June 25, 2020 12:38 PM To: National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization Data-Ingestion-and-Harmonization@noreply.github.com Cc: Stephanie Hong shong59@jh.edu; Assign assign@noreply.github.com Subject: Re: [National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization] Field length in DI&H target data base causing clipping / truncation (#44)

  External Email - Use Caution

@stephanieshonghttps://github.com/stephanieshong this has been resolved through extending the length of the fields in Oracle to 255? is this correct?

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization/issues/44#issuecomment-649679348, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVLW5ZJXDARDIEQFH5VHWLRYN4ODANCNFSM4OFHBNTQ.

DaveraGabriel commented 4 years ago

44 ☺

Best,

Davera Gabriel, RN Senior Research Terminologist

Johns Hopkins University Institute for Clinical and Translational Research 2024 E Monument St, Suite I-200 Baltimore, MD 21287 +1 (530) 723-8356 davera@jhu.edumailto:davera@jhu.edu

From: Stephanie Hong notifications@github.com Sent: Thursday, June 25, 2020 12:40 PM To: National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization Data-Ingestion-and-Harmonization@noreply.github.com Cc: Davera Gabriel dgabrie4@jhmi.edu; Author author@noreply.github.com Subject: Re: [National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization] Field length in DI&H target data base causing clipping / truncation (#44)

  External Email - Use Caution

Which issue number is this ?

From: Davera Gabriel notifications@github.com<mailto:notifications@github.com> Sent: Thursday, June 25, 2020 12:38 PM To: National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization Data-Ingestion-and-Harmonization@noreply.github.com<mailto:Data-Ingestion-and-Harmonization@noreply.github.com> Cc: Stephanie Hong shong59@jh.edu<mailto:shong59@jh.edu>; Assign assign@noreply.github.com<mailto:assign@noreply.github.com> Subject: Re: [National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization] Field length in DI&H target data base causing clipping / truncation (#44)

External Email - Use Caution

@stephanieshonghttps://github.com/stephanieshong this has been resolved through extending the length of the fields in Oracle to 255? is this correct?

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization/issues/44#issuecomment-649679348, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVLW5ZJXDARDIEQFH5VHWLRYN4ODANCNFSM4OFHBNTQ.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization/issues/44#issuecomment-649681487, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ALQXTQMMAQQ6LNSSVLNY3DDRYN4X3ANCNFSM4OFHBNTQ.

stephanieshong commented 4 years ago

Yes, this has been resolved.

stephanieshong commented 4 years ago

Yes, it is resolved.

From: Davera Gabriel notifications@github.com Sent: Thursday, June 25, 2020 12:45 PM To: National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization Data-Ingestion-and-Harmonization@noreply.github.com Cc: Stephanie Hong shong59@jh.edu; Mention mention@noreply.github.com Subject: Re: [National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization] Field length in DI&H target data base causing clipping / truncation (#44)

  External Email - Use Caution

44 ☺

Best,

Davera Gabriel, RN Senior Research Terminologist

Johns Hopkins University Institute for Clinical and Translational Research 2024 E Monument St, Suite I-200 Baltimore, MD 21287 +1 (530) 723-8356 davera@jhu.edumailto:davera@jhu.edu<mailto:davera@jhu.edu%3cmailto:davera@jhu.edu>

From: Stephanie Hong notifications@github.com<mailto:notifications@github.com> Sent: Thursday, June 25, 2020 12:40 PM To: National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization Data-Ingestion-and-Harmonization@noreply.github.com<mailto:Data-Ingestion-and-Harmonization@noreply.github.com> Cc: Davera Gabriel dgabrie4@jhmi.edu<mailto:dgabrie4@jhmi.edu>; Author author@noreply.github.com<mailto:author@noreply.github.com> Subject: Re: [National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization] Field length in DI&H target data base causing clipping / truncation (#44)

External Email - Use Caution

Which issue number is this ?

From: Davera Gabriel notifications@github.com<mailto:notifications@github.com<mailto:notifications@github.com%3cmailto:notifications@github.com>> Sent: Thursday, June 25, 2020 12:38 PM To: National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization Data-Ingestion-and-Harmonization@noreply.github.com<mailto:Data-Ingestion-and-Harmonization@noreply.github.com<mailto:Data-Ingestion-and-Harmonization@noreply.github.com%3cmailto:Data-Ingestion-and-Harmonization@noreply.github.com>> Cc: Stephanie Hong shong59@jh.edu<mailto:shong59@jh.edu<mailto:shong59@jh.edu%3cmailto:shong59@jh.edu>>; Assign assign@noreply.github.com<mailto:assign@noreply.github.com<mailto:assign@noreply.github.com%3cmailto:assign@noreply.github.com>> Subject: Re: [National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization] Field length in DI&H target data base causing clipping / truncation (#44)

External Email - Use Caution

@stephanieshonghttps://github.com/stephanieshong this has been resolved through extending the length of the fields in Oracle to 255? is this correct?

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHubhttps://github.com/National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization/issues/44#issuecomment-649679348, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVLW5ZJXDARDIEQFH5VHWLRYN4ODANCNFSM4OFHBNTQ.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization/issues/44#issuecomment-649681487, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ALQXTQMMAQQ6LNSSVLNY3DDRYN4X3ANCNFSM4OFHBNTQ.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/National-COVID-Cohort-Collaborative/Data-Ingestion-and-Harmonization/issues/44#issuecomment-649686924, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVLW55ZGWI7KRMUPR2AWILRYN5JFANCNFSM4OFHBNTQ.