Radiology Information System Master Data & Configuration
Home / Clinical Modules / Radiology Information System / Master Data

Radiology Information System Master Data & Configuration

Master Data Inventory

ID Data Set Source Approx. Records Owner Update Frequency Approver
MD-RIS-001 Radiology Exam Codes (CPT) AMA CPT Radiology section (70000–79999) ~3,000 Radiology Admin Annually with CPT release Chief Radiologist + Revenue Cycle Lead
MD-RIS-002 Body Part Codes SNOMED CT + RadLex subset ~200 Radiology Informatics With terminology releases (6–12 monthly) Radiology Informatics Lead
MD-RIS-003 Modality Types DICOM Modality codes ~25 System Admin Rarely changes CIO / Imaging IT Manager
MD-RIS-004 Imaging Protocols Facility-defined ~500 Lead Radiologist per modality Annual review; ad‑hoc updates Radiology Protocol Committee
MD-RIS-005 Report Templates Facility-defined ~200 Chief Radiologist Annual review; ad‑hoc updates Radiology Quality Committee
MD-RIS-006 Contrast Agents Facility formulary (linked to PIS) ~20 Pharmacy Committee With formulary changes Pharmacy & Therapeutics (P&T) Committee
MD-RIS-007 Diagnostic Reference Levels (DRLs) UAE MOH radiation safety + IAEA ~50 Radiation Safety Officer (RSO) As regulatory guidance changes; at least annually Radiation Safety Committee
MD-RIS-008 Laterality Codes HL7 / DICOM standard 4 System Config Owner Fixed Radiology Informatics Lead
MD-RIS-009 Report Status Codes HL7 Table 0085 ~8 System Config Owner Fixed Radiology Informatics Lead
MD-RIS-010 Priority Codes Facility-defined 4 Radiology Admin Annual review Chief Radiologist
MD-RIS-011 RadLex Terminology Subset RSNA RadLex ~68,000 Radiology Informatics With RadLex releases Radiology Informatics Lead
MD-RIS-012 Radiologist Reading Assignments Department schedule Varies (per day) Chief Radiologist Weekly / Monthly Chief Radiologist
MD-RIS-013 Modality Resources Facility inventory Per device count Imaging IT Manager On acquisition / decommission Radiology Director
MD-RIS-014 NABIDH/Malaffi Imaging Facility & Department IDs DHA / DOH registration 1–20 per org IT / Integration Team On registration or change IT Director
MD-RIS-015 UAE Radiation Dose Units & Measurement Codes UCUM + UAE MOH guidance ~20 RSO Rare Radiation Safety Committee

Note: Shared entities (patients, providers, encounters, facilities, departments, users, payers) are defined in their owning modules and referenced here via foreign keys only. See ../ehr-patient-mgmt/06-master-data.md and ../policy-contract-mgmt/06-master-data.md.

Setup Sequence

Dependency Diagram

flowchart TD A["Step 1: Shared Entities<br/>Facilities, Departments, Users, Providers, Payers"] --> B["Step 2: MD-RIS-003 Modality Types"] A --> C["Step 2: MD-RIS-008 Laterality Codes"] A --> D["Step 2: MD-RIS-009 Report Status Codes"] A --> E["Step 2: MD-RIS-010 Priority Codes"] B --> F["Step 3: MD-RIS-013 Modality Resources"] A --> F B --> G["Step 3: MD-RIS-001 Radiology Exam Codes (CPT)"] C --> G E --> G G --> H["Step 4: MD-RIS-004 Imaging Protocols"] B --> H I["MD-RIS-002 Body Part Codes"] --> H H --> J["Step 5: MD-RIS-007 Diagnostic Reference Levels (DRLs)"] B --> J I --> J K["MD-RIS-015 Dose Units & Measurement Codes"] --> J G --> L["Step 5: MD-RIS-005 Report Templates"] I --> L D --> L M["MD-RIS-006 Contrast Agents"] --> H M --> L N["MD-RIS-011 RadLex Terminology Subset"] --> L A --> O["Step 6: MD-RIS-012 Radiologist Reading Assignments"] G --> O A --> P["Step 7: MD-RIS-014 NABIDH/Malaffi Imaging IDs"] F --> P J --> Q["Step 8: Radiation Dose Monitoring Config"] F --> Q L --> R["Step 9: Go-Live – Reporting"] O --> R P --> R Q --> R

Load Sequence (Narrative)

  1. Foundation (shared & static config)
    - Load shared entities from owning modules: facilities, departments, providers, users, payers.
    - Configure static code sets:

    • MD-RIS-003 Modality Types
    • MD-RIS-008 Laterality Codes
    • MD-RIS-009 Report Status Codes
    • MD-RIS-010 Priority Codes

  2. Terminology & structure
    - MD-RIS-002 Body Part Codes
    - MD-RIS-015 Dose Units & Measurement Codes
    - MD-RIS-011 RadLex Terminology Subset (can be loaded in parallel).

  3. Equipment & resources
    - MD-RIS-013 Modality Resources (per facility/department).

  4. Clinical catalogues
    - MD-RIS-001 Radiology Exam Codes (CPT) — mapped to modality types, body parts, and billing.
    - MD-RIS-006 Contrast Agents — mapped to PIS formulary.

  5. Clinical configuration
    - MD-RIS-004 Imaging Protocols — depends on exam codes, modality types, body parts, contrast agents.
    - MD-RIS-007 DRLs — depends on modality types, body parts, dose units.
    - MD-RIS-005 Report Templates — depends on exam codes, body parts, report status codes, RadLex subset.

  6. Operational configuration
    - MD-RIS-012 Radiologist Reading Assignments — depends on providers and exam codes.
    - MD-RIS-014 NABIDH/Malaffi Imaging Facility & Department IDs — depends on facilities/departments and modality resources.

  7. Finalisation
    - Validate dose monitoring configuration (alerts, DRL thresholds).
    - End-to-end test of ordering → protocolling → acquisition → reporting → HIE submission.

Master Data Specifications

Below, each dataset includes: purpose, schema, sample data, governance, and validation rules.
All tables should include bilingual fields (*_en, *_ar) to support UAE requirements.

