Template
Use the following template to fill in members: (template) Member.Register.xlsx
...
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 > 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 | |
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 | |
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: | |
UID Number | NoYes | 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 | NoYes | 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 | NoYes | 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 | NoYes | 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 | NoYes | The origin of the product sold to the member. | 2 = Abu Dhabi 4 = Dubai | |
Product Code | NoYes | The ID of the insurance product as in the insurer's marketing literature. | ||
Product ID | NoYes | 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 | NoYes | 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 | NoYes | 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 | NoYes | 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 | NoYes | 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 | NoYes | 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 | NoYes | The type of the sponsoring entity. | 1 = Resident 2 = Citizen (i.e. UAE locals, GCC locals) 3 = Establishment 4 = Property Owner | |
Establishment Entity ID | NoYes | The official ID of the sponsoring entity:
| ||
Establishment Contact Number | NoYes | The primary contact number of the policy holder. | (Country code) (Area Code) ( Number) | |
Establishment Email | NoYes | 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. |
...