Professional Services Automation Data Dictionary

Changes to the Schema in Summer 2023

The following changes have been introduced in the Summer 2023 release.

New Objects Added

Work_Event__c
Work_Event_Invite__c

Deprecated Objects

No changes have been made in this release.

Updates to Objects

New Fields Added

Object NameField NameType
Assignment_Settings__c Retain_Schedule_On_Hold__c Checkbox
Group_Actuals__c NRV_Billable_External_Hours__c Number(18,2)
NRV_Billable_Internal_Hours__c Number(18,2)
NRV_Billed__c Currency(18,2)
NRV_Billings__c Currency(18,2)
NRV_Bookings__c Currency(18,2)
NRV_Credited_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Excluded_Hours__c Number(18,2)
NRV_Expense_Budget__c Currency(18,2)
NRV_Expense_Costs__c Currency(18,2)
NRV_External_Costs__c Currency(18,2)
NRV_Has_Difference_In_Verification__c Checkbox
NRV_Internal_Budget__c Currency(18,2)
NRV_Internal_Costs__c Currency(18,2)
NRV_Invoiced__c Currency(18,2)
NRV_Margin__c Currency(18,2)
NRV_Non_Billable_External_Hours__c Number(18,2)
NRV_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Other_Costs__c Currency(18,2)
NRV_Pass_Through_Billings__c Currency(18,2)
NRV_Pre_Billed__c Currency(18,2)
NRV_Revenue__c Currency(18,2)
NRV_Total_Costs__c Currency(18,2)
Practice_Actuals__c NRV_Billable_External_Hours__c Number(18,2)
NRV_Billable_Internal_Hours__c Number(18,2)
NRV_Billed__c Currency(18,2)
NRV_Billings__c Currency(18,2)
NRV_Bookings__c Currency(18,2)
NRV_Credited_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Excluded_Hours__c Number(18,2)
NRV_Expense_Budget__c Currency(18,2)
NRV_Expense_Costs__c Currency(18,2)
NRV_External_Costs__c Currency(18,2)
NRV_Has_Difference_In_Verification__c Checkbox
NRV_Internal_Budget__c Currency(18,2)
NRV_Internal_Costs__c Currency(18,2)
NRV_Invoiced__c Currency(18,2)
NRV_Margin__c Currency(18,2)
NRV_Non_Billable_External_Hours__c Number(18,2)
NRV_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Other_Costs__c Currency(18,2)
NRV_Pass_Through_Billings__c Currency(18,2)
NRV_Pre_Billed__c Currency(18,2)
NRV_Revenue__c Currency(18,2)
NRV_Total_Costs__c Currency(18,2)
Project_Actuals_Converted__c NRV_Billable_External_Hours__c Number(18,2)
NRV_Billable_Internal_Hours__c Number(18,2)
NRV_Billed__c Currency(18,2)
NRV_Billings__c Currency(18,2)
NRV_Bookings__c Currency(18,2)
NRV_Credited_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Excluded_Hours__c Number(18,2)
NRV_Expense_Budget__c Currency(18,2)
NRV_Expense_Costs__c Currency(18,2)
NRV_External_Costs__c Currency(18,2)
NRV_Has_Difference_In_Verification__c Checkbox
NRV_Internal_Budget__c Currency(18,2)
NRV_Internal_Costs__c Currency(18,2)
NRV_Invoiced__c Currency(18,2)
NRV_Margin__c Currency(18,2)
NRV_Non_Billable_External_Hours__c Number(18,2)
NRV_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Other_Costs__c Currency(18,2)
NRV_Pass_Through_Billings__c Currency(18,2)
NRV_Pre_Billed__c Currency(18,2)
NRV_Revenue__c Currency(18,2)
NRV_Total_Costs__c Currency(18,2)
Project_Actuals__c NRV_Billable_External_Hours__c Number(18,2)
NRV_Billable_Internal_Hours__c Number(18,2)
NRV_Billed__c Currency(18,2)
NRV_Billings__c Currency(18,2)
NRV_Bookings__c Currency(18,2)
NRV_Credited_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Excluded_Hours__c Number(18,2)
NRV_Expense_Budget__c Currency(18,2)
NRV_Expense_Costs__c Currency(18,2)
NRV_External_Costs__c Currency(18,2)
NRV_Has_Difference_In_Verification__c Checkbox
NRV_Internal_Budget__c Currency(18,2)
NRV_Internal_Costs__c Currency(18,2)
NRV_Invoiced__c Currency(18,2)
NRV_Margin__c Currency(18,2)
NRV_Non_Billable_External_Hours__c Number(18,2)
NRV_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Other_Costs__c Currency(18,2)
NRV_Pass_Through_Billings__c Currency(18,2)
NRV_Pre_Billed__c Currency(18,2)
NRV_Revenue__c Currency(18,2)
NRV_Total_Costs__c Currency(18,2)
Regional_Actuals__c NRV_Billable_External_Hours__c Number(18,2)
NRV_Billable_Internal_Hours__c Number(18,2)
NRV_Billed__c Currency(18,2)
NRV_Billings__c Currency(18,2)
NRV_Bookings__c Currency(18,2)
NRV_Credited_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Excluded_Hours__c Number(18,2)
NRV_Expense_Budget__c Currency(18,2)
NRV_Expense_Costs__c Currency(18,2)
NRV_External_Costs__c Currency(18,2)
NRV_Has_Difference_In_Verification__c Checkbox
NRV_Internal_Budget__c Currency(18,2)
NRV_Internal_Costs__c Currency(18,2)
NRV_Invoiced__c Currency(18,2)
NRV_Margin__c Currency(18,2)
NRV_Non_Billable_External_Hours__c Number(18,2)
NRV_Non_Billable_Internal_Hours__c Number(18,2)
NRV_Other_Costs__c Currency(18,2)
NRV_Pass_Through_Billings__c Currency(18,2)
NRV_Pre_Billed__c Currency(18,2)
NRV_Revenue__c Currency(18,2)
NRV_Total_Costs__c Currency(18,2)
Revenue_Forecast_Setup__c Assignment_Bill_Rate_Field__c Text(255)
Assignment_Percent_Comp_Weighting_Field__c Text(255)
Exclude_From_Forecast_Assignment_Field__c Text(255)
Exclude_From_Forecast_Resource_Req_Field__c Text(255)
Milestone_Total_Revenue_Field__c Text(255)
Project_Total_Revenue_Field__c Text(255)
Res_Req_Percent_Comp_Weighting_Field__c Text(255)
Resource_Request_Bill_Rate_Field__c Text(255)
Use_Weighted_Percent_Comp_Calc__c Checkbox
Revenue_Forecast_Version_Detail__c Actuals_Total__c Currency(18,2)
Corp_Actuals_Total__c Currency(18,2)
Corp_Scheduled_Total__c Currency(18,2)
Scheduled_Total__c Currency(18,2)
Revenue_Forecast_Version__c Locked_Datetime__c DateTime
Revenue_Forecast__c Actual_Weighted_Effort__c Number(18,2)
Scheduled_Weighted_Effort__c Number(18,2)
Utilization_Result__c Resource_Change__c Lookup
Utilization_Run_Batch__c End_Date__c Date
Scope__c LongTextArea(32768)
Stage__c Picklist:
Deleting Utilization Results
Start_Date__c Date
Utilization_Run__c Subtract_Holidays_From_Calendar_Hours__c Checkbox
Timecard_Statuses__c Text(255)
Utilization_Setup__c Subtract_Holidays_From_Calendar_Hours__c Checkbox
Timecard_Statuses__c Text(255)
Utilization__c Use_Utilization_Calculation__c Checkbox

Deprecated Fields

No changes have been made in this release.


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