Close Period Task

The ClosePeriodTask compass extract query limits records to close years greater than 2019. To expand the time frame, update the “WHERE” clause of the query.

Measure	Source and/or calculation
Close Period Task Actual Days To Close	Days between actual begin date and actual due date
Close Period Task Count	ClosePeriodTask record count
Close Period Task Detail Expected Effort Variance	Difference between actual level of effort and scheduled level of effort
Close Period Task Expected Begin Days Variance	Days between scheduled begin date and actual begin date
Close Period Task Expected Begin Hours Variance	Hours between scheduled begin time and actual begin time
Close Period Task Expected Days To Close Variance	Days between actual days to close and scheduled days to close
Close Period Task Expected Due Days Variance	Days between scheduled due date and actual due date
Close Period Task Expected Due Hours Variance	Hours between scheduled due time and scheduled begin time
Close Period Task Expected Effort Variance	Difference between actual level of effort and scheduled level of effort
Close Period Task Scheduled Days To Close	Days between scheduled begin date and scheduled due date