Professional Services Automation Data Dictionary

Skill__c

Label: Skill or Certification

Records a certain competency or accreditation. Use Skills and Certifications to describe staffing requirements for projects and to track individual resource competencies.

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

Picklist:
Cisco
Google
Microsoft
Salesforce.com
false
Description__c Description Pre-Spring 2018 Text description of this Skill or Certification.

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

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

Picklist:
Java
Microsoft
Salesforce.com
false
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 false
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) false
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 false
Parent_Category__c Parent Category Spring 2018 The parent of this skill in the skill hierarchy.

Looks up to: Skill__c
Lookup false
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) false
Parent_Record_Type__c Parent Record Type Spring 2018 The parent record type for this skill.

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

Formula:
RecordType.DeveloperName
Text false
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 false
Skill_Or_Certification__c Skill Or Certification Pre-Spring 2018 Deprecated. See Record Type instead.

Picklist:
Certification
Skill
false
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
false
Unique_Name__c Unique Name Pre-Spring 2018 The unique skill name.

Text(80) false


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