Professional Services Automation Data Dictionary

Assignment_Daily_Note__c

Label: Assignment Daily Note

Stores daily notes for an assignment, usually entered by an assigned resource and viewed by users with staffing or project management roles.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Assignment__c Assignment Pre-Spring 2018 The Assignment to which the Daily Note belongs (master-detail).

Looks up to: Assignment__c
MasterDetail
Date__c Date Pre-Spring 2018 Date for which the Daily Note applies. Only one Daily Note per day per Assignment

Date Today()
LastModifiedByUsername__c LastModifiedByUsername Pre-Spring 2018 Formula:
LastModifiedBy.FirstName & ' ' & LastModifiedBy.LastName
Text
Note__c Note Pre-Spring 2018 Contents of the Daily Note (max 255 chars).

TextArea
Project__c Project Pre-Spring 2018 Formula hyperlink to Assignment Project associated with Daily Note

Formula:
IF(OR(ISNULL(Assignment__c),(Assignment__c=''),ISNULL(Assignment__r.Project__c),(Assignment__r.Project__c='')),null,HYPERLINK('/'&Assignment__r.Project__c,Assignment__r.Project__r.Name))
Text
Resource__c Resource Pre-Spring 2018 Formula hyperlink to Assigned Resource associated with Daily Note

Formula:
IF(OR(ISNULL(Assignment__c),(Assignment__c=''),ISNULL(Assignment__r.Resource__c),(Assignment__r.Resource__c='')),null,HYPERLINK('/'&Assignment__r.Resource__c,Assignment__r.Resource__r.FirstName&' '&Assignment__r.Resource__r.LastName))
Text


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