Template
Use the following template to fill in encounters: (template) Encounter.Submission.xlsx
Data description
The table below describes each column in expected Excel file.
| Worksheet | Column | Description | Possible Values |
|---|---|---|---|
| Encounters | Sender ID | An identification code of a healthcare provider that is the sender of the transaction. | |
| Receiver ID | An identification code of the receiver of the transaction. Predefined value is MOH. | ||
| Encounter ID | A unique key that is generated by a healthcare provider. Cannot be re-assigned to another encounter/visit. | ||
| Provider Code | A healthcare provider identification code. Unique for each facility. | ||
| Provider Type | Type of a healthcare provider dealing with specified group of patients according to a certain set of regulations. | ||
| National ID | A national identifier of a person. | ||
| Patient ID | 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. | ||
| Birth Date | The date of birth of a patient as per identification document. | ||
| Birth Country | 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. | ||
| Gender | A code which defines the sex of a patient. | ||
| Nationality | A code which defines the nationality of a patient as stated in the identification document used for patient identity proof. | ||
| Residence Country | A code of a country of residence of a patient as stated in the identification document used for patient identity proof. | ||
| Residence City | A code of a city of residence of a patient. | ||
| 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. | ||
| Pilgrim Type | A flag to indicate if a patient is internal/external Hajj, as represented by a code. | ||
| Marital Status | A code that defines marital status of a patient. | ||
| Occupation | Self-reported employment status of a patient, immediately prior to receiving healthcare services. | ||
| Mobile Number | Contact mobile telephone number of a patient as stated by the individual. | ||
| Type | A type of the encounter/visit, as represented by a code. | 1 = Hospital Inpatient - patient occupies inpatient bed and stays overnight 2 = Day Case - patient occupies bed and is disharged on the same day 3 = Emergency - patient is seen in Emergency Department and is not admitted to Inpatient Bed 4 = Outpatient - patient not admitted and not seen in Emergency Department | |
| Admission Type | A code which identifies how a patient was admitted to hospital. | ||
| Emergency Arrival Code | The mode of transport by which the patient arrives at the emergency department, as represented by a code. | ||
| 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. | 01 = Acute Care 02 = Rehabiitation 03 = General Maintenance 04 = Complex Maintenance 05 = Boarder 06 = Palliative | |
| Start | 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. | ||
| End | The date the patient is discharged from the inpatient care referenced in the applicable hospitalization or hospice date. | ||
| Triage Date | The date on which the patient is triaged. | ||
| 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. | ||
| 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 | An identifier of the specialty practiced by the health practitioner. | ||
| Admission Weight | Birth weight and Neonatal Weight are defined separately. | ||
| 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. | ||
| Leave Duration | Sum of the length of leave (date returned from leave minus date went on leave) for all periods within the hospital stay. | ||
| Discharge Mode | 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. | ||
| Emergency Disposition Code | The status of the patient at the end of the non-admitted patient emergency department service episode, as representd by a code. | 1 = Admitted to this hospital 2 = Non-admtted patient ED eptisde completed-departed without being admtted or referred to another hospital 3 = Non admitted patient ED episode completed - referred to another hospital for admission 4 = Did not wait to be attended by a healthcare professional 5 = Left at own risk after being attended by a healthcare professional, but before the non-admitted patient ED service episode was completed | |
| Discharge Specialty | An identifier of the specialty practiced by the health practioner. | ||
| Emergency Major Diagnostic Block | Emergency department major diagnostic block | ||
| MDC | The category into which the patient diagnosis and the assocated Australian refined diagnosis related group (ARDRG) falls, as represented by a code. | ||
| 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). | ||
| Diagnoses | Encounter ID | Reference to Encounter ID on Encounters worksheet | |
| Diagnosis Type | A diagnosis type, as reprsented by a code. | 1 = Principal 2 = Secondary 3 = Morphology 4 = DeathCause | |
| 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. | ||
| 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. | ||
| Activities | Encounter ID | Reference to Encounter ID on Encounter worksheet | |
| Activity ID | Activity id sent by a healthcare provider. An activity is unique within an encounter. | ||
| Activity Type | Activity type, as represented by a code. | 1 = ACHI 2 = Trade Drug 3 = AR-DRG | |
| Activity Code | 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. | ||
| Ordering Clinician Code | A unique identificatoin code of a clinician provided by the Saudi Commission for Health Specialties for the Consultant. | NNAANNNN… Alpha numeric, 5-16 characters | |
| Observations | Encounter ID | Reference to Encounter ID on Encounters worksheet | |
| Activity ID | Reference to Activity ID on Activities worksheet | ||
| Observation Type | An observation type. | 1 = LOINC 2 = Text 3 = File | |
| Observation Code | The tests, measurements, and observations conducted with value and unit, as represented by a code. | ||
| Observation Value | An observation value for the activity. | ||
| Observation Value Type | Unit of measure for an observation value. |