Professional Services Automation Data Dictionary

Experience__c

Label: Experience

Stores details of a resource's experience.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Assignment__c Assignment Fall 2021 Lookup to the related assignment for the experience.

Looks up to: Assignment__c
Lookup
Description__c Description Fall 2021 Gives further information about the experience.

TextArea
End_Date__c End Date Fall 2021 Date the experience ended.

Formula:
IF(NOT(ISBLANK(Project_Task_Assignment__c)),Project_Task_Assignment__r.Project_Task_End_Date__c,IF(NOT(ISBLANK(Assignment__c)),Assignment__r.End_Date__c,null))
Date
Hours__c Hours Fall 2021 Number of hours spent on the experience.

Formula:
IF(NOT(ISBLANK(Project_Task_Assignment__c)),Project_Task_Assignment__r.Hours__c,IF(NOT(ISBLANK(Assignment__c)),Assignment__r.Scheduled_Hours__c,null))
Number(18,2)
Project_Task_Assignment__c Project Task Assignment Fall 2021 Lookup to the related project task assignment for the experience.

Looks up to: Project_Task_Assignment__c
Lookup
Resource__c Resource Fall 2021 Lookup to the related resource.

Looks up to: Contact

Lookup
Start_Date__c Start Date Fall 2021 Date the experience started.

Formula:
IF(NOT(ISBLANK(Project_Task_Assignment__c)),Project_Task_Assignment__r.Project_Task_Start_Date__c,IF(NOT(ISBLANK(Assignment__c)),Assignment__r.Start_Date__c,null))
Date


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