Published by
Dubai Courts
Number of Data Files / Resources 1
Updated: 01 Mar 2021
This Dataset will list all the records of court session information that are scheduled within the next seven days
Request Permission

I acknowledge that I have read and agree to the terms and conditions

Send Request
Your request has been successfully submitted
You will receive a confirmation within 14days time period. If you are
having any query feel free to contact us.
Updated: 01 Mar 2021
Field Value
Data Provenance This data set represent a list of all courts session at Dubai Courts is generated by by Case management application that run using Oracle tools and Orale Database over Dubia Courts infrastructre
Tags / Keywords
Dataset Source next_sess_rol_details
Remarks/Special Business Rules
Coverage (Geographic area)
Dataset Temporal Windows
Monthly upload is a full dump
Frequency of Update on Source
Frequency of Update to SDP
Expected Volume/Ingestion Cycle(Daily if Real-time)
3000 records
Source Platform Type
OLTP relational database (Oracle)
Already Shared?
If Shared, with which Entities?
Already Published?
If Published, where?
Attribute Name Attribute Description Attribute Language Attribute Classification Attribute Datatype Attribute Size Attribute Range of Values Attribute Foreign Key
session_date The date of the case session English Open DATE 10 DD-MM-YYYY Denormalized
session_day Day of session English Open VARCHAR2 10 Denormalized
session_time The time of session English Open VARCHAR2 5 DD-MM-YYYY HH24:MI Denormalized
area_description The jurisdiction area English Open VARCHAR2 100 Please see CaseArea tab Denormalized
hall_description The hall number Arabic Open VARCHAR2 60 Please see CaseHall tab Denormalized
session_sequence_number sequence of the session in a particular the hall (Multiple rows) Arabic Open NUMBER 4 Denormalized
case_subtype_code Case number PK1 (Multiple rows) English Open NUMBER 3 Please see CaseSubtype tab Denormalized
case_year Case number PK2 (Multiple rows) English Open NUMBER 4 Denormalized
case_serial_number Case number PK2 (Multiple rows) English Open NUMBER 5 Denormalized
case_number Concatenated Case key with subtype code description (Multiple rows) Arabic Open VARCHAR2 250 Denormalized
status Status of the case (Multiple rows) Arabic Open VARCHAR2 150 Please see CaseStatus tab Denormalized
postponement_reason The reason of the case postponement (Multiple rows) Arabic Open VARCHAR2 150 Denormalized