Technical References

1-59
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
Data Mart Database Objects
The following table lists the database tables and views used for the Service Catalog data mart and
exposed to users via the Custom Reports package. The tables/views are mapped directly to
corresponding query subjects.
Data Mart Table/View Primary Key Query Subject/Description
DM_DEFSERVICE ServiceID Service information (which includes
Service Group and Service Team
information)
DM_DEFDICTIONARY DictionaryID Dictionary information
DM_PERSON PersonID Person information
DM_DATE DateID Calendar information
VIEW_CUSTOMER CustomerID Customer information
VIEW_REQUESTOR RequestorID Requestor (initiator) information
VIEW_PERFORMER PerformerID Information about the person who
performs a task
VIEW_QUEUE QueueID The queue to which a task is assigned
VIEW_CALENDARCLOSED
DATE
ClosedDateID The date a task or requisition was
closed and the accompanying date
hierarchy
VIEW_CALENDARDUEDATE DueDateID The date a task or requisition was due
and the accompanying date hierarchy
VIEW_CALENDAR
SCHEDULEDDATE
ScheduledDateID The date a task or requisition was
scheduled to start and the
accompanying date hierarchy
VIEW_CALENDARSTARTEDDATE StartedDateID The date a task or requisition was
started and the accompanying date
hierarchy
DM_REQUISITIONENTRY
FACT
RequisitionEntryID Individual requisition entries (services)
ordered
DM_SERVICETASKFACT ServiceTaskID Tasks performed at the service
(requisition entry) level, including
delivery tasks, ad-hoc tasks and service
group authorizations and reviews
DM_REQUISITONTASKFACT RequisitionTaskID Tasks performed at the requisition level,
including financial authorizations and
organizational unit authorizations and
reviews
DM_TASKEFFORTENTRY
FACT
EffortEntryID Effort expended in the performance of a
delivery task
DM_FDR_DICTIONARY_n
(n=1, 2, 3, ...)
RequisitionEntryID Corresponding dictionary attribute
information
DM_FDR_SERVICE_n
(n=1, 2, 3, ...)
RequsitionEntryID Corresponding service form data
attribute information