Glossary

1	CDS	Core Data Set
2	EMR	Electronic Medical Record
3	OMD	Ontario Medical Documentation

1. Administration/ Data Import

1.1 Summary

1.1.1 Business Need

Defined users:

Super User/Administrator with full rights:

Add/Edit/Delete
Reactivate account
Access to admin part of the OSCAR

Main purpose of Administration/ data Import is:

To import all OMD CDS data in batch
To create import event log which is output to a text file and printed
To create import error log which is output to a text file

Data Import requirements (Confluence link: https://oscaremr.atlassian.net/wiki/pages/viewpage.action?spaceKey=QA&title=OLD+OMD-based+testing+checklist&src=email) need to be aligned with Ontario MD EMR Specification document set that describes the high level and detail requirements central to the general EMR application. Data Import Use cases are created to meet the EMR Requirements of Appendix B – EMR Specification v4.0 (2.2 – Data Import Requirements) for Oscar application and to validate the application data Import functionality.

1.1.2. Description

Import demographic allows to import demographic and clinical data in a standard format from another Oscar or other compatible EMR . Administration/ Import use cases are designed to include all OMD Import data elements (Appendix B - EMR Specification v4.0 - 2.2 – Data Import Requirements). Data from import file(s) must be imported to the EMR discrete data fields where applicable and the import processes must function in a batch mode. Import Event Log must be output to a text file (Appendix B - EMR Specification v4.0 - 3.5 – Import Event Log) and printed. Import Error Log file which includes each record that failed to upload for each patient generates to a text file.

1.1.3. Pre-action requirements/state:

OSCAR McMaster Test Version 12.1, system, and DB are up, configured and working as expected.

1.1.4. Post-action state:

OSCAR McMaster Test Version 12.1 is running and behaving as expected.
OSCAR McMaster Test Version 12.1 has all functionality prior to the change (outside of removing functionality intentionally)

1.2 Flow of Events

This section describes the main flow of the Use Case and system responses.

Import all OMD CDS data elements

Num.	Step	Description	System Response	User
	Pre-condition	The zip file from the other system in CMS spec format is available
1	Connect to the OSCAR main page	Launch URL: http://192.168.1.202:8080/Oscar12_1/index.jsp	OSCAR main page with the login is opened	Super User
2	Log In	Enter user's valid credentials (User Name / Password/2nd Level Pass code if applicable)	By entering right credentials user is getting system verification acceptance	Super User
3	Access Import Demographic screen	Select Administration Tab → Data Management → Import New Demographic	Import Demographic page appears in a new window	Super User
4	Import Demographic data	Browse to the file, choose options and import	Data is imported	Super User
5	Verify all OMD CDS data elements	Verify that all OMD CDS data elements are included in Import report. Refer to Appendix B - EMR Specification v4.0- 2.0 – Data Portability Requirements)	All OMD CDS data elements are included in Import report.	Super User

1.2.1 Alternate Flows of Events

Alternative Flow 1

Import process must function in a batch mode

Num.	Step	Description	System Response	User
	Pre-condition	The zip file from the other system in CMS spec format is available
1	Connect to the OSCAR main page	Launch URL: http://192.168.1.202:8080/Oscar12_1/index.jsp	OSCAR main page with the login is opened	Super User
2	Log In	Enter user's valid credentials (User Name / Password/2nd Level Pass code if applicable)	By entering right credentials user is getting system verification acceptance	Super User
3	Access Import Demographic screen	Select Administration Tab → Data Management → Import New Demographic	Import Demographic page appears in a new window	Super User
4	Import Demographic data	Browse to the file, choose options and import	Data is imported	Super User
5	Import is able to happen in batch	Verify that import process functions in a batch mode	Import process functions in a batch mode	Super User

Alternative Flow 2

Create import event log which is output to a text file and printed

Num.	Step	Description	System Response	User
	Pre-condition	The zip file from the other system in CMS spec format is available
1	Connect to the OSCAR main page	Launch URL: http://192.168.1.202:8080/Oscar12_1/index.jsp	OSCAR main page with the login is opened	Super User
2	Log In	Enter user's valid credentials (User Name / Password/2nd Level Pass code if applicable)	By entering right credentials user is getting system verification acceptance	Super User
3	Access Import Demographic screen	Select Administration Tab → Data Management → Import New Demographic	Import Demographic page appears in a new window	Super User
4	Import Demographic data	Browse to the file, choose options and import	Data is imported	Super User
5	Create Import Event Log as output to a text file	Verify that Import Event Log can be created as output to a text file. Refer to Appendix B - EMR Specification v4.0 - 3.5 – Import Event Log	Import Event Log can be created as output to a text file	Super User
6	Print Import Event Log	Verify that Import Event Log is printable	Import Event Log is printable	Super User

Alternative Flow 3

Create import error log which is output to a text file

Num.	Step	Description	System Response	User
	Pre-condition	The zip file from the other system in CMS spec format is available
1	Connect to the OSCAR main page	Launch URL: http://192.168.1.202:8080/Oscar12_1/index.jsp	OSCAR main page with the login is opened	Super User
2	Log In	Enter user's valid credentials (User Name / Password/2nd Level Pass code if applicable)	By entering right credentials user is getting system verification acceptance	Super User
3	Access Import Demographic screen	Select Administration Tab → Data Management → Import New Demographic	Import Demographic page appears in a new window	Super User
4	Import Demographic data	Browse to the file, choose options and import	Data is imported	Super User
5	Create Import Error Log as output to a text file	Verify that Import Error Log can be created as output to a text file and which includes each record that failed to upload for each patient	Import Event Log can be created as output to a text file	Super User

1.2.2 Exception Flows of Events (Negative)

N/A

OSCAR EMR

Use Cases Administration/ Data Import