Template

Use one of the following templates to fill in encounters:

The default format - Encounter.Submission Default_Template.xlsx.
The MBDS format - Encounter.Submission MBDS_Template.xlsx.

Data description

The table below describes each column in expected Excel file.

Worksheet	Column (Default Template)	Column (MBDS Template)	Description	Possible Values or Format
Encounters	Sender ID	Sender ID	An identification code of a healthcare provider that is the sender of the transaction.
	Receiver ID	Receiver ID	An identification code of the receiver of the transaction. Predefined value is MOH.	MOH
	Encounter ID	Encounter Number	A unique key that is generated by a healthcare provider. Cannot be re-assigned to another encounter/visit.
	Provider Code	Unique Health Care Facility Identifier	A healthcare provider identification code. Unique for each facility.
	Provider Type	Healthcare Facility Sector Identifier	Type of a healthcare provider dealing with specified group of patients according to a certain set of regulations.	Codes
	National ID	Patient National Identity Number (KSA-ID)/Entry Number	A national identifier of a person.
	Patient ID	Patient Identifier (UMRN)	A patient medical record number. The number is used by the hospital as a systematic documentation of a patient's medical history and care during each hospital stay or visit.
	Patient Primary Eligibility	Patient Primary Eligibility	This field describes the health sector to which the Patient belongs.
	Birth Date	Date of Birth	The date of birth of a patient as per identification document.	dd/mm/yyyy
	Birth Country	Country of Birth	A code of a country in which the patient was born. It refers to a country if the person was born outside Saudi Arabia. The geographic location is specified according to boundaries current at the time the data is collected, not the boundaries at the time of birth.	Codes
	Gender	Gender	A code which defines the sex of a patient.	Codes
	Nationality	Nationality	A code which defines the nationality of a patient as stated in the identification document used for patient identity proof.	Codes
	Residence Country	Country of Residence	A code of a country of residence of a patient as stated in the identification document used for patient identity proof.	Codes
	Residence City	City of Residence	A code of a city of residence of a patient.	Codes
	Religion	Religion	A religion which is a patient self-identification as having a connection or affiliation with any religious denomination, group. For infants or children, religion refers to the specific religiousgroup or denomination in which they are being raised, if any.	Codes
	Pilgrim Type	HAJJ/Umrah Season Patient	A flag to indicate if a patient is internal/external Hajj, as represented by a code.	Codes
	Marital Status	Marital Status	A code that defines marital status of a patient.	Codes
	Occupation	Occupation	Self-reported employment status of a patient, immediately prior to receiving healthcare services.	Codes
	Mobile Number	Mobile phone number	Contact mobile telephone number of a patient as stated by the individual.
	Type	Encounter Type	A type of the encounter/visit, as represented by a code.	Codes
	Admission Type	Admission Type	A code which identifies how a patient was admitted to hospital.	Codes
	Service Event Type	Initial or Subsequent Service Event	An indicator of whether the service event is the first service event for a new referral or a follow up service event.
	Care Type	Care Type	The nature of clinical service provided to an admitted patient during an episode of care, acute vs. sub-acute, as represented by a code.	Codes
	Start	Admission Date/Outpatient Service Event Date/Encounter Start Date & Time	IP and OP: The date the patient is admitted to hospital at the sart of a hospital stay. ED: The date (time) on which non-admitted patient emergency department clinical care commences.	dd/mm/yyyy hh:mm
	End	Discharge Date/Encounter End Date & Time	The date the patient is discharged from the inpatient care referenced in the applicable hospitalization or hospice date.	dd/mm/yyyy hh:mm
	Triage Date	Triage Date/Time	The date on which the patient is triaged.	dd/mm/yyyy hh:mm
	Triage Category	Triage Category	A catetory assigned to a patient as a result of an initial assessment by medial or nursing staff in an Accident and Emergency Deparment. Used to determine the patient's priorty for treatment, and to informa the patient of their waiting time.	Codes
	Emergency Arrival Code	ED Arrival Mode (Transport)	The mode of transport by which the patient arrives at the emergency department, as represented by a code.	Codes
	Emergency Service Start	ED Service Commencement Date/Time	This is the date and time the clinician starts to treat the patient.
	Emergency Waiting Time	ED Waiting Time	The time elapsed in minutes for a patient from presentation in the emergency department to a service occurrence of a speicifed event related to service delivery.
	Admission Specialty	Specialty on Admission	An identifier of the specialty practiced by the health practitioner.	Codes
	Admission Weight	Admission Weight < 1-year-old	Birth weight and Neonatal Weight are defined separately.
	Intended Los	Intended LOS	The intention of the responsible clinician at the time of the patient's admission to hospital or at the time the patient is placed on an elective surgery waiting list, to discharge the patient either on the day of admission or a subsequent date, as represented by a code.	Codes
	Leave Duration	Duration of Leave	Sum of the length of leave (date returned from leave minus date went on leave) for all periods within the hospital stay.
	Discharge Mode	Discharge Mode/Status/Disposition	A code which defines the circumstances under which a patient left hospital. For the majority of patients this is when they are discharged by the consultant.	Codes
	Emergency Disposition Code	ED Disposition Code	The status of the patient at the end of the non-admitted patient emergency department service episode, as representd by a code.	Codes
	Discharge Specialty	Specialty at Discharge	An identifier of the specialty practiced by the health practioner.	Codes
	Emergency Major Diagnostic Block	ED Major Diagnostic Block (MDB) Category Code	Emergency department major diagnostic block.	Codes
	MDC	MDC	The category into which the patient diagnosis and the assocated Australian refined diagnosis related group (ARDRG) falls, as represented by a code.	Codes
	PCCL	PCCL	A measure of the cumulative effect of a patient’s complications and comorbidities (CCs) that is calculated for each episode of admitted patient care. Each diagnosis is assigned CCL (Clinical Complexity Level).	Codes
	Comments	Comments	This field contains comments related to the encounter.
