How are Allocation, % Allocation, and Availability calculated? These are seen on the Resource, Projects and detail pages. How are these values computed and where are they stored in the database?
Component: Clarity Resource Management
The Resource Availability Rate field and the Allocation fields are computed and stored in a BLOB Curve fields in the database. These fields cannot be queried directly. The data can be found in Time Slice tables.
The Allocation and Availability dates are computed according to the following rules:
start date = max(project start, resource doh, team prAvailStart, assignment actthru).
The 'start date' for the curve is determined by the latest date compared among the following attributes:
The 'finish date' for the curve is determined by the earliest date compared among the following attributes:
The only attribute that can't be null is the project start and project finish dates.
The % Allocation field is calculated as follows:
if (availability > 0) pct = allocation / availability
else pct = 0