MD-RIS-001: Radiology Exam Codes (CPT)

Table: ris_exam_codes

Purpose

Catalogue of all orderable radiology exams, mapped to CPT codes, modality, body part, and billing attributes. Used by:

  • radiology_orders.exam_code_cpt
  • Scheduling and modality worklist routing
  • Billing & claims (CPT, modifiers)
  • DRL and dose benchmarking by exam type

Schema

Field Type Required Description
exam_code_cpt VARCHAR(10) YES CPT code (70000–79999) for the exam; primary business key
internal_exam_code VARCHAR(20) YES Facility-specific code (unique)
display_name_en VARCHAR(200) YES English exam name
display_name_ar VARCHAR(200) YES Arabic exam name
modality_type_code VARCHAR(10) YES FK → ris_modality_types.modality_type_code
body_part_code VARCHAR(20) YES FK → ris_body_parts.body_part_code
default_laterality_code VARCHAR(5) NO FK → ris_laterality_codes.laterality_code (if applicable)
contrast_required_flag BOOLEAN YES Whether contrast is typically required
default_contrast_agent_code VARCHAR(30) NO FK → ris_contrast_agents.contrast_agent_code
default_priority_code VARCHAR(20) YES FK → ris_priority_codes.priority_code
icd10_suggested_list VARCHAR(500) NO Comma-separated common ICD-10-AM indications (for CDS)
is_active BOOLEAN YES Active flag
effective_from DATE YES Start date for use
effective_to DATE NO End date (for retired codes)
created_by BIGINT YES FK → users.user_id
created_at TIMESTAMP YES Creation timestamp
updated_by BIGINT NO FK → users.user_id
updated_at TIMESTAMP NO Last update timestamp

Sample Data

exam_code_cpt internal_exam_code display_name_en display_name_ar modality_type_code body_part_code default_laterality_code contrast_required_flag default_contrast_agent_code default_priority_code icd10_suggested_list is_active
71046 XR-CHST-2V Chest X-ray 2 Views أشعة سينية للصدر - منظرين XR CHEST NA FALSE NULL ROUTINE J18.9,R07.9,R06.02 TRUE
72148 MR-LSPN-NC MRI Lumbar Spine without Contrast رنين مغناطيسي للعمود القطني بدون صبغة MR SPINE_LUMBAR NA FALSE NULL ROUTINE M54.5,M51.26 TRUE
70450 CT-HED-NC CT Head without Contrast أشعة مقطعية للرأس بدون صبغة CT HEAD NA FALSE NULL URGENT I63.9,S06.0X TRUE
74177 CT-ABDPEL-WWO CT Abdomen & Pelvis with and without Contrast أشعة مقطعية للبطن والحوض مع وبدون صبغة CT ABDOMEN_PELVIS NA TRUE IOHEXOL_350 ROUTINE C18.9,K57.30 TRUE
76805 US-OB-1TRI Obstetric Ultrasound ≥ 14 weeks سونار حمل فوق ١٤ أسبوع US PREG_UTERUS NA FALSE NULL ROUTINE Z34.0,O09.9 TRUE
73030 XR-SHL-2V Shoulder X-ray 2 Views أشعة سينية للكتف - منظرين XR SHOULDER R FALSE NULL ROUTINE M25.511,S43.40X TRUE
77067 MG-BILAT-SCR Screening Mammography Bilateral تصوير الثدي الشعاعي الثنائي للفحص MG BREAST B FALSE NULL ROUTINE Z12.31,Z80.3 TRUE

Governance

  • Owner: Radiology Admin
  • Approver: Chief Radiologist + Revenue Cycle Lead
  • Update Frequency: Annually with AMA CPT updates; ad‑hoc for new services
  • Change Process: 1. Request from Radiology or Billing. 2. Impact analysis (billing, DRLs, modality capacity). 3. Approval in Radiology–RCM joint meeting. 4. Update in test environment; regression test with billing and RIS workflows. 5. Scheduled deployment; notify radiologists, technologists, scheduling, and billing.

Validation Rules

  • exam_code_cpt must be a valid CPT in radiology range (70000–79999) and unique.
  • internal_exam_code unique per facility.
  • modality_type_code must exist in ris_modality_types.
  • body_part_code must exist in ris_body_parts.
  • If contrast_required_flag = TRUE, then default_contrast_agent_code must be non-null and valid.
  • effective_to must be ≥ effective_from.
  • Inactive exams (is_active = FALSE) cannot be used in new orders but remain for historical records.

MD-RIS-002: Body Part Codes

Table: ris_body_parts

Purpose

Standardised list of anatomical regions/body parts used for:

  • Exam definition and protocolling
  • DRL benchmarking by body region
  • Worklist filtering and analytics
  • Mapping to SNOMED CT and RadLex for structured reporting

Schema

Field Type Required Description
body_part_code VARCHAR(20) YES Internal body part code (PK)
display_name_en VARCHAR(200) YES English name
display_name_ar VARCHAR(200) YES Arabic name
snomed_code VARCHAR(20) YES SNOMED CT concept ID
snomed_display VARCHAR(200) YES SNOMED CT preferred term
radlex_id VARCHAR(20) NO RadLex identifier (if available)
parent_body_part_code VARCHAR(20) NO FK → ris_body_parts.body_part_code for hierarchical grouping
is_active BOOLEAN YES Active flag
sort_order INT NO For UI ordering
created_at TIMESTAMP YES Creation timestamp
updated_at TIMESTAMP NO Last update timestamp

Sample Data

body_part_code display_name_en display_name_ar snomed_code snomed_display radlex_id parent_body_part_code is_active
HEAD Head الرأس 69536005 Structure of head RID1279 NULL TRUE
CHEST Chest الصدر 51185008 Thoracic structure RID1305 NULL TRUE
ABDOMEN_PELVIS Abdomen and Pelvis البطن والحوض 416550000 Abdomen and pelvis RID58 NULL TRUE
SPINE_LUMBAR Lumbar Spine العمود الفقري القطني 122494005 Lumbar spine structure RID1282 SPINE TRUE
BREAST Breast الثدي 76752008 Breast structure RID1322 CHEST TRUE
SHOULDER Shoulder الكتف 16982005 Structure of shoulder region RID1310 UPPER_LIMB TRUE
PREG_UTERUS Pregnant Uterus الرحم الحامل 119253004 Pregnant uterus structure RID28441 PELVIS TRUE

