Problem Statement:
For employees getting added from API calls we are enforcing unique email address for employees at company level. However, later in system we allow employee / admin to modify their email address on demographics page without check for unique email address. For this we are suggesting to add a validation check on demographic update which will ensure that system does not allow duplicate email address for an employee within same company.


Implementation
1. Expose a flag(checkbox) in Company System Settings.
2. Based on this flag,email address of the company will be validated for it's uniqueness.
3. By default flag will be no so that existing data on company is not hampered.


Implementation to be done on save of:
1. Add Employee
2. Demographics
3. Import
4. Change status
5. Scrub data SP

Status not to be considered while checking for unique email:
1. Terminated
2. Inactive
3. Deceased 


Implementation Details:

Flag and Functionality:-
1. Add a checkbox named Require Uniuqe Email address on Company System settings.
2. By Default this checkbox will be unchecked. (i.e by default set to no) 
3. When this checkbox is checked,existing data of the company will be verified for uniqueness of email.
4. If duplicate email id's are found,error popup will be displayed indicating the user to check and change already existing duplicated email ids.
5. Checkbox will be unchecked,if duplicate email id is found.

Add Employee and Demographics:-
1. When Email id is added, on blur of it's textbox, Flag on company settings will be verified.
2. If set to yes, validation to check if email id exists will be fired.
3. All employee status, except Terminated,Inactive and Deceased will be considered for validation.
4. If email id is present, appropriate message will be shown and email textbox will be cleared.
5. If email id is not present, it will be allowed to save.


Change Status:-
1. If an employee status is changing from Terminated to Active, on change of his class,validation to check his email id will be fired.
2. If email id is present, appropriate message will be shown to change his email id.
3. If email id is not present, it will be allowed to save.

Import:-
1. On Import, whenever employee is added, Flag on company settings will be verified.
2. If set to yes, validation to check if email id exists will be fired.
4. If email id is present, record will go to bad file with appropriate message.
5. If email id is not present, it will be allowed to import.

Scrub Data SP:-
1. While doing company restore, make the checkbox(flag) unchecked.