| is_deleted | boolean | Indicates if this record should be considered soft deleted |
| organisation | varchar | An identifier for the source of data (an organisation) relating to a given GP practice |
| drug_record_id | varbinary | Unique identifier for the associated drug record |
| patient_id | varbinary | Unique identifier for the patient associated with this issue |
| code_id | bigint | Identifier for the clinical code associated with this medication issuer |
| dmd_product_code_id | bigint | dm+d (Dictionary of Medicines and Devices) product code identifier for the medication |
| dosage | varchar | Dosage instructions for the medication as recorded at the point of issue |
| quantity | double | Total quantity of medication issued |
| quantity_multiplicand | double | Multiplicand component of the quantity calculation |
| quantity_multiplier | double | Multiplier component of the quantity calculation |
| quantity_multiplier_uom | varchar | Unit of measure for the quantity multiplier |
| quantity_representation | varchar | Human-readable representation of the quantity |
| quantity_unit | varchar | Unit of measure for the total issued quantity |
| course_duration_in_days | bigint | Intended course duration in days |
| max_next_issue_days | bigint | Maximum interval to next issue |
| min_next_issue_days | bigint | Minimum interval to next issue |
| number_of_issues_authorised | bigint | Number of authorised issues |
| issued_count | bigint | Number of issues already issued |
| is_prescribed_as_contraceptive | boolean | Indicates if the medication is prescribed as a contraceptive |
| is_privately_prescribed | boolean | Indicates if the medication is privately prescribed |
| prescription_type_description | varchar | Description of the prescription type |
| first_issue_datetime | varchar | First issue month/year |
| most_recent_issue_datetime | varchar | Most recent issue month/year |
| most_recent_issue_method_description | varchar | Description of issue method |
| authorised_course_datetime | varchar | Authorised course month/year |
| effective_datetime | timestamp(6) with time zone | Effective date/time of medication |
| review_date | date | Date/time for medication review |
| expiry_datetime | varchar | Expiry month/year |
| cancellation_datetime | timestamp(6) with time zone | Date the issue was cancelled; NULL if not cancelled |
| local_mixture_name | varchar | Name of the local mixture, populated when the issue relates to a locally prepared mixture |
| model_updated_datetime | timestamp(6) with time zone | The date that the model record was last updated in the source system |
| transform_datetime | timestamp(6) with time zone | The date that the data was made available in the model with a relevant change |