Governance

  • Owner: Radiology Informatics
  • Approver: Radiology Informatics Lead
  • Update Frequency: With SNOMED CT / RadLex updates or when new protocols require finer granularity.
  • Change Process: 1. Request from radiologist or protocol committee. 2. Map to SNOMED CT and RadLex. 3. Review for duplication and hierarchy. 4. Implement in test; validate mapping in protocols and templates. 5. Deploy and communicate to reporting and analytics teams.

Validation Rules

  • body_part_code unique, uppercase, alphanumeric with underscores.
  • snomed_code must be a valid SNOMED CT concept ID.
  • parent_body_part_code, if provided, must exist and cannot create cycles.
  • is_active = FALSE only allowed if no active exam/protocol/template references it.

MD-RIS-003: Modality Types

Table: ris_modality_types

Purpose

Standard list of imaging modality types (DICOM Modality) used for:

  • Routing orders to modality worklists
  • Mapping to PACS and DICOM MPPS
  • DRL and dose configuration
  • Worklist filtering and analytics

Schema

Field Type Required Description
modality_type_code VARCHAR(10) YES DICOM modality code (PK) e.g., CT, MR
display_name_en VARCHAR(100) YES English name
display_name_ar VARCHAR(100) YES Arabic name
dicom_description VARCHAR(200) YES DICOM definition
is_cross_sectional BOOLEAN YES Flag for CT/MR/PET etc.
is_ionizing_radiation BOOLEAN YES TRUE for CT, XR, NM, etc.
is_active BOOLEAN YES Active flag
created_at TIMESTAMP YES Creation timestamp
updated_at TIMESTAMP NO Last update timestamp

Sample Data

modality_type_code display_name_en display_name_ar dicom_description is_cross_sectional is_ionizing_radiation is_active
CT Computed Tomography الأشعة المقطعية Computed Tomography TRUE TRUE TRUE
MR Magnetic Resonance Imaging التصوير بالرنين المغناطيسي Magnetic Resonance TRUE FALSE TRUE
US Ultrasound الموجات فوق الصوتية Ultrasound FALSE FALSE TRUE
XR X-ray الأشعة السينية Plain Radiography FALSE TRUE TRUE
MG Mammography تصوير الثدي الشعاعي Mammography FALSE TRUE TRUE
NM Nuclear Medicine الطب النووي Nuclear Medicine TRUE TRUE TRUE
PT PET التصوير المقطعي بالإصدار البوزيتروني Positron Emission Tomography TRUE TRUE TRUE

Governance

  • Owner: System Admin (Imaging IT)
  • Approver: CIO / Imaging IT Manager
  • Update Frequency: Rare; when new modality types are introduced.
  • Change Process:
  • New modality type request → DICOM review → mapping to PACS and RIS → test → deploy.

Validation Rules

  • modality_type_code must match DICOM PS3.3 modality codes.
  • is_ionizing_radiation must be TRUE for CT, XR, MG, NM, PT; FALSE for MR, US.
  • Cannot deactivate a modality type if active modality resources reference it.

MD-RIS-004: Imaging Protocols

Table: radiology_protocols (owned entity)

Purpose

Standardised imaging protocols per exam type and modality, including technical parameters, contrast requirements, and prep instructions. Used in:

  • WF-RIS-001 Imaging Order Receipt & Protocolling
  • WF-RIS-003 Image Acquisition
  • Dose benchmarking and QA

Schema (extends brief)

Field Type Required Description
protocol_id BIGINT YES PK
exam_code_cpt VARCHAR(10) YES FK → ris_exam_codes.exam_code_cpt
modality_type_code VARCHAR(10) YES FK → ris_modality_types.modality_type_code
body_part_code VARCHAR(20) YES FK → ris_body_parts.body_part_code
protocol_name_en VARCHAR(200) YES English name
protocol_name_ar VARCHAR(200) YES Arabic name
protocol_parameters_json JSON YES JSON of kVp, mAs, slice thickness, sequences, etc.
contrast_required BOOLEAN YES Whether contrast is required
contrast_route VARCHAR(20) NO e.g., IV, Oral
default_contrast_agent_code VARCHAR(30) NO FK → ris_contrast_agents.contrast_agent_code
default_contrast_volume_ml DECIMAL(6,2) NO Default volume in mL
default_prep_instructions_en TEXT YES English prep instructions
default_prep_instructions_ar TEXT YES Arabic prep instructions
estimated_duration_minutes INT YES Typical exam duration
is_pediatric BOOLEAN YES Pediatric-specific protocol flag
is_active BOOLEAN YES Active flag
effective_from DATE YES Start date
effective_to DATE NO End date
created_by BIGINT YES FK → users.user_id
created_at TIMESTAMP YES Creation timestamp
updated_by BIGINT NO FK → users.user_id
updated_at TIMESTAMP NO Last update timestamp

Sample Data

protocol_id exam_code_cpt modality_type_code body_part_code protocol_name_en protocol_name_ar contrast_required contrast_route default_contrast_agent_code default_contrast_volume_ml estimated_duration_minutes is_pediatric
1001 70450 CT HEAD CT Head Non-Contrast Stroke أشعة مقطعية للرأس بدون صبغة - سكتة دماغية FALSE NULL NULL NULL 15 FALSE
1002 74177 CT ABDOMEN_PELVIS CT Abdomen/Pelvis Triphasic أشعة مقطعية للبطن والحوض ثلاثية المراحل TRUE IV IOHEXOL_350 100.00 30 FALSE
1003 71046 XR CHEST Chest X-ray PA & Lateral أشعة سينية للصدر - أمامي وجانبي FALSE NULL NULL NULL 10 FALSE
1004 72148 MR SPINE_LUMBAR MRI Lumbar Spine Non-Contrast رنين مغناطيسي للعمود القطني بدون صبغة FALSE NULL NULL NULL 30 FALSE
1005 76805 US PREG_UTERUS Obstetric US 2nd Trimester سونار حمل - الثلث الثاني FALSE NULL NULL NULL 25 TRUE

