Technical References

1-56
Cisco Prime Service Catalog 10.0 Reporting Guide
OL-31037-01
Chapter 1 Advanced Reporting Data Mart
Data Mart Administration
DM_FDR_ETLSERVICEMETADATA
The DM_FDR_ETLSERVICEMETADATA table holds the information about the tables that are used to
store information about each reportable service.
DM_FDR_SERVICEMETADATA
The DM_FDR_SERVICEMETADATA table holds the Metadata information about which service
attributes are populated in which columns of the service tables and, also the usage name of each of the
columns.
LastProcessedTime Datetime Date and time when the ETL to load the custom
Reports Package was most recently run.
LastServiceTableSequence Integer Sequence number of the last service table used
in the data mart.
LastSvcRequisitionID Integer Last requisition ID of the service data.
ServiceTablePattern Varchar(50) Pattern for the name of the service tables; by
default DM_FDR_SERVICE_; specified via
Advanced Reporting installation.
DictionaryTotalDateField Integer The total number of date fields used for
dictionary and service tables.
DictionaryTotalNumericField Integer The total number of numeric fields used for
dictionary and service tables.
DictionaryTotalVarcharField Integer The total number of character fields used for
dictionary and service tables.
ServiceTotalDateField Integer The total number of date fields used for service
tables.
ServiceTotalNumericField Integer The total number of numeric fields used for
service tables.
ServiceTotalVarcharField Integer The total number of character fields used for
service tables.
Column Name Data Type Description
Column Name Data Type Description
LastServiceDateField Integer Last datetime type field used in the service table
LastServiceNumericField Integer Last numeric type field used in the service table
LastServiceVarcharField Integer Last character type field used in the service table
ServiceID Integer Unique Identifier assigned to the service
ServiceTableName Varchar Name of the data mart database table where the
service data is stored
Column Name Data Type Description
DestinationColumnName Varchar(100) Column name of the table where this attribute is
stored