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

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.

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.