Governance

  • Owner: Lead Radiologist per modality
  • Approver: Radiology Protocol Committee (includes RSO for dose-related protocols)
  • Update Frequency: Annual review; ad‑hoc for new evidence or equipment.
  • Change Process: 1. Proposal by radiologist/RSO. 2. Dose and image quality assessment. 3. Committee approval. 4. Update in RIS and modality protocol library. 5. Training for technologists; update SOPs.

Validation Rules

  • exam_code_cpt must be active in ris_exam_codes.
  • Only one active default protocol per (exam_code_cpt, is_pediatric) combination; additional variants must be clearly named.
  • If contrast_required = TRUE, then contrast_route, default_contrast_agent_code, and default_contrast_volume_ml must be populated.
  • estimated_duration_minutes > 0.

MD-RIS-005: Report Templates

Table: radiology_templates (owned entity)

Purpose

Standardised report structures per exam type/body part, supporting:

  • Consistent reporting language
  • Structured data capture (RadLex, SNOMED CT)
  • Faster dictation with voice recognition
  • Compliance with NABIDH/Malaffi structured reporting expectations

Schema (extends brief)

Field Type Required Description
template_id BIGINT YES PK
template_name_en VARCHAR(200) YES English name
template_name_ar VARCHAR(200) YES Arabic name
modality_type_code VARCHAR(10) YES FK → ris_modality_types.modality_type_code
body_part_code VARCHAR(20) YES FK → ris_body_parts.body_part_code
exam_code_cpt VARCHAR(10) NO FK → ris_exam_codes.exam_code_cpt (optional if generic)
template_content_en TEXT YES English template (with placeholders)
template_content_ar TEXT YES Arabic template (with placeholders)
structured_fields_json JSON NO JSON definition of structured fields (RadLex, LOINC)
default_impression_text_en TEXT NO Optional default impression text
default_impression_text_ar TEXT NO Optional default impression text (Arabic)
created_by BIGINT YES FK → users.user_id
is_active BOOLEAN YES Active flag
version_number INT YES Template version
effective_from DATE YES Start date
effective_to DATE NO End date
created_at TIMESTAMP YES Creation timestamp
updated_at TIMESTAMP NO Last update timestamp

Sample Data

template_id template_name_en template_name_ar modality_type_code body_part_code exam_code_cpt is_active version_number
2001 CT Head Stroke Protocol تقرير أشعة مقطعية للرأس - سكتة دماغية CT HEAD 70450 TRUE 3
2002 Chest X-ray Adult تقرير أشعة سينية للصدر - بالغ XR CHEST 71046 TRUE 2
2003 MRI Lumbar Spine تقرير رنين مغناطيسي للعمود القطني MR SPINE_LUMBAR 72148 TRUE 1
2004 Obstetric Ultrasound 2nd Trimester تقرير سونار حمل - الثلث الثاني US PREG_UTERUS 76805 TRUE 1
2005 Screening Mammography تقرير تصوير الثدي الشعاعي للفحص MG BREAST 77067 TRUE 2

Example template_content_en (CT Head Stroke):

Clinical Indication: ___
Technique: Non-contrast CT of the head performed. Axial images with multiplanar reconstructions.
Findings:
- Brain parenchyma: ___
- Ventricles and cisterns: ___
- Extra-axial spaces: ___
- Skull and sinuses: ___
Impression: ___

Governance

  • Owner: Chief Radiologist
  • Approver: Radiology Quality Committee
  • Update Frequency: Annual review; ad‑hoc for guideline changes.
  • Change Process: 1. Draft by subspecialty lead. 2. Peer review and QA review. 3. Versioned update; old versions retained for historical reports. 4. Training and communication to radiologists.

Validation Rules

  • Only one active template per (modality_type_code, body_part_code, exam_code_cpt, version_number) combination.
  • version_number must increment for each change; effective_to of previous version set accordingly.
  • template_content_en and template_content_ar must not be empty and should include sections for “Findings” and “Impression”.

MD-RIS-006: Contrast Agents

Table: ris_contrast_agents

Purpose

List of radiology contrast agents, linked to the enterprise medication formulary, used for:

  • Protocol configuration
  • Contrast administration documentation
  • Allergy and reaction tracking
  • Billing and inventory

Schema

Field Type Required Description
contrast_agent_code VARCHAR(30) YES Internal code (PK)
display_name_en VARCHAR(200) YES English name
display_name_ar VARCHAR(200) YES Arabic name
rxnorm_code VARCHAR(20) NO RxNorm code (if available)
active_ingredient_en VARCHAR(200) YES Active ingredient
concentration VARCHAR(50) YES e.g., 350 mgI/mL
route VARCHAR(20) YES e.g., IV, Oral
osmolality_type VARCHAR(50) NO e.g., Low-osmolar, Iso-osmolar
linked_medication_id BIGINT NO FK → medication_master.medication_id (from CPOE/PIS)
is_iodinated BOOLEAN YES For CT contrast
is_gadolinium BOOLEAN YES For MR contrast
is_active BOOLEAN YES Active flag
created_at TIMESTAMP YES Creation timestamp
updated_at TIMESTAMP NO Last update timestamp

Sample Data

contrast_agent_code display_name_en display_name_ar active_ingredient_en concentration route osmolality_type is_iodinated is_gadolinium is_active
IOHEXOL_350 Iohexol 350 mgI/mL IV أيوهكسول ٣٥٠ مجم/مل وريدي Iohexol 350 mgI/mL IV Low-osmolar TRUE FALSE TRUE
IOPAMIDOL_300 Iopamidol 300 mgI/mL IV أيوباميدول ٣٠٠ مجم/مل وريدي Iopamidol 300 mgI/mL IV Low-osmolar TRUE FALSE TRUE
GADOBUTROL_1 Gadobutrol 1.0 mmol/mL IV جادوبوترول ١.٠ ملمول/مل وريدي Gadobutrol 1.0 mmol/mL IV Non-iodinated FALSE TRUE TRUE
BARIUM_SULF_SUS Barium Sulfate Suspension Oral كبريتات الباريوم معلق فموي Barium sulfate 2 g/mL Oral Non-iodinated FALSE FALSE TRUE
SALINE_FLUSH Normal Saline Flush محلول ملحي عادي للغسل Sodium chloride 0.9% 0.9% IV Non-iodinated FALSE FALSE TRUE

