DATA VALIDATION RULES

 

Field Name 

Validation 

Comments 

VAC Number 

 

Provided by BMAF Area Club on acceptance as club member 

Title 

Dr, Dame, Lady, Lord, Miss, Mr, Mrs, Ms, Rev, Sir or blank 

 

FirstName 

First Letter only in Upper Case 

 

LastName 

First Letter only in Upper Case 

 

Initials 

First letter (in upper case) of all names except the last first, no spaces 

Defaults to first letter of first name 

Date of Birth 

Day: format = dd 

 

Month: format = mm 

Year: format = yyyy 

Gender 

Female, Male 

 

Interests-sprints 

Multiple choices possible 

Abbreviation = “s” 

Interests-middle distance 

Abbreviation = “m” 

Interests-road running 

Abbreviation = “r” 

Interests-jumps 

Abbreviation = “j” 

Interests-throws 

Abbreviation = “t” 

Interests-cross country 

Abbreviation = “x” 

Interests-walks 

Abbreviation = “w” 

Interests-coaching 

Abbreviation = “c” 

Interests-officials 

Abbreviation = “o” 

Address1  

Mandatory 

 

Address2   

Optional (excludes postal town/city) 

 

Address3 

Postal town/city, all in uppercase letters 

 

Address4 

County/state - optional
(including country and postcode, if not UK) 

 

PostCode 

UK only
all letters in uppercase 

 

Country 

This is the country for which the passport is held. 

Blank is equivalent to United Kingdom 

Telephone  

starting “0” if UK, starting “00 “ if country not UK)
Space after area code and after 4 digits in an 8 digit local number 

Examples:
023 1234567
020 8123 4567
01234 567890
00 852 1234 5678 

Mobile 

Space after provider code 

Example:
07123 456789 

Email 

Mandatory for online members 

Used for communications from BMAF and BMAF area clubs 

Salutation 

Optional
(Defaults to First Name) 

Used for communications from BMAF and BMAF area clubs
e.g. Fred or Mr AB Smith 

First Claim Club 

Mandatory (but the club does not have to be UKA Affiliated) 

Use full club name, not an abbreviation except AC 

Other Veterans clubs 

Abbreviation (e.g. SCVAC) 

Used to ensure BMAF record for each club are in place 

UKA Registration Number 

Optional 

Supplied by 1st Claim club for new members 

Passport will be sent 

Yes or No (blank =No) 

Set to “Yes” by non-affiliated, non-British passport holders who are sending the passport for verification
Set back to “No” by membership secretary after verification is complete