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.
having any query feel free to contact us.
Done
| 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 | ||||||
| Language | |||||||
| Remarks/Special Business Rules | |||||||
|
Coverage (Geographic area)
|
|||||||
|
Dataset Temporal Windows
|
Monthly upload is a full dump
|
||||||
|
Rights
|
N/A
|
||||||
|
Frequency of Update on Source
|
RealTime
|
||||||
|
Frequency of Update to SDP
|
Daily
|
||||||
|
Expected Volume/Ingestion Cycle(Daily if Real-time)
|
3000 records
|
||||||
|
Source Platform Type
|
OLTP relational database (Oracle)
|
||||||
|
Already Shared?
|
N
|
||||||
|
If Shared, with which Entities?
|
|||||||
|
Already Published?
|
Y
|
||||||
|
If Published, where?
|
www.dc.gov.ae
|
||||||
| Show more | |||||||
| 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 | |
| Show more Show less | |||||||