Governance

  • Owner: Pharmacy Committee
  • Approver: P&T Committee
  • Update Frequency: With formulary changes; at least annually.
  • Change Process:
  • New agent or change requested by Radiology/RSO → P&T review → update PIS and RIS → update protocols and nursing workflows.

Validation Rules

  • route must be one of configured medication routes (e.g., IV, Oral).
  • Only one of is_iodinated or is_gadolinium can be TRUE; both FALSE for agents like barium.
  • Cannot deactivate an agent if referenced in active protocols.

MD-RIS-007: Diagnostic Reference Levels (DRLs)

Table: ris_drls

Purpose

Diagnostic Reference Levels per modality, body region, and exam type, aligned with UAE MOH radiation safety guidance and IAEA recommendations. Used in:

  • WF-RIS-007 Radiation Dose Monitoring & ALARA Compliance
  • Radiation dose alerts and dashboards

Schema

Field Type Required Description
drl_id BIGINT YES PK
modality_type_code VARCHAR(10) YES FK → ris_modality_types.modality_type_code
body_part_code VARCHAR(20) YES FK → ris_body_parts.body_part_code
exam_code_cpt VARCHAR(10) NO FK → ris_exam_codes.exam_code_cpt (optional; region-level DRL if null)
patient_category VARCHAR(20) YES e.g., Adult, Pediatric_5_10y
dose_metric VARCHAR(20) YES e.g., CTDIvol, DLP, DAP
dose_unit VARCHAR(20) YES e.g., mGy, mGy·cm, Gy·cm²
drl_value DECIMAL(10,2) YES DRL threshold
source_en VARCHAR(200) YES e.g., UAE MOH 2025 CT DRL guideline
source_ar VARCHAR(200) YES Arabic description
effective_from DATE YES Start date
effective_to DATE NO End date
is_active BOOLEAN YES Active flag
created_by BIGINT YES FK → users.user_id
created_at TIMESTAMP YES Creation timestamp

Sample Data

drl_id modality_type_code body_part_code exam_code_cpt patient_category dose_metric dose_unit drl_value source_en is_active
3001 CT HEAD 70450 Adult CTDIvol mGy 60.00 UAE MOH CT DRL 2025 TRUE
3002 CT CHEST NULL Adult DLP mGy·cm 400.00 UAE MOH CT DRL 2025 TRUE
3003 CT ABDOMEN_PELVIS 74177 Adult DLP mGy·cm 800.00 UAE MOH CT DRL 2025 TRUE
3004 CT HEAD 70450 Pediatric_5_10y CTDIvol mGy 40.00 UAE MOH CT DRL 2025 TRUE
3005 XR CHEST 71046 Adult DAP Gy·cm² 0.20 UAE MOH XR DRL 2025 TRUE

Governance

  • Owner: Radiation Safety Officer (RSO)
  • Approver: Radiation Safety Committee; external oversight by UAE MOH if required.
  • Update Frequency: As MOH guidance changes; at least every 2–3 years.
  • Change Process: 1. Review new MOH / IAEA DRL publications. 2. Compare local median doses vs proposed DRLs. 3. Committee approval. 4. Update RIS thresholds and dose dashboards. 5. Communicate to radiologists and technologists; adjust protocols if needed.

Validation Rules

  • drl_value must be > 0.
  • dose_metric must be from controlled list: CTDIvol, DLP, DAP, EffectiveDose.
  • Only one active DRL per (modality_type_code, body_part_code, exam_code_cpt, patient_category, dose_metric) combination.

MD-RIS-008: Laterality Codes

Table: ris_laterality_codes

Purpose

Standard laterality values used in orders, exams, and reporting, aligned with HL7 and DICOM.

Schema

Field Type Required Description
laterality_code VARCHAR(5) YES PK; e.g., L, R, B, NA
display_name_en VARCHAR(50) YES English name
display_name_ar VARCHAR(50) YES Arabic name
hl7_code VARCHAR(5) YES HL7/DICOM code (often same as laterality_code)
is_active BOOLEAN YES Active flag
sort_order INT YES UI ordering

Sample Data

laterality_code display_name_en display_name_ar hl7_code is_active sort_order
L Left يسار L TRUE 1
R Right يمين R TRUE 2
B Bilateral ثنائي الجانب B TRUE 3
NA Not Applicable غير محدد NA TRUE 4

Governance

  • Owner: System Config Owner
  • Approver: Radiology Informatics Lead
  • Update Frequency: Fixed; no routine changes.

Validation Rules

  • Only these four codes allowed unless HL7/DICOM standards change.
  • Laterality must be provided for exams where body part is paired (e.g., SHOULDER, KNEE, BREAST).

MD-RIS-009: Report Status Codes

Table: ris_report_status_codes

Purpose

Standard report status values aligned with HL7 Table 0085, used in:

  • radiology_reports.report_status
  • HIE submissions (NABIDH/Malaffi)
  • Analytics (TAT, addendum rate)

Schema

Field Type Required Description
report_status_code VARCHAR(10) YES PK; e.g., PRELIM, FINAL
display_name_en VARCHAR(100) YES English name
display_name_ar VARCHAR(100) YES Arabic name
hl7_code VARCHAR(5) YES HL7 Table 0085 code (e.g., P, F, C)
is_terminal BOOLEAN YES TRUE if no further edits allowed (e.g., FINAL, CORRECTED)
is_active BOOLEAN YES Active flag
sort_order INT YES UI ordering

Sample Data

report_status_code display_name_en display_name_ar hl7_code is_terminal is_active
DRAFT Draft مسودة X FALSE TRUE
PRELIM Preliminary أولي P FALSE TRUE
FINAL Final نهائي F TRUE TRUE
CORRECTED Corrected مصحح C TRUE TRUE
ADDENDUM Addendum ملحق A TRUE TRUE
CANCELLED Cancelled ملغى X TRUE TRUE

