Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Current »

Workflows

  1. Payer system has several options to make member details available for GDRFAD Members Validation:
    1. Excel file placed into special folder.
    2. Staging table in payer system database.
    3. Specify SELECT SQL how to read member details from payer system.
  2. Every member is checked against GDRFAD.

  3. For all members that failed GA Data Validation or GDRFAD validation:

    1. Send one failure e-mail with all failed member details as described in section Validation Failure Alert.

  4. GA will check for new member details with the frequency specified in GA Settings. This way Payer can control when new members would be uploaded to DHA Post Office.

Data Required for Members Validation

Table below presents data required for GDRFAD members validation. GA expects all below fields to be available. Note that sequence of columns does not matter, GA must check only column names.

Column NameDescription
MemberIDMember insurance card number.
PersonBirthDate

Member's birth date. The expected formats are explained in section /wiki/spaces/GA/pages/10813482.

PersonGenderMember's gender: 1 for male and 0 for female.
PersonNationality

Member nationality as 3-digit; GA will check that nationality code is specified in the official list from DHA Post Office.

PersonPassportNumber

Number of member passport that has UAE visa. If not available, it can be National ID, e.g. GCC Nationals.

PersonEmirate

Emirate where member's residency/visa is issued. The following values are allowed:
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

PersonUIDNumber

Unified Identity Number issued by the Ministry of Interior (MOI). The number is available on the Visa or Residency Document of the member under U.I.D Number title.

Before validating members against GDRFAD, GA has to run the following data validation:

  1. All fields except PersonUIDNumber are mandatory.
  2. Value in field PersonBirthDate has one of the formats described in Supported Date Formats.
  3. Field PersonGender has value of 1 for male or 0 for female.
  4. Field PersonNationality has one of the allowed values published on DHPO.
  • No labels