Demographic Mapping OSCAR to E2E

E2E Mapping Demographics Section

The E2E Demographics section contains data pertaining to the specific patient that the record represents. Data such as name, age, gender, HIN, and birth date should be expected.

General Assumptions

User Assumptions

• Each demographic in OSCAR represents one unique patient
• Each demographic will be independent of another

Data Assumptions

• Each demographic will map to exactly one E2E record in the export
• There are no other constructs within OSCAR which models or represents a patient

Issues

Issue 1

• HINs, or Health Identification Numbers can be entered by the user in OSCAR but a HIN isn't considered a mandatory field. It is possible for a patient to have a record without the HIN documented.
• E2E requires a HIN to be populated - the field cannot be left empty

Decision

• The HIN field in E2E will be populated with "000000000" should the HIN not be defined within OSCAR.

Issue 2

• Birth Date within OSCAR is saved separately as day, month and year fields. E2E specifies birthdate as one field.

Decision

• The year, month and date are manually concatenated to create the expected E2E date output.

Mapping

Relevant OSCAR DB Tables: demographic

Demographic Mapping Table