Governance

  • Owner: System Config Owner
  • Approver: Radiology Informatics Lead
  • Update Frequency: Fixed; changes only if HL7/NABIDH/Malaffi requirements change.

Validation Rules

  • hl7_code must be valid per HL7 Table 0085 or local extension.
  • Only one status per report at a time; transitions must follow configured workflow (e.g., DRAFT → PRELIM → FINAL).

MD-RIS-010: Priority Codes

Table: ris_priority_codes

Purpose

Standard priority values for orders and worklists, used in:

  • radiology_orders.priority
  • Worklist sorting (WF-RIS-001, WF-RIS-004)
  • Critical result escalation logic

Schema

Field Type Required Description
priority_code VARCHAR(20) YES PK; e.g., ROUTINE, URGENT, STAT, WET_READ
display_name_en VARCHAR(100) YES English name
display_name_ar VARCHAR(100) YES Arabic name
priority_rank INT YES Lower = higher urgency (e.g., STAT=1)
default_tat_minutes INT YES Target TAT in minutes
description_en VARCHAR(255) NO Description
description_ar VARCHAR(255) NO Description (Arabic)
is_active BOOLEAN YES Active flag

Sample Data

priority_code display_name_en display_name_ar priority_rank default_tat_minutes
STAT STAT عاجل جداً 1 60
URGENT Urgent عاجل 2 240
ROUTINE Routine عادي 3 1440
WET_READ Wet Read قراءة فورية 1 30

Governance

  • Owner: Radiology Admin
  • Approver: Chief Radiologist
  • Update Frequency: Annual review.
  • Change Process: Review TAT KPIs and adjust default_tat_minutes and definitions as needed.

Validation Rules

  • priority_rank unique per code.
  • STAT and WET_READ must have highest urgency (lowest rank).
  • Used consistently across orders, worklists, and analytics.

MD-RIS-011: RadLex Terminology Subset

Table: ris_radlex_terms

Purpose

Local subset of RSNA RadLex ontology used for structured findings, technique descriptors, and QA metrics.

Schema

Field Type Required Description
radlex_id VARCHAR(20) YES PK; e.g., RID1310
display_name_en VARCHAR(200) YES English term
display_name_ar VARCHAR(200) YES Arabic translation
category VARCHAR(50) YES e.g., Anatomy, Finding, Technique
parent_radlex_id VARCHAR(20) NO FK → ris_radlex_terms.radlex_id
snomed_code VARCHAR(20) NO Mapped SNOMED CT code (if applicable)
is_active BOOLEAN YES Active flag
created_at TIMESTAMP YES Creation timestamp

Sample Data

radlex_id display_name_en display_name_ar category parent_radlex_id
RID1305 Chest الصدر Anatomy NULL
RID1279 Head الرأس Anatomy NULL
RID1310 Shoulder الكتف Anatomy RID1305
RID3957 Ground-glass opacity عتامة زجاجية Finding NULL
RID28441 Pregnant uterus الرحم الحامل Anatomy NULL
RID10321 Non-contrast CT أشعة مقطعية بدون صبغة Technique NULL

Governance

  • Owner: Radiology Informatics
  • Approver: Radiology Informatics Lead
  • Update Frequency: With RadLex releases; at least annually.
  • Change Process: Import from RSNA; select relevant subset; map to SNOMED CT where needed; test in structured reporting.

Validation Rules

  • radlex_id must exist in official RadLex.
  • category from controlled list: Anatomy, Finding, Technique, Device, Pathology, etc.
  • No cycles in parent-child relationships.

MD-RIS-012: Radiologist Reading Assignments

Table: ris_reading_assignments

Purpose

Defines which radiologist is responsible for which modality/body part/time period, used for:

  • Auto-assignment of exams to reading worklists (WF-RIS-004)
  • Productivity and RVU analytics
  • On-call coverage

Schema

Field Type Required Description
assignment_id BIGINT YES PK
radiologist_id BIGINT YES FK → providers.provider_id
facility_id BIGINT YES FK → facilities.facility_id
modality_type_code VARCHAR(10) YES FK → ris_modality_types.modality_type_code
body_part_code VARCHAR(20) NO FK → ris_body_parts.body_part_code (optional)
shift_start TIMESTAMP YES Start of assignment
shift_end TIMESTAMP YES End of assignment
max_concurrent_cases INT NO For load balancing
is_primary_reader BOOLEAN YES Primary vs secondary reader
created_by BIGINT YES FK → users.user_id
created_at TIMESTAMP YES Creation timestamp

Sample Data

assignment_id radiologist_id facility_id modality_type_code body_part_code shift_start shift_end is_primary_reader
4001 501 10 CT ABDOMEN_PELVIS 2026-02-07 08:00 2026-02-07 16:00 TRUE
4002 502 10 MR SPINE_LUMBAR 2026-02-07 08:00 2026-02-07 16:00 TRUE
4003 503 10 XR NULL 2026-02-07 08:00 2026-02-07 20:00 TRUE
4004 504 10 CT HEAD 2026-02-07 16:00 2026-02-08 08:00 TRUE
4005 501 10 MG BREAST 2026-02-07 08:00 2026-02-07 12:00 TRUE

Governance

  • Owner: Chief Radiologist
  • Approver: Chief Radiologist (self-approval) with HR oversight for workload.
  • Update Frequency: Weekly or monthly, aligned with department schedule.
  • Change Process: Schedule planning → entry in RIS → communication to radiologists and reception.

Validation Rules

  • shift_end must be > shift_start.
  • No overlapping assignments for same radiologist, facility, modality, and body part unless explicitly allowed.
  • Used by worklist logic to assign exams; if no assignment found, route to default pool.

MD-RIS-013: Modality Resources

Table: modality_resources (owned entity)

Purpose

Registry of imaging equipment (CT, MRI, US, XR, etc.) per facility, used for:

  • Scheduling and slot management
  • DICOM AE Title and IP configuration
  • Maintenance planning
  • Dose and DRL analytics per device

