Technical References

1-28
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Advanced Reporting Module
Data Mart Facts
The query subjects in the Facts folder provide information about the tasks and service requests logged
via the application service catalog.
ServiceRequestFact (Requisitions)
The ServiceRequestFact provides information about services ordered. Folders group metrics for
On-Time and Request Status Counts.
Query Item Description
RequisitionEntryID Unique ID for the service request
RequisitionID Unique ID for the requisition (shopping cart) in which the
service was requested
ServiceID Service ID for the service
Service Bundle ID Service ID of the service bundle
Requestor ID Unique ID for the service requestor (initiator of the service
request)
Customer ID Unique ID for the customer (recipient) of the request
Status Current status of the service request
Quantity Service quantity that was requested
Price Price of the service
Started Date Date the service request was started
Due Date Date the service request is/was due
Closed Date Date the service request was closed
Started DateTime Date and time when the service was requested
Due DateTime Date and time when the service delivery is due
Closed DateTime Date and time when the service request was closed
Default Duration The configured duration required to deliver the service;
specified in hours
ActualDuration The actual duration taken to deliver the service
ServiceOntimeFlag Flag that indicates whether the service request was completed
on time (1) or late (0)
ServiceStandardComplianceFlag Flag that indicates standard compliance for the service request
Completed On-Time Request Count 1 if the current request was completed on time, zero (0)
otherwise; count is automatically totaled when requests are
grouped on a report
Completed On-Time Percentage Percentage of requests that were completed on time
Standard Compliance Percentage Percentage of requests that were completed in compliance with
their SLAs
Submitted Count Number of requests submitted; since requests are not added to
the data mart until they are submitted, this will always equal the
number of requests