                         owning_organisation_id int COMMENT 'refers to the organisation that owns/manages the event',
                         status_concept_id bigint NOT NULL COMMENT 'refers to information model, giving the event status (e.g. active, final, pending, amended, corrected, deleted)',
                         is_confidential boolean NOT NULL COMMENT 'indicates this is a confidential event',
-                        original_code varchar(20) COLLATE utf8_bin DEFAULT NULL,
-                        original_concept varchar(1000) DEFAULT NULL,
-                        original_code_scheme varchar(20) DEFAULT NULL,
+                           original_code varchar(20) COLLATE utf8_bin DEFAULT NULL,
+                           original_term varchar(1000) DEFAULT NULL,
+                           original_code_scheme tinyint DEFAULT NULL COMMENT 'Original code scheme - 0=READ2, 1=READ3, 2=SnomedCT, 3=ICD-10, 4=OPCS-4, 5=MILLENNIUM',
+                           original_system tinyint DEFAULT NULL COMMENT 'Original system - 0=EMIS, 1=TPP, 2=VISION, 3=CERNER',
                         ubrn varchar(255) COMMENT 'e-RS booking number',
                         priority_concept_id bigint COMMENT 'refers to information model to give the priority (e.g. urgent, routing, 2-week wait)',
                         sender_organisation_id int,

                                 owning_organisation_id int COMMENT 'refers to the organisation that owns/manages the event',
                                 status_concept_id bigint NOT NULL COMMENT 'refers to information model, giving the event status (e.g. active, final, pending, amended, corrected, deleted)',
                                 is_confidential boolean NOT NULL COMMENT 'indicates this is a confidential event',
                                 original_code varchar(20) COLLATE utf8_bin DEFAULT NULL,
                                 original_concept varchar(1000) DEFAULT NULL,
                                 original_code_scheme varchar(20) DEFAULT NULL,
                                 priority_concept_id bigint COMMENT 'concept giving the priority of this request',
                                 recipient_organisation_id int COMMENT 'to whom the request was made',
                                 request_identifier varchar(255) COMMENT 'local identifier for the request (e.g. order number)',

                                    owning_organisation_id int COMMENT 'refers to the organisation that owns/manages the event',
                                    status_concept_id bigint NOT NULL COMMENT 'refers to information model, giving the event status (e.g. active, final, pending, amended, corrected, deleted)',
                                    is_confidential boolean NOT NULL COMMENT 'indicates this is a confidential event',
	                        	   original_code varchar(20) COLLATE utf8_bin DEFAULT NULL,
    	                	       original_term varchar(1000) DEFAULT NULL,
        	        	           original_code_scheme tinyint DEFAULT NULL COMMENT 'Original code scheme - 0=READ2, 1=READ3, 2=SnomedCT, 3=ICD-10, 4=OPCS-4, 5=MILLENNIUM',
            		               original_system tinyint DEFAULT NULL COMMENT 'Original system - 0=EMIS, 1=TPP, 2=VISION, 3=CERNER',
                                    type_concept_id bigint NOT NULL COMMENT 'refers to information model to give the prescription type (e.g. Acute, Repeat, RepeatDispensing)',
                                    medication_amount_id bigint COMMENT 'refers to the medication_amount table for the dose and quantity',
                                    issues_authorised int COMMENT 'total number of issues allowed before review, for acutes this value will be 1',
