Role Removal


The Role Removal Technical Trick provides the information for the creation of the following tables and columns which are necessary to perform the role removal:
1. Role - mapping table
2. Tables / Columns that need to be updated with Resource ID fields
3. Tables / Columns that need to be updated with Role Code fields
4. Tables that will need to be deleted
5. PRTEAM table should be checked
In many instances, having excess information stored within the database can cause poor performance or slowness when retrieving data. Administrators are always seeking out ways to clean and remove unused information. This technical trick on role removal provides the steps necessary to remove roles that would otherwise be unused and eliminating unwanted information.

Download Details
Submission Date Sep 22, 2012 10:40 am
Submitter Rego
Content Type Document
Work Type
Work Categories
Related Content
Supported Versions 12.x, 13.x, 14.x, 15.x
Special Instructions The only safe method to remove a role is to first map any reference to that role to another role that will not be removed. This will maintain the integrity of the database pointers and the project plans by mapping the references to that role before the role is removed. The role mapping can be imported to a table within the Clarity database. Because of these challenges, use of this technical trick will require up to 15 hours of additional Rego Consulting time.
Company Rego Consulting