The following submission types can be generated with the means of Greenrain Submission:
- Encounter.Submission
Both xls or xlsx formats are supported. An Excel file for Encounter.Submission must contain the following worksheets:
- Encounters
- Diagnoses
- Activities
- Observations
Use the following template to fill in encounters: Encounter.Submission Template.xlsx
The table below describes each column in expected Excel file.
| Worksheet | Column | Description | Possible Values or Format |
|---|---|---|---|
| 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. | 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. | Codes | |
| 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. | ||
| Patient Primary Eligibility | The health sector to which the patient belongs. Such categorization helps to classify the patient healthcare providers in the future planning and performance comparison. | Codes | |
| Birth Date | The date of birth of a patient as per identification document. | dd/mm/yyyy | |
| 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. | Codes | |
| Nationality | A code which defines the nationality of a patient as stated in the identification document used for patient identity proof. | Codes | |
| Residence Country | A code of a country of residence of a patient as stated in the identification document used for patient identity proof. | Codes | |
| Residence City | A code of a city of residence of a patient. | Codes | |
| 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 | A flag to indicate if a patient is internal/external Hajj, as represented by a code. | Codes | |
| Marital Status | A code that defines marital status of a patient. | Codes | |
| Occupation | Self-reported employment status of a patient, immediately prior to receiving healthcare services. | Codes | |
| 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. | Codes | |
| Admission Type | A code which identifies how a patient was admitted to hospital. | Codes | |
| Service Event Type | A code which identifies how a patient was admitted to hospital. | Codes | |
| 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. | ||
| 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. | dd/mm/yyyy hh:mm | |
| End | 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 | The date on which the patient is triaged. | dd/mm/yyyy hh:mm | |
| 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 | The mode of transport by which the patient arrives at the emergency department, as represented by a code. | Codes | |
| Emergency Service Start | The date/time on which non-admitted patient emergency department clinical care commences. | ||
| Emergency 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. | Codes | |
| 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. | Codes | |
| 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. | Codes | |
| 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. | ||
| Discharge Specialty | An identifier of the specialty practiced by the health practioner. | Codes | |
| Emergency Major Diagnostic Block | Emergency department major diagnostic block. | Codes | |
| 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 | 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 | |
| Diagnoses | Encounter ID | Reference to Encounter ID on Encounters worksheet | |
| Diagnosis Type | A diagnosis type, as reprsented by a code. | ||
| 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. | Codes | |
| 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. | ||
| 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. | ||
| Quantity | The quantity of each drug item dispensed for the treatment of ill health during the encounter. | ||
| Ordering Clinician Code | A unique identification 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. | ||
| 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. |