PSA Data Dictionary

Project_Task_Assignment__c

Label: Project Task Assignment

Project task assignments are distinct from standard assignments. They associate a resource or resource role (for example, Project Manager) with a project task. Project tasks have a master-detail relationship with project task assignments.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Action_Sync_With_External_Calendar__c Action: Sync with External Calendar Winter 2023 Checkbox to sync PTA with external calendar.

Checkbox false
Allocation_Hours__c Allocation Hours Fall 2019 The number of hours allocated to a resource for a project task assignment.

Number(7,2)
Allocation_Percentage__c Allocation Percentage Spring 2019 The percentage resource and/or role allocation of the task's estimated hours.

Percent(5,2)
Assignment__c Assignment Pre-Spring 2018 Looks up to: Assignment__c
Lookup
End_Date__c End Date Pre-Spring 2018 Formula:
IF( NOT(ISBLANK(Assignment__c)), Assignment__r.End_Date__c, IF(NOT(ISBLANK(Resource_Request__r.Preferred_Schedule__c)), Resource_Request__r.Preferred_Schedule__r.End_Date__c, Resource_Request__r.End_Date__c ) )
Date
External_Resource__c External Resource Pre-Spring 2018 Text(255)
Hours__c Hours Pre-Spring 2018 The number of scheduled hours.

Formula:
IF( AND(NOT(ISBLANK(Assignment__c)), NOT(ISBLANK(Assignment__r.Scheduled_Hours__c)) ), Assignment__r.Scheduled_Hours__c, IF( NOT(ISBLANK(Resource_Request__c)), IF( AND( NOT(ISBLANK(Resource_Request__r.Preferred_Schedule__c)), NOT(ISBLANK( Resource_Request__r.Preferred_Schedule__r.Scheduled_Hours__c)) ), Resource_Request__r.Preferred_Schedule__r.Scheduled_Hours__c, IF( NOT(ISBLANK(Resource_Request__r.SOW_Hours__c)), Resource_Request__r.SOW_Hours__c, 0) ), 0) )
Number(18,2)
Project_ID__c Project ID Pre-Spring 2018 Formula:
Project_Task__r.Project__c
Text
Project_Task_End_Date__c Project Task End Date Pre-Spring 2018 Formula:
Project_Task__r.End_Date__c
Date
Project_Task_Start_Date__c Project Task Start Date Pre-Spring 2018 Formula:
Project_Task__r.Start_Date__c
Date
Project_Task__c Project Task Pre-Spring 2018 Project Task to which the Resource is being Associated

Looks up to: Project_Task__c
MasterDetail
Project__c Project Pre-Spring 2018 Formula:
IF(OR(ISNULL(Project_Task__c),(Project_Task__c=''),ISNULL(Project_Task__r.Project__c),(Project_Task__r.Project__c='')),'',HYPERLINK('/'&Project_Task__r.Project__c,IF(OR(ISNULL(Project_Task__r.Project__r.Name),(Project_Task__r.Project__r.Name='')),Project_Task__r.Project__c,Project_Task__r.Project__r.Name)))
Text
Resource_Request__c Resource Request Pre-Spring 2018 Looks up to: Resource_Request__c
Lookup
Resource_Role__c Resource Role Pre-Spring 2018 Picklist:
Architect
Business Analyst
Client Manager
Consultant
Contractor
Executive
Project Manager
Senior Consultant
Trainer
Resource__c Resource Pre-Spring 2018 Resource being associated with the Project Task

Looks up to: Contact

Lookup
Schedule_Type__c Schedule Type Pre-Spring 2018 Formula:
IF( NOT(ISBLANK(Assignment__c)), $Label.pta_schedule_type_assignment, IF(NOT(ISBLANK(Resource_Request__c)), IF(NOT(ISBLANK(Resource_Request__r.Preferred_Schedule__c)), $Label.pta_schedule_type_rr_schedule, $Label.pta_schedule_type_rr_dates ), $Label.pta_schedule_type_rr_none ) )
Text
Start_Date__c Start Date Pre-Spring 2018 Formula:
IF( NOT(ISBLANK(Assignment__c)), Assignment__r.Start_Date__c, IF(NOT(ISBLANK(Resource_Request__r.Preferred_Schedule__c)), Resource_Request__r.Preferred_Schedule__r.Start_Date__c, Resource_Request__r.Start_Date__c ) )
Date


© Copyright 2009–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.