Schema (extends brief)

Field Type Required Description
resource_id BIGINT YES PK
facility_id BIGINT YES FK → facilities.facility_id
department_id BIGINT YES FK → departments.department_id
modality_type_code VARCHAR(10) YES FK → ris_modality_types.modality_type_code
equipment_name VARCHAR(200) YES Display name (e.g., CT1 – 64-slice)
manufacturer VARCHAR(100) YES Vendor name
model VARCHAR(100) YES Model name
serial_number VARCHAR(100) NO Device serial
ae_title VARCHAR(50) YES DICOM AE Title
ip_address VARCHAR(50) YES IP or hostname
port INT NO DICOM port (default 104/11112)
is_active BOOLEAN YES Active flag
max_daily_slots INT YES Scheduling capacity
maintenance_status VARCHAR(50) YES e.g., Operational, Planned_Maintenance, Down
last_qa_date DATE NO Last QA test date
next_qa_due DATE NO Next QA due date
created_at TIMESTAMP YES Creation timestamp
updated_at TIMESTAMP NO Last update timestamp

Sample Data

resource_id facility_id department_id modality_type_code equipment_name manufacturer model ae_title ip_address is_active max_daily_slots maintenance_status
6001 10 101 CT CT1 – 128-slice Siemens Somatom Definition AS+ DUBAIHOSP_CT1 10.10.10.21 TRUE 40 Operational
6002 10 101 MR MRI1 – 1.5T GE Optima 450w DUBAIHOSP_MR1 10.10.10.31 TRUE 25 Operational
6003 10 102 XR XR1 – DR Room Philips DigitalDiagnost DUBAIHOSP_XR1 10.10.10.41 TRUE 80 Operational
6004 10 103 US US1 – General Samsung RS80A DUBAIHOSP_US1 10.10.10.51 TRUE 50 Operational
6005 10 104 MG MG1 – Mammography Hologic Selenia Dimensions DUBAIHOSP_MG1 10.10.10.61 TRUE 30 Planned_Maintenance

Governance

  • Owner: Imaging IT Manager
  • Approver: Radiology Director
  • Update Frequency: On acquisition, relocation, or decommissioning.
  • Change Process: Asset management → DICOM configuration → RIS/PACS update → test connectivity.

Validation Rules

  • ae_title must be unique per facility.
  • ip_address must be valid IPv4/IPv6 or resolvable hostname.
  • max_daily_slots > 0 for active resources.
  • maintenance_status from controlled list: Operational, Planned_Maintenance, Down.

MD-RIS-014: NABIDH/Malaffi Imaging Facility & Department IDs

Table: ris_hie_imaging_ids

Purpose

Maps local facilities/departments to NABIDH (Dubai) and Malaffi (Abu Dhabi) imaging identifiers for:

  • Outbound HL7 ORU^R01 submissions (INT-RIS-004, INT-RIS-005)
  • Compliance with DHA/DOH HIE requirements

Schema

Field Type Required Description
hie_mapping_id BIGINT YES PK
facility_id BIGINT YES FK → facilities.facility_id
department_id BIGINT YES FK → departments.department_id
emirate VARCHAR(20) YES e.g., Dubai, Abu Dhabi
hie_system VARCHAR(20) YES NABIDH or Malaffi
hie_facility_id VARCHAR(50) YES HIE-assigned facility ID
hie_department_id VARCHAR(50) NO HIE-assigned department ID (if applicable)
is_active BOOLEAN YES Active flag
effective_from DATE YES Start date
effective_to DATE NO End date

Sample Data

hie_mapping_id facility_id department_id emirate hie_system hie_facility_id hie_department_id is_active
7001 10 101 Dubai NABIDH DHA-DUBAIHOSP-001 DHA-DUBAIHOSP-RAD TRUE
7002 20 201 Abu Dhabi Malaffi DOH-ABUDHABIHOSP-010 DOH-ABUDHABIHOSP-RAD TRUE

Governance

  • Owner: IT / Integration Team
  • Approver: IT Director
  • Update Frequency: On facility registration or change with DHA/DOH.
  • Change Process: Receive official IDs from DHA/DOH → update mapping → test HIE messages.

Validation Rules

  • hie_system must be NABIDH or Malaffi.
  • hie_facility_id must match official registration.
  • Only one active mapping per (facility_id, department_id, hie_system).

MD-RIS-015: UAE Radiation Dose Units & Measurement Codes

Table: ris_dose_units

Purpose

Standard dose units and codes (UCUM-based) used in dose recording and DRLs, aligned with UAE MOH radiation safety reporting.

Schema

Field Type Required Description
dose_unit_code VARCHAR(20) YES PK; e.g., mGy, mGy.cm, Gy.cm2
display_name_en VARCHAR(100) YES English name
display_name_ar VARCHAR(100) YES Arabic name
ucum_code VARCHAR(20) YES UCUM code
description_en VARCHAR(255) NO Description
description_ar VARCHAR(255) NO Description (Arabic)
is_active BOOLEAN YES Active flag

Sample Data

dose_unit_code display_name_en display_name_ar ucum_code is_active
mGy Milligray ملي غراي mGy TRUE
mGy.cm Milligray-centimeter ملي غراي-سنتيمتر mGy.cm TRUE
Gy.cm2 Gray-square centimeter (DAP) غراي-سنتيمتر مربع Gy.cm2 TRUE
mSv Millisievert ملي سيفرت mSv TRUE
mGy.cm2 Milligray-square centimeter ملي غراي-سنتيمتر مربع mGy.cm2 TRUE

Governance

  • Owner: RSO
  • Approver: Radiation Safety Committee
  • Update Frequency: Rare; when MOH reporting formats change.

Validation Rules

  • ucum_code must be valid UCUM.
  • Used consistently in radiation_dose_records.dose_unit, ctdi_vol, dlp, dap, effective_dose_msv.

Configuration Parameters

Key RIS configuration parameters related to master data and behaviour.

