Published by
DHA
Number of Data Files / Resources 1
Updated: 01 Jan 2020
This dataset contains the Active health facilities details
Request Permission

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

Cancel
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.
Done
Field Value
Data Provenance Active Facility details are listed out from the view vFacilityForSearch.The tables involved are Facility,FacilityLicense,FacilitySubCategory,FacilityCategory,Area
Tags / Keywords
Dataset Source Text File
Language
Remarks/Special Business Rules
Coverage (Geographic area)
Dataset Temporal Windows
ALWAYS APPLICABLE
Rights
N/A
Frequency of Update on Source
Frequency of Update to SDP
Daily
Expected Volume/Ingestion Cycle(Daily if Real-time)
BULK
Source Platform Type
Flat File Source
Already Shared?
Y
If Shared, with which Entities?
Already Published?
Y
If Published, where?
Attribute Name Attribute Description Attribute Language Attribute Classification Attribute Datatype Attribute Size Attribute Range of Values Attribute Foreign Key
unique_id Unique Number for each Facility English Open Bigint 8
f_name_english Facility Name in English English Open Nvarchar 500
f_name_arabic Facility Name in Arabic Arabic Open Nvarchar 500
facility_category_name_english Facility Sub Category Name in English English Open Nvarchar 500
facility_category_name_arabic Facility Sub Category Name in Arabic English Open Nvarchar 500
address_line_one Facility Main Category Name in English English Open Nvarchar 500
address_line_two_english Facility Main Category Name in Arabic English Open Nvarchar 500
address_line_two_arabic   English Open Nvarchar 500
po_box P O Box No English Open Varchar 50
website Website Address English Open Nvarchar 500
telephone_1 Telephone 1 number English Open Nvarchar 100
telephone_2 Telephone 2 number English Open Nvarchar 100
fax Fax number English Open Nvarchar 100
expiry_date Expiry Date English Open Datetime 8
status Status English Open Char 3
area_id Area ID English Open Bigint 8
x_coordinate X Coordinate English Open Varchar 50
y_coordinate Y Coordinate English Open Varchar 50
email Email Address English Open Nvarchar 200
area_english Area in English English Open Nvarchar 500
area_arabic Area in Arabic English Open Nvarchar 500