Skip to content
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Medication Prescription table

The Medication Prescription [sn_hcls_medication_prescription] table stores the information about prescriptions ordered for a patient.

Key features

Includes the medication prescription details, prescription status, dosage, and diagnosis details.

Role required to configure the table: sn_hcls.admin.

For more information, see Healthcare and Life Sciences data model.

FieldData typeDescription
CaseReferenceParent case associated with the medication prescription.
Days supplyIntegerNumber of days for which the medication is prescribed.
Date authoredDate/TimeDate and time when the prescription was written.
Dosage instructionsStringInstructions for the dosage of the medication product.
External identifierStringIdentifier of the record in an electronic medical record \(EMR\) system.
Medication productReferenceMedication product being prescribed for the patient.
NumberString

Alpha-numeric profile identifier of the enrolled program.

The value is auto-generated and is incremented every time you add a new observation to your ServiceNow instance. The initial value for the Number field is MEDPR00001001.

Note: To customize the number, define the auto-numbering format for the Medication Prescription [sn_hcls_medication_prescription] table. For more information, see Add auto-numbering records in a table.

OrganizationReferenceHealthcare provider that is responsible for the prescription.
PatientReferenceName of the patient to whom the medication will be given.
PractitionerReferenceName of the practitioner who ordered the prescription for the patient.
Primary diagnosisReferenceMain condition in a patient submitted by the practitioner as the reason for the healthcare service requested.
Prior prescriptionReferencePrescription ordered earlier for the patient.
PriorityChoice listUrgency of the prescription that is used to make informed decision if needing to be prioritized.
QuantityDecimalQuantity of the specified medication in one fill.
Reference Medication eventReferenceEncounter that identifies the occurrence of contact between patient and healthcare provider.
RefillsIntegerNumber of authorized refills for the medication.
Secondary diagnosisReferenceCoexisting condition that might exist in a patient submitted by the practitioner.
SourceReferenceSource system details of an external healthcare system in a ServiceNow instance.
StatusChoice listStatus of the ordered prescription. The following statuses are available by default: - Active - Draft - Cancelled - Completed - Entered in error - Expired - On-Hold - Stopped - Unknown For more information about the available statuses, see medication prescription statuses defined in the FHIR specifications.
Status reasonStringExplanation of the selected status.
Tertiary diagnosisReferenceHighly specialized medical care recommended for the patient by the practitioner.
Validity start dateDateEarliest time of the validity period of the prescription.
Validity end dateDateLatest time of the validity period of the prescription.

Parent Topic:Healthcare and Life Sciences data model tables