Opened 8 years ago
Last modified 8 years ago
#906 closed task
Create alias for Patient, Case, Specimen and Blood items for external use — at Version 16
Reported by: | Nicklas Nordborg | Owned by: | Nicklas Nordborg |
---|---|---|---|
Priority: | major | Milestone: | Reggie v4.7 |
Component: | net.sf.basedb.reggie | Keywords: | |
Cc: |
Description (last modified by )
The SCAN-B ID that is used to keep track of all items is sensitive information that we should avoid to use externally. We should add a new unique identifier to Patient, Case, Specimen, NoSpecimen and Blood (including fullow-up blood) items. A simple running number that is zero-padded to 6 digits should be ok (same as we currently do for naming Patient items). Use 'Q' as prefix for Patients, 'C' as prefix for Case items, and 'S' as prefix for specimen/nospecimen and 'B' for blood. If a case is arriving with multiple tubes, each tube should have it's own unique identifier.
The new identifier should be saved in the "External ID" field.
Other tools can then use the external identifiers instead of the SCAN-B ids. For example:
1234567.1.l.r.lib --> Q000001.C000001.S000001.l.r.lib
Other notes:
- Since we are already using a similar scheme for the 'name' of Patients, the we should create random gaps in the external id sequence. For example by randomly incrementing with 2 instead of 1.
- Cases that are created as placeholder for retracted items should not have en external id.
Change History (16)
comment:1 by , 8 years ago
Description: | modified (diff) |
---|---|
Summary: | Create alias for Case and Specimen items for external use → Create alias for PAtient, Case, Specimen and Blood items for external use |
comment:2 by , 8 years ago
comment:3 by , 8 years ago
comment:4 by , 8 years ago
(In [4071]) References #906: Create alias for PAtient, Case, Specimen and Blood items for external use
Implemented for Specimen/NoSpecimen items.
comment:5 by , 8 years ago
comment:6 by , 8 years ago
Summary: | Create alias for PAtient, Case, Specimen and Blood items for external use → Create alias for Patient, Case, Specimen and Blood items for external use |
---|
comment:7 by , 8 years ago
comment:8 by , 8 years ago
Description: | modified (diff) |
---|
Use 'Q' instead of 'P' as prefix for patients.
comment:9 by , 8 years ago
comment:10 by , 8 years ago
comment:11 by , 8 years ago
comment:12 by , 8 years ago
comment:13 by , 8 years ago
comment:14 by , 8 years ago
(In [4085]) References #906: Create alias for Patient, Case, Specimen and Blood items for external use
The gene and transcript data tables now also uses the external id if that option is enabled. The file generation order had to be changed so that the cohort data tables are generated first while we generate a mapping from raw bioassay name to external id that is then used when generating the data files.
comment:15 by , 8 years ago
Status: | new → assigned |
---|
comment:16 by , 8 years ago
Description: | modified (diff) |
---|
(In [4069]) References #906: Create alias for PAtient, Case, Specimen and Blood items for external use
Implemented for Case items.