Diagnoses	Encounter ID	Encounter Number	Reference to Encounter ID on Encounters worksheet
	Diagnosis Type	-	A diagnosis type, as reprsented by a code. Note: This field is not expected for MBDS format.	Codes
	Diagnosis Code	OPD Primary Diagnosis Code	The main diagnoses refelecting the main injuries, disease condition, paitent characteristics or cirumstances impacting the outpatient service event, as determinied by the physician at the conclusion of the visit.
		Principal Diagnosis (ICD-10-AM 6th edn)
		Additional Diagnosis (ICD-10-AM 6th edn)
		Morphology
		Cause of Death
	Condition Onset Flag	Condition Onset Flag	A qualifier for each coded diagnosis to indicate the onset of the condition relative to the beginning of the episode of care, as represented by a code.	Codes
Activities	Encounter ID	Encounter Number	Reference to Encounter ID on Encounter worksheet
	Activity ID	Activity Number	Activity id sent by a healthcare provider. An activity is unique within an encounter.
	Activity Type	-	Activity type, as represented by a code. Note: This field is not expected for MBDS format.	Codes
	Activity Code	AR-DRG	A patient's classification scheme which provides a clinically meaningful way of relating the number and types of patients treated in a hospital to the resources required by the hospital, as represented by a code.
		Procedure Codes
		Laboratory Code
		Drug Item Codes
	Quantity	Drug Item Units (Quantity)	The quantity of each drug item defined in "Drug Item Codes" dispensed for the treatment of ill health during this encounter.
	Ordering Clinician Code	Healthcare Practitioner ID	A unique identificatoin code of a clinician provided by the Saudi Commission for Health Specialties for the Consultant.	NNAANNNN… Alpha numeric, 5-16 characters
	Comments	Comments	This field contains comments related to the activity.