Data Model - Skill vs. Competency
I have a question on the OOTB data model/db layout. I see that there are Skills and Competencies, and both of these link to Resource. They also both link to Profile.
What does Insight consider to be the difference between a Skill and a Competency? What about a Profile and a Resource? Along the same lines, I'm struggling to define the differences between Organization / ResourceGroup / Pool. We have a custom Focal Point workspace that I am trying to map into Insight that tracks supply and demand data, and I'm struggling to understand where to map the data to. Any assistance I could get on this subject would be great. |
4 answers
|
|
Does anyone have thoughts on this? Those fields were created to support Rational Project Conductor (RPC) a couple of years ago. As RPC is no longer an active product, I don't think they are being used. I can try to find out what were intended to mean originally if you want. I don't know how they might relate to Focal Point. Mike Fox |
|
Thanks Mike. I guess if the rest of the products will be ignoring these tables we can probably use them however we want, I just didn't want to start defining a custom mapping and end up causing inconsistent data if other tools were also populating these or will be in the future (such as RRC, which we haven't investigated).
We're not only investigating them from Focal Point, but also from ClearQuest where we have a custom schema that has an extended User record that tracks department/organization data and also allows for Group ID's that contain links to multiple users, so we're looking at this from multiple aspects to see what the best fit is. |
Resources - the actual physical human resource are ready to be allocated to a project.
Profile - human resource yet to be recruited (aka virtual resource). Its common practice that during the project planning stage Profiles will be introduced and allocated same way as Resources. Profiles will be treated pretty much same way as Resources except they are not there physically. Thats why you see Profiles also have links to Skill and Competencies. Once the actual Resource for a Profile is recruited all the allocations and assignments done so far with the Profile will be replaced with actual recruited Resource. Also for a given project, summation of all the Profile allocations is called Demand for a project, meaning how much more resource actually needed to execute the project. Eg for Skill would be C, C++, Java, UI programming, Functional Test etc, where as eg for Competencies would be Programmer, Development Lead, Architect etc. Regarding the Resource Group or Pool -- though users can define as many logical grouping of resources based of their convenience and requirement, Insight have currently have tables for Organization (business unit or division of an organization) and CITY (geography where the resource blog). Hope this helps. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.