Professional Services Automation Data Dictionary

Skill__c

Label: Skill / Certification

Records a certain competency or accreditation. Use skills/certifications to describe staffing requirements for projects and to track individual resource competencies.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Certification_Source__c Certification Source Pre-Spring 2018 Organization or institution that grants this certification.

Picklist:
Cisco
Google
Microsoft
Salesforce.com
Description__c Description Pre-Spring 2018 Text description of this skill or certification.

TextArea
External_Id__c External ID Spring 2018 The ID to identify this skill in an external system.

Text(255)
Group__c Group Pre-Spring 2018 Picklist of certification groups.

Picklist:
Java
Microsoft
Salesforce.com
Hierarchy_Key_Path__c Hierarchy Key Path Spring 2018 Path field for auto-generated concatenated ancestor IDs of the skill in the hierarchy.

Formula:
IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK( Parent_Category__r.Parent_Category__c), "", Parent_Category__r.Parent_Category__c & ",") & IF(ISBLANK(Parent_Category__c), "", Parent_Category__c)
Text
Hierarchy_Level__c Hierarchy Level Spring 2018 Indicates the level within the skills hierarchy.

Formula:
IF ( ISBLANK ( Parent_Category__c ), 0, ( LEN ( Hierarchy_Key_Path__c ) + 1 ) / 16 ) + 1
Number(2,0)
Hierarchy_Path__c Hierarchy Path Spring 2018 Path field for auto-generated concatenated ancestor names of the skill in the hierarchy.

Formula:
IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK( Parent_Category__r.Parent_Category__r.Name), "", Parent_Category__r.Parent_Category__r.Name & " > ") & IF(ISBLANK(Parent_Category__r.Name), "", Parent_Category__r.Name)
Text
Parent_Category__c Parent Category Spring 2018 The parent of this skill in the skill hierarchy.

Looks up to: Skill__c
Lookup
Parent_Hierarchy_Level__c Parent Hierarchy Level Spring 2018 Indicates at which level in the skills hierarchy the parent of this skill resides.

Formula:
IF ( ISBLANK ( Parent_Category__c ), NULL, Parent_Category__r.Hierarchy_Level__c )
Number(2,0)
Parent_Record_Type__c Parent Record Type Spring 2018 The parent record type for this skill.

Formula:
Parent_Category__r.RecordType.DeveloperName
Text
Record_Type_Name__c Record Type Name Spring 2018 The record type name for this skill.

Formula:
RecordType.DeveloperName
Text
Resource_Roles__c Resource Roles Fall 2021 Resource roles associated with this skill. The picklist values available come from the Resource Role global picklist value set.

MultiselectPicklist
Skill_Or_Certification__c Skill Or Certification Pre-Spring 2018 Deprecated. See Record Type instead.

Picklist:
Certification
Skill
Type__c Type Pre-Spring 2018 Set of skill types. Used when grouping skills capacity reports.

Picklist:
Business Analysis
Industry
Programming
Project Manager
Strategy
Technical
Technical & Architecture
Technical Architecture
Unique_Name__c Unique Name Pre-Spring 2018 The unique skill name.

Text(80)


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.