Technical References

1-30
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
RequisitionTaskFact
The RequisitionTaskFact provides information about requisition-level authorization and review tasks
performed to complete a service requisition. This query subject is provided for upward compatibility
with legacy systems only; the All Tasks, Service Delivery Tasks, or Authorizations Tasks query subject
should be used, as appropriate.
ServiceTaskFact
The ServiceTaskFact provides information about delivery tasks, ad-hoc tasks, service group
authorizations and service group reviews performed to complete a service requisition. This query subject
is provided for upward compatibility with legacy systems only; the All Tasks, Service Delivery Tasks,
or Authorizations Tasks query subject should be used, as appropriate.
TaskEffortEntryFact
The TaskEffortEntryFact provides information about effort expended in the performance of a task.
Planned Effort (Hours) Planned effort specified for the task in the service
definition
Planned Duration (Hours) Configured duration for the task to be performed, in hours,
as specified by the service designer
Actual Duration (Hours) Actual duration taken for the task as performed, in hours,
as calculated by the system, based on the customer's
calendar
Performer’s Actual Duration (Hours) Actual duration taken for the task as performed, in hours,
as calculated by the system, based on the performer's
calendar
Completed Task Count Indication of whether a task has been completed; 1 if the
task has been completed, 0 if it has not
Completed On-Time Task Count Indication of whether a task was completed on time; 1 if
the task was completed before its scheduled completion
date, 0 if it was not
Completed On-Time Percentage Percentage of tasks completed on time; for each individual
completed task, this is either 100% or 0%; the computation
applies as tasks are summarized
Late Open Task Count Number of tasks still open that are late
Standard Compliance Percentage Percentage of tasks that were completed within their
specified duration
Query Item Description
Query Item Description
EffortEntryID Unique ID for the effort entry
ServiceTaskID Unique ID identifying the task on which this effort was expended
EnteredDate Date the effort was logged
Description Description of the effort