GDRFAD Members Table

This table contains members that have been successfully validated against GDRFAD.

Column Name	Data Type	Allows Nulls	Description
UniqueId	nvarchar(50)	No	Unique ID of the member in the database. This is GUID value generated by GA. This column is Primary Key.
MemberId	nvarchar(100)	No	Member insurance card number.
PersonBirthDate	date	Yes	Member's birth date.
PersonGender	tinyint	Yes	Member's gender.
PersonNationality	smallint	Yes	Member nationality.
PersonPassportNumber	nvarchar(30)	Yes	Number of member passport that has UAE visa. If not available, it can be National ID, e.g. GCC Nationals.
PersonEmirate	tinyint	Yes	Emirate where member's residency/visa is issued.
PersonUidNumberPayer	nvarchar(50)	Yes	Member UID as per data source provided by payer.
PersonUidNumberGdrfad	nvarchar(50)	Yes	Member UID returned by GDRFAD. This value is set to `ValidateMemberUIDResponse.UID` returned from DHPO.
PostOfficeReturnCode	int	Yes	This value is set to `ValidateMemberUIDResponse.Result` returned from DHPO.
PostOfficeReturnMessage	nvarchar(MAX)	Yes	This value is set to `ValidateMemberUIDResponse.ErrorMessage` returned from DHPO.
ValidationDate	datetime	Yes	Date and time when GA has validated the member against GDRFAD.
RecordNo	bigint	No	This is auto incremental number generated by database automatically when new record is added. This column is added only to contain Cluster Index.

Greenrain Automation Help