[CORE-123] Update demo patient MRNs and sites Created: 23/Jun/14  Updated: 01/Jul/14  Resolved: 01/Jul/14

Status: Closed
Project: i2b2 Core Software
Component/s: Data
Affects Version/s: 1.7.01
Fix Version/s: 1.7.02

Type: Improvement Priority: Major
Reporter: Janice Donahoe Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i00013:
i2b2 Sponsored Project/s:
i2b2 Core
Affects Database/s:
All databases
Developer Notes: The site / location for the demo patient MRNs have been updated in the following tables:

PATIENT_MAPPING
IM_MPI_MAPPING
IM_PROJECT_SITES

The insert data scripts for the above tables were updated for Oracle, PostgreSQL and SQL Server.
Testing Notes: Tested and appears to be working correctly. I was able to drag a patient set to the Patient Mapping view to see all the MRN's and sites for each patient in the set.
Participant/s:

 Description   
The MRN's and sites associated with the demo patients in the i2b2 demo data are to be updated to be very generic. Although they are not real MRNs the i2b2 team does not want to mislead users into believing they are real.

This needs to be updated in both the demodata tables and the imdata tables.
Generated at Fri Apr 19 05:49:39 UTC 2024 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.