search

CDMFORUM / CDM-ERRATA

The errata lists the minor errors and typos that have been identified in the PCORnet Common Data Model (CDM) specification.
Other
12 stars 7 forks source link

PRO_ITEM field length #1

Closed rusincovitch closed 8 years ago

rusincovitch commented 8 years ago

The PRO_CM.PRO_ITEM field length is currently 7. However, a network has increased the field length to 10 to accommodate additional local instrument unique identifier codes.

rusincovitch commented 8 years ago

This modification creates a downstream effect on Data Characterization.

rusincovitch commented 8 years ago

The network reports that the SAS data type errata correction accomodates their data, which was a critical dependency. This change is complete.

A non-critical enhancement: the data partner suggests a modification of the PRO_ITEM length to accomodate their MS-SQL data type data type of NUMERIC(17,7) [ Length = 9 bytes ]; perhaps setting the specification to a total length of 10 bytes. He recommends a numeric(p,s) rather a decimal with floating point representation (which can be a little challenging).

rusincovitch commented 8 years ago

Because this is not an errata, merged into https://github.com/CDMFORUM/CDM-GUIDANCE/issues/2