OSCAR DB Tables

This page describes the bare minimum tables required to model a patient and their data in OSCAR.

Table	Notes
admission	12.1/Master schema slightly different - provider_no should be 000000; needed to view eChart
allergies	Main Allergies table
casemgmt_cpp	Case management summary
casemgmt_issue	Who entered data and when
casemgmt_issue_notes	Connect issue to notes
casemgmt_note	Full log of case management entry and actions taken (toilet roll)
casemgmt_note_ext	Extra flags/data elements
demographic	Main patient demographic data
demographicArchive	Deleted patient data table
demographicExt	Extra flags about demographic
demographiccust	Unknown but required
drugs	Main medication table
dxresearch	Main problem list table
eChart	Encounter data presentation table
fileUploadCheck	Lab file upload md5
hash_audit	Lab hash archive
hl7TextInfo	Imported lab metadata
hl7TextMessage	Raw imported HL7 2.x text string (base64)
measurementGroup	User specified measurement
measurementGroupStyle	CSS related "style"
measurements	Lab or in-clinic entered measurement values
measurementsExt	Extra metadata about measurements
patientLabRouting	Correlate lab data to patient
prescription	Groups drugs into prescription (more for UI presentation)
preventions	Main immunization table
preventionsExt	Extra immunization metadata
program_access	Define OSCAR "programs"
program_access_roles	Define what programs a provider has access to
program_provider	Define roles a provider has
property	Enable RX3
provider	Main provider data table
providerLabRouting	Relates imported labs with provider
quickListUser	Front-end related - "default" user
secUserRole	Define user role in system
security	Contains login info to OSCAR EMR