client and contract information mis-placed

[cccs-ip]

Our current database organization mis-places the variables about clients and contracting. Consultants can be hired to a project via other consultancies, and each Associate will have be issued a different contract to work on an assignment. These variables should therefore not be attributed to a specific project (as is currently the organization, e.g. World Bank Country Profile: Indigenous Peoples of the Russian Federation - scroll to the bottom], but instead they should be linked into the project information per consultant, e.g. Aaron Dennis]. The same applies also to where the services are performed.

To re-cap, we should move the following values from projects to consultant CVs (project data field)

• Service on site
• Service off site
• Service remote [NOTE: This is the same as off site; it should be deleted; the option for both on- and off- site should be added]
• Client end
• Client contract
• Client beneficiary
• Contract

Please help us to re-work the database accordingly. We can manually re-enter and data lost as a result. Please note that I am also adding corresponding label change requests under Issue #110

[pwhipp]

I've copied the data as part of the migration (South is sweet) but, if and where it exists, it is duplicated for each cvproject since it was currently only associated with the project.

Lucky I changed the cvproject to a stackedInline in admin ;)

[cccs-ip]

thank you