Professional Services Automation Object Model Diagrams
G Practice__c Practice +Practice Name+NameName -Action: Update Current Time Period-Action_Update_Current_Time_Period__cAction_Update_Current_Time_Period__c -Actuals: Last Update Date-Actuals_Last_Update_Date__cActuals_Last_Update_Date__c -Actuals: Last Updated By-Actuals_Last_Updated_By__cActuals_Last_Updated_By__c -Backlog: Last Update Date-Backlog_Last_Update_Date__cBacklog_Last_Update_Date__c -Backlog: Last Updated By-Backlog_Last_Updated_By__cBacklog_Last_Updated_By__c -Billable Hours (External)-Billable_External_Hours__cBillable_External_Hours__c -Billable Hours (Internal)-Billable_Internal_Hours__cBillable_Internal_Hours__c -Billed-Billed__cBilled__c -Billings-Billings__cBillings__c -Bookings-Bookings__cBookings__c -Credited Hours-Credited_Non_Billable_Internal_Hours__cCredited_Non_Billable_Internal_Hours__c -Current Time Period-Current_Time_Period__cCurrent_Time_Period__c -Current Time Period End Date-Current_Time_Period_End_Date__cCurrent_Time_Period_End_Date__c -Default Work Calendar-Default_Work_Calendar__cDefault_Work_Calendar__c -Exclude from Utilization-Exclude_From_Utilization__cExclude_From_Utilization__c -Excluded Hours-Excluded_Hours__cExcluded_Hours__c -Expense Budget-Expense_Budget__cExpense_Budget__c -Expense Costs-Expense_Costs__cExpense_Costs__c -External Costs-External_Costs__cExternal_Costs__c -Global Practice-Global_Practice__cGlobal_Practice__c -Hierarchy Depth-Hierarchy_Depth__cHierarchy_Depth__c -Hist Sch Utilization Billable Hours-Hist_Sch_Utilization_Billable_Hours__cHist_Sch_Utilization_Billable_Hours__c -Hist Sch Utilization Credited Hours-Hist_Sch_Utilization_Credited_Hours__cHist_Sch_Utilization_Credited_Hours__c -Hist Sch Utilization Excluded Hours-Hist_Sch_Utilization_Excluded_Hours__cHist_Sch_Utilization_Excluded_Hours__c -Hist Sch Utilization Held Hours-Hist_Sch_Utilization_Held_Hours__cHist_Sch_Utilization_Held_Hours__c -Hist Sch Utilization Non Billable Hrs-Hist_Sch_Utilization_Non_Billable_Hrs__cHist_Sch_Utilization_Non_Billable_Hrs__c -Historical Utilization-Historical_Utilization__cHistorical_Utilization__c -Historical Utilization Billable Hours-Historical_Utilization_Billable_Hours__cHistorical_Utilization_Billable_Hours__c -Historical Utilization Calendar Hours-Historical_Utilization_Calendar_Hours__cHistorical_Utilization_Calendar_Hours__c -Historical Utilization Credited Hours-Historical_Utilization_Credited_Hours__cHistorical_Utilization_Credited_Hours__c -Historical Utilization Excluded Hours-Historical_Utilization_Excluded_Hours__cHistorical_Utilization_Excluded_Hours__c -Historical Utilization Non Billable Hrs-Historical_Utilization_Non_Billable_Hrs__cHistorical_Utilization_Non_Billable_Hrs__c #Historical Utilization Target#Historical_Utilization_Target__cHistorical_Utilization_Target__c #Historical Utilization Target Attainment#Historical_Utilization_Target_Attainment__cHistorical_Utilization_Target_Attainment__c -Historical Utilization Target Hours-Historical_Utilization_Target_Hours__cHistorical_Utilization_Target_Hours__c -Inactive Project Backlog-Inactive_Project_Backlog__cInactive_Project_Backlog__c -Include In Forecasting-Include_In_Forecasting__cInclude_In_Forecasting__c -Internal Budget-Internal_Budget__cInternal_Budget__c -Internal Costs-Internal_Costs__cInternal_Costs__c -Invoiced-Invoiced__cInvoiced__c #Margin#Margin__cMargin__c -Non-Billable Hours (External)-Non_Billable_External_Hours__cNon_Billable_External_Hours__c -Non-Billable Hours (Internal)-Non_Billable_Internal_Hours__cNon_Billable_Internal_Hours__c -Other Costs-Other_Costs__cOther_Costs__c -Parent Practice-Parent_Practice__cParent_Practice__c -Pass-Through Billings-Pass_Through_Billings__cPass_Through_Billings__c -Plan: Last Update Date-Plan_Last_Update_Date__cPlan_Last_Update_Date__c -Plan: Last Updated By-Plan_Last_Updated_By__cPlan_Last_Updated_By__c -Planned Billings-Planned_Billings__cPlanned_Billings__c -Planned Bookings-Planned_Bookings__cPlanned_Bookings__c -Planned External Costs-Planned_External_Costs__cPlanned_External_Costs__c -Planned Internal Costs-Planned_Internal_Costs__cPlanned_Internal_Costs__c #Planned Margin#Planned_Margin__cPlanned_Margin__c -Planned Revenue-Planned_Revenue__cPlanned_Revenue__c -Planned Utilization-Planned_Utilization__cPlanned_Utilization__c -Practice ID Chain-Practice_ID_Chain__cPractice_ID_Chain__c -Practice Name Chain-Practice_Name_Chain__cPractice_Name_Chain__c -Practice Owner-Practice_Head__cPractice_Head__c -Pre-Billed-Pre_Billed__cPre_Billed__c -Revenue-Revenue__cRevenue__c -Reversed Practice ID Chain-Reversed_ID_Chain__cReversed_ID_Chain__c -Scheduled Backlog Calculated Date-Scheduled_Backlog_Calculated_Date__cScheduled_Backlog_Calculated_Date__c -Scheduled Backlog End Date-Scheduled_Backlog_End_Date__cScheduled_Backlog_End_Date__c -Scheduled Milestone-Scheduled_Milestone__cScheduled_Milestone__c -Scheduled Time-Scheduled_Time__cScheduled_Time__c -Scheduled Utilization-Scheduled_Utilization__cScheduled_Utilization__c -Scheduled Utilization Billable Hours-Scheduled_Utilization_Billable_Hours__cScheduled_Utilization_Billable_Hours__c -Scheduled Utilization Calendar Hours-Scheduled_Utilization_Calendar_Hours__cScheduled_Utilization_Calendar_Hours__c -Scheduled Utilization Credited Hours-Scheduled_Utilization_Credited_Hours__cScheduled_Utilization_Credited_Hours__c -Scheduled Utilization Excluded Hours-Scheduled_Utilization_Excluded_Hours__cScheduled_Utilization_Excluded_Hours__c -Scheduled Utilization Held Hours-Scheduled_Utilization_Held_Hours__cScheduled_Utilization_Held_Hours__c -Scheduled Utilization Non Billable Hrs-Scheduled_Utilization_Non_Billable_Hrs__cScheduled_Utilization_Non_Billable_Hrs__c #Scheduled Utilization Target#Scheduled_Utilization_Target__cScheduled_Utilization_Target__c #Scheduled Utilization Target Attainment#Scheduled_Utilization_Target_Attainment__cScheduled_Utilization_Target_Attainment__c -Scheduled Utilization Target Hours-Scheduled_Utilization_Target_Hours__cScheduled_Utilization_Target_Hours__c #Total Costs#Total_Costs__cTotal_Costs__c -Total Time Period Hours-Total_Time_Period_Hours__cTotal_Time_Period_Hours__c -Unscheduled Backlog-Unscheduled_Backlog__cUnscheduled_Backlog__c -Utilization-Utilization__cUtilization__c -Utilization-Total_Utilization__cTotal_Utilization__c -Utilization Calculation Date-Utilization_Calculation_Date__cUtilization_Calculation_Date__c -Utilization Period End Date-Utilization_Period_End_Date__cUtilization_Period_End_Date__c -Utilization Period Start Date-Utilization_Period_Start_Date__cUtilization_Period_Start_Date__c #Utilization Target#Utilization_Target__cUtilization_Target__c #Utilization Target Attainment#Utilization_Target_Attainment__cUtilization_Target_Attainment__c -Utilization Target Hours-Utilization_Target_Hours__cUtilization_Target_Hours__c -Utilization: Elapsed Hours-Utilization_Elapsed_Hours__cUtilization_Elapsed_Hours__c -Utilization: Last Calculation Date-Utilization_Last_Calculation_Date__cUtilization_Last_Calculation_Date__c -Utilization: Last Update Date-Utilization_Last_Update_Date__cUtilization_Last_Update_Date__c -Utilization: Last Updated By-Utilization_Last_Updated_By__cUtilization_Last_Updated_By__c -Utilization: Over Full Time Period-Utilization_Over_Full_Time_Period__cUtilization_Over_Full_Time_Period__c + View_Transactions() + View_Hierarchy() + Calculate_Backlog() + Calculate_Forecast() + Calculate_Utilization() + Calculate_Missing_Timecard() + Calculate_Time_Variance() Time_Period__c Time Period Practice__c->Time_Period__c Practice_Actuals__c Practice Actuals +Practice Actuals For+NameName -Billable Hours (External)-Billable_External_Hours__cBillable_External_Hours__c -Billable Hours (Internal)-Billable_Internal_Hours__cBillable_Internal_Hours__c -Billed-Billed__cBilled__c -Billings-Billings__cBillings__c -Bookings-Bookings__cBookings__c -Credited Hours-Credited_Non_Billable_Internal_Hours__cCredited_Non_Billable_Internal_Hours__c #End Date#End_Date__cEnd_Date__c -Excluded Hours-Excluded_Hours__cExcluded_Hours__c -Expense Budget-Expense_Budget__cExpense_Budget__c -Expense Costs-Expense_Costs__cExpense_Costs__c -External Costs-External_Costs__cExternal_Costs__c #Has Difference in Verification#Has_Difference_In_Verification__cHas_Difference_In_Verification__c -Individual Billable Hours (External)-NRV_Billable_External_Hours__cNRV_Billable_External_Hours__c -Individual Billable Hours (Internal)-NRV_Billable_Internal_Hours__cNRV_Billable_Internal_Hours__c -Individual Billed-NRV_Billed__cNRV_Billed__c -Individual Billings-NRV_Billings__cNRV_Billings__c -Individual Bookings-NRV_Bookings__cNRV_Bookings__c -Individual Credited Hours-NRV_Credited_Non_Billable_Internal_Hours__cNRV_Credited_Non_Billable_Internal_Hours__c #Individual Difference in Verification#NRV_Has_Difference_In_Verification__cNRV_Has_Difference_In_Verification__c -Individual Excluded Hours-NRV_Excluded_Hours__cNRV_Excluded_Hours__c -Individual Expense Budget-NRV_Expense_Budget__cNRV_Expense_Budget__c -Individual Expense Costs-NRV_Expense_Costs__cNRV_Expense_Costs__c -Individual External Costs-NRV_External_Costs__cNRV_External_Costs__c -Individual Internal Budget-NRV_Internal_Budget__cNRV_Internal_Budget__c -Individual Internal Costs-NRV_Internal_Costs__cNRV_Internal_Costs__c -Individual Invoiced-NRV_Invoiced__cNRV_Invoiced__c #Individual Margin#NRV_Margin__cNRV_Margin__c -Individual Non-Billable Hours (External)-NRV_Non_Billable_External_Hours__cNRV_Non_Billable_External_Hours__c -Individual Non-Billable Hours (Internal)-NRV_Non_Billable_Internal_Hours__cNRV_Non_Billable_Internal_Hours__c -Individual Other Costs-NRV_Other_Costs__cNRV_Other_Costs__c -Individual Pass-Through Billings-NRV_Pass_Through_Billings__cNRV_Pass_Through_Billings__c -Individual Pre-Billed-NRV_Pre_Billed__cNRV_Pre_Billed__c -Individual Revenue-NRV_Revenue__cNRV_Revenue__c #Individual Total Costs#NRV_Total_Costs__cNRV_Total_Costs__c -Internal Budget-Internal_Budget__cInternal_Budget__c -Internal Costs-Internal_Costs__cInternal_Costs__c -Invoiced-Invoiced__cInvoiced__c -Is Verification-Is_Verification__cIs_Verification__c #Margin#Margin__cMargin__c -Non-Billable Hours (External)-Non_Billable_External_Hours__cNon_Billable_External_Hours__c -Non-Billable Hours (Internal)-Non_Billable_Internal_Hours__cNon_Billable_Internal_Hours__c -Other Costs-Other_Costs__cOther_Costs__c -Pass-Through Billings-Pass_Through_Billings__cPass_Through_Billings__c -Practice-Practice__cPractice__c #Practice Owner#Practice_Head__cPractice_Head__c -Pre-Billed-Pre_Billed__cPre_Billed__c -Revenue-Revenue__cRevenue__c -Scheduled Backlog Calculated Date-Scheduled_Backlog_Calculated_Date__cScheduled_Backlog_Calculated_Date__c -Scheduled Milestone-Scheduled_Milestone__cScheduled_Milestone__c -Scheduled Time-Scheduled_Time__cScheduled_Time__c #Start Date#Start_Date__cStart_Date__c -Time Period-Time_Period__cTime_Period__c #Time Period Type#Time_Period_Type__cTime_Period_Type__c #Total Costs#Total_Costs__cTotal_Costs__c -Unique Name-Unique_Name__cUnique_Name__c -Unscheduled Backlog-Unscheduled_Backlog__cUnscheduled_Backlog__c -Verified By-Verified_By__cVerified_By__c Practice_Actuals__c->Practice__c Practice_Actuals__c->Time_Period__c Practice_Plan__c Practice Plan +Practice Plan Number+NameName #End Date#End_Date__cEnd_Date__c -Planned Billings-Planned_Billings__cPlanned_Billings__c -Planned Bookings-Planned_Bookings__cPlanned_Bookings__c -Planned External Costs-Planned_External_Costs__cPlanned_External_Costs__c -Planned Internal Costs-Planned_Internal_Costs__cPlanned_Internal_Costs__c #Planned Margin#Planned_Margin__cPlanned_Margin__c -Planned Revenue-Planned_Revenue__cPlanned_Revenue__c -Planned Utilization-Planned_Utilization__cPlanned_Utilization__c -Practice-Practice__cPractice__c #Practice Owner#Practice_Owner__cPractice_Owner__c #Practice Plan For#Practice_Plan_For__cPractice_Plan_For__c #Start Date#Start_Date__cStart_Date__c -Time Period-Time_Period__cTime_Period__c #Time Period Type#Time_Period_Type__cTime_Period_Type__c -Unique Name-Unique_Name__cUnique_Name__c Practice_Plan__c->Practice__c Practice_Plan__c->Time_Period__c
© Copyright 2009–2025 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.