We have created a field 'Employee Type and Location' on stage Nexion company. we need to have a trigger to add / update value of this field. This drives the eligibility of employee for selerix plans.

Logic for deciding values is as follows,
Attached herewith is excel sheet Class1MgtandOthers.xls. This file is having 2 lists one is class 1 for management and other is class 1 for others. These are class 1 values. Class 1 is having job titles that categorized in two types Management and others. We want to divide these class 1 values in another 8 groups based employee state.
1. All employees having class 1 values from 'class 1 for others' list and state as Colorado will have having value 'Colorado (EMP)' for 'Employee Type and Location'
2. All employees having class 1 values from 'class 1 for management' list and state as Colorado will have having value 'Colorado (MGMT)' for 'Employee Type and Location'
3. All employees having class 1 values from 'class 1 for others' list and state as Louisiana will have having value 'Louisiana (EMP)' for 'Employee Type and Location'
4. All employees having class 1 values from 'class 1 for management' list and state as Louisiana will have having value 'Louisiana (MGMT)' for 'Employee Type and Location'
5. All employees having class 1 values from 'class 1 for others' list and state as Maryland will have having value 'Maryland (EMP)' for 'Employee Type and Location'
6. All employees having class 1 values from 'class 1 for management' list and state as Maryland will have having value 'Maryland (MGMT)' for 'Employee Type and Location'
7. All employees having class 1 values from 'class 1 for others' list and state as Texas will have having value 'Texas (EMP)' for 'Employee Type and Location'
8. All employees having class 1 values from 'class 1 for management' list and state as Texas will have having value 'Texas (MGMT)' for 'Employee Type and Location'
9. For all other the default value of 'Employee Type and Location' will be 'None'