|Specimen Repository Alias GlobalUniqueID||Anthony Corbett||2013-04-22 12:09|
In a current use case I have to need to alias the current GlobalUniqueId column in the Specimen Repository. In this case a shared resource lab is taking in specimens with a Customer ID and internally using their own Internal ID. When results and data are returned to the Customer there is a need to map back to the CustomerID in the copy to study assay results dataset grid view.
In 13.1 I saw the addition of alias for ParticipantIds and didn't know if there were plans to do the same for Specimen GloablUniqueIds?
Ideally, there would be a second column "GlobalUniqueIDAlias" available in any grid where SpecimenID is a look up and this column could be brought into the grid view. Places where this would be helpful are the assay results grid and the assay dataset when copied to study.
So in the short term I'm wondering if I can use a different field in the Specimen Repository as a convention for the CustomerID and which one would be the best choice in terms of being able to customize grid views to bring in this column. I tried the 'type_type' column but this column is not available as a column in the customize view for the assay results or assay study datasets. I also tried the 'class_id' column but this is restricted to 4 characters in length.