Person.Register DoH
Template
Use the following template to fill in persons: (template) Person.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 |
|---|---|---|---|---|
| Persons | Sender ID | Yes | The license number of a healthcare entity that is the sender of the transaction. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Licenses > Insurers, column Auth.No where Classification = Insurance https://www.doh.gov.ae/en/Shafafiya/dictionary > Licenses > Facilities, worksheet Facility, column License |
| Receiver ID | Yes | The license number of a healthcare entity that is the receiver of the transaction. | HAAD | |
| Unified Number | No | Unique person identifier issued by the MOI. It identifies an individual through passport (for nationals) or visa (for expatriates) issuance and renewal processes. | ||
| First Name | No | The person's first name, as spelled in the passport. | ||
| First Name En | No | The person's first name in English for whom the Insurance policy is issued. | ||
| Middle Name En | No | The person's second name in English for whom the Insurance policy is issued. | ||
| Last Name En | No | The person's family name in English for whom the Insurance policy is issued. | ||
| First Name Ar | No | The person's first name in Arabic for whom the Insurance policy is issued. | ||
| Middle Name Ar | No | The person's second name in Arabic for whom the Insurance policy is issued. | ||
| Last Name Ar | No | The person's family name in Arabic for whom the Insurance policy is issued. | ||
| Contact Number | No | The telephone contact number provided by the patient. If multiple numbers are available, the mobile phone number is used. If multiple mobile phone numbers are provided, it is the first mentioned number which is personal to the patient. | ||
| Birth Date | Yes | The date on which a person was born or is officially deemed to have been born. If it is not known but the age is known, then the birth date is assumed to be on the 1st of January 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 current nationality of the person, as defined by the passport. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Codes > Other Codes > worksheet Nationality, column Code | |
| Nationality Code | No | The code of the person's nationality. | ||
| City | Yes | The person’s actual city of residence. | ||
| City Code | No | The code of the person's city of residence. | ||
| Country Of Residence | No | The name of the person’s country of usual residence. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Codes > Other Codes > worksheet Nationality, column Country | |
| Emirate Of Residence | No | The code of the person’s Emirate of usual residence if the person is a resident of the UAE. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Codes > Other Codes > worksheet Emirate, column Code | |
| Passport Number | No | The passport number, or, if not available, the National ID. | ||
| Emirates ID Number | Yes | The unique number the government assigns to a citizen. | NNN-NNNN-NNNNNNN-N When EmiratesIDNumber is not available:
| |
| Sponsor Number | No | An employer or individual number that offers a group health plan to its employees or members. | ||
| Sponsor Name En | No | An employer or individual English name that offers a group health plan to its employees or members. | ||
| Sponsor Name Ar | No | An employer or individual Arabic name that offers a group health plan to its employees or members. | ||
| Is Resident | No | The flag which indicates whether the person is the UAE resident or not (e.g. visitor or applying for the residence or diplomat, etc). | True / False | |
| Member ID | Yes | Insurer's identifier for its member. The same MemberID cannot be assigned to more than one person. In Person.Register transactions submitted by Providers, such as to report self-pay, medical tourism and other persons without insurance cards, MemberID must be equal to ClaimMemberID reported in related claims (EncounterFacilityID#EncounterPatientID). | ||
| Relation | No | Family relationships. | Principal | |
| Relation To | No | MemberID of the principal member of the family. | ||
| Relation To Emirates ID Number | No | Emirates ID Number of the principal member of the family. Emirates ID Number is a unique number the government assigns to a citizen. | NNN-NNNN-NNNNNNN-N | |
| Relation To Unified Number | No | Unified Number of the principal member of the family. Unified Number is a unique person identifier issued by the MOI. It identifies an individual through passport (for nationals) or visa (for expatriates) issuance and renewal processes. | ||
| Payer ID | No | Insurer's license number the member has a contract with. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Licenses > Insurers | |
| TPA ID | No | The license number of TPA that administers the contact the member has a contract with. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Licenses > Insurers | |
| Package Name | No (Yes for payer / TPA) | The name of the insurance package. | https://www.doh.gov.ae/en/Shafafiya/dictionary > Codes > Benefit Packages | |
| Start Date | No (Yes for payer / TPA) | The date the member first became insured. Restrictions:
| dd/mm/yyyy | |
| Renewal Date | No (Yes for payer / TPA) | The date the insurance was last renewed. If it is first time insurance, the date is the same as used for Contract Start Date. Restrictions:
| dd/mm/yyyy | |
| Expiry Date | No (Yes for payer / TPA) | The date the insurance will expire if it is not renewed. Restrictions: cannot be less than 01/01/1900. | dd/mm/yyyy | |
| Gross Premium | No (Yes for payer / TPA) | The AED amount of the monthly, quarterly or yearly premium the member has to pay for his insurance policy. The insurer may choose to use the average gross premium for the specific package used. | ||
| Policy Holder | No (Yes for payer / TPA) | The indication of the policy holder. | 1 = Government 2 = Government related services 4 = Private companies < 1,000 employees 6 = Private companies ≥ 1,000 and < 50,000 employees 7 = Private companies ≥ 50,000 and < 100,000 employees 8 = Private companies ≥ 100,000 employees 9 = Embassy 10 = Individual 11 = SME 12 = Diplomat 13 = Dar Zayed 99 = Others | |
| Company ID | No | The trade license number of the member's company. | ||
| Collected Premium | No | The AED amount received by the payer as a premium for the term of the member’s insurance contract. | ||
| VAT | No | The total Value Added Tax amount appropriated for the collected premium. | Number, two decimals | |
| VAT Percent | No | The Value Added Tax rate. | [0...100], one decimal | |
| Contract Status | No (Yes for payer / TPA) | Contract status. | New |