Professional Services Automation Data Dictionary

Time_Variance_Detail__c

Label: Time Variance

Contains time variance calculation details for a single region, practice, or group. PSA calculates time variance as a percentage based on the number of approved working hours divided into the number of recorded working hours. You can reflect this as a percentage or as strict hours. Time variance calculations are a lookup to the Time Variance Calculation object.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Allowed_Variance_Over__c Allowed Variance Over Pre-Spring 2018 Number(18,2)
Allowed_Variance_Under__c Allowed Variance Under Pre-Spring 2018 Number(18,2)
Billable_Hours__c Billable Hours Pre-Spring 2018 The number of submitted hours that are billable.

Number(18,2)
Credited_Hours__c Credited Hours Pre-Spring 2018 The number of submitted hours that are credited.

Number(18,2)
End_Date__c End Date Pre-Spring 2018 Date
Exclude_Billable_Hours__c Exclude Billable Hours Pre-Spring 2018 Specifies that billable hours were excluded when this Time Variance was calculated.

Checkbox false
Exclude_Credited_Hours__c Exclude Credited Hours Pre-Spring 2018 Specifies that credited hours were excluded when this Time Variance was calculated.

Checkbox false
Exclude_Excluded_Hours__c Exclude Excluded Hours Pre-Spring 2018 Specifies that excluded hours were excluded when this Time Variance was calculated.

Checkbox false
Excluded_Hours__c Excluded Hours Pre-Spring 2018 The number of submitted hours that are excluded.

Number(18,2)
Group__c Group Pre-Spring 2018 Looks up to: Grp__c
Lookup
Nonbillable_Hours__c Non-billable Hours Pre-Spring 2018 The number of submitted hours that are non-billable.

Number(18,2)
Practice__c Practice Pre-Spring 2018 Looks up to: Practice__c
Lookup
Region__c Region Pre-Spring 2018 Looks up to: Region__c
Lookup
Resource__c Resource Pre-Spring 2018 Looks up to: Contact

Lookup
Start_Date__c Start Date Pre-Spring 2018 Date
Time_Variance_Calculation__c Time Variance Calculation Pre-Spring 2018 Looks up to: Time_Variance_Calculation__c
Lookup
Total_Hours__c Total Hours Submitted Pre-Spring 2018 Number(18,2)
Variance__c Variance Pre-Spring 2018 Number(18,2)
Work_Calendar_Hours__c Work Calendar Hours Pre-Spring 2018 The number of hours from the Resource's Work Calendar.

Number(18,2)


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