Parameter Type Default Description Governance
max_results_per_search Integer 50 Max records returned in worklist/search queries System Admin
default_priority_code String ROUTINE Default priority for new orders when not specified Radiology Admin
stat_escalation_minutes Integer 15 Minutes before STAT critical result escalates to next level Chief Radiologist
urgent_escalation_minutes Integer 30 Minutes before URGENT critical result escalates Chief Radiologist
critical_ack_required_within_minutes Integer 30 Required acknowledgement time for critical results (PDPL audit) Chief Radiologist + DPO
drl_alert_threshold_percent Integer 100 Percentage of DRL at which to trigger alert (e.g., 100 = at DRL) RSO
max_daily_dose_alert_msv Decimal 20.0 Daily effective dose threshold for alerting (per patient) RSO
enable_pediatric_protocol_suggestion Boolean true Suggest pediatric protocols based on age/weight Radiology Informatics
default_report_status_on_sign String FINAL Status to set when radiologist signs (FINAL or PRELIM) Chief Radiologist
allow_prelim_for_stat Boolean false Whether STAT exams can be left as preliminary Chief Radiologist
nabidh_submission_enabled Boolean true Enable outbound ORU^R01 to NABIDH for Dubai facilities IT / Integration
malaffi_submission_enabled Boolean true Enable outbound ORU^R01 to Malaffi for Abu Dhabi facilities IT / Integration
anonymize_for_teaching Boolean false Enable anonymisation of images/reports for teaching datasets (PDPL) DPO + Radiology Director
default_worklist_sort String priority_then_oldest Default sort for reading worklist Radiology Informatics
max_concurrent_worklist_assignments Integer 20 Max open cases per radiologist to avoid overload Chief Radiologist
modality_slot_buffer_minutes Integer 10 Buffer time between scheduled exams per modality Lead Technologist
enable_auto_protocol_assignment Boolean true Auto-assign protocol based on exam code and body part Radiology Informatics

Data Load Procedures

1. Initial Load

Radiology Exam Codes (CPT)

  • Source: AMA CPT Radiology section (licensed), existing hospital RIS/RCM.
  • Format: CSV or Excel with fields: CPT code, description, modality, body part, default priority, charge details.
  • Process: 1. Import into staging table stg_ris_exam_codes. 2. Map modality and body part to ris_modality_types and ris_body_parts. 3. Validate uniqueness and CPT range (70000–79999). 4. Load into ris_exam_codes via ETL with audit trail.

Body Part Codes

  • Source: SNOMED CT + RadLex export.
  • Format: CSV/JSON with SNOMED ID, English term, RadLex ID.
  • Process:
  • Import to staging → select subset → add Arabic translations → load into ris_body_parts.

Modality Types & Dose Units

  • Source: DICOM standard, UCUM.
  • Process: Pre-configured seed data scripts; rarely changed.

Contrast Agents

  • Source: PIS / formulary (see CPOE module).
  • Format: CSV or API (JSON) with medication ID, name, route, concentration.
  • Process:
  • Map to RIS contrast_agent_code and link to PIS medication_id.
  • Validate routes and flags (is_iodinated, is_gadolinium).

Imaging Protocols & Report Templates

  • Source: Existing RIS, Word templates, or vendor library.
  • Format: CSV for metadata + HTML/RTF for content, or JSON for structured templates.
  • Process:
  • Manual curation and mapping to exam codes, body parts, RadLex terms.
  • Import via admin UI or ETL scripts with versioning.

DRLs

  • Source: UAE MOH radiation safety documents (PDF/Excel).
  • Process:
  • Convert to CSV → map to modality/body part/exam → load into ris_drls.
  • Validate against ris_dose_units.

Modality Resources

  • Source: Biomedical engineering / IT asset inventory.
  • Process:
  • Manual entry or CSV import with facility, department, AE Title, IP.
  • Connectivity test to PACS and modalities after load.

HIE IDs (NABIDH/Malaffi)

  • Source: DHA/DOH registration letters.
  • Process:
  • Manual entry by Integration team into ris_hie_imaging_ids.
  • Validate via test ORU^R01 messages.

2. Ongoing Synchronisation

  • CPT & Exam Codes: Annual CPT update; compare old vs new; retire obsolete codes with effective_to; add new codes.
  • SNOMED/RadLex: Periodic terminology updates; use versioned imports; maintain mapping tables.
  • Contrast Agents: Sync with PIS formulary via API (daily/weekly); deactivate agents removed from formulary.
  • DRLs: Update when MOH issues new guidance; maintain historical versions for audit.
  • Reading Assignments: Updated weekly/monthly via scheduling interface; no external sync.

3. Import/Export Formats

  • Import:
  • CSV (UTF-8) for bulk loads (exam codes, DRLs, body parts, contrast agents).
  • JSON for structured templates and protocol parameters.

  • API-based sync (REST/JSON) for formulary and provider data from other modules.

  • Export:

  • CSV/Excel for analytics and regulatory reporting (dose reports, DRL compliance).
  • JSON for integration with external analytics or AI tools (e.g., RadLex-coded findings).

4. Validation on Import

For all imports:

  1. Structural Validation
    - Required columns present.
    - Data types correct (e.g., numeric fields, dates in ISO 8601).

  2. Referential Integrity
    - Foreign keys (modality, body part, facility, provider) exist.
    - No orphan references.

  3. Business Rules
    - CPT range for radiology.
    - DRL values > 0 and within reasonable bounds.
    - No duplicate active records for unique business keys (e.g., DRL combinations, laterality codes).

  4. UAE Regulatory Checks
    - DRLs aligned with latest UAE MOH guidance.
    - HIE IDs match DHA/DOH registration.
    - PDPL: ensure no patient-identifiable data in master data imports; only configuration/terminology.

  5. Approval Workflow
    - Changes to clinical content (protocols, templates, DRLs) require electronic approval recorded in the system (owner + approver).
    - Audit logs retained for at least the period mandated by UAE regulations and internal policy.

This specification provides the master data and configuration foundation for the Radiology Information System, ensuring consistent, compliant, and interoperable imaging workflows across UAE facilities.

← Previous Radiology Information System Integration Specifications Next → Radiology Information System KPIs & Reporting
content/clinical/ris/06-master-data.md Generated 2026-02-20 22:54