Member.Register DHA

Template

Use the following template to fill in members: (template) Member.Register.xlsx

Data description

The table below describes each column in the expected Excel file. Some columns are always required (Mandatory = Yes), some are optional, and some are conditional (depend on data entry).

Worksheet	Column	Mandatory	Description	Possible Values
Members	Sender ID	Yes	The license number (eClaimLink ID) of a healthcare entity that is the sender of the transaction.	https://www.eclaimlink.ae > DHD > Codes and Lists > Payers
	Receiver ID	Yes	The license number (eClaimLink ID) of a healthcare entity that is the receiver of the transaction.	DHA
	First Name	Yes	The patient's first name, as spelled in the passport.
	Second Name	No	The patient's second name as spelled in the passport.
	Family Name	Yes	The patient's family/last/surname name as spelled in the passport.
	Contact Number	No	The primary mobile contact number of the insured member. - If the insured member is a minor, the number is that of a parent/guardian. - If the insured member does not have or does not disclose a mobile number, then the mobile number is that of their emergency contact.	(Country code) (Area Code) (Number)
	Birth Date	Yes	The date on which a person was born or is officially deemed to have been born. In cases, where despite best efforts Birth Date is not known but the age is known, Birth Date is assumed to be on the 1-Jan of the current year, minus the age of the person.	dd/mm/yyyy
	Gender	Yes	The patient's gender.	1 = Male 0 = Female 9 = Unknown
	Nationality	Yes	The person's current nationality as defined by the passport.	https://www.eclaimlink.ae > DHD > Codes and Lists > GDRFA Nationalities The 3-digit code, for example: 101 = United Arab Emirates, 131 = Algeria.
	Passport Number	Yes	The number of the passport that has the UAE visa, or if not available, the National ID (for example GCC Nationals).
	Marital Status	Yes	The current marital status of the person.	1 = Unmarried 2 = Married
	Email	No	The personal email address of the insured member. It is highly recommended to provide this field as per the DHA.
	Emirate	Yes	The Emirate from which the member's visa/residency is issued from.	1 = Sharjah 2 = Abu Dhabi 4 = Dubai 5 = Umm Al Quwain 6 = Ajman 7 = Ras Al Khaimah 9 = Fujairah 10 = UAE national 11 = Dubai national 12 = GCC national 13 = Diplomat
	Residential Location	Yes	The person's actual place of residence.	https://www.eclaimlink.ae > DHD > Codes and Lists >DSC Locations NNN, for example: 356 = UMM SUQEIM FIRST, 346 = BUSINESS BAY
	Work Location	Yes	The person's actual place of work based on the Location list (DSC Locations) published on eClaimLink. If the place of work varies, use the location of the head office of the sponsor.	https://www.eclaimlink.ae > DHD > Codes and Lists >DSC Locations NNN, for example: 356 = UMM SUQEIM FIRST, 346 = BUSINESS BAY
	Salary	Yes	The salary bracket of the insured member.	1 = Salary less than 4,000 AED per month 2 = Salary between 4,001 and 12,000 AED per month 3 = Salary greater than 12,000 AED per month 4 = No salary (used for dependants or children that do not acquire a salary)
	Commission	Yes	If the member is acquiring income on a commission based plan.	1 = Yes, some (or all) of the member's income is based on a commission plan 2 = No, the member's income is not based on a commission plan
	Emirates ID Number	Yes	The unique number the government assigns to a citizen.	NNN-NNNN-NNNNNNN-N When EmiratesIDNumber is not available: 000-0000-0000000-0 = National without card 111-1111-1111111-1 = Expatriate resident without a card 333-3333-3333333-3 = Newborn without a card
	UID Number	Yes	Unified Identity Number issued at the time of entry by the Ministry of Interior (MOI). - The number is available on the Visa or residency document of the member under U.I.D Number. Insurance companies and TPAs will be able to validate or acquire this number from the General Directorate of Residency and Foreigners Affairs (GDRFA).
	Member ID	Yes	The patient’s insurance member number, if the patient is claiming insurance. Otherwise, it is empty.
	Relation	Yes	The information about family relationships under the same Payer ID (insurance company). - This value must be 1 = Principal if the member does not have any relation with another insured member under the same Payer ID. - This value will have a relation with the insured family member if one exists.	Principal Spouse Child Parent Other
	Relation To	Yes	The information about Member ID of the principal member of the family within the same Payer ID. - If the reported member has no other related family members under the same Payer ID (Relation = Principal), then Relation To = Member ID. - If the reported member has a related family member under the same Payer ID (Relation = Spouse, Parent, Child or Other), then Relation To is the insured Member ID of the family member.
	Payer ID	Yes	The patient's insurance DHA payer ID. For self-paid schemes, this is the eClaimLink Self Paid scheme ID assigned by the DHA.	https://www.eclaimlink.ae > DHD > Codes and Lists > Payers
	Product Origin	Yes	The origin of the product sold to the member.	2 = Abu Dhabi 4 = Dubai
	Product Code	Yes	The ID of the insurance product as in the insurer's marketing literature.
	Product ID	Yes	The code granted by the eClaimLink to the registered product. - if there is no Product ID, 'PayerID-0000-00' is used until receiving further instructions from DHA on Product Registration. - if Product Origin = 1 (Abu Dhabi), then the Abu Dhabi Product ID is used.
	Policy ID	Yes	The ID of the insurance policy as registered in the insurer's system.
	Top Up Policy	No	Any policy which provides benefits over and above the benefits provided under the main Dubai compliant policy.	1 = Top-Up Policy 2 = Main Policy
	Enrollment Date	Yes	The day (at 00.00 hours local time), month and year from which the Policy became effective for the Insured Member.	dd/mm/yyyy
	Deletion Date	Yes	Expiry Date of the policy unless the member has been removed prior to the expiry of the policy. In this case, it is the day at 00:00hrs local time, month and year on which the insured member's coverage ceases as the result of his/her deletion at the request of the PolicyHolder. If there is no deletion date, then the expiry date of the policy is put.	dd/mm/yyyy
	Gross Premium	Yes	This is the amount in AED of the annualized premium payable for this insured member. - if Product Origin = 1 (Abu Dhabi), then 0000 is put as a default value.
	Actual Premium	Yes	The amount in AED of the premium payable for this insured member if charged on a pro-rata basis related to the period of coverage. If not charged on a pro-rata basis, then it reflects the same figure as for Gross Premium. If Product Origin = 1 (Abu Dhabi), then 0000 is put as a default value.
	Establishment Entity Type	Yes	The type of the sponsoring entity.	1 = Resident 2 = Citizen (i.e. UAE locals, GCC locals) 3 = Establishment 4 = Property Owner
	Establishment Entity ID	Yes	The official ID of the sponsoring entity: if the sponsor is a Resident, then the UID of the resident is used (Residence File number); if the sponsor is a Citizen, then the UID of the Citizen is used (Citizen File number) if the sponsor is an Establishment, then the Establishment Code is used (UID). if the sponsor/applicant is a Property Owner, then the property owner's UID is used.
	Establishment Contact Number	Yes	The primary contact number of the policy holder.	(Country code) (Area Code) ( Number)
	Establishment Email	Yes	The email address of the policy holder. If the policy holder is an establishment, this is the email ID of an individual or a department responsible for health insurance related matters.