14.04.02: Validations run for DTL1 records

1

SUSPEND a record if the Country Code is other than USA and the Postal Code is blank.

2

SUSPEND a record if either Address 1 or Zip-1 change and the country code is USA, and a partial address is reported. (Address 1, City, State, and Zip-1 are all required if the Country Code is USA. If any or all of these fields are missing, the address is considered partial.)

3

SUSPEND a record if either the Address 1, Postal Code, or Country Code change and the country code is other than USA, and a partial address is reported. (Address 1, Province, Postal Code, and Country Code are all required if the country Code is other than USA. If any or all of these fields are missing, the address is considered partial.)

4

SUSPEND a record if either Address 1 or Zip-1 are not on file and a partial address is reported, and the Country Code is USA. (Address 1, City, State, and Zip-1 are all required if the Country Code is USA. If any or all of these fields are missing, the address is considered partial.)

5

SUSPEND a record if either Address 1, Postal Code, or Country Code are not on file and a partial address is reported, and the Country Code is other than USA. (Address 1, Province, Postal Code, and Country Code are all required if the Country Code is other than USA. If any or all of these fields are missing, the address is considered partial.)

6

SUSPEND a DTL1 record if the complete demographic details are not present in the members account and the DTL1 record does not include the five required data elements. An account is said to have complete demographic details if it has all the following fields: First Name, Last Name, Date of Birth, Address, and Gender.

7

FLAG a record for an account if the date of birth on the record is different than the date of birth on file.

8

FLAG a record if the gender does not match the gender on file.

9

FAKE POST all DTL1 records reported for a member in Refunded, Death Refunded, Service Retirement, Disability Retirement, and Survivor Retirement statuses even before any validation of basic edits run on the record.

10

FLAG a DTL1 record if the First Name and/or the Last Name reported on the record is different than the First Name and/or the Last Name in the system.