Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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 GDRFAD 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.

...

Column NameDescription
MemberIDMember insurance card number.
PersonBirthDate

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

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.

...

  1. All fields except PersonUIDNumber are mandatory.
  2. Value in field PersonBirthDate has one of the formats described in 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.