3. Modify the Database
Create and execute SQL Script:
Modify the Candidates table to add a column
Purpose is to distinguish these candidates from the new candidates to be loaded:
Name for Column AreaOfConsideration
Should be able to easily change the values if the terms are determined not helpful
4. Modify the Search Page
Add another feature to the search page to include a pulldown box which allows for filtering search results based
on the new column created in step 3.
Modify the SQL statement which extracts the search results
5. Create a new domain called CMSTEST
Copy the existing CMSDEV domain to the new domain, verify the new domain is functioning and operational.