| drugrecordguid | varchar | Unique identifier for the drug authorisation record. Part of the composite primary key. | {R8S9T0U1-V2W3-4567-XYZA-678901234567} | 38 | False |
| patientguid | varchar | References the patient in Admin_Patient. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| organisationguid | varchar | References the practice in Admin_Organisation. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| effectivedate | date | The clinical date the medication was authorised. | 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 authorising 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. | 17141000033112 | 8 | False |
| dosage | varchar | The free-text dosage instructions for the medication. | TAKE ONE DAILY | 400 | False |
| quantity | decimal | The quantity prescribed per issue. | 28 | 5 | False |
| quantityunit | varchar | The unit of measure for the quantity. | tablet(s) | 60 | False |
| problemobservationguid | varchar | References the clinical problem the medication is associated with. | {P6Q7R8S9-T0U1-2345-VWXY-456789012345} | 38 | False |
| prescriptiontype | varchar | Classifies the prescription type (e.g., Repeat, Acute, Repeat Dispensing). | Repeat | 20 | False |
| isactive | boolean | Indicates whether the drug authorisation is currently active. | true | 1 | False |
| cancellationdate | date | The date the drug record was cancelled, if applicable. | 2007-11-02 | 3 | True |
| numberofissues | tinyint | The number of issues generated from this authorisation so far. | 6 | 1 | True |
| numberofissuesauthorised | tinyint | The total number of issues authorised for this drug record. | 6 | 1 | True |
| isconfidential | boolean | Indicates whether the drug record is marked as confidential. | false | 1 | False |
| deleted | boolean | Indicates whether the record is deleted. Always false in this BulkView. | false | 1 | False |
| expirydate | datetime | The expiry date and time of the drug authorisation. | 2022-05-25 00:00:00 | 23 | True |