| issuerecordguid | varchar | Unique identifier for the prescription issue event. Part of the composite primary key. | {S9T0U1V2-W3X4-5678-YZAB-789012345678} | 38 | False |
| patientguid | varchar | References the patient in Admin_Patient. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| organisationguid | varchar | References the issuing practice in Admin_Organisation. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| drugrecordguid | varchar | References the parent drug authorisation record in Prescribing_DrugRecord. | {R8S9T0U1-V2W3-4567-XYZA-678901234567} | 38 | False |
| effectivedate | date | The clinical date of the prescription issue. | 2007-11-02 | 3 | True |
| effectivedateprecision | varchar | The precision of the effective date (e.g., YMD = Year/Month/Day). | YMD | 100 | False |
| entereddate | date | The date the record was entered into EMIS Web. | 2007-11-02 | 3 | False |
| enteredtime | time | The time the record was entered into EMIS Web. | 11:00:00 | 5 | True |
| clinicianuserinroleguid | varchar | References the issuing clinician in Admin_UserInRole. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | False |
| enteredbyuserinroleguid | varchar | References the staff member who entered the record. | {G7H8I9J0-K1L2-3456-MNOP-567890123456} | 38 | False |
| codeid | bigint | References the drug code in Coding_DrugCode. | 2261441000033110 | 8 | False |
| dosage | varchar | The dosage instructions as printed on this issue. | 1 AT NIGHT | 400 | False |
| quantity | decimal | The quantity dispensed in this issue. | 56 | 5 | False |
| quantityunit | varchar | The unit of measure for the quantity dispensed. | tablet(s) | 60 | False |
| problemobservationguid | varchar | References the clinical problem this issue is linked to. | {P6Q7R8S9-T0U1-2345-VWXY-456789012345} | 38 | False |
| coursedurationindays | integer | The intended course duration in days. | 30 | 4 | False |
| estimatednhscost | smallmoney | The estimated NHS cost of this prescription issue. | 13.14 | 4 | False |
| isconfidential | boolean | Indicates whether the issue record is marked as confidential. | false | 1 | False |
| emiscode | varchar | EMIS-specific legacy code associated with the issue record. | CP173 | 50 | True |
| patientmessage | varchar | Message printed on the prescription for the patient. | Please book appointment with nurse | 8000 | True |
| scriptpharmacystamp | varchar | Pharmacy stamp information printed on the prescription script. | Asda Pharmacy | 255 | True |
| compliance | decimal | Compliance indicator for the prescription issue. | 0.417720228 | 5 | True |
| averagecompliance | decimal | Average compliance value calculated across issues. | 0.417720228 | 5 | True |
| isprescribedascontraceptive | boolean | Indicates whether the medication is prescribed as a contraceptive. | false | 1 | False |
| isprivatelyprescribed | boolean | Indicates whether the medication is privately prescribed (i.e., not on the NHS). | false | 1 | False |
| pharmacymessage | varchar | Pharmacy-specific instructions associated with this issue. | Please make an appointment for BP | 8000 | True |
| pharmacytext | varchar | Free-text pharmacy message for this issue. | qty reduced as review overdue | 8000 | True |
| consultationguid | varchar | References the consultation in which this issue was created. | {L2M3N4O5-P6Q7-8901-RSTU-012345678901} | 38 | True |
| reviewdate | datetime | The scheduled review date for this prescription. | 2022-05-25 00:00:00 | 23 | True |
| issuemethoddescription | varchar | How the prescription was issued (e.g., Electronic Prescription Service, hand-written). | Outside Hospital | 100 | True |
| deleted | boolean | Indicates whether the record is deleted. Always false in this BulkView. | false | 1 | False |