FORMATS: TABULAR HIERARCHICAL

Tables
Table
Name Comment Column
ca_asset_source  
ca_company  
ca_contact  
ca_currency_type Holds the different currency information, Eg: United States Dollor, Euro etc
ca_locale Holds the different locales, locales are used for localization Eg: us_en, cn_zh
ca_location  
ca_location_type  
ca_organization  
ca_time_zone Holds the settings for different timezones, Eg: EST, PST
usm_account
The entity which defines the enterprise level account.

Account drives the USM Model and is a key entity in the system.

Account is entity which can be billed. Service Level Contracts can be defined
usm_account_app_user
This table is used by the configuration manager to map users for an application to an USM login account.  It is populated upon startup, and scheduled to repopulate each hour.
usm_account_domain Persists every usm_billing_account with the complete path from it's domain up to the service provider. In other words, this table will store the complete tenant hierarchy for any account that also has a billing profile (i.e.: usm_billing_account record)
usm_acl
Defines the access control list which is used to control access to different  entities like, the dynamic links, reports etc

This is being replaced by eiam security model and will be deprecated in R11
usm_adjustment
All adjustments are recorded here and then applied to the accounts when they are invoiced in a bill run.

When adjustment_type=0 (general adjustment) and value_type=0 (fixed amount):
"	enum_1 = billing cycle (0=onetime, 1=periodic, 2=every invoice)
"	enum_2 = periodic type (0=NA,1=daily,2=weekly,3=monthly,4=quarterly,5=yearly)

When adjustment_type=0 (general adjustment) and value_type=1 (percentage):
"	enum_1 = billing cycle (0=onetime, 2=every invoice)
"	enum_2 = periodic type (0=NA)
"	enum_3 = apply adjustment to (1=offering,2=rate column, 3=all charges, 4=total invoice amount)
"	enum_4 = select offering ( when enum_3=1 or 2, then this is the offering_id )
"	enum_5 = select rate column ( when enum_3=2, then this is the item_id of the column header rate item)
"	enum_6 = percent of ( when enum_3=2, then 0=Quantity, 1=UnitCost, 2=Cost)
usm_analysis
This table represents the analysis repository. 

It contains a summary of the analysis created as xml.
usm_analysis_layout_set  
usm_analyze_export_option Attributes used for export to Portal. Previosly this was also used for ftp export, but this will functionality will not be supported in r11.
usm_analyze_function
Describes the available SLM analyzer functions. 

Supported functions are--

- real
- downtime
- availability
- stateHistory
- sum
usm_analyze_job
Represents an analyze job, that may be scheduled to be executed at regular interval specified in usm_analyze_schedule.

Each job is associated with a scope and a set of report groups.  The scope analyze function will be executed on the metric instances within the associated report groups that matches the scopes metrics and also the analyze function metrics.
usm_analyze_job_option Optional attributes for an analyze job.
usm_analyze_schedule Specifies the job schedule using crontab expressions. The associated analyze job will be run according to the crontab expression.
usm_analyzed_event_data
Contains analyzed event data received from SMA analyze jobs. 
usm_appuser
Defines an application based user which is tied to user based on each application.
usm_asset Defines asset information by the user for the system, the asset can be file, folder etc
usm_attr_reference_plugin
Identifies the metric attribute plugins available.

A plugin is used to retrieve attributes from an external source. This may for example be other SQL tables, SNMP data or some other datasource. 

Attributes to be retrieved by the plugin is identified by a reference_key. 

For example, a plugin may exist that retrieves hostname from the usm_host table. The reference key in that case will typically be the host_id. If the hostname changes, it is not necessary to update the metric instances and metric definitions as long as the host_id is identical.

The plugin architecture may not be utilized in r11.
usm_attr_reference_plugin_attr
Attributes for a metric attribute reference plugin. 

Attributes may for example be the table name where the data is retrieved from, the community string for SNMP lookups etc.
usm_billing_account All the information viewed through the billling profile in the UI is stored in this table. Except for the configuration table, all the other tables have some form of dependency on this table.
usm_billing_group Defines a billing group, billing group is a grouping of billing_accounts to achieve a billing related task, such as bill run, batch invoice printing etc
usm_branding_template Defines a template for the Branding in UI. A branding template contains a list of branding variables which define the whole branding layout
usm_branding_variable Defines a branding variable which is a part of branding template, a bunch of variable constitute a template
usm_bus_queue
Used to queue up metric requests which were unable to be sent over the sla bus.  When a successful transmittion to SLA occurs, the sla bus queue will be flushed.
usm_cache Defines a caching mechanism which can be used to cache the data generated from the left and right hand pane nodes.
usm_cache_listener Defines cache listener objects that relates to cache object.
usm_calendar
Represents a calendar.

A calendar has multiple associated event categories that may contain events. Also, the calendar itself may contain events not related to any event categories.
usm_calendar_category
A link between a calendar and an event category. A event category may be associated with multiple calendars.

This is currently supported in the datamodel, but not in the business logic. So for r11, one event category will always belong to one calendar.
usm_cat_application Defines an application type with version and other configuration.
usm_cat_event_type
The usm_event_type table represents all events supported by SLM r11. An event type identifies a type of measurement that can be performed by a collector. 

The usm_event_type table represents the data in eventinfo.dat in Assure 2.2. In r11, the events may be represented both in eventinfo.dat and in this table.
usm_cat_link_app_metric Many - Many relationship between a schema and a metric category
usm_cat_link_event_metric link table linking an event type to a metric category
usm_cat_metric
A metric category specifies one type of metric data that can be measured and calculated for a set of associated metrics.

Examples of metric categories--

- Application Availability
- Platform availability
- Bandwidth percentage

One metric category may have an associated set of metrics. Which metric is used to measure the category is defined by the associated schema.  

Typically, a metric category like Application Availability will have different metrics defined for different schemas. Each of these metrics will use a collector to collect data and may have different attribute specifications.

The Application Availabilty metric category has 4 types of metrics associated with separate schemas. Each of these metrics uses the same collector, but they have different attribute specifications in that the component attribute values for each metric is different. This is used during resource assignment so that the metric instance has all the associated components.
usm_cat_unittype
Defines the specific unit for a given metric category.
usm_collection_profile Defines a collection profile
usm_collection_profile_attrs Attributes for one metric in a collection profile
usm_collection_profile_metric Represents the collection profile element for one given metric on one given agent host.
usm_collector Defines a service metering data collector.
usm_comp_instance A comp instance represents a component instance running on an installed instance of a schema, i.e It is the instance of a schema component running on a host.
usm_configuration
All the configurable value for Accounting and the catalog are set in this table.
Primary keys are: domain, group_name, name
usm_contact_domain Defines which domain, user is belongs to on what level of authentication.
usm_contact_domain_role Defines which domain and which role, user is belongs to with default domain information.
usm_contact_extension Defines extended contact information for user.
usm_content_pack To Store the list of content packs imported in the system
usm_content_pack_tracking To store the tracking ids of the objects imported in the content pack
usm_contract Defines an SLA contract, One are more contracts are tied to an account, basically contract is the primary entity to do service level assurance
usm_contract_action Defines a action which is based on an SLA contract
usm_cor_data
The usm_cor_data table holds a long-lived cache of elements from the core. It is populated based on the capabilities defined in usm_cor_metric_capability. The data is organized as a folder tree that equals the structure in COR. The lowest level of the tree points out what metrics that can be used to measure that type of COR objects. The actual objects is not stored in the cache, but is pulled from COR when needed.

Fields--
 cor_data_id - a sequential id for the data element.
 slm_server_id - the id of the COR gateway server.
 parent_path - a slash separated path of cor_data_id representing the tree
 level - the level in the tree (0 is a root node).
 label - the label for the data element.
 icon - name of icon to display.
 metric_id -  the metric capable of measuring such objects. If NULL, it is a folder, and therefore has something below it. The metric name of the metric should be sent in the ObjectGet call to the COR
usm_cor_dynamic  
usm_cor_dynamic_attr  
usm_cor_dynamic_report_group  
usm_cor_metric_capability
How a metric is capable to measure different kinds of objects in COR, needs to be represented in the data model. In 3.5 this was accomplished with the vendor and devicetype metric fields. It was limited to specifying a single capability even though keywords such as any and unknown was allowed. In r11 the COR metric capabilities will be put in a separate table--

 usm_cor_metric_capability
 metric_id (FK -> usm_metric.metric_id)
 vendor
 device_type

The set of COR object types that a metric can measure, can be found by listing all metric capabilities (vendor, device type pairs) for the metric id.
The information in usm_cor_metric_capability will be used when data is pulled from COR and temporary stored in the usm_cor_data table. It will be used for resolving capable metrics based on the vendor and device type attributes of the COR elements.
The vendor and device_type fields may contain keywords like any and unknown as previously.
usm_cost_pool
This table holds information related to cost pools.  A pool consists of a collection cost elements related to a single activity.
usm_cp_inclusion This table ties cost elements (rate items) to specific cost pools.
usm_das_analyses  
usm_das_analysis_summaries  
usm_das_analyzer_attributes  
usm_das_analyzer_definitions  
usm_das_analyzer_types  
usm_das_analyzers  
usm_dash
Defines the dashboard information.  For each defined dashboard, user can customise their board by adding portal contents.
Organization can have one or more dashboards which are shown to all the users in that organization.
Users also have their personal dashboards, where they store their personal preferences
usm_data_collector Not used - To be deleted
usm_db
Defines each data source which is used to connect to different data sources.
All components access the database by reading this specific entry. This also has the access permission to the database being accessed.
usm_dca_app_status This table is used by the dcanalyzer when computing the availability status of an application.
usm_dca_comp_status used by the dcanalyzer when computing the availability status of an application.
usm_default_service_hours The default service hours for all report groups. Report groups that are missing service hours for some time interval will use the default service hours defined here.
usm_dependency Persists the dependencies between offerings, and offerings to tenants.
usm_dm_event_data
Contains event data received for a event instance. 
usm_doctmpl_layoutlist Defines the document template layout list for each document template
usm_document_template Defines a template for a document in Document Management.
usm_dst Defines the day light saving rules for different time zones which need it.
usm_event_category
The event category is associated with a calendar and is a grouping of events, one-time or recurring. 

An event category may have an associated set of legal values, event_category_values. 

It may also have an exporter that is used to export events within this category to an external source.
usm_event_category_value
An event category value specifies one legal value for a event category. It is thus possible to specify a set of legal values for events within a event category. The user will then, when creating or updating events within that category be presented with a selection of the allowed values.

Event categories may or may not have associated event category values.
usm_event_data
Contains event data received for a event instance. 
usm_event_instance
An event instance is an instance of an event type. It identifies a running event type for a given  schema, event type, agent host and target_host.

The number if instances in usm_event_instance at a give point in time identifies the number of running data collections/measurements. An event instance is similar to a data collection in slm 3.5. 

One event instance can be used by multiple metric instances to produce the metric result. A event instance has an associated set of attributes, which is identified by the usm_event_instance_value table.

usm_event_instance_value
Contains defined attribute values for a given event instance. The attribute values itself references the usm_metric_attr_value table. 

The attribute values for an event instance is defined when the event instance is created. They are derived from the metric_attr_spec of the selected metric to be instantiated together with the values provided by the user.
usm_event_type
The usm_event_type table represents all events supported by SLM r11. An event type identifies a type of measurement that can be performed by a collector. 

The usm_event_type table represents the data in eventinfo.dat in Assure 2.2. In r11, the events may be represented both in eventinfo.dat and in this table.
usm_event_type_attributes
Contains attributes for a given event type. All attributes for the event type that are not fields in usm_event_type can be represented in this table.

This will typically be data that tells the collector how to collect the event data. For example, this can be logwatcher regular expressions or other information. For some events, these attributes will be kept in collector specific configuration files in r11, such as logwatcher.cfg. This will be moved into the attributes tables in future versions. SLM 3.5 metric types may be represented with event types with event type attributes.
usm_event_type_collector  
usm_exchange_rate Persists the mappings between different exchange rates based on currency. The rate is always stored relative to the SP currency. So to convert from one currency to another currency where neither the SP currency is, you first convert to the first currency then convert to the second currency.
usm_export This is used in exporting purposes within billing.
usm_exporter Defines exporter for a calendar category. This exporter is used to export all calendar events to an external source. The exporter will be called for insert, update,delete of events within the associated event category
usm_featured_offering This table associates a feature offering to a catalog folder (many-to-one). Featured offerings are a new means for the catalog administrator to choose specific offerings in the catalog and feature them at different levels of request web store browsing. They can be shown on the landing page, the browse drill down UIs, and the offering details UI. This is a way to advertise new or popular offerings in the browsing UIs. On the offering details page, featured offerings can serve as alternative or complimentary choices.
usm_fiscal_period The fiscal periods are defined in this table
usm_form_attributes_schema This table defines the attributes for all the component types
usm_form_component_attributes  
usm_form_component_long_attributes
It stores the long attribute value overflow of the form component attributes.  When attribute type value equals to 2 (Long Attribute) of the usm_form_component_attributes, then it will store the long attribute to this table.
usm_form_entities This table contains all the entities that are displayed in the tree and the form
usm_guinode Guinode is the information about dynamic linked data in the USM UI. The UI information defines which data can be retrieved dynamically from the backend engines.
usm_guinode_content This table is the extension to the usm_guinode table, storing the content of the guinode, the content specifies which Content Engine handles the request, which plugin method needs to be invoked etc.
usm_hierachical_data_types to store Service Catalog hierachical data types like resources for an examples, computer, cpu, memory, and hard disk etc
usm_host
Defines the host.
Host is either auto-discovered or added. Various things tie to the host in order to meter the data 
usm_host_element
Defines the element of a host. Interfaces for a network device will be represented here.
Eg-- Serial1, Ethernet1 etc

This table is deprecated. ( We are not using this table from R11.0)*
usm_host_type Defines the type of the host - Linux, HP_UX, Cisco Router etc
usm_icon The icon information that user can define as UI resource and can use for their UI.
usm_id_mapping
A generic table for integration with other components that can specify how to map objects from one system to another. The description of the fields is listed below but only really as a guideline. During integration there is flexibility to change the behaviors and meaning of these fields.
Primary keys are: domain, ican_type, system_id, object_id
usm_id_pd Holds the last id for the plan definition table entries.
usm_id_plan Holds the last id for the plan table.
usm_import_attribute Attributes for an importer that is not part of a rule or a field in usm_importer. May for example be the directory where the imported files are imported from, the check interval etc
usm_import_export_mapping
for ixutil import and export, this will store imported or exported unique UUID by table_name, id, uuid, tenant_id mapping table with timestamp.  This will help to migrate data with unique identifier
usm_import_rule Defines the rules for a importer such as field separator, which field has which meaning etc
usm_import_table_index Table used for bulk load imports. The data is first bulk loaded into temporary tables. Each temporary table is registered in this table. A background job will then move data from the temporary tables into the event_data tables
usm_importer
Represents a SLM importer, capable of importing event data into the event_data tables.  This entity was known as import metrics in SLM 3.5
usm_importer_instance An instance of an importer running on one specific dc server
usm_importer_spec The specification of the attributes used to instantiate an importer into an importer instance.
usm_importer_spec_value Used to represent a set of legal values for a usm_importer_spec attribute.
usm_install Defines the installation definition and value, used by installation to determine what is installed.
usm_installed_component Defines each component which is installed on the system. There are multiple installed components linked to a system install representing different components installed on the system. Eg: Billing, ViewManager, Scheduler, WorkFlow etc
usm_installed_subcomponent Defines the installation sub components available on the system
usm_invoice_history Every bill run and invoice on demand is recorded in this table.
usm_keyword All unique keywords are stored in this table. Keywords are then looked up in associated tables with their corresponding keyword unique ID. As of r11.2, the only supported association is rate item definition to keyword mapping.
usm_last_analysis This table contains information about the last run analysis for a given analysis job.
usm_lastid Persists the last id generated for many of the tables records. This is maintained and updated by Accounting and the Catalog. Integrated components should not update this table, reference it, or rely on it any way. This table can change to support design implementations that enhance the product.
usm_launchpad
Defines the menu information for the USM UI.  Menu will be contructed dynamically by retrieving the launch information by the backend engine.
usm_launchpad_content For each USM launchpad, defines what contents will be dynamically retrieved to contruct menu and what backend class will handle those request.
usm_link_account_user Place holder for many to many relationship between user and account, a account can have may users and a user can be part of many accounts.
usm_link_analysis_layout usm_link_analysis_layout
usm_link_analyze_func_metr_cat link table idenfying which metric categories supports which functions
usm_link_analyze_job_group Link that represents the report groups for an analyze job
usm_link_analyze_job_ticket  
usm_link_billing_account_group The table billing_groups are used internally and are never exposed to any GUI and is not integrated with any other component, and therefore may change and is not documented here nor supported.
usm_link_calendar_contract  
usm_link_contract_sla_inst This table is the relationship place holder for a SLA contract and an SLA instance
usm_link_event_inst_metr_inst
Many to many link between metric instances and event instances. Identifies which metric instances used which event instances.

One event instance may be reused by multiple metric instances.
usm_link_event_metric_category link table linking an event type to a metric category
usm_link_guinode_guinode Defines the relationship of child and parent guinode information. Guinode can contain child guinodes to retrieve more data to user interface.
usm_link_importer_inst_metric This table is the place holder for the relationships between an importer instance and metric
usm_link_install_comp_subcomp Place holder for the relationship as which install components are part of which system install
usm_link_launchpad_launchpad Defines the relationship of child and parent launchpad information. Launchpad can contain child launchpads to retrieve sub menu.
usm_link_method_method
This table is used in the multiple method invocation feature, this holds the relationships for a plugin  methods
usm_link_metric_schema_comp This table is the placeholder for relationships between a metric and a schema component
usm_link_metric_scope Many - many relationship between scope and metirc/metric_category.
usm_link_mr_import_event_inst  
usm_link_object_keyword This table is used to store information linking a rate item to a keyword ID (from usm_keyword). Currently (r11.2+) this keyword assignment is only supported and assigned at the rate item level on the rate item definition UI (one-to-many).This table is designed to accommodate the future design plan to support keyword assignments for any object type in the system (for example, offerings, rate plans, reports, etc).
usm_link_offering_ci Table to map one or many Service Catalog Offerings to one or many CMDB Configuration Items.
usm_link_plugin_plugintype
This table is the place holder for relationships between a plug-in and a  plugintype
usm_link_profile_hosts Many-many link between collection profile and the hosts(target hosts)
usm_link_rateitem_model This table is used to store information linking a rate item to a UAPM asset model. This model assignment takes place at the rate row level on the rate plan definition UI (one-to-many)
usm_link_report_variable_data Holds many to many relationship between report data objects and report variables. A data object can have multiple variables and a report variable can be used in many report data objects
usm_link_request_reservation to map Service Catalog usm reservation, reserved resource items, and its subscriptions of the service
usm_link_resource_outage  
usm_link_rtapp_account Defines relationship on what runtime application are tied to an account
usm_link_schema_component
icsmcomponent ties schema and schema component

Eg-- It ties winword.exe to Citrix-MS Office
usm_link_schema_inst_metr_cat Many - Many relationship between an installed schema instance(appinstance) and a metric category.
usm_link_schema_metr_category Many - Many relationship between a schema and a metric category
usm_link_schema_slo_template Link betwwn schema and slo template
usm_link_scope_layout
identifies which report layouts can be used for which scope. Many - many link. This will not be used in r11, as usm_analyze_function FK in usm_scope will be used instead
usm_link_server_systeminstall Many-Many relationships between a system install entity and the server entity. Ex: Many system install object use one mail server
usm_link_service_event
This table links a calendar category with a contract or a host. It is used to represent service events for the given contract or host using the provided calendar category.

Representation of service events for contracts and hosts will not change in r11, and stay the same as in Assure 2.2

This table is included for future versions
usm_link_service_event_metr_in
Link identifying which metric instances are affected by which service incident.

Only manually added service events has this link. Calendar derived service events are not associated with metric instances directly, but rather with report groups/contracts(usm_link_service_event)
usm_link_service_event_ticket  
usm_link_sla_calendar_event  
usm_link_slo_instance_instance  
usm_link_slo_package_template This table is the placeholder for relationships between an SLO package and templates.
usm_link_slo_template_template This table is the placeholder for the relationships between SLO templates
usm_link_subscription_asset
This table is used to store the information linking a request item with an UAPM asset (ca-asset record) for those request items filled from existing inventory (one-to-many).  This table will also be used to store the asset ID when we create a new asset for assets newly purchased based on a request.  Creating an asset is a future (but necessary) feature and will take more design.
usm_link_sysinstall_installcom Place holder for the relationship as which install components are part of which system install
usm_link_ticket_request_item This table is used to store the mapping between tickets in Unicenter Service Desk and Service Delivery's Request Object (request_item_id and request_id fields). Once a ticket has been linked to a request item it is possible to view the related ticket(s) via the Request detail screen. A new column called 'Related Ticket' has been added next to Amount and Period. This column will show the ID of the Service Desk ticket as a link. Clicking the link will pop up a window displaying the Service Desk ticket. If more than one ticket is associated to the request item they will appear as comma separated.
usm_localization_value language localized values for Service Catalog content data
usm_meter_gui_cfg Defines the service metering configuration user interface.
usm_metering_package Defines a service metering package that is available on the system. A metering package is a collection of metric categories for an associated schema. I.e a collection of metrics.
usm_method
Defines a multi-method hierarchy for UI backend, which is used to generate the contents.
To construct the hierachy structure, the self join has been implemented by the field method_parend_id
usm_method_input This table is the extension of usm_method table and stores the input parameters for a usm_method and is used in multi method invocation plugin method heirarchy
usm_method_optional_input This table is the extension of usm_method table and stores the optional input parameters for a usm_method
usm_metric
A metric, or metric type, represents a way to collect metric data for a given metric category.  All metrics within the same metric category collects the same type of metric data, but using different collectors.

A metric type is associated with a schema and a metric category.

 A metric type has set of attribute specifications that gives the default values for attributes for metric instances of this metric type. 

usm_metric_analyzer Contains definition of how a metric category is analyzed by DcAnalyzer. Has an associated set of attributes in usm_metroicc_analyzer_attrs. In Assure 2.2 this data is represented in metricinfo.dat. In r11, this data will still be kept in metricinfo.dat, but for r12 this should be represented in the database
usm_metric_analyzer_attrs Attributes for a metric analyzer. Will probably not be used in r11, included for future versions
usm_metric_attr_spec
The metric attribute specification specifies which attributes can be set for a given metric type during instantiation. It also specifies the default value of the attribute if available.

If an attribute has multiple values allowed, and the user enters multiple values during instantiation/deployment/resource assignment, multiple event instances will be created for the metric instance. This mechanism should be used to reporesent the Assure 2.2. component concept.
usm_metric_attr_spec_value If a metric attribute spec attribute have a fixed set of allowed values, this table is used to represent the set of allowed values.
usm_metric_attr_value
This table contains values for a given metric attribute. Multiple metric instances(of the same metric type) with the same attribute value should reference the same usm_metric_attr_value. 

Note, we may make this table independent of metric_attr_spec, so that metric attribute values can be shared across different metric types.
usm_metric_category
A metric category specifies one type of metric data that can be measured and calculated for a set of associated metrics.

Examples of metric categories--

- Application Availability
- Platform availability
- Bandwidth percentage

One metric category may have an associated set of metrics. Which metric is used to measure the category is defined by the associated schema.  

Typically, a metric category like Application Availability will have different metrics defined for different schemas. Each of these metrics will use a collector to collect data and may have different attribute specifications.

The Application Availabilty metric category has 4 types of metrics associated with separate schemas. Each of these metrics uses the same collector, but they have different attribute specifications in that the component attribute values for each metric is different. This is used during resource assignment so that the metric instance has all the associated components.
usm_metric_folder
represents a folder in the metric tree.  Gives an hierarchical overview of all the metrics in the system.

A metric folder can either be a set of other folders & metrics, or it can be represented as a schema.
usm_metric_instance
usm_metric_instance is created when metric instance is created, it is tied to usm_schema and usm_metric_category.

A metric instance is mapped to one or more event instances that does the actual measurements. For metric instances with multiple components, this will result in one metric instance mapped to multiple event instances.
 
usm_metric_instance_appuser
  This is the list of application users that are tied to a specific metric instance, this list can be used to group by ( application user list) implementation.
usm_metric_resultXXXXX
The usm_metric_resultXXXXX tables are dynamically created by dcanalyzer when it aggregates events into a meaningful value for this metric.  The XXXXX value will be the metric category id for the metrics being aggregated.
This table is added to serve as a prototype for all the dynamic usm_metric_result tables
This was done to enhance the access performance when multiple USM components needed to access the result tables simultaneously.
usm_mr_ierror Holds the errors occurred during the data mediation process, errors may be either due to upload or importing based
usm_mr_ievent_load  
usm_mr_ievent_metric This the mapping for event and metric information, place holder as which eventID it mapped to which metricID
usm_mr_ifield The fields mapping for the external data for the Data Mediation process
usm_mr_ifile The information for the Imported data file or the external database where the data is fetched from
usm_mr_iftype Field Type Definition for the fields used in the data mediation process. These are the fields in the system used to map the external data
usm_mr_imap Holds the mapping of holding mandatory fields for different types of profiles. Eg-- For metric information, timestamp, account, value, offering etc are mandatory
usm_mr_import For each profile, the aggregation import information is defined here.
usm_mr_iref Import reference table, reference tables are used in conjuction with the the profile data to drive the business logic during aggregation
usm_mr_isystem It holds the information for the data process operational key - last processing ID
usm_mr_itable Information for the defined profile is stored here
usm_mr_itrend Aggregated metric trend information, trend is rollup based on a service, account and this data is persisted here to avoid running complex queries to the result tables
usm_mr_ivalue Static values for the fields is stored here for the data that is imported
usm_news This is the place holder to transmit any common news messages accross users
usm_note Currently persists only notes for rate items and requests. But can be used to store notes for any object.
usm_numeric_policy Defines the policy used in determining the currency while billing
usm_object_wf_instance_ref
This table is used to store the information linking a USM object (like a request or request item) with a process instance (one-to-many).  

Object (like Request/Request Item) - Process Instance Cross Reference
usm_offering All offerings, offering is a service that can be subscribed to.
usm_offering_ratedef_inclusion Persists the inclusion relation between offerings and the rate plan rows. After a rate_plans object is included into an offering, the user selects which rows are visible and selected by default. This table stores that relationship.
usm_offering_rplan_inclusion
Persists the inclusion relation between offerings and rate plans. For every rate plan included into an offering a record is created in this table.

This table is renamed to usm_offering_rateplan_inclusion from usm_offering_rateplans_inclusion as the table name is too long
usm_offering_sla This table associates an SLA with a rate row defined under an offering. Since the same rate row can exist in multiple offerings, the SLA is set at the offering level. This allows a rate row that exists in multiple offerings to have different SLAs for each offering. Users can specify how long it should take for a request containing a particular rate row to go from one status to the next. Out-of-box reports allow users to see which requests have violated the SLA (taken longer than specified).
usm_offering_sla_history
History table which stores version history of offering sla definition.
When offering sla definition need to be changed, current sla definition will be stored as old version with user’s provided comment.  usm_offering_sla_history_link table is relationship between usm_offering_sla (definition) and usm_offering_sla_history table.
usm_offering_sla_history_link
History table which stores version history of offering sla definition.
When offering sla definition need to be changed, current sla definition will be stored as old version with user’s provided comment.  usm_offering_sla_history_link table is relationship between usm_offering_sla (definition) and usm_offering_sla_history table.
usm_onetime_event
A one-time event describes a event that is not recurring. I.e it happens only once and has a fixed start and end time.

A one-time event may be related to a recurring event. If so, it is used to override an recurring occurrence for the recurring event in cases where an occurrence is updated or deleted.

usm_pattern_type
A pattern type describes one type of pattern supporting recurring events. A separate java class is specified that actually implements the pattern parsing.

The pattern type is related to a set of recurring events that uses this pattern type.

In r11, only crontab type of patterns are supported.
usm_payment_method
Store all the detailed payment information here. The primary key for these objects are account_no and id. The id is calculated from billing_account.last_payment_id

the values for the overloaded fields for the payment types supplied out-of-the-box. Users can created there own payment plugins and override the meanings of these fields.

When type_1=CreditCard
"	type_2: 0=VISA, 1=MasterCard, 2=AMEX
"	text_1: issued by, ex: Citibank
"	text_2: card number
"	date_1: expiration date

When type_1=Check
"	text_1: check number
"	text_2: routing number
"	text_3: account_number
"	date_1: check date

When type_1=Cash
no fields overloaded for cash

When type_1=Direct
"	text_1: institution number
"	text_2: routing number

When type_1=PrePay
"	numeric_1: deposited amount
"	numeric_2: applied amount
"	date_1: prepayment date

When type_1=Coupon
"	text_1: coupon number
"	date_1: expiration date

When type_1=Tip
"	type_2: tip type, ex: normal, holiday, etc.
"	text_1: tip to who
usm_plan
usm_plan contains information relating to a plan item.

This table is deprecated. ( We are not using this table from R11.0)*
usm_plan_data This table holds the plan data for set/cost_pool/fiscal_periods combinations.
usm_plan_def usm_plan_def contains information relating to a plans definition grouping.
usm_plan_set
Logical groupings of related financial quantities used in the budget and planning process.

This table is deprecated. ( We are not using this table from R11.0)*
usm_planning_set Logical groupings of related financial quantities used in the budget and planning process.
usm_plugin Defines a plugin for driving the content in iCanView
usm_plugin_type Defines the grouping of plugin’s based on the type
usm_policy_entities
This table is to store the policies created in Policy Builder

The scope of this feature is to allow service designer the ability to dynamically assign pending actions based using a policy. Currently service builders have to create a service specific workflow if they want to do multi level
usm_portal_content Defines the content for portal object.
usm_portal_template Defines the template library for portal management
usm_pwd_policy Defines a password policy which is enforced on the users logging in
usm_queue_item Queue item is used for inter process distributed communitcation, a request is posted to the queue_item and it is picked up by the any of the distributed servers. Eg: When a bill run is scheduled using the UI, a queue_item is posted, and any of the billing services can pick this up and handle it on the FCFS basis.
usm_queue_item_detail Details for each queue_item are added here.
usm_rate_def_ext
This table is for supporting extra key value (Contractual metrics, incentive metrics) for usm_rate_defination.  Table to store Contractual metrics and incentive metrics as key value pair
usm_rate_definition
Rate items -

This table is perhaps the most complicated of them all. In addition to the number of rate items that are provided, and the fact that new ones can be added as plugins, but many of the rate items share certain properties, and many of the overloaded fields are used to keep the meaning consistent for related rate items. Programmatically this allows for an inherited structure of objects.

Chargeable rate items:
There is no rate item called Chargeable, however, rate items that have similar properties and extend from this set of overloaded fields and maintain there meaning:
Chargeable rate items are: Rate, Application, Agreement, Adjustment
The fields and there meanings are:
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_9 = cost type, 1=sp/st specify, 3=user specified
"	enum_10 = periodic type interval
"	text_1 = unit type
"	text_4 = unit cost text
"	numeric_1 = unit cost

Chargeable Associated rate items:
Similarly, there is no rate item called Chargeable, however, rate items that have similar properties and extend from this set of overloaded fields and maintain there meaning. What is significant about this set is that ChargeableAssociated rate item also extend from Chargeable rate items.
Chargeable Associated rate items are: Application, Agreement
The fields and there meanings are:
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental

Associated rate items:
Similarly, there is no rate item called Associated, however, rate items that have similar properties and extend from this set of overloaded fields and maintain there meaning:
Associated rate items are: Numeric, Boolean, Date
The fields and there meanings are:
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental

Range rate items:
Similarly there is no rate item called Range, however, rate items that have similar properties and extend from this set of overloaded fields and maintain there meaning:
Range rate items are: Numeric Range, Date Range
The fields and there meanings are:
"	enum_1 = 1 is infinite upper bound, 0 is not.


The following list is a compilation of all the fields used for each type of rate item:

When item_type = 0 (text rate item)
"	text_1 = textual value

When item_type = 1 (header rate item)
does not use overloaded fields

When item_type = 2 (numeric range rate item)
"	enum_1 = 1 is infinite upper bound, 0 is not.
"	numeric_1 = lower bound
"	numeric_2 = upper bound

When item_type = 3 (rate rate item)
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_5 = quantity type,  0=flat rate, 1=specify, 2=admin lookup, 3=user specified, 4=system passes, 5=user lookup
"	enum_6 = rate item id for quantity if a lookup is being made to another rate item for the quantity
"	enum_7 = 1 means show quantity on the invoice, 0 means dont
"	enum_8 = offering id for quantity. This is needed in cunjunction with enum_6 because a rate plan can be included in more then one offering and therefore is necessary to not only know the rate item but which offering.
"	enum_9 = cost type, 0=sp/st specify, 1=user specified
"	enum_10 = periodic type interval
"	text_1 = unit type
"	text_4 = unit cost text
"	numeric_1 = unit cost
"	numeric_2 = quantity

When item_type = 4 (application rate item)
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_5 = pricing structure, 0=subscription, 1=tiered, 2=usage based
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental
"	enum_7 = 1 is show mteric result on invoice, 0 is dont
"	enum_9 = cost type, 1=sp/st specify, 3=user specified
"	enum_10 = periodic type interval
"	text_1 = unit type
"	text_2 = application id
"	text_3 = metric id
"	text_4 = unit cost text
"	numeric_1 = unit cost

When item_type = 5 ( agreement rate item)
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental
"	enum_7 = 1 is charge for sla, 0 is dont
"	enum_9 = cost type, 0=sp/st specify, 1=user specified
"	enum_10 = periodic type interval
"	text_1 = unit type
"	text_2 = agreement id
"	text_4 = unit cost text
"	numeric_1 = unit cost

When item_type = 6 (numeric rate item)
"	enum_1 = quantity type,  0=flat rate, 1=specify, 2=admin lookup, 3=user specified, 4=system passes, 5=user lookup
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental
"	numeric_1 = numeric value
"	enum_7 = 1 is show quantity on invoice, 0 is dont

When item_type = 7 (boolean rate item)
"	enum_3 = the boolean value, 0 = false, 1 = true
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental

When item_type = 8 (adjustment rate item)
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = pointer to the rate item that this adjustment will be applied to
"	enum_7 = adjustment type, 0=applied amount, 1=multiplier, 2=limit applied amount
"	numeric_2 = adjusment value
"	enum_8 = pointer to the offering that contains the rate item being adjusted. This is needed in cunjunction with enum_6 because a rate plan can be included in more then one offering and therefore is necessary to not only know the rate item but which offering.
"	enum_9 = cost type, 0=sp/st specify, 1=user specified
"	enum_10 = periodic type interval
"	text_1 = unit type
"	text_4 = unit cost text
"	numeric_1 = unit cost

When item_type = 9 (date rate item)
"	enum_1 = date type, 0=specify, 1=subscription date, 2=invoice date
"	enum_5 = 1 means rate item is associated to a rate plan, 0 is not
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 2=fixed, 3=fixed incremental, 4=fixed decremental, 5=fixed incremental/decremental, 6=variable lookup, 7=variable fixed, 8=variable fixed incremental, 9=variable fixed decremental, 10=variable fixed incremental/decremental
"	text_1 = the date value

When item_type = 10 (date range rate item)
"	enum_1 = 1 is infinite upper bound, 0 is not.
"	text_1 = lower bound date
"	text_2 = upper bound date

When item_type = 11 (day rate item)
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_5 = quantity type,  0=flat rate, 1=specify, 2=admin lookup, 3=user specified, 4=system passes, 5=user lookup
"	enum_6 = rate item id for quantity if a lookup is being made to another rate item for the quantity
"	enum_7 = 1 means show quantity on the invoice, 0 means dont
"	enum_8 = offering id for quantity. This is needed in conjunction with enum_6 because a rate plan can be included in more then one offering and therefore is necessary to not only know the rate item but which offering.
"	enum_9 = cost type, 0=sp/st specify, 1=user specified
"	enum_10 = periodic type interval
"	enum_11 = a value for the day of week or the day of month
"	text_1 = unit type
"	text_4 = unit cost text
"	numeric_1 = unit cost
"	numeric_2 = quantity

When item_type = 12 (cost allocation rate item)
"	enum_1 = billing_cycle, 0=onetime, 1=installments , 2=periodic, 3=na
"	enum_2 = periodic type, -1=na, 0=daily, 1=weekly, 2=monthly
"	enum_3 = number of installments
"	enum_4 = charge type, 0=credit, 1=debit
"	enum_5 = pricing structure 1=tiered, 2=usage based
"	enum_6 = tier type, -1=na, 0=lookup, 1=lookup multiple, 6=variable lookup
"	enum_7 = 1 is show mteric result on invoice, 0 is dont
"	enum_9 = cost type, 1=sp/st specify, 4=allocation
"	enum_10 = periodic type interval
"	enum_11 = 0 don't add budget, 1=add budget
"	text_1 = unit type
"	text_2 = application id
"	text_3 = metric id
"	text_4 = unit cost text
"	numeric_1 = unit cost
usm_rate_plan Holds rate plan, a rate plan consists of one or more rate items and will be included in a offering to allow for subscription to Accounts
usm_rateplan_inclusion Persists the relationship of which rate items belong to which rate plans. The concept of this table is that every rate plan has many rate items of which some are no longer available, due to soft deleted rate items and rate items that are tracked for auditing purposes. Only the available rate items will appear in the table.
usm_rateplan_inheritance Persists the relationship of between rate plans and the rate items that they are inheriting. The concept of this table is that a component can determine if a rate plan inherits from another rate plan if it has entries in this table. From this table a rate plan inheritance tree can be formed.
usm_recurring_event
A recurring event is an description of a recurring pattern of events. One recurring event will result in a series of events, called recurring occurrences. 

A pattern is used to decribe the recurring event. Crontab is supported but other pattern types may be supported in the future.
usm_report_data
Defines a data object for a report.

Data object is responsible for fetching the data from the data source.
usm_report_dataview Defines a data view for a report. The dataview displays the data retrieved from data object in customizable chart or table format.
usm_report_dataview_field Defines a relationship for storing multi valued attribute field. A report dataview can have multiple fields.
usm_report_group
A report group is a collection of metric instances with a set of assicated service goals. Also, a set of analyses are schedules on the metric instances within the report group.

A report group is associated with a contract. The contract is used to retrieve the service hours. 
Also, the contract may be used to retrieve a overall status for the report group. This may not be included in r11.
usm_report_group_attr  
usm_report_group_attr_spec  
usm_report_group_goal The service goal for a given report group
usm_report_group_metr_instance
Identifies the metric instances used by this report group.

It is possible to specify whether a metric instance should be affected by service events from the calendar or not. The field use_calendar specifies this.

usm_report_group_spec_value  
usm_report_group_template
A report group template represents a collection of metrics with associated default service goals. Such a template can be instantiated into a report group.

A report group template may also be organized into a hierarchy, so that it is possible to instantiate a complete report group hierarchy from a report group template.

In r11, only one report group template will be supported.
usm_report_layout
Defines the layout of the report.
Layout is a combination of one or more report views. Report layout contains the definition of how the report views are layed out and displayed
usm_report_layout_obj_list A list containing settings for various components displayed in the layout
usm_report_profile This table represents report profiles that are used to create a profile for how reports look and what properties the reports have.
usm_report_profile_attrs One attribute for a given report profile.
usm_report_profile_spec
Specification of the attributes that a report profile can have. 

A specification gives the attribute names, default value, whether it is a selection list or input field, the order of the fields etc.

The attributes are divided into sections, i.e. one for line-chart, one for layout
usm_report_profile_spec_values Set of allowed selection values for a given attribute for a report profile and a section
usm_report_variable Defines a variable used in the reports
usm_request This table stores all the request header information. A request header can have many fields depending on the implementation. To facilitate dynamic fields it is closely tied to usm_request_values table. The line items of a request are stored in usm_subscription_details table.
usm_request_auto_delegation Table to persist auto-delegation setting for a user
usm_request_item_form Form information associated to a form type request item (subscription_detail_id) is stored in this table. Form information is stored as name-value pairs. Note - The Form rate item was introduced as part of a patch to Catalog r11.1. This functionality is also in Catalog r11.2 and includes additional functionality.
usm_request_pending_act_hist Table to track request pending action history
usm_request_pending_action
This table is used to store the information linking a request or request item with an user ID to which a workflow task or non-USF approval is currently assigned (one-to-many).  This table is populated based on the request item status changes.

Request/Request Item User ID Cross Reference
usm_request_resource_item catalog request resource items for an example like for the reserved vitural machine vm1, vm2 at the computer type, for disk1, disk2 at the hard disk type level
usm_request_sla_instance Table contains all SLAs instance information at service options level and monitored status sla level, for each requests
usm_request_status In r11.1 request status history was fetched from event audit trail table, usm_system_change which did not scale well to high load. For r11.2, in order to improve performance and to show pending action at the request item level the request status history was stored in this new table.
usm_request_value This table is used to store the order header information.
usm_reservation to store catalog request reservation
usm_role
Defines the role which a user can be assigned.
Role determines the level of access. Eg: service provider administrator, super tenant administrator , enduser etc
usm_role_user Place holder for the relationship as which users belong to which group
usm_rsc_map Defines relationship to represent hierarchy structure of resource
usm_rsc_method
Defines resource methods
usm_rsc_nmrefer
Defines the relationship between resource node and resource method
usm_rsc_node
Defines the resource node for the resource management
usm_rsc_parameter
Defines parameters which is related to the resource method
usm_rsc_property
Defines resource property information for the resource node.
usm_rsc_system
Keep the last accessed IDs for resource management
usm_rule
Rule is a basic entity which drives the fulfilment of a task, we can add any number of rule for a specific rule_event_type.

Rule will hold a bunch of action associated which will be triggred on execution of this rule

Eg: A new hire is added to a company and you want to drive certain thing as soon as a user is added into the system.

Here "new hire" is a new rule which is added to rule_event_type ADD_USER.
usm_rule_action
Rule Action is the action which achieves the end task to be fulfilled.

There can be many actions associated to a rule, so when a rule  is satisfied all its actions are triggered
usm_rule_condition When adding a rule, there is an option to specify an event filter. Any event filters defined from this section for a particular rule are stored in this table . For a rule to trigger, all the rule conditions associated with that rule need to be satisfied.
usm_rule_event_param
Rule event param is the event parameter information of event notifications that the system can support.

Rule event param specifies the list of parameter information for each event type
usm_rule_event_type
Rule event type is the type of event notifications the system can support.

Rule event type specifies the list of system level notification than can happen. 

Eg. USER CREATE, SUBSCRIPTION CHANGE etc
usm_runtime_application Defines a Web based runtime application which is based on an USM Application being served and can be single singed on into.
usm_runtime_component Defines each runtime component which is will run on the system
usm_runtimecomp_parameter Place holder for the different parameters for the runtime component
usm_schema
Defines an application type with version and other configuration.

icsloruleinfo is replaced with a new link table link_apptype_slorule.( many -many)
icmetricinfo is replaced with a new link table link_apptype_metric.( many -many)
usm_schema_comp
Defines a schema component.

Eg--winword.exe, excel.exe, apache.exe
usm_schema_instance This is the installed instance of the schema
usm_scope
A scope identifies a set of metrics/metric categories with a similar set of characteristics. A scope also identifies the analyses that can be performed on the metric instances within a scope. This is done through the link to usm_link_scope_layout and usm_analyze_function.

In r11, the analyze functions will be used to create analyses, and not layouts. 

Scopes may be hierarchical, but in r11 they probably will not.
usm_search_node Defines the control for the search pages. The bucket search API used the searchnode implementation to do various searches
usm_security This table holds the security mapping for the resouces and the access control lists.
usm_server Defines the servers that are available like mail server, print server etc
usm_service_desk_priority  
usm_service_desk_ticket  
usm_service_event
Service events are used in SLM analyses to comment or remove down events within given time intervals. 

Service events can be added directly, or they can be exported from a associated calendar category.

Manually added service events are associated with metric instances using usm_link_service_event_metric_instance. Calendar exported service events are mapped to a report group(or contract) using usm_link_service_event
usm_service_goal The default service goals.
usm_service_goal_values A set of legal service goal values for a given service goal
usm_service_hours Contains the service hours for a report group. If service hours are not defined for a given day, the default service hours applies.
usm_serviceconfig
When a contract is created an entry is created in serviceconfig for the resource and it needs to be provisioned. This entry has details on which engine is responsible for aggregation and which application instance  and metric instance are used. 
usm_settlement
Settlements are special type of adjustments, they are not used in the current billing system

This table is deprecated. ( We are not using this table from R11.0)*
usm_sla_calendar
request sla service hour object, which includes, event_group =1, outage calendar=2, business hour=3.  Outage calendar can include event group other than events
usm_sla_calendar_group  
usm_sla_config Defines the configuration for an SLA instance.
usm_sla_event  
usm_sla_instance
Service Level Aggreement Package Definition - defines an SLA package which is tied to an application. This groups a bunch of the icslo objects to create a package.

aggregationtype is made single valued, hence use delimited sepreated list
usm_sla_metric_instance
This table provides a many-many relationship between a metric instance and an sla.

usm_slm_server
Represents various slm servers running on a host somewhere. Each server has an associated table with configuration information and another giving the state of the server. 

Such servers can be DC Hubs, DC Servers, SLA engines for example.
usm_slm_server_config Configuration attribute for a slm server. One slm server may have multiple configuration attributes. Each attribute has a name and a value and is associated with a usm_slm_server.
usm_slm_server_status
The status of an SLM server.  The status is updated by a separate process monitoring each slm server.
usm_slm_server_status_type
List of known status types for a server. 

The following types should be defined. Others may also be defined

- disk
- cpu
- connection
- process
usm_slm_server_type
This entity defines the various server types available in the system

- DC Hub
- The various collector types
- DC Server
usm_slm_server_type_spec The attribute specification for a server type.
usm_slm_server_type_value Identifies the legal values for a server type specification attribute. Used for for example selection type of attributes.
usm_slo_data Contains aggregated slo data. One entry pr. report interval pr slo_instance for each sla/contract
usm_slo_event Contains service violations.
usm_slo_instance Defines a Service Level Objective which is part of the SLA package
usm_slo_package
Package of SLO templates.

aggregationtype is made single valued, hence use delimited sepreated list
usm_slo_template Defines a service level offering rule based on an SLO
usm_slo_template_sla_config This table is the placeholder for the SLO template's SLA configuration
usm_slo_threshold  
usm_sm_comp
This table has information on which schema component is installed on which host and for which metric instance.
 
usm_sm_event
Events sent to assure for analysis are stored in this table.  Host and contract service events are also stored in this table.
usm_snmp_config
 The snmp_config table is used by the snmp collector. The table contains information needed by an snmp agent for selecting snmp version, community string and so on.
usm_statement Contains all items associated to a particular invoice.
usm_stylesheet Defines the style sheet that specifies the style for portal components
usm_subscription_detail
all the subscription information

the values for the overloaded fields for the subscription_details supplied out-of-the-box. 

When subscription_type = 0
"	text_5 = the unit cost text for display
"	enum_1 = pointer to another subscription_details record for looking up other subscription info, such as user specified quantity, etc.
"	numeric_1 = user defined quantity
"	numeric_2 = unit cost used for calculations

When subscription_type = 1
"	text_1 = application id
"	text_2 = application name
"	text_3 = service config id
"	text_5 = the unit cost text for display
"	enum_1 = metric ID
"	enum_2 = offset used in making queries to the SM result tables.
"	numeric_2 = unit cost used for calculations

When subscription_type = 2
"	text_1 = contract ID
"	text_2 = sla package name
"	text_5 = the unit cost text for display
"	numeric_2 = unit cost used for calculations

When subscription_type = 3
"	enum_1 = the adjustment ID that the subscription was created for
"	numeric_1 = quantity used when invoicing adjustment depending on the what the adjustment is applied to (ie: rate's quantity, rate's unit cost, rate's cost, etc)
usm_subscription_mgmt
Persists all the subscription management criterias such as billing in advance, date differentials, and suspensions

the values for the overloaded fields for the subscription_mgmt types supplied out-of-the-box. 

When type = 0
"	enum_1 = differential type. 0=no difference, 1=fixed, 2=absolute, 3=offset, 4=user
"	enum_2 = day differential
"	enum_3 = month differential
"	enum_4 = year differential
"	enum_5 = day differential value
"	enum_6 = month differential value
"	enum_7 = year differential value
"	date_1 = fixed date of the date differential

When type = 1
"	enum_1 = bill advance type. 0=no billing in advance, 1=specify billing in advance
"	enum_2 = the number periods to bill in advance

When type = 4
"	enum_1 = the offering id
"	enum_2 = rate plan id
"	enum_3 = rate item id
"	enum_4 = 1 means the suspension is fully applied and will no longer be applied to new charges. 0 means keep applying
"	date_1 = the start date of the suspension
"	date_2 = the end date of the suspension
"	date_3 = the applied date of the suspension. That is, up to what date has the suspension already been applied.
usm_system_alert Place holder for all the system alerts, alerts are generated if something goes down or something is not working properly
usm_system_change This table holds the basic information about the event or transaction that had taken place in the iCan System. External events from other system can also be posted to iCan system.
usm_system_change_detail An event might occur when an object gets added, deleted or modified in the iCan system or external system. This table allows you to store the state of the object before modification and the state of the object after modification.
usm_system_change_detail_ext When storing the state of the object in the transaction_details table, some of the fields can be multi-valued. These multi-valued field values are propagated to the transaction_details_ext table.
usm_system_install
Defines a installed system for iCanView, only machine which are registered in icsysteminstall can host iCanView.

icinstalledcomponentinfo is removed, instead should use link_systeminstall_installcomp table
usm_task Defines a task for the scheduler to pick up
usm_tenant_ext
Defines an organization/department which will contain users and accounts.
usm_tenant_ext_ldap_conf Place holder for the external LDAP configuration at the organization level
usm_transaction
This table records all the transactions associated to a billing_account. The primary key is the account_no and the id. The id is calculated from the billing_account.last_transaction_id

the values for the overloaded fields for the transaction types supplied out-of-the-box. Users can created there own transcation plugins and override these fields meanings.

When type = 0 (Offering Transcations)
"	enum_1 = pointer to the subscription, ie: subscription_details.subscription_id
"	enum_2 = pointer to the offering, ie: offerings.offering_id

When type = 1 (Rateplan Transcations)
"	enum_1 = pointer to the subscription, ie: subscription_details.subscription_id
"	enum_2 = pointer to the offering, ie: offerings.offering_id
"	enum_3 = pointer to the rate plan, ie: rate_plans.rate_plan_id

When type = 2 (Rateitem Transactions)
"	enum_1 = pointer to the subscription, ie: subscription_details.subscription_id
"	enum_2 = pointer to the offering, ie: offerings.offering_id
"	enum_3 = pointer to the rate plan, ie: rate_plans.rate_plan_id
"	enum_4 = pointer to the rate item, ie: rate_definition.item_id
"	enum_5 = installment total. For transactions that are created from rate items that charge in installments
"	enum_6 = installments. For transactions that are created from rate item that charge in installments this will specify how may installment to date have been made.
"	enum_7 = rate item type
"	enum_8 = show additional value from numeric_1 on the invoice(ie: metric result, user entered quantity, etc)
"	numeric_1 = rate item result value (ie: metric result )
"	date_1 = the transaction from date
"	date_2 = the transaction to date
"	prorate_value = the number of days in the billing period.
"	period_multiplier = the factor calculated from prorating
"	num_periods = the number of periods the transaction is being billed for
"	advanced_periods = the number of perios the transaction is being billed in advance for.
"	period_type: -1=onetime, 0=daily, 1=weekly, 2=mon
usm_unittype
Defines the specific unit for a given metric category.
usm_user
Defines the  user in the system, inherited from inetOrgPerson, a standard ldap user class. 
This is the physical user who will get authenticated and can login in into the system.

User belongs to a tenant( domain), and will login into the specific domain he is part of to acess the system

User also is tied to a role which determines what level of access he has

icgroupname is replaced by icroleid
icuserquery is replaced with user_query_history
icpwdhistrory is replaced with user_pwd_history
usm_user_query_history Place holder for the query history, a list of queries done by the user are stored here and can be selected by used to run the queries
usm_webservice Defines a web service available as part of the product suite, the is the intefaces for SOAP protocal into the product
usm_webservice_method Defines a web service method which can be accessed throught web services provided in the suite
usm_webservice_sessions To store the webservice session ids in the table
usm_wmi_classes
This table will hold a list of all of the WMI Classes that were found on a particular WMI gateway the last name a class query was made.
Keeping a list of these classes allows us to have a cache so that we do not need to connect to the gateway each time we set-up a WMI Metric Instance.
This also makes it easier to use filter the list of classes in the GUI by searching for certain strings in their names.
usm_wmi_expression
This table will be used to hold a list of the WMI expressions, which are used for the translation of data that is collected from a WMI Gateway to a format that is acceptable for the SLM r11 database. 

 For example, since strings are a valid type of information collected by the WMI and the events table can only store numeric information, we need a way to map the data into the database.  This is accomplished by using an expression, which can be saved for future use, or applied to other types of WMI metric instances.  The expression itself will probably use a language such as Tcl, which is used by the SNMP Metric Wizard expressions in SLM 3.5.
Column(s) of "ca_asset_source" Table
Name Datatype Null Option Comment
asset_source_uuid byte varying(16) NOT NULL  
logical_asset_uuid byte varying(16) NULL  
source_location_uuid byte varying(16) NULL  
subschema_id integer NOT NULL  
creation_user varchar(64) NULL  
creation_date integer NULL  
last_update_user varchar(64) NULL  
last_update_date integer NULL  
version_number integer NULL  
Column(s) of "ca_company" Table
Name Datatype Null Option Comment
company_uuid byte varying(16) NOT NULL  
parent_company_uuid byte varying(16) NULL  
company_name varchar(100) NULL  
inactive integer NULL  
description varchar(400) NULL  
company_type integer NULL  
alias varchar(30) NULL  
month_fiscal_year_ends integer NULL  
web_address varchar(50) NULL  
bbs varchar(30) NULL  
creation_user varchar(64) NULL  
creation_date integer NULL  
last_update_user varchar(64) NULL  
location_uuid byte varying(16) NULL  
primary_contact_uuid byte varying(16) NULL  
version_number integer NULL  
last_update_date integer NULL  
Column(s) of "ca_contact" Table
Name Datatype Null Option Comment
contact_uuid binary NOT NULL  
middle_name nvarchar(200) NULL  
alias nvarchar(60) NULL  
last_name nvarchar(200) NOT NULL  
first_name nvarchar(200) NULL  
pri_phone_number nvarchar(80) NOT NULL  
alt_phone_number nvarchar(80) NULL  
fax_number nvarchar(80) NULL  
mobile_phone_number nvarchar(80) NULL  
pager_number nvarchar(80) NULL  
email_address nvarchar(240) NULL  
location_uuid binary NULL  
floor_location nvarchar(60) NULL  
pager_email_address nvarchar(240) NULL  
room_location nvarchar(60) NULL  
contact_type int NULL  
inactive int NOT NULL  
creation_user nvarchar(128) NULL  
creation_date int NULL  
last_update_user nvarchar(128) NULL  
last_update_date int NULL  
version_number int NULL  
department int NULL  
comments nvarchar(510) NULL  
company_uuid binary NULL  
organization_uuid binary NULL  
admin_organization_uuid binary NULL  
alternate_identifier nvarchar(60) NULL  
job_title int NULL  
job_function int NULL  
mail_stop nvarchar(60) NULL  
cost_center int NULL  
userid nvarchar(60) NULL  
supervisor_contact_uuid binary NULL  
exclude_registration int NULL  
delete_time int NULL  
inrdid int NULL  
tenant binary NULL  
Column(s) of "ca_currency_type" Table
Name Datatype Null Option Comment
currency_type_code varchar(3) NOT NULL
Type code is the  code for a particular currency, Eg- USD, EURO etc
name varchar(64) NOT NULL Descriptive name of the currency Eg- United States Dollor
symbol varchar(4) NOT NULL The actual symbol of currency, Eg- $
in_use int NULL  
country nvarchar(512) NOT NULL  
description varchar(128) NOT NULL A detailed description of this currency, Eg- US dollor is universal currency and is taken as a base for all other currency conversions
Column(s) of "ca_locale" Table
Name Datatype Null Option Comment
locale_code varchar(4) NOT NULL locale code is the code for particular locale, Eg- us_en for united states english, cn_zh for simplified chinese
name varchar(64) NOT NULL Descriptive name of the locale like, United States English etc
language_code nvarchar(2) NULL  
country_code nvarchar(2) NOT NULL  
language_name nvarchar(32) NULL  
country_name nvarchar(32) NOT NULL  
description varchar(128) NOT NULL A detailed description of the locale and how it is used
Column(s) of "ca_location" Table
Name Datatype Null Option Comment
location_uuid byte varying(16) NOT NULL  
location_name varchar(100) NULL  
inactive integer NULL  
location_type integer NULL  
pri_phone_cc integer NULL  
pri_phone_number varchar(32) NULL  
fax_cc integer NULL  
fax_number varchar(32) NULL  
address_1 varchar(50) NULL  
address_2 varchar(50) NULL  
mail_address_1 varchar(50) NULL  
mail_address_2 varchar(50) NULL  
mail_address_3 varchar(50) NULL  
city varchar(50) NULL  
state integer NULL  
address_3 varchar(50) NULL  
mail_address_6 varchar(50) NULL  
mail_address_5 varchar(50) NULL  
mail_address_4 varchar(50) NULL  
address_6 varchar(50) NULL  
address_5 varchar(50) NULL  
address_4 varchar(50) NULL  
primary_contact_uuid byte varying(16) NULL  
zip varchar(20) NULL  
country varchar(50) NULL  
county varchar(50) NULL  
geo_coord_type integer NULL  
geo_coords varchar(40) NULL  
company_uuid byte varying(16) NULL  
contact_address_flag integer NULL  
creation_user varchar(64) NULL  
site_id integer NULL  
creation_date integer NULL  
COMMENT varchar(255) NULL  
last_update_user varchar(64) NULL  
last_update_date integer NULL  
version_number integer NULL  
Column(s) of "ca_location_type" Table
Name Datatype Null Option Comment
id integer NOT NULL  
inactive integer NULL  
name varchar(100) NULL  
creation_user varchar(64) NULL  
creation_date integer NULL  
last_update_user varchar(64) NULL  
last_update_date integer NULL  
version_number integer NULL  
description varchar(255) NULL  
Column(s) of "ca_organization" Table
Name Datatype Null Option Comment
organization_uuid byte varying(16) NOT NULL  
parent_org_uuid byte varying(16) NULL  
description varchar(255) NULL  
org_name varchar(100) NOT NULL  
abbreviation varchar(30) NULL  
pri_phone_cc integer NULL  
pri_phone_number varchar(32) NOT NULL  
alt_phone_cc integer NULL  
alt_phone_number varchar(32) NOT NULL  
fax_cc integer NULL  
fax_number varchar(32) NOT NULL  
email_address varchar(120) NOT NULL  
location_uuid byte varying(16) NOT NULL  
pager_email_address varchar(120) NOT NULL  
inactive integer NOT NULL  
creation_user varchar(64) NULL  
creation_date integer NULL  
last_update_user varchar(64) NULL  
last_update_date integer NULL  
version_number integer NULL  
company_uuid byte varying(16) NULL  
COMMENT varchar(255) NULL  
contact_uuid byte varying(16) NULL  
cost_center varchar(50) NULL  
Column(s) of "ca_time_zone" Table
Name Datatype Null Option Comment
time_zone_code varchar(64) NOT NULL time zone code is the code for a particular time zone, Eg- EST, PST etc
name varchar(64) NULL Descriptive name of the time zone, Eg- Eastern Standard Time( US & Canada)
description varchar(128) NOT NULL A description of time zone
dst_flag int NULL Flag to indicate if day light savings time is used or not
dst_id varchar(128) NULL  
Column(s) of "usm_account" Table
Name Datatype Null Option Comment
account_id varchar(50) NOT NULL Unique ID of the account
status int NOT NULL account status - 0 open, 1 close
name varchar(64) NOT NULL Readable account name
label nvarchar(64) NOT NULL Readable account label
opened_date datetime NOT NULL account open date, recorded date when opening the account
closed_date datetime NULL account close date, recorded date when closing the account
email varchar(128) NULL email contact for the account
website varchar(128) NULL website of the account
data1 nvarchar(32) NULL for integration
data2 nvarchar(32) NULL for integration
data3 nvarchar(32) NULL for integration
data4 nvarchar(64) NULL for integration
data5 nvarchar(64) NULL for integration
data6 nvarchar(64) NULL for integration
data7 nvarchar(128) NULL for integration
tenant_id varchar(50) NOT NULL tenant ID, the handle to the tenant which is the holder of this account
time_zone_code varchar(64) NULL time zone, for billing caluclations EG: EST, PST
location_uuid tinyint(16) NULL location, handle to the location table
single_user_mode integer NULL If it is true, then an account can have only one user associated with it. For request account, the account is created along with user and this account is set with the column single_user_mode as true
contact_uuid tinyint(16) NULL Contact UUID
Column(s) of "usm_account_app_user" Table
Name Datatype Null Option Comment
app_user_id varchar(50) NOT NULL The application user for this mapping
account_id varchar(50) NOT NULL The ican account for this mapping
app_login_id varchar(50) NULL application login name for the application
schema_id int NULL index to the application type
user_id varchar(50) NULL user login id associated with this application and applogin
Column(s) of "usm_account_domain" Table
Name Datatype Null Option Comment
account_no varchar(50) NOT NULL pointer back to the billing_account record.
path varchar(346) NOT NULL string representing the full path of tenants leading from the accounts tenant id to the service provider’s tenant id. The format is SP/PST1/…/CST/…/Tenant
domain_type varchar(4) NULL type of domain the account belongs to. Ex: SP, ST, TE, etc.
Column(s) of "usm_acl" Table
Name Datatype Null Option Comment
acl_id varchar(50) NOT NULL Unique id for the access control list
create_permit int NULL Flag for create permissions, 1 is permit, 0 is not permit
delete_permit int NULL Flag for delete permissions, 1 is permit, 0 is not permit
domain varchar(50) NULL The domain/organization for this ACL
modify_permit int NULL Flag for modify permissions, 1 is permit, 0 is not permit
read_permit int NULL Flag for read permissions, 1 is permit, 0 is not permit
execute_permit int NULL Flag for execute permissions, 1 is permit, 0 is not permit
mod_permit int NULL Flag for permission for modifying permissions, 1 is permit, 0 is not permit
list_permit int NULL Flag for list permissions, 1 is permit, 0 is not permit
is_system bit NULL flag for whether access control group is system defined
description varchar(128) NULL Description of the access control group
roles varchar(512) NULL the access control group name
Column(s) of "usm_adjustment" Table
Name Datatype Null Option Comment
adjustment_id integer NOT NULL unique identifier that identifies each adjusment.
adjustment_name nvarchar(50) NULL the name of the adjustment that appears in the adjustment gui, and on the invoice.
domain varchar(50) NOT NULL This is the tenant ID of the account
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
charge_type integer NULL 0=apply as credit, 1=apply as debit
adjustment_type integer NULL 0=general adjustment, 1=violation adjustment
value float NULL the amount of the adjustment (this is either a fixed amount or a percentage).
value_type integer NULL 0=fixed amount, 1=percentage, 2=association (for violation adjustment that will do a tiered lookup into a rate plan to determine the adjustment), 3=SLO association, 4=SLO value association, 5=catalog percentage. For most purposes, any integrated components will almost always use fixed amount or percentage.
description nvarchar(128) NULL appended to the adjusment_name and display on the invoice if there is a value for this field.
status integer NULL 0=not active 1=active
active_date date NULL this is populated with the date of when the status field is set to 0
inactive_date date NULL this is populated with the date of when the status field is set to 1
global_adjustment integer NULL 0=applied to a single account, 1=applied to all accounts
account_no varchar(50) NULL if global_adjustment=0 then this is a pointer to the billing_account record.
account_label nvarchar(128) NOT NULL if global_adjustment=0 then this is the displayable label of the billing_account.
start_date date NULL currently not used.
end_date date NULL currently not used.
enum_1 integer NULL See Table Comment
enum_2 integer NULL See Table Comment
enum_3 integer NULL See Table Comment
enum_4 integer NULL See Table Comment
enum_5 integer NULL See Table Comment
enum_6 integer NULL See Table Comment
text_1 nvarchar(50) NULL reference to SLA when adjustment is for SLA
text_2 nvarchar(50) NULL ·text_2: too detailed to describe here.
text_3 nvarchar(50) NULL ·text_3: too detailed to describe here.
Column(s) of "usm_analysis" Table
Name Datatype Null Option Comment
analysis_id integer NOT NULL Unique identity for the analysis
report_group_id int NULL Unique identity for the report group
category nvarchar(255) NULL The category of the analysis
access_group nvarchar(255) NULL The access group to which the analysis belongs
commandLineArgs varchar(255) NULL
Identifies the command line arguments needed to rerun the command in addition to the class and metric scopes.

Syntax: A:B:C 

A - command line args
B - class scope
C - metric scope

class and metric scope is not used anymore.
analyze_period varchar(50) NULL
Identifies the period for the report.

For example, Monday, Tuesday, ...
analyze_title nvarchar(255) NULL The title of the analysis
analyze_job_id integer NULL Unique identity for the analyze job
url varchar(20) NULL The file name for the file containing the report for this analysis. ".html" is stripped from the filename.
created integer NULL Epoch time of creation
modified integer NULL Epoch time of modification
analyze_status integer NULL
Overall status of the analysis:

Which statuses are supported is TBD.
release_status integer NULL Indicates whether the analysis in a release cycle is released or not.
period_start integer NULL The start time of the analysis in epoch
period_stop integer NULL Then end_time of the analysis in epoch
period_type varchar(20) NULL
Defines the interval of the analyzis relative to the time of the analyze job. 

For example today.
analysis_layout_set_id int NULL  
Column(s) of "usm_analysis_layout_set" Table
Name Datatype Null Option Comment
analysis_layout_set_id int NOT NULL  
report_layout_id varchar(50) NOT NULL Specifies the Unique identifier for the report layout. It is created when the layout is saved
is_default varchar(1) NOT NULL  
Column(s) of "usm_analyze_export_option" Table
Name Datatype Null Option Comment
analyze_export_option_id integer NOT NULL Unique identity for this option
name varchar(50) NOT NULL The name of the attribute
value nvarchar(255) NOT NULL Value of the attribute
analyze_job_id integer NOT NULL Unique identity for the analyze job
Column(s) of "usm_analyze_function" Table
Name Datatype Null Option Comment
analyze_function_id integer NOT NULL Unique identifyer for the analyze function
name varchar(50) NULL The name of the function
Column(s) of "usm_analyze_job" Table
Name Datatype Null Option Comment
analyze_job_id integer NOT NULL Unique identity for the analyze job
title nvarchar(255) NULL The title for the job and the created analyses/reports.
scope_id integer NULL Unique identity for the scope
recent_analysis_status integer NULL
The status of the most recent analysis available for this analyze job.

The most recent is not necessarilty the last run analysis
created int NULL  
updated int NULL  
analysis_layout_set_id int NULL  
Column(s) of "usm_analyze_job_option" Table
Name Datatype Null Option Comment
analyze_job_option_id integer NOT NULL Unique identity for this option
name varchar(50) NOT NULL The name of the attribute
value nvarchar(255) NOT NULL The value of the optional attribute
analyze_job_id integer NOT NULL Unique identifier for the analyze job
Column(s) of "usm_analyze_schedule" Table
Name Datatype Null Option Comment
analyze_job_id integer NOT NULL Unique identity for the analyze job
time varchar(20) NULL Crontab expression for when the analyze job should be run
period varchar(10) NULL
Textual representation of the schedule period.

- hourly
- daily
- weekly
- monthy
- quarterly
- yearly
period_type varchar(6) NULL
Defines the interval of the analyzis relative to the time of the analyze job. 

     h - This hour
     H  - Last hour
     d - Today
     D -Yesterday
     w - This week
     W - Last week
     m - This month
     M - Last month
     q - This quarter
     Q - Last quarter
     y - This year
     Y - Last year
     last30 - Last 30 days
     last90 - Last 90 days
Column(s) of "usm_analyzed_event_data" Table
Name Datatype Null Option Comment
event_instance_id int NOT NULL The unique identity of the event instance
time_stamp integer NOT NULL The time_stamp in epoch for the data
user_name varchar(64) NULL User name to which the data reflects
value float NULL The measured value
maximum float NULL The maximum value if reduction has been performed. Null orderwise
minimum float NULL The minimum value if reduction has been performed. Null otherwise.
reductionlevel bit NULL The reduction level. Null means no reduction
interval integer NULL
The sample interval  
no_of_samples integer NULL The number of samples in the reduction. Null means no reduction
insert_time integer NULL The inserted time in epoch
Column(s) of "usm_appuser" Table
Name Datatype Null Option Comment
appuser_id varchar(50) NOT NULL application user ID
user_id nvarchar(100) NULL User ID of the user
app_loginid varchar(50) NULL Place holder to store the login attribute for the external application
schema_id int NULL handle to usm_schema table
expire_time datetime NULL expiration time
host_id varchar(50) NULL handle to usm_host
label varchar(64) NULL Label for the application user
param_input_user varchar(50) NULL For storing other user input data
password varchar(128) NULL password for the external application in binary value
runtime_application_id varchar(50) NULL handle to usm_runtime_application
app_domain varchar(64) NULL Place holder to store the domain attribute for the external application
use_password int NULL Flag indicating the ican user password should be used or not
Column(s) of "usm_asset" Table
Name Datatype Null Option Comment
asset_id varchar(50) NOT NULL Asset ID
asset_parent_id varchar(50) NULL Asset Parent ID
is_folder int NULL Defines the asset type - true: folder asset, false: file asset
path varchar(256) NULL file or folder path for the asset resource
url varchar(256) NULL url for the asset resource, if it has one
file_name varchar(64) NULL Defines the name for the asset
description varchar(128) NULL Description of the asset
created_date datetime NULL asset create date
modified_date datetime NULL asset modified date
is_system int NULL Defines wheither the asset is a system created one
icon_used varchar(256) NULL Defines the icon information for the user defined.
keywords varchar(64) NULL Keywords for the asset
mime_type varchar(32) NULL information the type for the file asset
file_size int NULL size of the file asset
tenant_id varchar(50) NULL Tenant ID who created asset
parent_tenant_id varchar(50) NULL Parent tenant ID of the tenant who created the asset
user_id varchar(50) NULL User ID who created the asset
locked int NULL
Defines the lock status,  whether the other user can claim the asset or not.
lockout_time datetime NULL Defines the lockout_time if the asset has been locked.
owner varchar(50) NULL asset owner
object_type integer NULL Indicates type of asset(usm document). Type=100 indicates a request attachment.
object_id integer NULL If object type is 100(request), Object ID stores Request ID for request folder/attachments, -1 for root request folder. Object ID is null otherwise.
lock_token varchar(256) NOT NULL Used to store WebDAV lock token when document is being edited
Column(s) of "usm_attr_reference_plugin" Table
Name Datatype Null Option Comment
attr_reference_plugin_id integer NOT NULL Unique identifier identifying the plugin
name varchar(50) NULL Descriptive name of the plugin
type varchar(20) NULL
Identifies the type of plugin.
- Java
plugin varchar(255) NULL The java class implementing the plugin. Could possibly also be C++ libraries.
Column(s) of "usm_attr_reference_plugin_attr" Table
Name Datatype Null Option Comment
attr_reference_plugin_attr_id integer NOT NULL Identifier for the metic_reference_plugin_attribute
name varchar(100) NULL Name of the attribute
value varchar(255) NULL The value
attr_reference_plugin_id integer NULL Unique identifier identifying the plugin
Column(s) of "usm_billing_account" Table
Name Datatype Null Option Comment
account_no varchar(50) NOT NULL The account number associated to the billing_account.
account_label nvarchar(128) NOT NULL This is the displayable name of the account
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
account_type integer NOT NULL 0=Open Item, 1=Balance Forward
billing_type integer NULL 0=Billable, 1=Chargeback, 2= Resource
credit_amount float NULL The account balance is derived from subtracting debit_amount from credit_amount
debit_amount float NULL The account balance is derived from subtracting debit_amount from credit_amount
opened_date date NOT NULL The date the billing_account record is created
closed_date date NULL This really means the date the status of account changed
billing_cycle nvarchar(50) NOT NULL Daily, Weekly, or Monthly
billing_cycle_date date NOT NULL This now represents the billing period TO date.
billing_cycle_interval integer NOT NULL An integer specifying the intervals of the billing cycle. For instance a billing_cycle=Monthly and billing_cycle_interval=1 would be a Monthly billing cycle, a billing_cycle=Monthly and billing_cycle_interval=3 would be a quaterly billing cycle, etc. A Daily billing cycle can only have 1 for its billing_cycle_interval
last_invoice_date date NULL This now represents the billing period FROM date.
invoice_sent_date date NULL This now represents the date of when the last time an invoice was generated for this account.
bill_date date NULL The date that an invoice should be generated for this account for the billing period specified in billing_cycle_date and last_invoice_date.
invoice_method nvarchar(50) NOT NULL Email, Fax, Postal, or Printer
payment_method nvarchar(50) NULL PrePay is the only value we currently support
status integer NOT NULL 1=deleted, 0=closed, 1=open, 2=suspended, 3=closed requested. A status of deleted is a soft deleted, it simply means the account and all it
status_reason nvarchar(128) NULL Generic item to state the reason for current state.
days_due_default int NOT NULL The number of days that will be added to the invoice date of the account
grace_days integer NOT NULL Currently not used.
notification_days integer NOT NULL Currently not used.
notification_method nvarchar(50) NOT NULL Currently not used.
notify_stmt_sent integer NOT NULL Currently not used.
notify_stmt_method nvarchar(50) NOT NULL Currently not used.
notify_stmt_to integer NOT NULL Currently not used.
notify_stmt_id nvarchar(50) NOT NULL Currently not used.
automatic_invoicing integer NOT NULL a 1 indicates this account should be automatically invoiced by being picked up in the next bill run if all other billing criterias for the bill run are satisfied. Changing this field to 0 is the quickest and easiest way to exclude this account from all bill runs.
summarize_statements integer NOT NULL Currently not used
taxable integer NOT NULL Currently not used
purchase_order_no nvarchar(30) NULL Generic item that can be used in integration.
payment_applied_method integer NOT NULL Currently not used
revenue_sharing_account integer NULL Currently not used. Not likely to ever really be used.
aggregate integer NULL 0=does not contribute it
aggregation_type integer NULL if the aggregate value = 2, then this field would specify the type of aggregation that should occur. 0=Total accounts, 1=Total charges.
text_1 nvarchar(100) NULL This column is not used
text_2 nvarchar(50) NULL This column is not used
enum_1 integer NULL This column is not used
last_transaction_id integer NOT NULL id of last transaction.
last_payment_id integer NOT NULL id of last payment.
last_statement_id integer NOT NULL id of last statement generated.
comments nvarchar(128) NULL used only in the billing profile gui
sub_billing_info nvarchar(128) NULL Currently not used. Not likely to ever really be used.
sub_billing_info_id integer NULL Currently not used. Not likely to ever really be used
domain varchar(50) NULL Domain to which this account belongs.
currency_type_code varchar(3) NULL The associated currency type.
Column(s) of "usm_billing_group" Table
Name Datatype Null Option Comment
group_id int NOT NULL Unique id assigned to the group.
domain varchar(50) NOT NULL The domain to which the group belongs.
time_zone_code varchar(64) NOT NULL Timezone shared by all associated accounts.
report_data_id varchar(50) NULL Unique identifier for the report data object. The unique identifier is assigned when the report data is saved.
name nvarchar(64) NULL Display name for the group.
type bit NULL
0=account lists are statically generated.
1=account lists are dynamically generated.
automatic_invoicing bit NULL
0=inactive
1=active
billing_cycle nvarchar(50) NOT NULL The billing cycle shared by all associated accounts.
billing_cycle_interval int NULL The interval between cycles.
last_invoice_date datetime NULL The period start date.
billing_cycle_date datetime NULL The period end date.
bill_date datetime NULL Bill run date.
days_due_default int NULL Default days due for associated accounts.
comment nvarchar(128) NOT NULL Text area for description.
comments nvarchar(128) NULL Text area for description.
Column(s) of "usm_branding_template" Table
Name Datatype Null Option Comment
branding_template_id varchar(50) NOT NULL branding template unique ID
tenant_id varchar(50) NOT NULL Tenant ID, which is related to the branding template.
is_default int NOT NULL whether the template is the default template for the tenant
branding_template_parent_id varchar(50) NULL branding template unique ID
is_shared int NULL Specifies if the branding template is shared a shared one or not private
description varchar(128) NULL description for the template
Column(s) of "usm_branding_variable" Table
Name Datatype Null Option Comment
variable_id varchar(50) NOT NULL The unique id for the branding variable
branding_template_id varchar(50) NOT NULL Handle to the branding template id
tenant_id varchar(50) NOT NULL Tenant ID, which is related to the branding template.
is_default int NOT NULL whether the template is the default template for the tenant
type varchar(256) NOT NULL Type of variable, PASS1_PATH, PASS2_PATH, INLINE etc
value nvarchar(256) NOT NULL Value for the branding variable
Column(s) of "usm_bus_queue" Table
Name Datatype Null Option Comment
time_stamp date NOT NULL time the real time event occurred.
dest varchar(64) NULL destination of sla real time event.
result_string varchar(1900) NULL encoded metric request class , with an embedded result in string format.
metric_instance_id int NULL Unique identifier
Column(s) of "usm_cache" Table
Name Datatype Null Option Comment
cache_id varchar(50) NOT NULL Cache object unique ID
use_cache int NULL flag for the cache is on or off
args_critical int NULL Determines if the arguments are critical for caching
refresh_time int NULL refresh duration time for the cache object
timeout int NULL time duration for cache object
hash_key varchar(64) NULL A system generated key for caching
Column(s) of "usm_cache_listener" Table
Name Datatype Null Option Comment
cache_id varchar(50) NOT NULL cache object ID, handle to the usm_cache table
cache_listener varchar(64) NOT NULL event listener names per the cache object
Column(s) of "usm_calendar" Table
Name Datatype Null Option Comment
calendar_oid varchar(256) NOT NULL Unique identity of the calendar
name nvarchar(50) NOT NULL Name of the calendar
description nvarchar(255) NULL Description
status c(1) NULL Status of the calendar.
Column(s) of "usm_calendar_category" Table
Name Datatype Null Option Comment
calendar_category_oid varchar(20) NOT NULL Calendar category identity
event_category_oid varchar(256) NULL The event category identity
calendar_oid varchar(256) NULL The calendar identity
Column(s) of "usm_cat_application" Table
Name Datatype Null Option Comment
application_id int NOT NULL ID of the application metric package
name varchar(64) NULL Name of the application metric package
description varchar(128) NULL Description of the application metric package
major_version varchar(20) NULL Major Version information
minor_version varchar(20) NULL Minor Version information
Column(s) of "usm_cat_event_type" Table
Name Datatype Null Option Comment
event_id int NOT NULL
The unique identity of the event type.

event_id < 100 000 is statically defined

dynamically defined event_ids should start at 100 000
name nvarchar(256) NOT NULL The name of the event type
label nvarchar(256) NOT NULL label of the event type
Column(s) of "usm_cat_link_app_metric" Table
Name Datatype Null Option Comment
application_id int NOT NULL ID of the application metric package
metric_id integer NOT NULL Unique identity identifying the metric category
Column(s) of "usm_cat_link_event_metric" Table
Name Datatype Null Option Comment
metric_id integer NOT NULL Unique identity identifying the metric category
event_id int NOT NULL
The unique identity of the event type.

event_id < 100 000 is statically defined

dynamically defined event_ids should start at 100 000
Column(s) of "usm_cat_metric" Table
Name Datatype Null Option Comment
metric_id integer NOT NULL Unique identity identifying the metric category
name varchar(64) NULL Name of the metric category
comments nvarchar(256) NULL  
metric_type int NULL
metric cateogryattribute to control the metric request creation user interface restrictions for the metric.   

Supported values are:

0 - Do not display component selection and display target host selection
1 - Allow only one component selection and display target host selection
2 - Allow multiple component selection and display target host selection
3 - Force all components to be selected and display target host selection
4 - (reserved)
5 - Do not display component and target host selections
6 - Allow only one component selection and do not display target host selection
7 - Allow multiple component selection and do not display target host selection
8 - Force all components to be selected and do not display target host selection
9 - Uses SMA metric attribute model
10 - SMA import metrics
metric_version int NULL Versioning info
user_dependent int NULL
attribute that identifies whether or not this metric is user-based.  Supported values are:
1 - user dependent metric
0 - non - user dependent metric
charge_type int NULL
attribute used by Accounting to determine if the metric provides for chargeback.  

1 indicates chargeback metric
0 indicates non-chargeback metric.
unittype_id int NULL Unique identity for this unit type
Column(s) of "usm_cat_unittype" Table
Name Datatype Null Option Comment
unittype_id int NOT NULL Unique identity for this unit type
name nvarchar(128) NULL The name of the unit type
description varchar(128) NULL A description
metric_result varchar(20) NULL  
Column(s) of "usm_collection_profile" Table
Name Datatype Null Option Comment
collection_profile_id int NOT NULL The identity of the collection profile
name varchar(50) NOT NULL The name of the profile
Column(s) of "usm_collection_profile_attrs" Table
Name Datatype Null Option Comment
collection_profile_metric_id integer NOT NULL Unique identity of the collection profile metric
metric_attr_spec_id integer NOT NULL Unique identifier for the metric attribute specification for the given attribute
value nvarchar(100) NULL The value of the attribute
Column(s) of "usm_collection_profile_metric" Table
Name Datatype Null Option Comment
collection_profile_metric_id integer NOT NULL Unique identity of the collection profile metric
collection_profile_id int NULL The identity of the collection profile
metric_id int NULL The identity of the metric
agent_host_id integer NULL Unique identifier for one slm server, which in this case should be a DC Hub.
description nvarchar(128) NOT NULL  
Column(s) of "usm_collector" Table
Name Datatype Null Option Comment
collector_id int NOT NULL Unique identity of the collector type
name varchar(64) NULL Name of the collector type
type varchar(20) NULL Type classification. Identifies whether the collector is OS specific, whether is monitors the local system or can monitor remote systems. OS, local, remote
parent_collector int NULL Unique identity of the collector type
Column(s) of "usm_comp_instance" Table
Name Datatype Null Option Comment
comp_instance_id varchar(50) NOT NULL Unique identity of the component instance.
dest_host_id int NULL The target host used by the component
comment varchar(64) NULL A comment, if available on the component instance.
name varchar(64) NULL The name, if available, of the component instance
sm_component_id varchar(50) NULL Identifies the schema & component to which this component instance belongs.
inst_host_id integer NULL The host where this component instance is installed.
schema_instance_id varchar(50) NULL The schema instance to which this component belongs
comments nvarchar(64) NULL  
Column(s) of "usm_configuration" Table
Name Datatype Null Option Comment
group_name nvarchar(50) NOT NULL configuration is split into the following groups: billingprofile=the default values for any new billing profiles created, statementengine=values that control how billing runs behave, scheduler=will soon be removed and replaced by billing groups, system=configuations defined at the system level (ex: posting events) these are only visible to the SP, invoicemethods=supported invoicing send methods, paymentmethods=supporte payment types, billingcycles=supported billing cycles, general=general configuration (ex: default post payment method) that are visible to all SP and ST.
name nvarchar(50) NOT NULL the name of the configuration parameter
domain varchar(50) NOT NULL domain group which is related to the configuration
data_type int NOT NULL 0=integer, 1=float, 2=boolean, 3=string, 4=object, 5=time stamp, 6=date stamp, 7=date/time stamp
is_visible integer NOT NULL 1=show in configuration gui, 0=hide
value nvarchar(2000) NULL the value of the configuration parameter
component_id integer NULL what component uses this configuration. ex: iCanBill, catalog, etc. Used only for maintenance as of now.
aclinfo varchar(128) NULL Access Control List like 111,114 etc
product_code nvarchar(64) NOT NULL Product Code like USV, USF etc
widget_type int NULL This column is not used
value_list ntext NOT NULL This column is not used
Column(s) of "usm_contact_domain" Table
Name Datatype Null Option Comment
domain varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
user_id nvarchar(100) NOT NULL  
authorization_level integer NULL  
Column(s) of "usm_contact_domain_role" Table
Name Datatype Null Option Comment
domain varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
role_id varchar(50) NOT NULL The unique identifier for the role, Eg: spadministrator, enduser etc
user_id nvarchar(100) NOT NULL  
default_domain int NOT NULL  
Column(s) of "usm_contact_extension" Table
Name Datatype Null Option Comment
user_id nvarchar(100) NOT NULL  
locale_code varchar(4) NULL locale code is the code for particular locale, Eg- us_en for united states english, cn_zh for simplified chinese
time_zone_code varchar(64) NULL time zone code is the code for a particular time zone, Eg- EST, PST etc
data1 nvarchar(512) NOT NULL  
data2 nvarchar(512) NOT NULL  
data3 nvarchar(512) NOT NULL  
data4 nvarchar(512) NOT NULL  
data5 nvarchar(512) NOT NULL  
data6 nvarchar(512) NOT NULL  
data7 nvarchar(512) NOT NULL  
Column(s) of "usm_content_pack" Table
Name Datatype Null Option Comment
id varchar(64) NOT NULL unique id of the content pack
tenant_id varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
name nvarchar(256) NOT NULL name of the content pack folder
version varchar(32) NOT NULL version number of the content pack
prompt nvarchar(2000) NOT NULL prompt message to be displayed during import of the content pack
description nvarchar(2000) NOT NULL description of the content pack
author nvarchar(512) NOT NULL author of the content
status int NOT NULL Enabled -1 (Default), Disabled -0
Column(s) of "usm_content_pack_tracking" Table
Name Datatype Null Option Comment
content_pack_id varchar(64) NOT NULL unique id of the content pack
tracking_id binary NOT NULL tracking id which maps to the uuid in the usm_import_export_mapping table
tenant_id varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
Column(s) of "usm_contract" Table
Name Datatype Null Option Comment
contract_id int NOT NULL Unique identity for the contract
expiredate datetime NULL Expire date for the contract
report_interval int NULL
Reporting interval. 

SLO's are checked for breaches for each reporting interval.
report_offset varchar(256) NULL  
start_date datetime NULL Start date of contract
status int NULL Active, Pending, Cancelled
description varchar(128) NULL Description of contract
account_id varchar(50) NULL Associated account id
tenant_id varchar(50) NULL Associated tenant id
contract_type varchar(20) NULL
Used to indicate hidden contracts that represents report groups. NULL indicates normal contract

'SMA' indicates SMA created contracts
service_hours varchar(100) NULL
Specification of service hours:

# separated list of HH:MM times where HH is hours and MM is minutes.

Starts with sunday and ends with saturday.
last_update datetime NULL  
Column(s) of "usm_contract_action" Table
Name Datatype Null Option Comment
contract_action_id int NOT NULL Unique identity
contract_id int NULL Contract identity
slo_instance_id int NULL Associated slo instance identity
rule_id varchar(50) NULL non-displayable id used in the backend as a reference between tables.
user_id nvarchar(100) NOT NULL  
Column(s) of "usm_cor_data" Table
Name Datatype Null Option Comment
cor_data_id int NOT NULL
cor_data_id - a sequential id for the data element.
metric_id int NULL The identity of the metric. the metric capable of measuring such objects. If NULL, it is a folder, and therefore has something below it. The metric name of the metric should be sent in the ObjectGet call to the COR
server_id integer NULL the id of the COR gateway server.
parent_path varchar(50) NOT NULL a slash separated path of cor_data_id representing the tree
level int NULL

 level - the level in the tree (0 is a root node).
label nvarchar(255) NOT NULL
).
 label - the label for the data element.
icon nvarchar(256) NOT NULL

 icon - name of icon to display.
tree_level int NULL  
Column(s) of "usm_cor_dynamic" Table
Name Datatype Null Option Comment
cor_dynamic_id int NOT NULL  
server_id integer NOT NULL Unique identifier for one slm server
metric_id int NOT NULL The identity of the metric
class_name varchar(255) NOT NULL  
bpv_uuid varchar(50) NOT NULL  
Column(s) of "usm_cor_dynamic_attr" Table
Name Datatype Null Option Comment
cor_dynamic_attr_id int NOT NULL  
cor_dynamic_id int NOT NULL  
metric_attr_spec_id integer NOT NULL Unique identifier for the metric attribute specification for the given attribute
value varchar(511) NOT NULL  
Column(s) of "usm_cor_dynamic_report_group" Table
Name Datatype Null Option Comment
cor_dynamic_report_group_id int NOT NULL  
cor_dynamic_id int NOT NULL  
report_group_id int NOT NULL Unique identity for the report group
use_calendar c(1) NOT NULL  
Column(s) of "usm_cor_metric_capability" Table
Name Datatype Null Option Comment
metric_id int NULL The identity of the metric
vendor varchar(128) NOT NULL The vendor from core
device_type varchar(255) NOT NULL The device type from cor
Column(s) of "usm_cost_pool" Table
Name Datatype Null Option Comment
cp_id integer NOT NULL Unique id for a cost pool.
domain varchar(50) NULL The domain to which the cost pool belongs.
name nvarchar(64) NOT NULL Display name for the pool.
type int NULL Type can be fixed or variable.
description nvarchar(256) NOT NULL description for the cost pool
Column(s) of "usm_cp_inclusion" Table
Name Datatype Null Option Comment
item_id integer NOT NULL the unique id for each rate item
cp_id integer NOT NULL Unique id for a cost pool.
Column(s) of "usm_das_analyses" Table
Name Datatype Null Option Comment
analysis_oid int NOT NULL  
analyzer_oid int NOT NULL  
xml long varchar NOT NULL  
Column(s) of "usm_das_analysis_summaries" Table
Name Datatype Null Option Comment
analysis_summary_oid int NOT NULL  
analyzer_oid int NOT NULL  
name varchar(50) NOT NULL  
value varchar(255) NOT NULL  
Column(s) of "usm_das_analyzer_attributes" Table
Name Datatype Null Option Comment
analyzer_attribute_oid int NOT NULL  
analyzer_oid int NOT NULL  
attribute_name varchar(50) NOT NULL  
attribute_value varchar(255) NOT NULL  
Column(s) of "usm_das_analyzer_definitions" Table
Name Datatype Null Option Comment
analyzer_definition_oid int NOT NULL  
description nvarchar(255) NOT NULL  
xml long varchar NULL  
Column(s) of "usm_das_analyzer_types" Table
Name Datatype Null Option Comment
analyzer_type_oid int NOT NULL  
analyzer_type_name varchar(100) NOT NULL UNIQUE constraints
description nvarchar(255) NOT NULL  
xml long varchar NULL  
element_category varchar(10) NOT NULL  
input_value_type_oid int NOT NULL  
output_value_type_oid int NOT NULL  
Column(s) of "usm_das_analyzers" Table
Name Datatype Null Option Comment
analyzer_oid int NOT NULL  
analyzer_type_oid int NOT NULL  
start_time int NOT NULL  
stop_time int NOT NULL  
Column(s) of "usm_dash" Table
Name Datatype Null Option Comment
dash_id varchar(64) NOT NULL Dashboard unique ID
label varchar(64) NULL Dashboard descriptive label
xsl_presentation varchar(64) NULL XSL file if the presentation is involved
full_size int NULL Specifies if full size is used
height int NULL dashboard window height
width int NULL dashboard window width
separate_window int NULL Determines if a different window is used to show the dash board contents
snapable int NULL Determines if the dash board is snapable
locked int NULL Determines if the dash board is locked
auto_arrange int NULL auto arangement turn on and off
timeout int NULL time out for retrieveing the dashboard content
tenant_id varchar(50) NULL Tenant ID is related to the dashboard
user_id nvarchar(100) NULL User ID is related to the dashboard
access_depth int NULL Defines the weither the child structure will come or not
is_default bit NULL specify whether the dashboard is default or not.
role_id varchar(50) NULL The unique identifier for the role, Eg: spadministrator, enduser etc
Column(s) of "usm_data_collector" Table
Name Datatype Null Option Comment
host_id c(18) NULL The identity of the host.
data_collector_name varchar(64) NULL  
Column(s) of "usm_db" Table
Name Datatype Null Option Comment
db_id varchar(50) NOT NULL Unique id for the db object
name varchar(64) NULL Descriptive name of the db object
status int NULL
Status of the db : Active(1) and null is active.
db_class varchar(128) NULL The class for the db driver implementation, eg- sun.jdbc.odbc.JdbcOdbcDriver
db_url varchar(256) NULL The url for the db implementation, example - jdbc:odbc:icandb-mahine1
login_id varchar(50) NULL The login id credentials to connect to the database
password nvarchar(256) NULL The password credentials to connect to the database
type varchar(20) NULL Specifies the type of the database, Eg: Oracle, Ingres
version varchar(20) NULL Specifies the version of the database, Eg: 9i, 10g etc
normalize_timestamps int NULL Specfies if the timestamps have to be normaized
dst_id varchar(30) NULL Handle to day light savings record
host_name varchar(64) NULL Hostname where the db server is installed
db_name varchar(64) NULL Name of the database
autocommit bit NULL autocommit on/off flag
time_zone_code varchar(64) NULL time zone code is the code for a particular time zone, Eg- EST, PST etc
Column(s) of "usm_dca_app_status" Table
Name Datatype Null Option Comment
metric_instance_id int NOT NULL Unique identifier
status integer NULL
status of the application.  0=down, 1=up
time_stamp int NULL time stamp for the status
Column(s) of "usm_dca_comp_status" Table
Name Datatype Null Option Comment
metric_instance_id int NOT NULL Unique identifier
event_instance_id int NULL The unique identity of the event instance
status int NULL
status of the application.  0=down, 1=up
time_stamp int NULL  
Column(s) of "usm_default_service_hours" Table
Name Datatype Null Option Comment
day_name nvarchar(50) NOT NULL
The valid day for the service hous

Values:

- monday
- tuesday
- wednesday
- thursday
- friday
- saturday
- sunday
start_time integer NULL Start time in seconds since 00:00
end_time integer NULL End time in seconds since 00:00
created integer NULL Epoch time of creation
Column(s) of "usm_dependency" Table
Name Datatype Null Option Comment
dependency_id integer NOT NULL the unique id for each rate item
dependency_type integer NOT NULL 0=tenant-offering, 1=offering-tenant, 2=subscribe offerings, 3=unsubscribe offerings, 4=enable offerings, 5=disable offerings
account_no varchar(50) NULL The account number associated to the billing_account.
is_global integer NOT NULL 1 = apply to all accounts of that tenant, any other value is currently not supported.
source_id integer NULL the id of the offering that will cause a dependent offering to be affected. For instance, subscribe to one offering may cause disabling another offering.
source_string_id varchar(128) NULL the id of the tenant that will cause a dependent offering to be affected. For instance: tenant T can only subscribe to offering O
target_id integer NULL the id of the offering that is dependent on another offering
target_string_id varchar(128) NULL the id of the tenant that is dependent on an offering
date_available date NULL currently not used.
date_unavailable date NULL currently not used.
status integer NULL 0=deleted, 1=active
enum_1 integer NULL currently not used.
enum_2 integer NULL currently not used.
enum_3 integer NULL currently not used.
enum_4 integer NULL currently not used.
text_1 varchar(128) NULL currently not used.
text_2 varchar(128) NULL currently not used.
Column(s) of "usm_dm_event_data" Table
Name Datatype Null Option Comment
event_instance_id int NOT NULL The unique identity of the event instance
time_stamp integer NOT NULL The time_stamp in epoch for the data
user_name varchar(64) NULL User name to which the data reflects
value float NULL The measured value
maximum float NULL The maximum value if reduction has been performed. Null orderwise
minimum float NULL The minimum value if reduction has been performed. Null otherwise.
reductionlevel bit NULL The reduction level. Null means no reduction
interval integer NULL
The sample interval  
no_of_samples integer NULL The number of samples in the reduction. Null means no reduction
insert_time integer NULL The inserted time in epoch
Column(s) of "usm_doctmpl_layoutlist" Table
Name Datatype Null Option Comment
document_template_id varchar(50) NOT NULL Document template unique ID
order int NOT NULL sequential number to specify the relationship order
content_order integer NOT NULL Field name "order" has been changed to "content_order"
report_layout_id varchar(64) NULL report layout ID that is related to the template
Column(s) of "usm_document_template" Table
Name Datatype Null Option Comment
document_template_id varchar(50) NOT NULL Unique ID for the document template
total_pages int NULL
n - indicates infinite value will be replaced by -1, has values
0-99
modify int NULL Flag to indicate one can modify or not
time_stamp datetime NULL The created time for the document template
comment varchar(64) NULL The desciptive comment
comments nvarchar(64) NULL
Field name "comment" has been changed to "comments" to support oracle
is_modify int NULL Flag to indicate one can modify or not
Column(s) of "usm_dst" Table
Name Datatype Null Option Comment
dst_id varchar(30) NOT NULL The unique id for the day light savings time, Eg: US, Australia_Tonga, Austalia_South
in_use int NULL If the daylight setting is used or not
start_month int NULL Starting month for this daylight savings
start_day int NULL Starting day for this daylight savings
start_dayof_week int NULL Starting day of the week for daylight savings
start_time int NULL Start time for day light savings
end_month int NULL Ending month for this daylight savings
end_day int NULL Ending day for this daylight savings
end_dayof_week int NULL Ending day of the week for daylight savings
end_time int NULL Ending time for the daylight savings
start_time_mode int NULL Start time mode for day light savings
end_time_mode int NULL End time mode for day light savings
dst_savings int NULL Day light savings
Column(s) of "usm_event_category" Table
Name Datatype Null Option Comment
event_category_oid varchar(256) NOT NULL Unique identity of the event category
name nvarchar(50) NOT NULL Name of the event category
description nvarchar(255) NULL Description of the event category
exporter_oid varchar(20) NULL The exporter to which events within this category will be exported. May be NULL
Column(s) of "usm_event_category_value" Table
Name Datatype Null Option Comment
event_category_value_oid varchar(20) NOT NULL Unique identity of the event category value
description nvarchar(255) NULL The description of the value
value nvarchar(255) NULL The value itself
event_category_oid varchar(256) NULL Unique identity of the event category
Column(s) of "usm_event_data" Table
Name Datatype Null Option Comment
event_instance_id int NOT NULL Event instance identity associated with the data
time_stamp integer NOT NULL The time_stamp in epoch for the data
user_name varchar(64) NULL User name to which the data reflects
value float NULL The measured value
maximum float NULL The maximum value if reduction has been performed. Null orderwise
minimum float NULL The minimum value if reduction has been performed. Null otherwise.
reductionlevel bit NULL The reduction level. Null means no reduction
interval integer NULL
The sample interval  
no_of_samples integer NULL The number of samples in the reduction. Null means no reduction
insert_time integer NULL The inserted time in epoch
Column(s) of "usm_event_instance" Table
Name Datatype Null Option Comment
event_instance_id int NOT NULL The unique identity of the event instance
schema_comp_id int NULL The shema component the event instance measures data for. May be NULL
event_id int NULL The event type identity
agent_host_id int NULL The agent host id
target_host_id int NULL The target host id. May be null.
Column(s) of "usm_event_instance_value" Table
Name Datatype Null Option Comment
event_instance_value_id int NOT NULL The identity of the event instance value
metric_attribute_value_id integer NULL Unique identity of the attribute value
event_instance_id int NULL The event instance to which this value belongs
Column(s) of "usm_event_type" Table
Name Datatype Null Option Comment
event_id int NOT NULL
The unique identity of the event type.

event_id < 100 000 is statically defined

dynamically defined event_ids should start at 100 000
collector_id int NULL The collector_id used to collect events of this type.
name varchar(100) NOT NULL The name of the event type
console_msg nvarchar(256) NOT NULL console message that is related to the event
event_class varchar(100) NULL The class of the DbLoader plugin used to load data into the events tables
table_name varchar(100) NULL The table name, usually event_data, or event_dataXXX to which the events are loaded.
label nvarchar(50) NOT NULL label of the event type
Column(s) of "usm_event_type_attributes" Table
Name Datatype Null Option Comment
event_id int NOT NULL Event type id to which the attributes belongs
attr_name varchar(50) NOT NULL The attribute name
attr_value nvarchar(256) NULL The attribute value
Column(s) of "usm_event_type_collector" Table
Name Datatype Null Option Comment
event_type_id int NOT NULL
The unique identity of the event type.

event_id < 100 000 is statically defined

dynamically defined event_ids should start at 100 000
collector_id int NOT NULL Unique identity of the collector type
agent_host_os varchar(20) NULL  
criteria_name varchar(20) NULL  
criteria_value varchar(20) NULL  
Column(s) of "usm_exchange_rate" Table
Name Datatype Null Option Comment
currency varchar(50) NOT NULL the value as used in iCanView that is stored in the tenant. Currently this is an integer value stored in a string field
exchange_date date NOT NULL the dat the exchange rate took affect
symbol_1 varchar(3) NOT NULL the text abbreviation of the currency (ie: USD, GBP, etc)
symbol_2 nvarchar(16) NOT NULL the actual symbo used (ie: $ )
rate varchar(64) NULL a multiplying factor
Column(s) of "usm_export" Table
Name Datatype Null Option Comment
type int NOT NULL Export Type
domain varchar(50) NOT NULL Related Domain
filename nvarchar(128) NOT NULL File Name
export_date date NULL export date
format nvarchar(10) NULL Format of the export
num_records integer NULL Number of exported records
text_1 nvarchar(50) NULL Description
date_1 date NULL Date
date_2 date NULL Date
Column(s) of "usm_exporter" Table
Name Datatype Null Option Comment
exporter_oid varchar(20) NOT NULL Unique identity of the exporter
exporter_class varchar(255) NULL Full package name and class of java class implementing the exporter
bundle_key varchar(50) NULL bundle key for exporter name
Column(s) of "usm_featured_offering" Table
Name Datatype Null Option Comment
featured_offering_id integer NOT NULL Featured Offering ID
featured_in_offering_id integer NOT NULL Featured Offering would be featured in this offering/folder
feature_type int NOT NULL
Currently supported feature types include 0 and 1 where 
  a) 0 stands for Feature offering in current folder, and, 
  b) 1 for Feature in current and children folders/offerings.
Column(s) of "usm_fiscal_period" Table
Name Datatype Null Option Comment
fp_id int NOT NULL Unique id for fiscal period.
name nvarchar(50) NULL descriptive name for the period. Ex: January 2002
year int NOT NULL the fiscal year of this period. This value can and often is different from the year specified in start_date and end_date.
start_date date NOT NULL beginning date of fiscal period
end_date date NOT NULL ending date of fiscal period
period integer NULL 0=monthly, 1=quarterly, 2=yearly
domain varchar(50) NULL Domain to which the period was defined.
Column(s) of "usm_form_attributes_schema" Table
Name Datatype Null Option Comment
attr_name varchar(256) NOT NULL Form Component Attribute Name
form_entity_type int NOT NULL Form Entity Type
attr_default_value nvarchar(4000) NULL Attribute Default Value
is_required int NOT NULL Specifies whether mandatory attribute or not. 0 = Not Mandatory, 1 = Mandatory
Column(s) of "usm_form_component_attributes" Table
Name Datatype Null Option Comment
form_comp_attr_id bigint NOT NULL Form Component Attribute Id
form_comp_id bigint NOT NULL Form Component id
attr_locale varchar(8) NOT NULL Attribute Locale
attr_name varchar(256) NOT NULL Attribute Name
attr_value nvarchar(4000) NOT NULL Attribute Value
attr_type int NULL
Attribute Type {Regular = 1, Long = 2}, default to Regular Attribute (1), if is Long Attribute, then the overflow attribute value will be in the table   usm_form_component_attrib_ext
Column(s) of "usm_form_component_long_attributes" Table
Name Datatype Null Option Comment
form_comp_attr_id bigint NOT NULL Form Component Attribute Id
attr_long_value ntext NOT NULL form attribute long value like long javascript etc
Column(s) of "usm_form_entities" Table
Name Datatype Null Option Comment
form_entity_id bigint NOT NULL Entity id
form_entity_name nvarchar(256) NOT NULL Form Entity name
tenant_id varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
form_entity_type int NOT NULL
Form entity type. 1 = Folder, 2 = Form, 3 = Column Layout, 4 = Column, 5 = Text Field, 7 = Check Box,  8 = Text Area, 9 = Select, 10 = Label, 11 = Option, 12 = Radio Group, 13 = Radio, 14 = Date, 15 = Image
last_modified datetime NOT NULL Last Modified Date
created_by binary NOT NULL  
created datetime NOT NULL Created date
is_system int NOT NULL To identify whether it is system defined entity or not. 0 = User defined, 1 = System Defined
form_entity_parent_id bigint NULL Parent entity ID of this entity
form_entity_path varchar(256) NOT NULL Form Entity Path
form_entity_position int NULL Form Entity Position
last_modified_by binary NOT NULL  
Column(s) of "usm_guinode" Table
Name Datatype Null Option Comment
guinode_id varchar(128) NOT NULL Guinode unique ID
title varchar(64) NULL desctriptive title for the guinode
label varchar(64) NULL descriptive label for the guinode
content_type int NULL 5 invoking the plugin method, 6 invoke the multi-plugin, 2 no invoking plugin
access_depth int NULL If it is 1, then assocated child guinode will be accessed, it it is 0 or null then the current node will be accessed.
keywords varchar(64) NULL Group, Locale, User, Domain
icon1 varchar(50) NULL To store icon information
icon_used int NULL specifies if customized icon is used or not, true or false
is_secured int NULL Flag to indicate if this guinode invocation is secure - not used
xsl_presentation varchar(64) NULL Relative xsl file location for presentation of xml generated by the invocation of guinode
xsl_transformation varchar(64) NULL Relative xsl file location for Transfromation of xml generated by the invocation of guinode
separate_window int NULL 0, 1; Specifies if a new window is to be opened to display the lauchpad content
type varchar(128) NULL Used for caching, specifying which context this guinode is being used
help_url varchar(256) NULL The url for accessing help information specific to this guinode
is_system int NULL Specifies if this is a system specific entity
need_login int NULL Specifies if one need to be authenticated to call this node, Eg: To bypass authentication
Column(s) of "usm_guinode_content" Table
Name Datatype Null Option Comment
guinode_id varchar(128) NOT NULL referenced guinode unigue ID
order integer NOT NULL sequential number for the one guinode if it has multiple contents
content_order int NOT NULL This specifies the order of the content, as that might be critical in processing. Column name "order" is DB keyword set, so change to content_order
content varchar(64) NULL plugin information to retrieve the content from the backend
Column(s) of "usm_hierachical_data_types" Table
Name Datatype Null Option Comment
hdt_id varchar(64) NOT NULL Id of the hierachical data
hdt_type int NOT NULL data type { resource type = 1 (default), request status=2 }
hdt_name nvarchar(256) NOT NULL name of the data
hdt_path varchar(2048) NOT NULL hierachical path to represent the data link tree
hdt_tenant_id varchar(50) NULL The unique tenantid that identifies this organization/tenant
hdt_parent_id varchar(64) NULL Id of the hierachical data
hdt_created_date datetime NOT NULL created date
hdt_last_modified_date datetime NOT NULL last modified date
hdt_created_by_uuid binary NULL user contact uuid
Column(s) of "usm_host" Table
Name Datatype Null Option Comment
host_id int NOT NULL The identity of the host.
hostname varchar(64) NULL The hostname
ip_address varchar(64) NULL The ip address of the host
description varchar(128) NULL A description of the host
comment varchar(64) NULL A comment
registered int NULL 1: Autodiscovered.
community_string varchar(64) NULL SNMP community string for the host
timeout int NULL SNMP timeout for the host
capability varchar(64) NULL Describes the capabilities of the host. net_device
host_type_id integer NULL Identifies the host type
asset_uuid tinyint(16) NULL FK to ca_asset_source table
retry int NULL This column is not used
secure_info varchar(512) NULL This column is not used
comments nvarchar(64) NULL
description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_host_element" Table
Name Datatype Null Option Comment
host_element_id int NOT NULL Unique identity for the usm_host_element
element_index int NULL Ordering of the host elements for a specific host.
type varchar(20) NULL  
oid_string varchar(64) NULL  
name varchar(64) NULL The name of the host element, for example interface name Serial2/0
address varchar(64) NULL  
host_id int NULL The identity of the host.
capability varchar(64) NULL  
Column(s) of "usm_host_type" Table
Name Datatype Null Option Comment
host_type_id int NOT NULL The identity for the host type
display_name varchar(64) NULL The name of the host type, Host, Host_AIX, Host_HPUX, Router, Switch etc.
description varchar(128) NULL A textual description of the host type
capability varchar(64) NULL The capability of the host type.
Column(s) of "usm_icon" Table
Name Datatype Null Option Comment
icon_id varchar(50) NOT NULL Unique ID
name varchar(64) NULL icon name
url varchar(64) NULL the location where the icon is located
type varchar(32) NULL descriptive type name for the icon
mime_type varchar(32) NULL file type
Column(s) of "usm_id_mapping" Table
Name Datatype Null Option Comment
domain varchar(128) NOT NULL typically the SP, but can be ST or tenant id
system_id varchar(64) NOT NULL the component that this mapping is for
object_id varchar(64) NOT NULL id of the object from the integrating component
ican_type integer NOT NULL an integer representing the type of ican object the component is trying to map to.
ican_id integer NOT NULL id of the object in ican the component is trying to map to.
change_date date NOT NULL Update date
text_1 varchar(128) NULL any additional information
Column(s) of "usm_id_pd" Table
Name Datatype Null Option Comment
id integer NOT NULL The next id for plan def table
Column(s) of "usm_id_plan" Table
Name Datatype Null Option Comment
pd_id integer NOT NULL The next plan def id for the plan table
id integer NOT NULL The next plan id for plan table
Column(s) of "usm_import_attribute" Table
Name Datatype Null Option Comment
import_attribute_id integer NOT NULL The identity of the import attribute
value varchar(255) NULL The value of the attribute
importer_instance_id integer NULL The identity of the import instance to which this attribute belongs
importer_spec_id integer NULL Specification of possible attribute values for an importer
Column(s) of "usm_import_export_mapping" Table
Name Datatype Null Option Comment
table_name varchar(64) NOT NULL ixutil import or export table name
id varchar(256) NOT NULL related ixutil import or export object ID
uuid binary(16) NOT NULL related ixutil import or export object UUID
domain varchar(50) NOT NULL related ixutil import or export tenant id
created_date datetime NULL related ixutil import or export record - first created dated
last_import_date datetime NULL related ixutil import or export record - last imported date
last_export_date datetime NULL related ixutil import or export record - last exported date
Column(s) of "usm_import_rule" Table
Name Datatype Null Option Comment
import_rule_id integer NOT NULL The import rule identiy
name varchar(100) NULL The name of the import rule
rule_string long varchar NULL The import rule itself.
importer_id integer NULL The importer, to which the rule belongs.
Column(s) of "usm_import_table_index" Table
Name Datatype Null Option Comment
table_name varchar(50) NOT NULL The name of the temporary import table
created_time integer NULL The epoch time stamp of when the table was created.
Column(s) of "usm_importer" Table
Name Datatype Null Option Comment
importer_id integer NOT NULL The unique identity of the importer
name varchar(50) NULL Unique symbolic name for the importer. Used for references on command line tools etc.
label nvarchar(50) NULL The label of the importer.
label_bundle_key varchar(50) NULL The bundle key for the label. This is used for i18n labels when label is NULL
callback_type c(1) NULL The callback type
callback_function varchar(255) NOT NULL The callback function
status c(1) NULL The status
metric_folder_id integer NULL The metric folder to which the imported metrics will be placed.
Column(s) of "usm_importer_instance" Table
Name Datatype Null Option Comment
importer_instance_id integer NOT NULL Unique identity for the importer instance
importer_id integer NULL The unique identity of the importer
server_id integer NULL Unique identifier for one slm server
Column(s) of "usm_importer_spec" Table
Name Datatype Null Option Comment
importer_spec_id integer NOT NULL Specification of possible attribute values for an importer
attribute_name varchar(50) NULL The name of the attribute
type varchar(50) NULL Defines the type of attribute, hidden, select etc.
label_bundle_key varchar(50) NULL The bundle key for the attribute label. Used if the label is not set.
label nvarchar(100) NULL The label of the attribute
default_value nvarchar(255) NULL The default value of the attribute
is_required c(1) NULL
Specifices whether the attribute is required or not.

Y - the attribute is required
N - optional attribute
importer_id integer NULL The unique identity of the importer
Column(s) of "usm_importer_spec_value" Table
Name Datatype Null Option Comment
importer_spec_id integer NOT NULL Specification of possible attribute values for an importer
value varchar(255) NOT NULL One of the values for the attribute spec
Column(s) of "usm_install" Table
Name Datatype Null Option Comment
host_id int NOT NULL The identity of the host.
product_code nvarchar(64) NOT NULL
product code are:

USV: Unicenter Service View

USA: Unicenter Service Accounting

USC: Unicenter Serviec Catalog

USM: Unicenter Service Meter

USS-BO: Unicenter Service SLM-Base Options

USS-AO: Unicenter Service SLM-Advance Options

name nvarchar(128) NOT NULL
Field name

it will contain data like

buildnumber

is_installed
value nvarchar(64) NULL field value
data_type bit NULL
Holds the Data Type for the name field

String  = 0

Integer = 1

Float   = 2

Date    = 3

Decimal = 4

Double  = 5

Binary  = 6

Column(s) of "usm_installed_component" Table
Name Datatype Null Option Comment
installed_component_id varchar(50) NOT NULL The unique id for the installed component
name varchar(64) NULL The descrive name of the installed component
type varchar(256) NULL The type of installed component, Scheduler type, Accounting type etc
Column(s) of "usm_installed_subcomponent" Table
Name Datatype Null Option Comment
installed_subcomponent_id varchar(50) NOT NULL The unique id for the installed sub component
class varchar(64) NULL The java class implementation for this sub component
comment varchar(64) NULL A decriptive comment for this component
description varchar(128) NULL Desciption of this component
comments nvarchar(64) NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_invoice_history" Table
Name Datatype Null Option Comment
invoice_history_id integer NOT NULL Unique id
start_date date NOT NULL The date the bill run associated to this invoice history record began
domain varchar(50) NOT NULL This is the tenant ID of the account
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
end_date date NULL The date the bill run associated to this invoice history record ended
status integer NOT NULL No Comment Available
phases integer NOT NULL Currently not used. Not likely to every be used again
num_invoices integer NOT NULL The number of invoices generated in the bill run or invoice on demand
total_invoices integer NOT NULL Total number of invoices to be generated that are supposed to be generated in the bill run or invoice on demand
forced integer NOT NULL Unsupported and exists for backward compatibility
debit_amount float NULL Total debits generated for all accounts in the bill run
credit_amount float NULL Total credits generated for all accounts in the bill run
system_name nvarchar(128) NOT NULL The host that ran the bill run or processed the invoice on demand
group_name nvarchar(128) NULL The billing group that the bill run processed
billing_cycle nvarchar(50) NULL Unsupported and exists for backward compatibility
billing_cycle_interval integer NULL Interval between billing cycles.
period_from_date date NULL Period start Date.
period_to_date date NULL Period end date.
bill_date date NULL Invoicing date.
days_due_default integer NULL Default days due from the account.
rollback_date date NULL Invoice Rollback Date
Column(s) of "usm_keyword" Table
Name Datatype Null Option Comment
keyword_id integer NOT NULL Unique ID for the keyword
keyword nvarchar(256) NULL keywords
Column(s) of "usm_last_analysis" Table
Name Datatype Null Option Comment
analyze_job_id integer NOT NULL Unique identity for the analyze job
period_start integer NULL The epoch start time of the analysis period.
period_stop integer NULL The epoch stop time for the period.
report_period varchar(30) NULL report period
error varchar(50) NULL error description
link varchar(100) NULL
Link to the html document containing the actual report.
Column(s) of "usm_lastid" Table
Name Datatype Null Option Comment
name varchar(50) NOT NULL a name representing an id that will be updated and referenced.
id integer NOT NULL value that represents the last id used
Column(s) of "usm_launchpad" Table
Name Datatype Null Option Comment
launchpad_id varchar(128) NOT NULL Unique ID
title varchar(64) NULL launchpad title
content_type int NULL 3, 5
menu_type int NULL
This field indicates the level of the menu item

0 = no rendering
1 = main tab
2 = sub tab
3 = vertical menu - gun handle - category
4 = vertical menu - gun handle- item
5 = vertical menu TREE (this is the root of a simple tree, so the backend would have to get all its children nodes) 

is_default bit NULL specifies the default flag
product_code nvarchar(64) NOT NULL product code
tag_name varchar(64) NULL tag name
display_intree int NULL Flag to indicate if need to be displayed in tree or not - not used for now
access_depth int NULL If it is 1, then assocated child menu will be accessed, it it is 0 or null then the current node will be accessed.
icon_used_image varchar(256) NULL if the icon used, then the image resource file name
separate_window int NULL 0, 1; Specifies if a new window is to be opened to display the lauchpad content
xsl_presentation varchar(64) NULL Relative xsl file location for presentation of xml generated by the invocation of guinode
xsl_transformation varchar(64) NULL Relative xsl file location for Transfromation of xml generated by the invocation of guinode
Column(s) of "usm_launchpad_content" Table
Name Datatype Null Option Comment
launchpad_id varchar(128) NOT NULL referenced launchpad unique ID
order integer NOT NULL sequential number for the one launchpad if it has multiple contents
content_order integer NOT NULL This specifies the order of the content, as that might be critical in processing. Column name "order" is DB keyword set, so change to content_order
content varchar(64) NULL launchpad content
Column(s) of "usm_link_account_user" Table
Name Datatype Null Option Comment
user_id nvarchar(100) NOT NULL handles the related user id
account_id varchar(50) NOT NULL handle to the account object
type int NULL Indicates if an account is a request account (type=2) or a regular account (type=1)
Column(s) of "usm_link_analysis_layout" Table
Name Datatype Null Option Comment
report_layout_id varchar(50) NOT NULL Specifies the Unique identifier for the report layout. It is created when the layout is saved
analysis_id integer NOT NULL Unique identity for the analysis
is_default binary NOT NULL default
Column(s) of "usm_link_analyze_func_metr_cat" Table
Name Datatype Null Option Comment
analyze_function_id integer NOT NULL Unique identifyer for the analyze function
metric_category_id integer NOT NULL Unique identity identifying the metric category
Column(s) of "usm_link_analyze_job_group" Table
Name Datatype Null Option Comment
analyze_job_id integer NOT NULL Unique identity for the analyze job
report_group_id int NOT NULL Unique identity for the report group
Column(s) of "usm_link_analyze_job_ticket" Table
Name Datatype Null Option Comment
service_desk_ticket_id int NOT NULL  
analyze_job_id integer NOT NULL Unique identity for the analyze job
Column(s) of "usm_link_billing_account_group" Table
Name Datatype Null Option Comment
group_id int NOT NULL The id of the accounting to which the associated account belongs.
account_no varchar(50) NOT NULL The account number associated to the billing_account.
type nvarchar(50) NOT NULL Type of the billing group link
Column(s) of "usm_link_calendar_contract" Table
Name Datatype Null Option Comment
calendar_oid varchar(256) NOT NULL Unique identity of the calendar
contract_id int NOT NULL Unique identity for the contract
Column(s) of "usm_link_contract_sla_inst" Table
Name Datatype Null Option Comment
contract_id int NOT NULL Unique identity for the contract
sla_instance_id int NOT NULL  
Column(s) of "usm_link_event_inst_metr_inst" Table
Name Datatype Null Option Comment
metric_instance_id int NOT NULL Unique identifier
event_instance_id int NOT NULL
Event instance identity  
Column(s) of "usm_link_event_metric_category" Table
Name Datatype Null Option Comment
metric_category_id integer NOT NULL Unique identity identifying the metric category
event_id int NOT NULL Event type identity
Column(s) of "usm_link_guinode_guinode" Table
Name Datatype Null Option Comment
guinode_parent_id varchar(128) NOT NULL parent guinode ID
guinode_id varchar(128) NOT NULL child guinode ID in hierarchy structure
link_order integer NOT NULL related child guinode sequential order
Column(s) of "usm_link_importer_inst_metric" Table
Name Datatype Null Option Comment
metric_id int NOT NULL The identity of the metric
importer_instance_id integer NOT NULL Unique identity for the importer instance
Column(s) of "usm_link_install_comp_subcomp" Table
Name Datatype Null Option Comment
installed_subcomponent_id varchar(50) NOT NULL The unique id for the installed sub component
installed_component_id varchar(50) NOT NULL The unique id for the installed component
Column(s) of "usm_link_launchpad_launchpad" Table
Name Datatype Null Option Comment
launchpad_parent_id varchar(128) NOT NULL parent lauchpad ID in hierarchy structure
launchpad_id varchar(128) NOT NULL child lauchpad ID in hierarchy structure
link_order integer NOT NULL related child launchpad sequential order
Column(s) of "usm_link_method_method" Table
Name Datatype Null Option Comment
method_id varchar(128) NOT NULL Plugin method unique ID
method_parent_id varchar(128) NOT NULL Plugin method unique ID
Column(s) of "usm_link_metric_schema_comp" Table
Name Datatype Null Option Comment
metric_id int NOT NULL The identity of the metric
schema_comp_id int NOT NULL Unique identity of the schema component
Column(s) of "usm_link_metric_scope" Table
Name Datatype Null Option Comment
link_metric_scope_id integer NOT NULL Identity of the metric scope link
metric_category_id integer NOT NULL Unique identity identifying the metric category
scope_id integer NOT NULL Unique identity for the scope
service_goal_id integer NULL Uniquely identifies the
Column(s) of "usm_link_mr_import_event_inst" Table
Name Datatype Null Option Comment
import_id int NOT NULL unique ID
event_instance_id int NOT NULL The unique identity of the event instance
Column(s) of "usm_link_object_keyword" Table
Name Datatype Null Option Comment
object_type varchar(32) NOT NULL Object Type
object_id integer NOT NULL Unique ID for the object
keyword_id integer NOT NULL Unique ID for the keyword
Column(s) of "usm_link_offering_ci" Table
Name Datatype Null Option Comment
offering_id integer NOT NULL the unique id for each offering.
ci_uuid byte varying(16) NOT NULL Unique CMDB Configuration Item ID.
status int NOT NULL Indicates if the mapping is active(1) or inactive(0). Mapping becomes inactive when associated CMDB CI is made inactive in CMDB.
Column(s) of "usm_link_plugin_plugintype" Table
Name Datatype Null Option Comment
plugin_type_id varchar(50) NOT NULL The unique id for the plugin type
plugin_id varchar(50) NOT NULL The unique id for the plugin
Column(s) of "usm_link_profile_hosts" Table
Name Datatype Null Option Comment
collection_profile_id int NOT NULL The identity of the collection profile
target_host_id int NOT NULL
The target host id.  
Column(s) of "usm_link_rateitem_model" Table
Name Datatype Null Option Comment
rate_item_id integer NOT NULL the unique id for each rate item
model_uuid tinyint(16) NOT NULL Stores an asset model UUID
created_date datetime NOT NULL The date when this record was created.
created_by_user_id nvarchar(100) NOT NULL The user id of the person creating this record.
Column(s) of "usm_link_report_variable_data" Table
Name Datatype Null Option Comment
report_data_id varchar(50) NOT NULL Refers to the unique identifier of the report data object
report_variable_id varchar(50) NOT NULL Refers to the unique identifier of the report variable
Column(s) of "usm_link_request_reservation" Table
Name Datatype Null Option Comment
request_id int NOT NULL related request id of the Catalog request reservation
reservation_sub_detail_id integer NOT NULL related subscription detail id of the Catalog request reservation
reservation_id varchar(64) NOT NULL related reservation id of the Catalog request reservation
reservation_form_sub_detail_id integer NULL related form subscription detail id of the Catalog request reservation
Column(s) of "usm_link_resource_outage" Table
Name Datatype Null Option Comment
calendar_oid varchar(256) NOT NULL Unique identity of the calendar
host_id int NOT NULL The identity of the host.
sla_instance_id int NOT NULL  
Column(s) of "usm_link_rtapp_account" Table
Name Datatype Null Option Comment
account_id varchar(50) NOT NULL Account ID that is related to runtime application
runtime_application_id varchar(50) NOT NULL Runtime application ID
Column(s) of "usm_link_schema_component" Table
Name Datatype Null Option Comment
smcomponent_id varchar(50) NOT NULL The unique identity of the component link
schema_comp_id integer NULL The schema component
schema_id int NULL The schema to which the component belongs
Column(s) of "usm_link_schema_inst_metr_cat" Table
Name Datatype Null Option Comment
schema_instance_id varchar(50) NOT NULL Indentifying the associated schema instance(app installed instance).
metric_category_id integer NOT NULL Unique identity identifying the metric category
Column(s) of "usm_link_schema_metr_category" Table
Name Datatype Null Option Comment
metric_category_id integer NOT NULL Unique identity identifying the metric category
schema_id integer NOT NULL Identifying the schema
Column(s) of "usm_link_schema_slo_template" Table
Name Datatype Null Option Comment
schema_id int NOT NULL The schema component
slo_template_id int NOT NULL The slo template
Column(s) of "usm_link_scope_layout" Table
Name Datatype Null Option Comment
scope_id integer NOT NULL Unique identity for the scope
report_layout_id varchar(50) NOT NULL The report layout id
Column(s) of "usm_link_server_systeminstall" Table
Name Datatype Null Option Comment
server_id int NOT NULL handle to server id
system_install_id varchar(64) NOT NULL handle to system install id
Column(s) of "usm_link_service_event" Table
Name Datatype Null Option Comment
calendar_oid varchar(256) NOT NULL Unique identity of the calendar
contract_id int NOT NULL The contract affected by the service events. Either host or contract is set, not both.
slo_instance_id int NULL  
Column(s) of "usm_link_service_event_metr_in" Table
Name Datatype Null Option Comment
service_event_id integer NOT NULL Unique identifier identifying the service event
metric_instance_id int NOT NULL Unique identifier
Column(s) of "usm_link_service_event_ticket" Table
Name Datatype Null Option Comment
service_desk_ticket_id int NOT NULL  
service_event_id integer NOT NULL Unique identifier
Column(s) of "usm_link_sla_calendar_event" Table
Name Datatype Null Option Comment
calendar_id varchar(128) NOT NULL Outage Calendar ID (Calendar ID or Business Hour ID)
event_id varchar(128) NOT NULL Outage Event ID
Column(s) of "usm_link_slo_instance_instance" Table
Name Datatype Null Option Comment
slo_instance_parent_id int NOT NULL  
slo_instance_id int NOT NULL  
Column(s) of "usm_link_slo_package_template" Table
Name Datatype Null Option Comment
slo_package_id int NOT NULL  
slo_template_id int NOT NULL
Identity of the SLO template.

Values < 1.000.000 are statically defined.

Dynamically assigned values should start at 1.000.000.
Column(s) of "usm_link_slo_template_template" Table
Name Datatype Null Option Comment
slo_template_id int NOT NULL
Identity of the SLO template.

Values < 1.000.000 are statically defined.

Dynamically assigned values should start at 1.000.000.
slo_template_parent_id int NOT NULL
Identity of the SLO template.

Values < 1.000.000 are statically defined.

Dynamically assigned values should start at 1.000.000.
Column(s) of "usm_link_subscription_asset" Table
Name Datatype Null Option Comment
request_id int NOT NULL Unique id associated to the order.
request_item_id integer NOT NULL the unique id for each subscription record
asset_uuid tinyint(16) NOT NULL Asset UUID
Column(s) of "usm_link_sysinstall_installcom" Table
Name Datatype Null Option Comment
installed_component_id varchar(50) NOT NULL handle to the installed component id
system_install_id varchar(64) NOT NULL handle to system install id
Column(s) of "usm_link_ticket_request_item" Table
Name Datatype Null Option Comment
persid varchar(30) NOT NULL
For CA's Service Desk product persid maps to the SD internal id. Other Helpdesk products 
can use persid to store something similar or to store a string representation of their id.
ref_num varchar(30) NOT NULL
For CA's Service Desk product ref_num maps to the SD external id. Other Helpdesk products 
can use ref_num to store something similar or to store an integer representation of their id.
request_item_id int NOT NULL Catalog Request Item ID that relates to the Helpdesk ticket
request_id int NOT NULL Catalog Request ID that relates to the Helpdesk ticket (parent of the Request Item ID)
Column(s) of "usm_localization_value" Table
Name Datatype Null Option Comment
localized_id varchar(64) NOT NULL identifier of localized value
obj_tbl_name varchar(64) NOT NULL related localized data table name
obj_id varchar(128) NOT NULL related localized data table identifier
locale_code vachar(8) NOT NULL language locale
attr_name varchar(256) NOT NULL related localized data field name
attr_localized_value nvarchar(1024) NULL localized value
created_date datetime NOT NULL created date
last_modified_date datetime NULL last modified date
Column(s) of "usm_meter_gui_cfg" Table
Name Datatype Null Option Comment
meter_gui_config_id varchar(50) NOT NULL Unique identity for the meter config
description varchar(128) NULL A description of the meter config
method_name varchar(64) NULL method name of the meter config
guinode_id varchar(128) NULL Associated GUI node used to provision the metric.
gui_type varchar(20) NULL
Defines the properties of the provisioning GUI.

See "Performing Resource Assignment" for more info
Column(s) of "usm_metering_package" Table
Name Datatype Null Option Comment
metering_package_id int NOT NULL Unique identity of the metering package
package_id int NULL The identity assigned to the package during import. Note. Should use only one id for a metering package.
major_version varchar(20) NULL Versioning info
minor_version varchar(20) NULL Versioning info
name varchar(64) NULL Name of the package
schema_id int NULL The schema to which the package belongs
Column(s) of "usm_method" Table
Name Datatype Null Option Comment
method_id varchar(128) NOT NULL Plugin method unique ID
guinode_id varchar(128) NULL handle to the Guinode record
name nvarchar(64) NULL java method name
class varchar(256) NULL plugin java class name
engine_id varchar(32) NULL backend engin id
description nvarchar(128) NULL description for the method
return_code varchar(32) NULL for integration
output varchar(64) NULL for integration
instance_level bit NULL engine instance level
exec_mode bit NULL for integration
is_system bit NULL specifies the system flag
Column(s) of "usm_method_input" Table
Name Datatype Null Option Comment
method_id varchar(128) NOT NULL Plugin method unique ID
input varchar(64) NOT NULL
defines the input information for the guinode  method
Column(s) of "usm_method_optional_input" Table
Name Datatype Null Option Comment
method_id varchar(128) NOT NULL Plugin method unique ID
optional_input varchar(64) NOT NULL defines optional input for the method
Column(s) of "usm_metric" Table
Name Datatype Null Option Comment
metric_id int NOT NULL The identity of the metric
major_version varchar(20) NULL Versioning info
minor_version varchar(20) NULL Versioning info
metric_category_id integer NULL Unique identity identifying the metric category
schema_id integer NULL The identity of the associated schema. May be null, in which case the metric is independent of schema.
collector_id integer NULL The collector type used to collect these metrics.
metric_folder_id integer NULL The metric folder to which this metric belongs
label nvarchar(100) NULL The label of the metric
label_bundle_key varchar(100) NULL The bundle key of the label. For out-of-the box metrics this can be used to have a i18n label for the metric.
name nvarchar(100) NULL The name of the metric.
class varchar(50) NULL
Identifies the measurement class:

- link - A link is measured.
- path - A path, multiple links, is measured
- node - A node
- none -
Column(s) of "usm_metric_analyzer" Table
Name Datatype Null Option Comment
metric_analyzer_id int NOT NULL Identity of the metric analyzer .
handler varchar(100) NOT NULL The handler for the metric analyzer.
plugin varchar(100) NOT NULL The plugin for the metric analyzer.
Column(s) of "usm_metric_analyzer_attrs" Table
Name Datatype Null Option Comment
metric_analyzer_id int NOT NULL The metric analyzer associated with the attribute
attr_name varchar(50) NOT NULL The attribute name
value varchar(512) NOT NULL The attribute value
Column(s) of "usm_metric_attr_spec" Table
Name Datatype Null Option Comment
metric_attr_spec_id integer NOT NULL Unique identifier for the metric attribute specification for the given attribute
attribute_name varchar(100) NOT NULL Name of the attribute
type varchar(20) NULL Defines the type of attribute, hidden, select etc.
label_bundle_key varchar(50) NULL The bundle key of the label. This bundle key should be used if the label field is NULL.
label nvarchar(100) NULL The label of the attribute
default_value nvarchar(255) NULL The default value for the attribute spec. If a plugin is used, the default value should be specified as NULL, and default_reference_key should be used.
default_reference_key varchar(50) NULL Reference key to the default value if reference plugins are used.
is_required c(1) NULL
Y - the attribute is required
N - optional attribute
metric_id int NULL Identifies the metric for which this attribute specification is valid.
allow_multiple_values c(1) NULL
Y - the user may enter multiple values for this attribute. 
N - only one value allowed.

A metric specification for a given metric should only contain one attribute where multiple values are allowed. This will be used to represent multiple components in r11
attr_reference_plugin_id integer NULL References the plugin used to retrieve the allowed attribute values.
tab_order integer NULL  
cor_property varchar(20) NULL Identifies GUI properties of metrics that have some instantiation data received from COR.
Column(s) of "usm_metric_attr_spec_value" Table
Name Datatype Null Option Comment
metric_attr_spec_value_id integer NOT NULL Unique identifier
metric_attr_spec_id integer NULL Unique identifier for the metric attribute specification for the given attribute
value nvarchar(100) NULL The value allowed. Should be null if attr_reference_plugins are used.
reference_key varchar(50) NULL The reference key used by the plugin to retrieve the value. Should be NULL if plugins are not used.
Column(s) of "usm_metric_attr_value" Table
Name Datatype Null Option Comment
metric_attribute_value_id integer NOT NULL Unique identity of the attribute value
value nvarchar(511) NULL The value
metric_attr_spec_id integer NULL Unique identifier for the metric attribute specification for the given attribute
reference_key varchar(20) NULL Key used by the metric_attr_plugin to retrieve the value. Should be NULL if metric_attr_reference_plugin_id is NULL
attr_reference_plugin_id integer NULL Unique identifier identifying the plugin. Should be NULL if no plugin is used.
Column(s) of "usm_metric_category" Table
Name Datatype Null Option Comment
metric_category_id integer NOT NULL Unique identity identifying the metric category
metric_type int NULL
metric cateogryattribute to control the metric request creation user interface restrictions for the metric.   

Supported values are:

0 - Do not display component selection and display target host selection
1 - Allow only one component selection and display target host selection
2 - Allow multiple component selection and display target host selection
3 - Force all components to be selected and display target host selection
4 - (reserved)
5 - Do not display component and target host selections
6 - Allow only one component selection and do not display target host selection
7 - Allow multiple component selection and do not display target host selection
8 - Force all components to be selected and do not display target host selection
9 - Uses SMA metric attribute model
10 - SMA import metrics
metric_version int NULL Versioning info
name varchar(64) NULL Name of the metric category
comment varchar(64) NULL Comment
real_time_metric int NULL
attribute that identifies whether or not this is a realtime metric.  Supported values are:

1 - realtime metric
0 - non - realtime metric
reporting_interval int NULL
The reporting interval is used to determine how frequently aggregation occurs.  This value in conjunction whit the report_interval_unit determine the length of the period between aggregations
sample_interval int NULL attribute that represents the polling interval of the data collector for this metric category
threshold float NULL The threshold value
user_dependent int NULL
attribute that identifies whether or not this metric is user-based.  Supported values are:
1 - user dependent metric
0 - non - user dependent metric
charge_type int NULL
attribute used by iCan Bill to determine if the metric provides for chargeback.  

1 indicates chargeback metric
0 indicates non-chargeback metric.
meter_gui_config_id varchar(50) NULL attribute specifying the meter_gui_config object ID used by the metering backend to determine how the metric should be provisioned
unit_type_id int NULL Identifies the unit type for the metrics of this category.
metric_analyzer_id int NULL identity of the metric analyzer used to analyze data for this metric category
comments nvarchar(256) NULL  
Column(s) of "usm_metric_folder" Table
Name Datatype Null Option Comment
metric_folder_id integer NOT NULL Metric folder identity
level integer NULL The level in the metric folder three. 0 is root.
parent_path varchar(255) NULL The parent path is a / reparated bath of identities. / means root.
label nvarchar(100) NULL The label of the folder
label_bundle_key varchar(50) NULL The bundle key label is used for i18n labels when the label itself is NULL.
schema_id int NULL The schema that represents this folder. May be null.
tree_level integer NULL  
Column(s) of "usm_metric_instance" Table
Name Datatype Null Option Comment
metric_instance_id int NOT NULL Unique identifier
comment varchar(64) NULL This is a descriptive comment on metic_instance, Example: If any special configuration is needed.
description varchar(128) NULL A description about this metric instance
destination varchar(20) NULL Destination of the metric instance. May be SLABUS:host:port, smdb etc.
enable int NULL  
end_time datetime NULL
End time, is the  date/time when the metric become inactive.
full_detail int NULL  
group_id int NULL
The code which determines what field to group by.
 0=No Group by
 1=Group by user
 2=group by DC Host
 4=group by Target Host
 8=group by Component

These values are Boolean, in order to allow a grouping code of multiple fields simultaneously.
metric_category_id integer NULL Unique identity identifying the metric category
metric_version varchar(20) NULL Metric request version
operator int NULL  
real_time_metric int NULL  
report_interval int NULL
The reporting interval is used to determine how frequently aggregation occurs.  This value in conjunction whit the report_interval_unit determine the length of the period between aggregations
requestor varchar(20) NULL The module requesting the creation of this metric instance, BILLING, METERING, SLA etc
request_type int NULL metric instance type: 0=Normal, 4=RealTime
sample_interval int NULL
The sample interval that is used to determine how frequently you would like the data collector to send events for this metric.  This value is always in seconds.
start_time datetime NULL : Start time, is the date/time when metric become active.
status int NULL status ACTIVE / INACTIVE
threshold float NULL The threshold value
unittype_id int NULL Unique identity for this unit type
user_dependent int NULL  
report_interval_unit int NULL
This is a code which determines the unit used  for the reporting interval.  
0=minutes (default)
1=hours
2=days
3=weeks
4=months
5=years
6=Day of month  (ie: the 15th day of the month)
schema_id int NULL schema associated with this metric request.
server_id integer NULL Unique identifier for one slm server
created int NULL Date of creation of metric instance in GMT epoch seconds. Field may be null if metric does not support last modified
created_by varchar(128) NULL Identifier for user or other entity (like a script, batch job, workflow) that created the metric instance. To be used as a human readable label.
last_modified int NULL
Date of last modification of metric instance in GMT epoch seconds. Modification of metric attributes, collector, event_type, event_instance and fields in metric instance it self may cause this to be set. Field is null at creation of metric instance. Field may be null if metric does not support last modified.
last_modified_by varchar(128) NULL
Identifier for user or other entity (like a script, batch job, workflow) that last modified the metric instance. To be used as a human readable label.
source_analyze_job_id integer NULL Unique identity for the analyze job
source_metric_instance_id int NULL Unique identifier
comments nvarchar(256) NULL  
analyzed_report_group_id int NULL Unique identity for the report group
Column(s) of "usm_metric_instance_appuser" Table
Name Datatype Null Option Comment
appuser varchar(50) NULL Application username
metric_instance_id integer NULL Unique identifier
Column(s) of "usm_metric_resultXXXXX" Table
Name Datatype Null Option Comment
sm_start_time datetime NULL The start time for the aggregation report interval period.
sm_end_time datetime NULL The end time for the aggregation report interval period.
sm_result float NULL The aggregated result value for this report interval.
sm_result_status int NULL
This show the result of the aggregation.  1=success, 0=failure.  A partial failure may occur, and the percentage of inaccurate data will be stored in sm_exclude.
sm_exclude integer NULL The percentage of inaccurate or unknown data which occurred during this report interval.
grouped_by varchar(256) NOT NULL When a result is aggregated, and multiple results are generated because of a group by clause, the grouped by value is stored it this field.
group_by_type int NULL This is a code, which is use by the aggregation logic to determine which field is to be use when doing the group by clause.
metric_instance_id int NULL The metric instance id that is associated with this result.
maximum float NULL If the data is reduced, this contain the maximum value of the reduced data.
minimum float NULL If the data is reduced, this contains the minimum value of the reduced data.
no_of_samples integer NULL No of samples reduced into one. Null if no reduction
reduction_level integer NULL Reduction level, 0 and Null means raw data.
Column(s) of "usm_mr_ierror" Table
Name Datatype Null Option Comment
type int NULL Type of the error, an error can be due to error in data, or error in import. 0=mr_ifile, 1=mr_import
ref_id int NULL reference id to the table mr_iref
file_row integer NULL Indicates the row which the error occurred
file_col integer NULL Indicates the column where the error occurred
status integer NULL Status of the error, listing how critical it is. 0=info, 1=warning, 2=error
err_code integer NULL Error code as the result of this error
err_text varchar(256) NULL Descriptive error details of the error
Column(s) of "usm_mr_ievent_load" Table
Name Datatype Null Option Comment
import_id int NULL unique ID
insert_time int NULL  
load_status int NULL  
load_from datetime NULL  
load_to datetime NULL  
file_id int NULL unique ID
Column(s) of "usm_mr_ievent_metric" Table
Name Datatype Null Option Comment
event_id integer NOT NULL The event id for the event metric mapping
metric_id integer NOT NULL The metric id for the event metic mapping
Column(s) of "usm_mr_ifield" Table
Name Datatype Null Option Comment
field_id int NOT NULL field number (for sorting)
table_id integer NOT NULL mr_itable.id
pos_1 int NULL file parsing start position
pos_2 integer NULL file parsing end position (for fixed-length records only - not used for now)
value_type integer NULL 0=from file, 1=static value, 2=user-defined value, 3=regular expression, 4=system variable
data_format nvarchar(32) NULL data conversion e.g. date format, picture codes (e.g. NN.NN, NNN-NNN-NNN)
value nvarchar(64) NULL static/default value
ftype_id integer NULL field type
Column(s) of "usm_mr_ifile" Table
Name Datatype Null Option Comment
id int NOT NULL unique ID
domain varchar(50) NULL domain of user who uploaded file
status integer NULL 0=uploading, 1=uploaded, 2=checking, 3=error, 4=validated, 5=remove, 6=removing, 7=deleted, 8=incomplete, 9=warning, 10=imported, 11=re-import, 12=archive, 13=archiving, 14=archived
upload_date date NOT NULL time when file is uploaded
process_date date NULL time when file is imported
user_id nvarchar(100) NULL user who uploaded the file
proc_id varchar(64) NULL importer engine ID (for future use)
server_file nvarchar(256) NULL file name on server
client_file nvarchar(256) NULL original file name
user_text nvarchar(128) NULL additional comments by user
err_code integer NULL error code
err_text nvarchar(256) NULL error details
source_id varchar(32) NULL icdb id
filter nvarchar(1024) NULL content filter on indivdual upload level
table_id integer NULL point to mr_itable
Column(s) of "usm_mr_iftype" Table
Name Datatype Null Option Comment
id integer NOT NULL field type id
name nvarchar(64) NULL descriptive name
field_name nvarchar(64) NULL table field name (used to create temp_XXX schema)
to_field varchar(64) NULL field in system: metric_id, value, account_no (for future use)
field_type integer NULL field type (0=char, 1=integer, 2=float, 3=date, 4=decimal or numner, 5=double)
field_size integer NULL field size (used to create temp_XXX schema)
field_decimal integer NULL field decimal size
mandatory integer NULL mandatory field? 0=no, 1=server mandatory, 2=client mandatory, 3=both
status integer NULL status 0=system (cannot delete), 1=active, 2=inactive
check_type integer NULL validation: 0=no check, 1=not empty, 2=range, 3=lookup, 4=lookup and replace
value_1 nvarchar(64) NULL range check (check_type=2)/lookup table name (check_type=3/4)
value_2 nvarchar(64) NULL range check (check_type=2)/lookup field name (check_type=3/4)
value_3 nvarchar(64) NULL replace field name (check_type=4)
value_4 nvarchar(64) NULL SQL where (check_type=4)
Column(s) of "usm_mr_imap" Table
Name Datatype Null Option Comment
type integer NOT NULL Type of the mapping 1=mr_iftype.id to mr_itable.file_type
mkey integer NOT NULL field type id
value integer NOT NULL value of the map
Column(s) of "usm_mr_import" Table
Name Datatype Null Option Comment
id int NOT NULL unique ID
domain varchar(50) NULL domain
name nvarchar(64) NULL descriptive name
table_name varchar(32) NULL event table name
status integer NULL process status: 0=pending, 1=processing, 2=processed, 3=error, 4=inactive
status_date date NULL last status change
priority integer NULL priority
import_type integer NULL 0=event, 1=mr_result (not used)
build_expr nvarchar(1024) NULL sql to populate events/mr_result
user_text nvarchar(128) NULL additional comments by user
table_id integer NULL mr_itable reference
event_id int NULL event id is related to the profile.
metric_id int NULL metric id is related to the profile.
Column(s) of "usm_mr_iref" Table
Name Datatype Null Option Comment
type int NULL 0=event, 1=result, 2=file
file_id integer NULL file ID
ebulk_id integer NULL used to group events data
rbulk_id integer NULL used to group results data
event_table varchar(32) NULL event table name
import_id integer NULL points to mr_import
metric_id int NULL metric id which is related to this reference
Column(s) of "usm_mr_isystem" Table
Name Datatype Null Option Comment
id integer NOT NULL ID for the system, currently it should be just 0
domain varchar(50) NULL domain for the Data mediation system (not used yet), cross domains are not supported
status integer NULL Status for the data mediation system.0=load files only, 1=import only, 2=aggregation, 3=finish!, 4=aggregation error, 5=waiting for billing to finish, 6=aggregating, 7=profiles pending, 8=profile error
status_date date NULL date/time when status changed
start_date date NULL metric start date/time
end_date date NULL metric end date/time
min_date date NULL min metric time stamp
max_date date NULL max metric time stamp
agg_mode integer NULL aggregation mode: 0=use min/max_date, 1=use start/end_date
interval varchar(16) NULL metric report interval
off_date integer NULL start day of month
etable_id integer NULL last event table name ID
file_id integer NULL last mr_ifile ID
table_id integer NULL last mr_itable ID
ftype_id integer NULL last mr_iftype ID
import_id integer NULL last mr_import ID
group_id integer NULL last group ID
proc_id integer NULL last process ID (for future use)
ebulk_id integer NULL last event table bulk_id
rbulk_id integer NULL last mr_result table bulk_id
last_agg_id integer NULL last processed bulk_id
file_path nvarchar(256) NULL upload file path (root)
Column(s) of "usm_mr_itable" Table
Name Datatype Null Option Comment
id integer NOT NULL unique ID
name nvarchar(64) NULL descriptive name
match varchar(64) NULL billing group description
table_name varchar(32) NULL event_XXX/temp_XXX table name
file_type integer NULL input file type: 0=reference file, 1=metric file, 2=assure file
file_format integer NULL input file format: 0=csv, 1=fix length, 2=database table import, 3=advanced database import
separator nvarchar(4) NULL input file data separator
status integer NULL 0=ready (simple), 1=pending, 2=ready (complex), 3=inactive
load_type integer NULL 0=add, 1=delete then add, 2=synchronize
key_cols varchar(64) NULL key column numbers in reference table
domain varchar(50) NULL domain
user_id nvarchar(100) NULL user who create the table
filter nvarchar(1024) NULL content filter, i.e. sql query or line number range and etc.
src_table varchar(64) NULL the source table name (for database import only)
source_id varchar(32) NULL handle to icdb
Column(s) of "usm_mr_itrend" Table
Name Datatype Null Option Comment
metric_id int NOT NULL Metric ID
service_code int NOT NULL catalog offering id
sm_start_time date NOT NULL start metric time
sm_end_time date NOT NULL end metric time
status integer NULL 0=no errors, 1=warning, 2=error
row_count integer NULL number of rows created in this aggregation run
rollup_value float NULL total value of rows created in this run
min_value float NULL minimum aggregation value
max_value float NULL maximum aggregation value
Column(s) of "usm_mr_ivalue" Table
Name Datatype Null Option Comment
file_id int NOT NULL handle to file_id
ftype_id integer NOT NULL handle to ftype_id
value nvarchar(64) NULL value
Column(s) of "usm_news" Table
Name Datatype Null Option Comment
news_id varchar(128) NOT NULL The unique id for the news record
delete_on_expire varchar(5) NULL Flag to purge these records, if this is true then the message will be deleted after it expires
description nvarchar(126) NULL The description of the news message
tenant_id varchar(50) NULL The domain targeted for the news message, if blank then for all domains
expire_time integer NULL The expiration time for this message
role_id varchar(256) NULL The targeted role for the message, if blank then all roles
importance varchar(10) NULL Specifies the importance of the message, URGENT, HIGH, MEDIUM, LOW, LEAST
message nvarchar(1000) NULL The actual broadcasted message
message_type varchar(50) NULL The type of the message, INTERNAL, OS, NETWORK, STORAGE
source_name nvarchar(50) NULL The source of the message, generally the userid who created the message
time_stamp date NOT NULL The message creation time stamp
user_name nvarchar(128) NULL The user name of the person who created the message.
Column(s) of "usm_note" Table
Name Datatype Null Option Comment
notes_id integer NOT NULL unique id for each note
source_type integer NOT NULL the origination of the note. Or an identifier as to where the note came from. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account
source_id integer NOT NULL currently not used.
ref_1 integer NOT NULL id of the object the note is posted to
ref_2 integer NOT NULL sub-id of the object the note is posted to. Requires that ref_1 has a value
ref_3 integer NOT NULL sub-sub-id of the object the note is posted to. Requires that ref_2 has a value
type_1 integer NOT NULL type of object specified in ref_1. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account
type_2 integer NOT NULL type of object specified in ref_3. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account
type_3 integer NOT NULL type of object specified in ref_3. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account
status integer NOT NULL currently not used
account_label nvarchar(128) NULL account label of the account this note was posted to
created_date date NOT NULL date the note was posted or modified
note_text ntext NULL note
note_type int NULL
1=approval notes, 2=fulfillment notes 
user_id nvarchar(100) NULL currently note used
account_id varchar(50) NOT NULL Account ID which this note belongs to
domain varchar(50) NULL Domain to which the notes belong.
Column(s) of "usm_numeric_policy" Table
Name Datatype Null Option Comment
policy_id varchar(30) NOT NULL Unique id.
scale int NULL The number of digits to the right of the decimal point.
rounding_mode int NULL
ROUND_CEILING - Rounding mode to round towards positive infinity. 
ROUND_DOWN - Rounding mode to round towards zero. 
ROUND_FLOOR - Rounding mode to round towards negative infinity. 
ROUND_HALF_DOWN - Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down. 
ROUND_HALF_UP - Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up. 
ROUND_UNNECESSARY - Rounding mode to assert that the requested operation has an exact result, hence no rounding is necessary. 
ROUND_UP - Rounding mode to round away from zero.
negative_symbol varchar(4) NULL Negative symbol to be used.
display_leading_zeros bit NULL Indication to display leading zeros.
type int NOT NULL
Type = 1  for quantity based
Type = 2 for currency based
min_scale int NULL minimun scale
Column(s) of "usm_object_wf_instance_ref" Table
Name Datatype Null Option Comment
object_workflow_instance_id int NOT NULL Unique ID for WF Instance ID
object_id1 int NOT NULL like Request ID
object_id2 int NULL like Request Item ID
process_instance_id varchar(256) NOT NULL related WF Process Instance ID
status int NOT NULL workflow process instance status
object_type integer NOT NULL 1=Request, others to be defined later
created_date datetime NULL created date
modified_date datetime NULL modified date
workflow_type integer NULL  
Column(s) of "usm_offering" Table
Name Datatype Null Option Comment
offering_id integer NOT NULL the unique id for each offering.
parent_id integer NOT NULL the offering_id of the parent offering, -1 means this offering is the root offering, -2 means there is no parent offering.
base_offering integer NOT NULL 1=not inherited, other wise points to an offering_id
top_base_offering integer NOT NULL 1=not inherited, other wise points to an offering_id
status integer NOT NULL 0=deleted, 1=available, 2=unavailable, 3=created, 4=cancelled
date_available date NULL set when status=1
date_unavailable date NULL set when status=2
date_created date NOT NULL set when status=3
date_cancelled date NULL set when status=4
code nvarchar(64) NULL SP/ST supplies code
offering_name nvarchar(128) NOT NULL name of the offering
description nvarchar(512) NULL description of the offering shown only in the catalog and no where else.
info_link nvarchar(128) NULL if it has a value in the form of a URL, a link will show up saying "more..." whenevery viewing the offering through the gui.
notes_id integer NULL currently not used.
selection_type integer NULL 0=none, 1=multiple. Setting this to 1 also allows a check box to appear to subscribe in the gui
is_leaf integer NULL 0=a node in the offering tree, 1=a leaf in the offering tree (ie: no children)
sort_order_type integer NOT NULL 0=no sorting, 1=sort by offering_name, 2=by selection_type, 3=by code, 4=by created_date, 5=custom (ie: a sorting number will be added to sort_order_no.
sort_order_no integer NOT NULL if sort_order_type=5 then this will have an integer value for the order in the sorted list.
sort_order integer NOT NULL 0=ascending, 1=descending
sub_note_control integer NULL currently not used.
image_file nvarchar(64) NULL name of image file to be display when viewing offering.
domain varchar(50) NOT NULL Domain to which the offering belongs.
approval_process int NOT NULL Indicates the type of approval - No Approval (0), System Approval(1) or WF Driven Approval (2)
approval_level int NULL Sets the minimum level of approval required for an offering. OOTB System Approval verifies if a user authorization is greater then or equal to offering approval level before granting approval. If not, approval flows up the management chain.
version varchar(8) NOT NULL Version number must be greater then 999. Numbers 0-999 are reserved for CA.
type int NULL Indicates if an offering is created using Catalog(type=0) or Accounting (type=1)
default_on_approval_status int NULL this holds the default status after offering is approved. The valid values are 1000 for Pending Fulfillment and 2 for Completed. The Default value is set to 2
sd_request_area varchar(30) NOT NULL maps the 'offering/rate plan/rate item' to a Service Desk Request Area
path varchar(128) NOT NULL Includes a folder ID path to an offering or a folder separated by a forward slash (/).
tree_level int NULL Includes the number of levels from the root folder.
feature_sort_order_type int NOT NULL
Featured Offerings including under an offering/folder are sorted by name, code, dates and sort number. 
(Numerical Value-Sort Order Type)
1   Offering Name
2   Offering Code
3   Offering Created Date
4   Offering Available Date
5   Sort Number
Default value for feature_sort_order_type is set to 1 for sort by offering name. 
feature_sort_order int NOT NULL
Based on the feature sort type, featured offerings can then be sorted in ascending/descending order. 
(Numerical Value-Sort Order Type)
0 Ascending, 1 Descending
 Default value for feature_sort_order is set to 0 for sort in ascending order. 
date_last_modified datetime NOT NULL
To keep a track of when the object (service offering, service option group) was last modified.

This is not nullable. The default value is same as the "date_created" value of the same record.
folder_display_type int NOT NULL Indicates whether this folder displays sub folders in the Browse Catalog section of Request Management. A value of 0 indicates System setting is used, 1 to overide system setting and show folder and 2 for hiding a folder. Note - This value is 0 for offerings and OOTB catalog content to maintain backward compatibility.
calendar_id varchar(128) NULL Associated Outage Calendar ID for offering
business_hour_id varchar(128) NULL Associated Business Hour ID for offering
Column(s) of "usm_offering_ratedef_inclusion" Table
Name Datatype Null Option Comment
id integer NOT NULL Unique id for this inclusion relationship
parent_id integer NULL the unique id for each offering.
rate_plan_id int NULL the unique id for each rate plan
child_id integer NULL the unique id for each rate item
base_id integer NOT NULL the offering_id of the base offering of the offering pointed to by parent_id
selection int NULL 1=this rate item is selected to be the default when viewing or subscribing to the offering, 0=is not the default
approval_level int NULL 0=no approval required, 1=one level of managerial approval, 2=two levels of managerial approval
approval_process int NULL
0=no approval process, 1=system, 2=workflow
Column(s) of "usm_offering_rplan_inclusion" Table
Name Datatype Null Option Comment
id int NOT NULL unique id for offerings_rateplans_inclusion
base_id integer NOT NULL the offering_id of the base offering of the offering pointed to by parent_id
parent_id integer NULL the offering_id.
child_id integer NULL the rate_plans_id of the included rate plan
Column(s) of "usm_offering_sla" Table
Name Datatype Null Option Comment
offering_sla_def_id varchar(128) NOT NULL offering sla defintion unique id
offering_id integer NULL the unique id for each offering.
item_id integer NULL the unique id for each rate item
start_status int NOT NULL If an SLA has been set up for this Rate Row, this value stores the start status for a status range to be monitored.
end_status int NOT NULL If an SLA has been set up for this Rate Row, this value stores the end status for a status range to be monitored.
wrn_millis bigint NOT NULL If an SLA has been set up for this Rate Row and this particular status range then this column shows the SLA warning time set up in the ‘Define SLA’ screen. Warning time must be less then Violation time.
vio_millis bigint NOT NULL If an SLA has been set up for this Rate Row and this particular status range then this column shows the SLA violation time set up in the ‘Define SLA’ screen.
is_option_decision_sla integer NOT NULL flag for service option level decision making sla: If the multiple request status monitoring SLAs are defined for one service option, then this flagged sla will be used whether the option level monitor value is good or bad.
is_active integer NOT NULL active/inactive
sla_def_name nvarchar(256) NULL sla definition descriptive name
sla_expectation_level integer NULL sla expectation level
created_date datetime NULL created timestamp
last_modified_date datetime NULL last modified date
Column(s) of "usm_offering_sla_history" Table
Name Datatype Null Option Comment
sla_history_id varchar(128) NOT NULL sla defintion version history unique id
sla_definition_status integer NOT NULL 1=available, 2=unavailable, 3=closed
created_date datetime NOT NULL created date of sla definition
effective_date datetime NULL effective date of sla definition
closed_date datetime NULL closed date of sla definition version
sla_version_comment nvarchar(1024) NULL description of reasoning to close sla definition version
user_id nvarchar(128) NULL user who closed the sla definition version
Column(s) of "usm_offering_sla_history_link" Table
Name Datatype Null Option Comment
sla_history_id varchar(128) NOT NULL sla defintion version history unique id
offering_sla_def_id varchar(128) NOT NULL offering sla defintion unique id
Column(s) of "usm_onetime_event" Table
Name Datatype Null Option Comment
onetime_event_oid varchar(20) NOT NULL Unique identity of the one-time event
start integer NOT NULL Start time in epoch for the one time event
duration integer NULL Durations, in seconds for the one time event
description nvarchar(255) NULL Textual description of the event
status c(1) NULL Status, 'D' - deleted, 'A' or null = active
value nvarchar(255) NULL value of the event
calendar_oid varchar(256) NULL The calendar to which this event belongs.
event_category_oid varchar(256) NULL The event category to which this event belongs
recurring_event_oid varchar(20) NULL A onetime event can be used to remove or add occurrences to a recurring event by pointing to the recurring event here.
event_category_value_oid varchar(20) NULL The event category value selected. May be null.
start_time integer NULL Start Time
Column(s) of "usm_pattern_type" Table
Name Datatype Null Option Comment
pattern_type_oid varchar(20) NOT NULL Unique identity of the pattern type
bundle_key varchar(255) NULL Bundle key used to retrieve the pattern description in i18n
scheduler_class varchar(255) NULL Fully qualified java class implementing the scheduler for this pattern type.
create_action varchar(100) NULL Not used in r11
update_action varchar(100) NULL Not used in r11
Column(s) of "usm_payment_method" Table
Name Datatype Null Option Comment
account_no varchar(50) NOT NULL The account to which payment has been made.
id integer NOT NULL Incremented integer associated to each payment.
domain varchar(50) NOT NULL This is the tenant ID of the account
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
status integer NOT NULL 1=deleted, 0=inactive, 1=active, 2=opened, 3=closed
type_1 varchar(50) NOT NULL payment plugin id, ex: Check, CreditCard, etc.
type_2 integer NULL additionaly distiguisher between payment types, ex: when type_1=CreditCard then type_2 could be AMEX, VISA, etc. In other words, this value is overloaded depending on the value of type_1.
p_name nvarchar(50) NULL Payer's name.
p_title nvarchar(50) NULL Payer's title.
p_address1 nvarchar(50) NULL Payer's address 1.
p_address2 nvarchar(50) NULL Payer's address 2.
p_city nvarchar(50) NULL Payer's city.
p_state nvarchar(50) NULL Payer's state.
p_zip nvarchar(50) NULL Payer's zip.
p_country nvarchar(50) NULL Payer's country.
p_tel nvarchar(50) NULL Payer's telephone number.
p_fax nvarchar(50) NULL Payer's fax number.
p_email nvarchar(50) NULL Payer's email address.
opened_date date NOT NULL Date of payment.
closed_date date NULL Date of completed payment.
active_date date NULL Currently not used.
inactive_date date NULL Currently not used.
enum_1 integer NULL overloaded depending on the value of type_1. Currenly no payment plugins provided out of the box uses this field, but exists for user plugins.
text_1 nvarchar(50) NULL overloaded depending on the value of type_1. ex: when type_1=Check then text_1 is check number
text_2 nvarchar(50) NULL overloaded depending on the value of type_1. ex: when type_1=Check then text_2 is the routing number
text_3 nvarchar(50) NULL overloaded depending on the value of type_1. ex: when type_1=Check then text_3 is the account number
numeric_1 float NULL overloaded depending on the value of type_1. ex: when type_1=PrePay then numeric_1 is the deposited amount
numeric_2 float NULL overloaded depending on the value of type_1. ex: when type_1=PrePay then numeric_2 is the applied amount
date_1 date NULL overloaded depending on the value of type_1. ex: when type_1=Check then date_1 is the date on the check
Column(s) of "usm_plan" Table
Name Datatype Null Option Comment
pd_id int NOT NULL Unique id for plan definition.
id int NOT NULL Unique Plan ID
src_type nvarchar(64) NULL Source type.
text_1 nvarchar(128) NULL Display text.
enum_1 integer NULL Rate item id.
enum_2 integer NULL  
enum_3 integer NULL  
numeric_1 float NULL Value associated with the plan.
Column(s) of "usm_plan_data" Table
Name Datatype Null Option Comment
fp_id int NOT NULL Unique id for fiscal period.
ps_id int NOT NULL Unique id for plan set.
cp_id integer NOT NULL Unique id for cost pool.
item_id int NOT NULL FK to usm_offering_ratedef_inclusion
type integer NOT NULL Used in determining if item is direct cost or a cost element within a cost pool.
domain varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
numeric_1 float NULL Value associated to the plan item.
Column(s) of "usm_plan_def" Table
Name Datatype Null Option Comment
pd_id int NOT NULL Unique id for plan definition.
lvl int NOT NULL Level of granularity.
lvl_type integer NOT NULL Level type: Catalog, Account, Catalog by Account
year integer NOT NULL Fiscal year.
period integer NOT NULL Period type: monthly, quarterly, yearly
start_date date NOT NULL Period start date.
end_date date NOT NULL Period end date.
set_code nvarchar(50) NOT NULL Set code associated with the definition.
activity integer NOT NULL Activity associated with the definition.
domain varchar(50) NULL The domain to which the definition belongs.
Column(s) of "usm_plan_set" Table
Name Datatype Null Option Comment
set_domain varchar(50) NOT NULL  
set_code varchar(50) NOT NULL  
name nvarchar(64) NULL  
status int NULL  
activity nvarchar(8) NULL  
src_type nvarchar(256) NULL  
description nvarchar(512) NULL Description of the plan set
Column(s) of "usm_planning_set" Table
Name Datatype Null Option Comment
ps_id int NOT NULL Unique id.
domain varchar(50) NULL Domain to which the set belongs.
name nvarchar(64) NOT NULL Display name associated to the set.
status integer NOT NULL
Specifies if plan data could be modified.
0=Locked
1=Unlocked
source integer NULL Determines where to draw data.
description nvarchar(128) NULL Set's description field.
code nvarchar(64) NOT NULL This column is not used
Column(s) of "usm_plugin" Table
Name Datatype Null Option Comment
plugin_id varchar(50) NOT NULL The unique id for the plugin
class varchar(256) NULL The java class implementation for this plugin
display_name varchar(64) NULL The readable name of the plugin
persistent int NULL If this plugin is to be persisted in memory or loaded/unloaded each time; 1 - persit; 0 - don’t persist
uuid varchar(20) NULL The unique identifier for this plugin
static int NULL Flag specifies if the implementation is static
load_on_startup int NULL Flag to specify if the plugin is to be loaded on system startup
installed_subcomponent_id varchar(50) NULL Handle to the installed subcomponent for this plugin
Column(s) of "usm_plugin_type" Table
Name Datatype Null Option Comment
plugin_type_id varchar(50) NOT NULL The unique id for the plugin type
uuid varchar(20) NULL The unique identifier for this plugin
installed_subcomponent_id varchar(50) NULL The unique id for the installed sub component
Column(s) of "usm_policy_entities" Table
Name Datatype Null Option Comment
policy_id varchar(128) NOT NULL Unique ID of the policy
policy_name nvarchar(512) NOT NULL Name of the policy
policy_description nvarchar(2048) NOT NULL Description of the Policy
policy_entity_type int NOT NULL Integer value for identifying the type of policy this is. 1 = Policy Folder, 2 = General Policy, 3 = Approval Policy
tenant_id varchar(50) NOT NULL tenant_id of the tenant in the usm_tenant table to which this policy belongs.
policy_parent_id varchar(128) NOT NULL The id of the policy entity that is the parent of this policy. The parent will be a policy that will be of the type Folder.
policy_condition ntext NOT NULL The condition of the policy. For policies of type Folder, this will be set to 'false'.
created_by binary(16) NOT NULL The contact_uuid from the ca_contact table of the user who created this policy.
created datetime NOT NULL The date and time when this policy was created.
last_modified_by binary(16) NOT NULL The contact_uuid from the ca_contact table of the user who last modified this policy.
last_modified datetime NOT NULL The date and time when this policy was last modified.
is_system int NOT NULL Value identifying if this is a system policy or not. 1 = True = System Policy, 0 = False = Not a system policy. (default is set to 0)
policy_version int NULL Version of the policy record
policy_priority int NOT NULL Value indicating the priority of this policy. 1000 = high priority, 1 = low priority. default 1000-default(default/system)
policy_status int NOT NULL Value indicating the status of this policy. 0 = active, 1 = inactive, 2 = deleted. default 0-active(active/inactive/delete)
policy_action ntext NOT NULL Serialized object representing the policy action for this policy. For policies of type Folder, the policy action will be the serialized object of the type NoOpPolicyAction. data type set to xml(sql server)/clob(oracle)
Column(s) of "usm_portal_content" Table
Name Datatype Null Option Comment
portal_content_id varchar(50) NOT NULL The unique id for the portal content
title varchar(64) NULL The descriptive title for the portal content
stylesheet_url varchar(64) NULL Relative location for the stylesheet
refresh_time int NULL Refresh time in seconds
full_size int NULL Flag indicating if the window should be opened in full screen
x int NULL The x coordinate for the new window left top corner
y int NULL The y coordinate for the new window left top corner
width int NULL width of the new window if opened
height int NULL height of the new window if opened
row int NULL
Row of the content

This Column is not used
col int NULL Column of the content
separate_window int NULL 0, 1; Specifies if a new window is to be opened to display the content
portal_template_id varchar(50) NULL Handle to portal tempalte
dash_id varchar(64) NULL Handle to the dash board
is_label bit NULL The label for the portal content
new_window int NULL New window is a flag to open a new window
params varchar(64) NULL Specifies additional parameters
is_hidden int NULL Specifies if the content is hidden or to be shown
data1 varchar(64) NULL for integration
data2 varchar(64) NULL for integration
data3 varchar(64) NULL for integration
resize int NULL Flag to specify if resizing is allowed
irow int NULL When the Auto-Arrange is checked in dashboard options, specifies the initial row where to be positioned.
Column(s) of "usm_portal_template" Table
Name Datatype Null Option Comment
portal_template_id varchar(50) NOT NULL Portal Library Unique ID
portal_template_parent_id varchar(50) NULL Parent portal ID
name varchar(64) NULL template name
description varchar(128) NULL template description
is_system int NULL Specifies if this is a system specific entity
content_type int NULL plugin method type
content_url varchar(256) NULL The url for the content display
embedded_content ntext NULL embedded content if it is used
criteria varchar(64) NULL The special criteria for the portal template
parse_content int NULL Flag to indicate if parsing is required
tag_name varchar(64) NULL The tag name for displaying the content
xsl_url varchar(256) NULL The relative location for the XSL
guinode_id varchar(128) NULL related Guinode ID
params varchar(64) NULL arguments which will be passed
embedded_xsl ntext NULL embedded xsl code
status int NULL status of the template, Eg: 1
expire_date datetime NULL expiration date
created_date datetime NOT NULL creation date
modified_date datetime NULL modified date
user_id varchar(50) NULL User who created the template
icon_used varchar(256) NULL used icon name and location
keywords varchar(64) NULL keywords for the portal template
tenant_id varchar(50) NULL Tenant ID is related to the template
parent_tenant_id varchar(50) NULL parent tenant ID is related to the tenant
asset_id varchar(50) NULL handle to the usm_asset
file_name varchar(64) NULL The file name for the portal template
authentication_url varchar(256) NULL The url for the external authentication
credentials ntext NULL Any credentials/password that is required to display the contents
label int NULL label for the template
new_window int NULL If a new window needs to be opened to show the contents
data1 varchar(64) NULL for integration
data2 varchar(64) NULL for integration
data3 varchar(64) NULL for integration
Column(s) of "usm_pwd_policy" Table
Name Datatype Null Option Comment
pwd_policy_id varchar(50) NOT NULL The unique identifier for the password policy
lockout_time int NULL The unlock time in Seconds after the user is locked
incorrect_pwd_count int NULL The maximum number of incorrect passwords before the account should be locked
first_time_change int NULL Flag indicating if the user have to change the password on first login
pwd_expire_days int NULL The number of days after which the password expires
pwd_history_count int NULL The number of last old passwords, that cannot be repeated
pwd_syntax varchar(20) NULL The perl based syntax to verify the password requirements, Too short, upper and lower comibnation etc
description varchar(128) NULL The description of the password policy
name varchar(64) NULL The readable name for the policy
Column(s) of "usm_queue_item" Table
Name Datatype Null Option Comment
queue_item_id integer NOT NULL The unique id for the queue item
created_time date NOT NULL created time stamp for this item
priority_no integer NOT NULL Priority for the item
status integer NOT NULL
status of the item:

ST_INACTIVE = 0, ST_ACTIVE = 1, ST_PROCESSING = 2, ST_PROCESSED_OK = 3, ST_PROCESSED_ERROR = 4
type varchar(50) NOT NULL
type of queue item
queue_item_name nvarchar(50) NOT NULL name of this component
group_id varchar(256) NOT NULL group id for a queue item
owner nvarchar(128) NULL owner id
start_time date NULL start time
end_time date NULL end time
delete_item integer NOT NULL delete flag for the queue item
deleted_time date NULL deleted time
item_comment nvarchar(128) NULL descriptive comments
data1 nvarchar(512) NULL information field for processing the queue item
data2 nvarchar(512) NULL information field for processing the queue item
data3 nvarchar(128) NULL information field for processing the queue item
Column(s) of "usm_queue_item_detail" Table
Name Datatype Null Option Comment
queue_item_detail_id int NOT NULL
Unique ID- detailed description of the queue item
queue_item_id integer NOT NULL Related Queue Item ID
created_time date NOT NULL Created Time
status integer NOT NULL Status of the queue item detail
status_time date NULL status time
guinode_id varchar(50) NULL related Guinode ID
label nvarchar(50) NULL
label of the queue item detail
details1 nvarchar(4000) NULL
detailed description
details2 nvarchar(256) NULL detailed description
details3 nvarchar(256) NULL detailed description
details4 nvarchar(256) NULL detailed description
details5 nvarchar(4000) NULL detailed description
owner nvarchar(128) NULL related owner
Column(s) of "usm_rate_def_ext" Table
Name Datatype Null Option Comment
id binary(16) NOT NULL Auto generated unique ID
item_id integer NULL the unique id for each rate item. item_id that referes to item_id in usm_rate_defination
ext_key varchar(128) NULL Oblicore integration item
ext_value nvarchar(512) NULL Value of Oblicore integration item
Column(s) of "usm_rate_definition" Table
Name Datatype Null Option Comment
item_id integer NOT NULL the unique id for each rate item
rate_plan_id integer NULL the unique id for each rate plan
base_id integer NOT NULL the rate item that this rate item inherits from.
association_id integer NOT NULL 1=no references, this is the associated rate_plan_id
rate_row integer NOT NULL the row position of this rate item in the rate plan
rate_col integer NOT NULL the column position of this rate item in the rate plan
code nvarchar(64) NULL SP/ST supplies code
status integer NOT NULL 0=delete, 1=active
item_text nvarchar(1024) NULL the display text of the rate item
item_type integer NOT NULL the type of the rate item. SP can create there own rate item by plugging them in and defining there own item_typ, the following are rate items provided out-of-the-box: -1=empty, 0=text, 1=header, 2=numeric range, 3=rate, 4=application, 5=agreement, 6=numeric, 7=boolean, 8=adjustment, 9=date, 10=date range, 11=day
is_hidden integer NOT NULL If set to 0 the item is subscribable and invoicable, if set to 1, then this rate item can be subscribed to but will not be included in any invoice calculations and will not appear on the invoice. If set to 2, then user will not see the rate item during subscription which means they won
notes_id integer NULL Currently not used.
info_link nvarchar(128) NULL if this contains a value in the form of a URL a "more info..." link will appear next to the rate item
currency_1 nvarchar(50) NULL The currency of the SP or ST creating this rate item.
currency_2 nvarchar(50) NULL Currently not used.
date_available date NULL the date the rate item is available for subscription and consequently invoicing
date_unavailable date NULL the date when the rate item is no longer available for subscription and consequently invoicing. If there is already a subscription to this rate item, then it will only be invoiced up to this date.
effective integer NULL This specifies when the dates_available/date_unavailable take effect for rate items already subscribed to the rate item for matters regarding invoicing. 0=beginning of an account
changeto_item_id integer NULL This value is -1 if a change to a rate item does does not create another rate item along the audit change trail. Otherwise it points to the id of another rate item.
enum_1 integer NULL See Table Comment
enum_2 integer NULL See Table Comment
enum_3 integer NULL See Table Comment
enum_4 integer NULL See Table Comment
enum_5 integer NULL See Table Comment
enum_6 integer NULL See Table Comment
enum_7 integer NULL See Table Comment
enum_8 integer NULL See Table Comment
enum_9 integer NULL See Table Comment
enum_10 integer NULL See Table Comment
enum_11 integer NULL See Table Comment
enum_12 integer NULL See Table Comment
enum_13 integer NULL See Table Comment
enum_14 integer NULL
Allocation method is : 0 default, 1 -Distribute by Subscribed Account,2- Distribute by Subscription, 3- Weighted distribution

While defining Service Option Element(SOE) if type “Application” is selected,Pricing Structure is : Susbcription Based,Cost Type : Allocate Cost is selected then the allocation method will be used
numeric_1 float NULL See Table Comment
numeric_2 float NULL See Table Comment
text_1 nvarchar(100) NULL See Table Comment
text_2 nvarchar(50) NULL See Table Comment
text_3 nvarchar(50) NULL See Table Comment
text_4 nvarchar(50) NULL See Table Comment
text_5 nvarchar(100) NULL
planning set id from  usm_planning_set table ps_id. This id is used when set is assigned.
date_1 date NULL
While Creating Service Option Group if we select type as Tiered, then while creating Service OptionElement if we select Date Range as type then date_1 is Lower bound
date_2 date NULL
While Creating Service Option Group if we select type as Tiered, then while creating Service OptionElement if we select Date Range as type then date_2 is Upper bound
sub_note_control integer NULL currently not used.
category integer NULL This field is used to logically group rate items the logical groups can be: 0=None, 1=Software, 2=Hardware. This field will be used as a field to filter in rule management to trigger different workflow
external_id nvarchar(64) NULL Stores External ID from the Rate Item Options tab.
approval_level integer NOT NULL
0=no approval required, 1=one level of managerial approval, 2=two level of managerial approval
approval_process int NULL
0=no approval process, 1=system, 2=workflow
category_class integer NULL
meta data to categories the rate item. Can you put this next to the category filed in the schema so they appear together
category_subclass integer NULL meta data to categories the rate item. Can you put this next to the category filed in the schema so they appear together
track_as_asset int NULL
0=do not track this rate item as an Argis asset, 1=track this rate item as an Argis asset
sd_request_area varchar(30) NOT NULL maps the 'offering/rate plan/rate item' to a Service Desk Request Area
enum_15 int NULL
This will be applicable to items with usm_rate_definition.item_type=4 (Application Rate Items).  The purpose is to indicate whether or not the Service Manager should create a service config for the item upon request/subscription.  If item_type=4 and enum_15=1, service config will not be created.
allowed_cancellation_state integer NULL The request status upto which cancellation for a service option is allowed
Column(s) of "usm_rate_plan" Table
Name Datatype Null Option Comment
rate_plan_id int NOT NULL the unique id for each rate plan
rate_plan_name nvarchar(128) NOT NULL name of the rate plan
rate_plan_type integer NOT NULL 0=fixed, 1=tiered
selection_type integer NOT NULL 0=no selection, 1=single selection, 2=multiple selection
status integer NOT NULL 0=deleted, 1=available, 2=unavailable, 3=created, 4=cancelled
code nvarchar(64) NULL set when status=1
date_available date NULL set when status=2
date_unavailable date NULL set when status=3
date_created date NOT NULL set when status=4
date_cancelled date NULL SP/ST supplies code
is_inherited integer NOT NULL 0=a base rate plan, 1=rate plan inherits some or all of it
has_header integer NOT NULL 0=no header rate items, 1=has header rate items
total_rows integer NOT NULL number of rows in the rate plan
total_cols integer NOT NULL number of columns in the rate plan
description nvarchar(128) NULL SP/ST admin description of the rate plan
notes_id integer NULL currently not used.
sub_note_control integer NULL currently not used.
domain varchar(50) NULL ID of the business unit to which this rate plan belongs.
folder nvarchar(64) NULL
this field holds the folder name in which a rate plan belong, it will help in organizing the rate plans in folders, we will support only 1 level deep folders.
sort_order_no int NULL Rate plan sort number is used when custom sort is used for an Offering.
sd_request_area varchar(30) NOT NULL maps the 'offering/rate plan/rate item' to a Service Desk Request Area
date_last_modified datetime NOT NULL
To keep a track of when the object (service offering, service option group) was last modified.

This is not nullable. The default value is same as the "date_created" value of the same record.
Column(s) of "usm_rateplan_inclusion" Table
Name Datatype Null Option Comment
id integer NOT NULL unique id for offerings_rateplans_inclusion
parent_id integer NULL the unique id for each offering
child_id integer NULL the rate_plans_id of the included rate plan
Column(s) of "usm_rateplan_inheritance" Table
Name Datatype Null Option Comment
id int NOT NULL unique id for rateplan_inclusion
base_id integer NOT NULL the rate plan inheriting rate items from another rate plan pointed to by base_id
item_id integer NOT NULL the unique id for each rate item
derived_id int NULL the unique id for each rate plan
Column(s) of "usm_recurring_event" Table
Name Datatype Null Option Comment
recurring_event_oid varchar(20) NOT NULL Unique identity for the recurring event
start integer NOT NULL Start time in epoch of the recurring event
expire integer NULL Expiry time in epoch of the recurring event. If NULL, the recurring event does not expire.
duration integer NOT NULL Durations in seconds, of one recurring occurrence for this recurrring event series.
description nvarchar(255) NOT NULL Description of all occurrences for this recurring event series.
value nvarchar(255) NULL Value of the event
timezone varchar(50) NULL Time zone id used to parse the pattern
pattern varchar(255) NOT NULL Pattern of the recurring event, parsed by the patter type scheduler.
calendar_oid varchar(256) NULL The calendar oid to which the recurring event belongs
pattern_type_oid varchar(20) NULL The pattern type used to parse the recurring events
event_category_oid varchar(256) NULL The event category to which occurrences of this recurring event belongs.
event_category_value_oid varchar(20) NULL Unique identity of the event category value
start_time integer NULL Start Time of the recurring event
Column(s) of "usm_report_data" Table
Name Datatype Null Option Comment
report_data_id varchar(50) NOT NULL Unique identifier for the report data object. The unique identifier is assigned when the report data is saved.
name varchar(64) NULL Human readable name of the data object
status int NULL Indicates whether the data object is active or inactive. If status is 1, the data object is active and if status is 0, the data object is inactive
type nvarchar(20) NULL Indicates the source of data
description varchar(128) NULL Detailed description of the purpose of the data object
db_id varchar(50) NULL Handle to the usm_db table
comment varchar(64) NULL Stores the comment entered when data object is created
time_stamp datetime NULL The time when the data object is created
pre_actions varchar(64) NULL Actions that have to be taken after the data is fetched from data source
query_string varchar(256) NULL The query which indicates which data should be fetched from data source
post_actions varchar(64) NULL Actions that have to be taken after the data is fetched from data source.
page_functions varchar(64) NULL Functions applied to each page of the report
report_functions varchar(64) NULL Functions applied to the entire report
fields varchar(64) NULL Specific fields to be selected when fetching data
data1 varchar(64) NULL external integration/additional data
data2 varchar(64) NULL external integration/additional data
delimiter nvarchar(20) NULL Seperates values of fields in the data
class varchar(64) NULL Class to which this data object belongs to
report_variable_string varchar(64) NULL Specifies the variables for this report
folder varchar(64) NULL Folder into which the data object is stored
owner varchar(50) NULL User who created the data object
reg_join_query_string varchar(256) NULL Select query if the data object type is registry join
pvt_row_fields varchar(64) NULL Row fields that are selected for pivoting
pvt_column_fields varchar(64) NULL Column fields by which data is grouped while pivoting
pvt_data_fields varchar(64) NULL Actual data values that are aggregated for the pivoted data
pvt_aggregate_fields varchar(64) NULL Values of data after aggregation
dblock_type int NULL Type of locking method when executing the database queries.
pvt_totals int NULL Specifies how the pivoted totals are displayed
pvt_aggregate_type int NULL Specifies how aggregation should be done
pvt_data varchar(64) NULL Stores the pivoted data
pvt_empty_cell_value varchar(64) NULL Specifies the value to be taken if cell is empty
pvt_error_value varchar(64) NULL Specifies the value to be taken if cell value is error
pvt_orig_fields varchar(64) NULL Original values of data before any pivoting
pvt_sort_order varchar(64) NULL Specifies how sorting should be done
bucket_no int NULL Specifies the number of buckets in the data
bucket_size int NULL Specifies the size of each bucket
pvt_col_sort_order varchar(64) NULL Specifies how column sort should be done
get_variables_page nvarchar(1024) NOT NULL Handle to the page displaying the variables of the data object
comments nvarchar(512) NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_report_dataview" Table
Name Datatype Null Option Comment
report_dataview_id varchar(128) NOT NULL Unique identifier for the report dataview. This is created when the dataview is saved
description varchar(128) NULL Describes the purpose of the data view
report_data_id varchar(50) NOT NULL Handle to the data object to which this dataview is associated
comment varchar(64) NULL Stores comments entered by the user when dataview is created
type nvarchar(20) NULL Specifies the type of the dataview
time_stamp datetime NULL Specifies the time when dataview is created
status int NULL Specifies the status of dataview: active or inactive
legend nvarchar(64) NULL Specifies the legend to be displayed on the chart
report_style_chart varchar(64) NULL Chart settings to be applied if dataview contains chart
report_style_table varchar(64) NULL Table settings to be applied if dataview contains table
bucket_size int NULL Specifies the number of rows to be displayed in each bucket
data1 varchar(64) NULL external integration/additional data
data2 varchar(64) NULL external integration/additional data
column_rules varchar(64) NULL Operations to be performed on each and individual column of data
dataview_type int NULL Specifies the type of dataview
dataobject_string varchar(64) NULL Specifies settings for the data object associated with the dataview
external_cmd varchar(64) NULL Store the command for external process invocation
external_file_name varchar(64) NULL Store the file name for external process invocation
external_params varchar(64) NULL Store the parameter for external process invocation
external_format varchar(64) NULL Store the format for external process invocation
external_cleanup int NULL Specify whether external cleanup is to performed
delimiter nvarchar(20) NULL Delimiter separating values of data
refresh_time int NULL Specifies how often dataview should be refreshed
print_settings varchar(64) NULL Specifies settings for printing the dataview
folder varchar(64) NULL Specifies folder in which dataview is saved
owner varchar(50) NULL Specifies user who created the dataview
get_variables_page varchar(256) NULL Handle to the page to get variables for the associated data object
pre_actions varchar(64) NULL Specifies actions to be performed before loading the dataview
post_actions varchar(64) NULL Specifies actions to be performed after loading the dataview
bucket_no int NULL Specifies the number of the page of dataview being displayed
path varchar(256) NULL Specifies path for storing offline report
file_name varchar(64) NULL Specifies filename for storing offline report
guinode_id varchar(128) NULL Specifies handle to the guinode for displaying the report
metering_string varchar(256) NOT NULL Specifies paramter for customizing the metering reports
name nvarchar(128) NULL Specifies Human readable name for the dataview
comments nvarchar(512) NOT NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_report_dataview_field" Table
Name Datatype Null Option Comment
report_dataview_id varchar(128) NOT NULL Handle to the usm_report_dataview table
field_type varchar(50) NOT NULL Define field type { CHART_XFIELDS,CHART_YFIELDS,TABLE_FIELDS,CHARTTITLE }
field ntext NOT NULL Specifies the value of field of the dataview
Column(s) of "usm_report_group" Table
Name Datatype Null Option Comment
report_group_id int NOT NULL Unique identity for the report group
parent_path varchar(255) NULL  
report_group_template_id int NULL Unique identity for the report group template from which this report group is derived.
contract_id int NULL The associated contract
name varchar(64) NOT NULL The name of the report group
description varchar(128) NOT NULL The description of the report group
level int NULL The level. Root level report groups have a level of "0".
calendar_oid varchar(256) NULL
Associated calendar for service events.

Events exported by that calendar into usm_service_events are used by analyses for this report group.

tree_level int NULL  
weight int NULL  
account_id varchar(50) NULL Unique ID of the account
time_zone_code varchar(64) NULL time zone code is the code for a particular time zone, Eg- EST, PST etc
sla_instance_id int NULL  
Column(s) of "usm_report_group_attr" Table
Name Datatype Null Option Comment
report_group_attr_id int NOT NULL  
report_group_id int NOT NULL Unique identity for the report group
report_group_attr_spec_id int NOT NULL  
value nvarchar(512) NOT NULL  
reference_key varchar(256) NOT NULL  
Column(s) of "usm_report_group_attr_spec" Table
Name Datatype Null Option Comment
report_group_attr_spec_id int NOT NULL  
attribute_name varchar(100) NOT NULL  
type varchar(256) NOT NULL  
form_type varchar(256) NOT NULL  
label nvarchar(100) NOT NULL  
label_bundle_key varchar(50) NOT NULL  
default_value nvarchar(255) NOT NULL  
default_reference_key varchar(50) NOT NULL  
is_required c(1) NOT NULL  
report_group_template_id int NULL Unique identity for the report group template
attr_reference_plugin_id integer NULL Unique identifier identifying the plugin
tab_order int NULL  
Column(s) of "usm_report_group_goal" Table
Name Datatype Null Option Comment
report_group_id int NOT NULL Unique identity for the report group
service_goal_id integer NOT NULL Uniquely identifies the
value varchar(255) NULL The value for the associated service goal for the associated report group
Column(s) of "usm_report_group_metr_instance" Table
Name Datatype Null Option Comment
report_group_id int NOT NULL Unique identity for the report group
metric_instance_id int NOT NULL Unique identifier
use_calendar c(1) NULL If 'N', the metric instance is not affected by the calendar service events. 'Y' or any other value means yes.
Column(s) of "usm_report_group_spec_value" Table
Name Datatype Null Option Comment
report_group_spec_value_id int NOT NULL  
report_group_attr_spec_id int NOT NULL  
label nvarchar(100) NOT NULL  
label_bundle_key varchar(50) NOT NULL  
value nvarchar(100) NOT NULL  
value_order int NULL  
reference_key varchar(50) NOT NULL  
Column(s) of "usm_report_group_template" Table
Name Datatype Null Option Comment
report_group_template_id int NOT NULL Unique identity for the report group template
parent_path varchar(255) NULL  
name varchar(64) NULL The name of the template
description varchar(128) NULL A description of the template
level int NULL The level of the template. Root level is 0
slo_package_id int NULL Identity of the associated slo package.
description_bundle_key nvarchar(50) NULL Bundle key for the description. This is used when the description is null. Used for i18n.
tree_level int NULL  
Column(s) of "usm_report_layout" Table
Name Datatype Null Option Comment
report_layout_id varchar(50) NOT NULL Specifies the Unique identifier for the report layout. It is created when the layout is saved
comment varchar(64) NULL Stores the comment entered by the user when layout is created
data1 varchar(64) NULL external integration/additional data
data2 varchar(64) NULL external integration/additional data
data3 varchar(64) NULL external integration/additional data
time_stamp datetime NULL Specifies the time when layout is created
folder varchar(64) NULL Specifies the folder in which layout is stored
name varchar(64) NULL Specifies the human readable name for the layout
owner varchar(50) NULL Specifies the user who created the layout
get_variables_page varchar(256) NULL Handle to get variables for the data object associated with the dataview displayed
document_string varchar(64) NULL Specifies the settings for the layout in general
external_params varchar(256) NOT NULL Specifies the external parameters string for the layout
file_name nvarchar(256) NOT NULL Specifies the file name for the layout
type nvarchar(20) NOT NULL Specifies type for the layout
status integer NULL Specifies status (available-1, created-0) for the layout
comments varchar(64) NOT NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_report_layout_obj_list" Table
Name Datatype Null Option Comment
report_layout_id varchar(50) NOT NULL Handle to the usm_report_layout table
layout_object_list ntext NULL Specifies settings for a particular component in the layout
report_dataview_id varchar(128) NULL Handle to the usm_report_dataview_table
Column(s) of "usm_report_profile" Table
Name Datatype Null Option Comment
report_profile_id integer NOT NULL Unique identity of the report profile
name nvarchar(50) NULL Name of the profile
Column(s) of "usm_report_profile_attrs" Table
Name Datatype Null Option Comment
report_profile_id integer NOT NULL Unique identity of the report profile
section varchar(50) NULL The section for the attribute
name varchar(50) NULL The attribute name
value nvarchar(2048) NULL The attribute value
Column(s) of "usm_report_profile_spec" Table
Name Datatype Null Option Comment
attribute_name varchar(50) NOT NULL Attribute name
section varchar(50) NOT NULL The section to which the attribute applies
default_value nvarchar(2048) NULL The default value for the attribute
label nvarchar(255) NULL The attribute label
label_bundle_key varchar(50) NULL The bundle key for the label. Used if label is null to create i18n labels.
help nvarchar(255) NULL Help text
help_bundle_key varchar(50) NULL Bundle key for the help text. Used if help is null to create i18n help texts
type varchar(50) NULL
The attribute type, for GUI

- check - Boolean checkbox
- entry - User is allowed to enter data
- hidden - Not shown to the user at all
- label - A simple label. Not for editing
- select - The user is presented with a selection list with the values from usm_report_profile_spec_values.
- text - Text field
tab_order integer NULL The ordering of the fields. Lowest tab order is presented first.
Column(s) of "usm_report_profile_spec_values" Table
Name Datatype Null Option Comment
attribute_name varchar(50) NOT NULL Attribute name
section varchar(50) NOT NULL The section to which the attribute applies
value varchar(2048) NULL A allowed select value for that attribute,section, and profile.
Column(s) of "usm_report_variable" Table
Name Datatype Null Option Comment
report_variable_id varchar(50) NOT NULL Unique identifier for each variable
name varchar(64) NULL Human readable name of the variable
status int NULL Specifies status of variable
type nvarchar(20) NULL Specifies the type of variable
data_type varchar(20) NULL Specifies the data type of variable
value varchar(64) NULL Specifies the value of the variable
prompt varchar(64) NULL Specifies the text to be displayed when prompting for value of variable
description varchar(128) NULL Specifies description of purpose of variable
constraints nvarchar(1280) NULL Specifies various contraints on value of variable
Column(s) of "usm_request" Table
Name Datatype Null Option Comment
request_id int NOT NULL Unique id associated to the order.
name nvarchar(128) NOT NULL Display name of order.
status integer NOT NULL The status of the order.
created_date datetime NOT NULL Date when order was initiated.
modified_date date NOT NULL Date when order was modified.
completion_date date NULL Date when order was completed.
desired_date date NULL Desired date the end user would like the order fulfilled
priority int NULL The priority associated with this order, it is primarily used for the fulfillment part.
req_for_account_id varchar(50) NULL The account number that this request is for
req_by_account_id varchar(50) NULL The account number that is creating this request
req_for_user_id varchar(50) NULL The user that this request is for
req_by_user_id varchar(50) NULL The user that is creating this request
code nvarchar(64) NULL user data
domain varchar(50) NULL Domain to which this order belongs.
location_uuid tinyint(16) NULL Location Unique ID
comments ntext NULL Comments associated to the order.
context_type int NOT NULL
This  new column is required to differentiate whether a request has been created through normal flow or through delegation of service request.  We should not allow null for this column to support backward compatability the old values should be 0
Column(s) of "usm_request_auto_delegation" Table
Name Datatype Null Option Comment
req_auto_delegation_id int NOT NULL Unique auto-generated Pending Auto Delegation ID.
delegator_id nvarchar(128) NOT NULL User ID of the person whose newly assigned request pending action(s) get auto-delegated.
delegate_id nvarchar(128) NOT NULL User ID of the delegated User. Newly assigned pending action(s) get automatically delegated from Delegator to this User.
delegation_type int NULL
This  new column is required to store the delegation type .For request auto delegation value=0 for service delegation value=1 .If any new delegation is added to request management we can assign other integer values 2,3 ,4 etc.  We should not allow null for this column to support backward compatability the old values should be 0
Column(s) of "usm_request_item_form" Table
Name Datatype Null Option Comment
subscription_detail_id integer NOT NULL the unique id for each subscription record
form_elem_name nvarchar(64) NOT NULL Includes request form element ID. Note- The form label is referenced from the related request form XML file.
form_elem_value ntext NOT NULL Includes request form element value(s).
Column(s) of "usm_request_pending_act_hist" Table
Name Datatype Null Option Comment
req_pend_act_hist_id int NOT NULL Unique auto-generated Pending Action History ID.
req_pend_act_id int NOT NULL Auto-generated unique ID.
reassigned_req_pend_act_id int NULL Auto-generated unique ID.
action_type int NOT NULL Action performed like take, return, transfer or delegate.
modified_by nvarchar(128) NOT NULL Record which user performed the action. Refers user id in CA_Contact table.
modified_date datetime NOT NULL Record when the pending action was modified (GMT)
Column(s) of "usm_request_pending_action" Table
Name Datatype Null Option Comment
request_pending_action_id int NOT NULL Auto-generated unique ID.
request_id int NULL ID of the request to which this pending action belongs.
object_id integer NOT NULL
FK to either usm_subsrcition_detail or usm_offering table this value depends on object_type field.
object_type int NULL 0=usm_subscription_detail, 1=usm_offering
process_instance_id varchar(20) NULL set to null if USF is not involved
workitem_id varchar(36) NULL set to null if USF is not involved
user_id nvarchar(100) NULL Indicates the user ID if a pending action is assigned to an individual user OR when a pending action is taken by a particular user in a group.
status integer NOT NULL 0=Assigned but not completed, 1=Completed by assigned user, 2=Completed but not by assigned user, 3=Process instance cancelled
complete_date datetime NULL store date and time workitem is completed
created_date datetime NULL This field will save the date for which the pending action is created
action_type int NULL This field will be used to indicate type of pending action. They are edit, approval or fulfillment
modified_date datetime NULL Date when this pending action was last modified.
modified_by nvarchar(128) NULL ID of the user who last modified this request.
is_group int NULL Indicates if a pending action is assigned to a user(is_group=0) or group(is_group=1)
object_group_id int NULL
-         Offering group_id will be stored in this column if object_type=1 (indicating that object_id is an offering id). 
-         This column is null if object_type=2 (indicating that object_id is a rate item id)
group_id nvarchar(100) NOT NULL Indicates the group ID if a pending action is assigned to a group. Otherwise, it is null when a pending action is assigned to an individual user.
Column(s) of "usm_request_resource_item" Table
Name Datatype Null Option Comment
resource_item_id varchar(64) NOT NULL identifier of catalog request resource item
resource_item_parent_id varchar(64) NULL parent identifier of catalog request resource item
resource_hierachical_type_id varchar(64) NOT NULL Id of the hierachical data
resource_item_status int NOT NULL status of item {CREATED(100), READY(200), CANCELLED(300), COMPLETED(400)}
resource_item_sub_detail_id integer NOT NULL related subscription detail id of the resource item
resource_item_created_date datetime NOT NULL resource item created date
resource_item_name nvchar(512) NULL resource item name
resource_item_identifier nvchar(512) NULL resource item identifier
resource_item_url nvchar(2000) NULL resource item created url
Column(s) of "usm_request_sla_instance" Table
Name Datatype Null Option Comment
sla_instance_id varchar(128) NOT NULL Request SLA Instance ID
offering_sla_def_id varchar(128) NOT NULL offering sla defintion unique id
request_id int NOT NULL Unique id associated to the order.
subscription_detail_id integer NOT NULL the unique id for each subscription record
is_sla_active integer NOT NULL sla instance active or inactive flag (Active=1/Inactive=0)
sla_status integer NULL sla instance status (Created=0/Warned=1/Violated=2/Completed=3/Paused=4/Resumed=5/Canceled=6)
time_to_warn bigint NULL remaining time upto warning
time_to_violate bigint NULL remaining time upto violation
last_event_time bigint NULL last occurred event time
next_event_time bigint NULL next occuring event time
next_event_type integer NULL next occuring event type like Outage/Warn/Violate/
created_time datetime NULL sla instance created timestamp
warned_time datetime NULL warned timestamp if sla instance is warned
violated_time datetime NULL violated timestamp if sla instance is violated
completed_time datetime NULL completed timestamp if sla instance is completed
paused_time datetime NULL paused timestamp if sla instance is stopped
resumed_time datetime NULL resumed timestamp if sla instance is resumed
canceled_time datetime NULL canceled timestamp, if request is canceled
Column(s) of "usm_request_status" Table
Name Datatype Null Option Comment
request_status_id int NOT NULL request status unique id
request_id int NOT NULL Unique id associated to the order.
subscription_detail_id integer NULL the unique id for each subscription record
status int NOT NULL Status of a request, service offeing or a service option.
status_date datetime NOT NULL Date when this status change was recorded.
user_id nvarchar(128) NULL User who initiated a status change.
status_old integer NULL stores old status ("from" status) of request status change. allowed null to support backward compatability
login_device integer NOT NULL
For Nomal system login (status updated) value = 0 (default value), PDA login (status updated) = 1. It can further extend to 2,3,4 for new type

User should either Login via PDA/System, default value 0
Column(s) of "usm_request_value" Table
Name Datatype Null Option Comment
request_id int NOT NULL Unique id associated to the order.
name varchar(50) NOT NULL filed name
value nvarchar(256) NULL filed value
type int NULL type of the field
data_type int NULL
Data type of the value,  0=string, 1=Date, 2=integer, 3=double
text_1 nvarchar(64) NULL user data
Column(s) of "usm_reservation" Table
Name Datatype Null Option Comment
reservation_id varchar(64) NOT NULL to store catalog request reservation
external_system_id varchar(64) NOT NULL identifier of an external reservation system like MRM, and DEMO1 etc
external_system_track_id nvarchar(256) NULL tracking id of an external reservation system like ticket id, or reservation id etc
status int NOT NULL status of reservation {CREATED(100), READY(200), CANCELLED(300), COMPLETED(400)}
start_date datetime NOT NULL reservation start date
end_date datetime NULL reservation end date
created_date datetime NOT NULL reservation created date
last_modified_date datetime NOT NULL reservation last modified date
Column(s) of "usm_role" Table
Name Datatype Null Option Comment
role_id varchar(50) NOT NULL The unique identifier for the role, Eg: spadministrator, enduser etc
access_depth int NULL Specifies the power of the rule, depth -1 is unlimited power for that domain scope
domain_type varchar(4) NULL For which domains is this role used, Eg: SP, ST, TE etc
name nvarchar(64) NULL The descriptive name of the role
description nvarchar(50) NULL The description of the role
domain varchar(50) NULL The unique tenantid that identifies this organization/tenant
sys_defined_group nvarchar(512) NULL System Defined Group
Column(s) of "usm_role_user" Table
Name Datatype Null Option Comment
user_id nvarchar(100) NOT NULL Related User ID
role_id varchar(50) NOT NULL Related Role ID
Column(s) of "usm_rsc_map" Table
Name Datatype Null Option Comment
id integer NOT NULL unique table id
type integer NULL 1=node relationship
parent_id integer NULL the parent node id
child_id integer NULL the child node id
Column(s) of "usm_rsc_method" Table
Name Datatype Null Option Comment
id integer NOT NULL unique table id
ds_type integer NULL data source type, 1=database, 2=registry query, 3=registry property, 4=java method
class_name varchar(64) NOT NULL registry class name or database table name
criteria varchar(256) NOT NULL the search criteria
data_source varchar(64) NOT NULL the icdb id, it allows the tree to display data from multiple data source. not used now
Column(s) of "usm_rsc_nmrefer" Table
Name Datatype Null Option Comment
id integer NOT NULL unique table id
method_id integer NULL the method id that uses the parameter
node_id integer NULL node id
seq_no integer NULL the method sequence number within one node, starts with 1
Column(s) of "usm_rsc_node" Table
Name Datatype Null Option Comment
id integer NOT NULL unique table id
type integer NULL the node type, 1=folder, 2=object
gui_action integer NULL
each bit represents a action, value 1 means yes and 0 means no.  Bit 0=expandable, 1=clickable, 2=right click able, 3=double clickable, 4=drag and drop able
name nvarchar(64) NOT NULL the folder name when type=1, object display attribute name type=2
icon_1 varchar(128) NULL the icon file name, used when the folder is closed
icon_2 varchar(128) NOT NULL the icon file name, used when the folder is open
Column(s) of "usm_rsc_parameter" Table
Name Datatype Null Option Comment
id integer NOT NULL unique table id
method_id integer NULL the method id that uses the parameter
seq_no integer NULL the parameter sequence number within one method
name nvarchar(64) NOT NULL the parameter name that matches to registry attribute name or table field name
Column(s) of "usm_rsc_property" Table
Name Datatype Null Option Comment
id int NOT NULL unique table id
node_id integer NULL the rsc_node id
type integer NULL 1=static value, 2=dynamic value
name nvarchar(64) NOT NULL the property name
value nvarchar(256) NOT NULL the property value
Column(s) of "usm_rsc_system" Table
Name Datatype Null Option Comment
id nvarchar(256) NOT NULL unique table id, there should be only one record with id=1
gui_action int NULL
each bit represents a action, value 1 means yes, 0 means no.  Bit 0=expandable, 1=clickable, 2=right click able, 3=double clickable, 4=drag and drop able
nmrefer_id integer NULL last rsc_nmrefer id
map_id int NULL last rsc_map id
parameter_id integer NULL last rsc_parameter id
method_id integer NULL last rsc_method id
property_id integer NULL last rsc_property id
node_id integer NULL last rsc_node id
Column(s) of "usm_rule" Table
Name Datatype Null Option Comment
rule_id varchar(50) NOT NULL non-displayable id used in the backend as a reference between tables.
status int NULL ACTIVE/DISABLED. A disabled rule does not get triggered when an event occurs.
display_name varchar(64) NULL Name for this rule.
description varchar(128) NULL text explaining the purpose of this rule.
is_hidden int NULL YES/NO. Any hidden rules will not be shown in the GUI. However, they will be triggered when an event corresponding to the event type this rule is subscribed for, occurs.
is_system int NULL YES/NO. iCanProvision comes with some in-built rules for certain event types such as SLA Violation etc. These are system rules.
event_type_id varchar(50) NULL non-displayable id used in the backend as a reference between tables.
type varchar(128) NULL Specifies the type of the rule
sub_type varchar(50) NULL Specifies the secondary type of the rule
start_time datetime NULL Specifies the start time of the rule activation
expire_time datetime NULL Specifies the expiration time of the rule
Column(s) of "usm_rule_action" Table
Name Datatype Null Option Comment
rule_action_id varchar(64) NOT NULL non-displayable id used in the backend as a reference between tables.
type varchar(128) NULL type of the rule action. JAVA, SHELL, HTTP etc.
action varchar(64) NULL String containing the action that needs to be executed. For example, if JAVA is selected above in the ictype field, this field contains the JAVA class name with the package qualifier. If SHELL is selected, this field contains the command that needs to be executed from a shell.
display_name varchar(64) NULL name for this action.
description varchar(128) NULL text explaining the purpose of this action.
is_system int NULL true/false. iCanProvision comes with some in-built rule actions for certain rules. These are system rule actions.
rule_id varchar(50) NULL non-displayable id used in the backend as a reference between tables.
options varchar(128) NULL Specifies the options for the rule action
exec_mode int NULL Specifies the execution mode
timeout int NULL Specifies the time out of the rule action
status int NOT NULL Specifies the status of the rule action
Column(s) of "usm_rule_condition" Table
Name Datatype Null Option Comment
rule_condition_id varchar(50) NOT NULL non-displayable id used in the backend as a reference between tables.
condition varchar(64) NULL SQL type String containing the event filter.
class varchar(256) NULL Specifies the class of rule condition
db_id varchar(20) NULL Handle to the database
description varchar(128) NULL Descriptive text for this rule condition
display_name varchar(64) NULL Display name of this condition
is_hidden int NULL If this condition is a hidden or not
is_system int NULL Specifies if this is a system manadated condition or not
type nvarchar(64) NULL table or class on which the above SQL query needs to be executed to check the condition in the event filter.
rule_id varchar(50) NULL non-displayable id used in the backend as a reference between tables.
Column(s) of "usm_rule_event_param" Table
Name Datatype Null Option Comment
event_param_id varchar(50) NOT NULL Unique Event Param ID
event_type_id varchar(50) NOT NULL non-displayable id used in the backend as a reference between tables.
event_param_name nvarchar(64) NOT NULL Name for the event parameter
event_param_data_type int NOT NULL Data type for the event parameter
Column(s) of "usm_rule_event_type" Table
Name Datatype Null Option Comment
event_type_id varchar(50) NOT NULL non-displayable id used in the backend as a reference between tables.
display_name varchar(64) NULL displayable name of the event type
description varchar(128) NULL short text explaining the nature of the event type
class nvarchar(20) NULL contains the component to which this event type belongs to. For example, REGISTRY, DATABASE or LOGICAL.
params varchar(64) NULL a comma-separated list of parameters associated with this event type. When an event is thrown, the parameters and their values need to be packaged as part of the event so that the action can use them to provision external systems. For example, a USER_CREATE event would contain the user id, first name, last name etc.
event_name varchar(64) NULL type of event. ADDED, MODIFIED, DELETED etc.
nsp_path varchar(128) NULL name of the table or class this event originated from. For example, for a USER_CREATE event, the table or class that gets affected is the icuser class in the Registry.
is_system int NULL Denotes if this event type is an external event defined by the user on a internal event such as USER_CREATE event.
eventq_id varchar(50) NULL qid of the event processing Queue.
event_dependency int NULL string defining the dependency of this event type on other event types. This string requires a combination of the iceventtypeid, icnsppath and iceventname fields to identify the event dependency.
installed_subcomponent_id varchar(50) NULL Handle to the installed sub component to indicate if which installed sub component is responsible for this rule event type
save_level int NULL Specifies the save level
Column(s) of "usm_runtime_application" Table
Name Datatype Null Option Comment
runtime_application_id varchar(50) NOT NULL Unique identity for the runtime application
schema_id integer NULL The schema to which th e runtime application belongs
comment varchar(64) NULL A comment
major_version varchar(256) NULL Versioning info
minor_version varchar(20) NULL Versioning info
name varchar(64) NULL The name of the runtime application
param_form varchar(64) NULL These are the form parameters for the runtime application. Eg: METHOD = GET etc
param_input varchar(64) NULL These ar the input parameters which have to be passed on to the end application
param_login varchar(50) NULL This is the place holder which specifies what is the parameter for login field
param_password varchar(128) NULL This is the place holder which specifies what is the parameter for the password field
param_script varchar(1024) NULL related parameter script
runtime_parameters varchar(64) NULL runtime parameter
status int NULL status for the runtime application
url varchar(64) NULL This is the URL for the external application
type varchar(256) NULL the runtime application type
param_domain varchar(50) NULL This is the place holder which specifies what is the parameter for domain field
file_name varchar(64) NULL This is the file name which has the image to be shown for this single sign on application
schema_instance_id varchar(50) NULL The schema instance(installed app instance) for this runtime application
comments varchar(64) NOT NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_runtime_component" Table
Name Datatype Null Option Comment
runtime_component_id varchar(50) NOT NULL Unique id for the runtime component
class varchar(64) NULL The java class name for the runtime application
name varchar(64) NULL The name of the runtime component
type varchar(20) NULL Specifies the component type
installed_component_id varchar(50) NULL handle to the installed component id
db_id varchar(50) NULL handle to the database id
Column(s) of "usm_runtimecomp_parameter" Table
Name Datatype Null Option Comment
runtime_component_id varchar(50) NOT NULL ID(FK) to runtime component
runtime_parameter varchar(64) NOT NULL ID(FK) to runtime component parameter
Column(s) of "usm_schema" Table
Name Datatype Null Option Comment
schema_id int NOT NULL Unique identity of the schema
major_version varchar(20) NULL Versioning info
minor_version varchar(20) NULL Versioning info
description varchar(128) NULL A description of the schema
name varchar(64) NULL A name of the schema
requestor varchar(20) NULL  
comment nvarchar(64) NULL A description of the schema
comments nvarchar(64) NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_schema_comp" Table
Name Datatype Null Option Comment
schema_comp_id int NOT NULL Unique identity of the schema component
name varchar(64) NULL Name of the schema component
comment varchar(64) NULL A comment of the component
gui_cfg varchar(32) NOT NULL  
comments varchar(64) NOT NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_schema_instance" Table
Name Datatype Null Option Comment
schema_instance_id varchar(50) NOT NULL Unique identity of the schema instance/installed instance
schema_id int NULL Identifies the schema installed.
Column(s) of "usm_scope" Table
Name Datatype Null Option Comment
scope_id integer NOT NULL Unique identity for the scope
level integer NULL The scope may be hierarchical. If so, the level tag identifies which level in the tree the scope is on. 0 means root.
parent_path varchar(255) NULL
If the scope is hierarchical, this attribute specifies a scope_id list separated by /.  The list includes the scope_id of the parent, but not itself.

A scope on the root level has a parent path of /. 
label nvarchar(100) NULL The label of the scope.
label_bundle_key varchar(50) NULL
A bundle key for the label. If the label is NULL, the bundle key is used to create an language depentent text for the scope.

label_bundle_keys will typically be used for out-of-the-box scopes.
analyze_function_id integer NULL
Unique identifyer for the analyze function that this scope supports.

A scope may only support one analyze function.
unit nvarchar(50) NULL The unit.
tree_level int NULL The scope may be hierarchical. If so, this specifies the level of the tree.
Column(s) of "usm_search_node" Table
Name Datatype Null Option Comment
search_node_id varchar(50) NOT NULL The unique id for the search implementation
params varchar(4000) NULL params is the list of parameters delimited by space
search_limit int NULL The max limit on the number of results to be searched, -1 is for no limit
default_param varchar(128) NULL The default parameter to fetch and show the results
bucket_size int NULL To fetch the results in a batch mode, to display limited results on a page, Eg: 1 to 50, 50 to 100 etc
table_name varchar(64) NULL table_names is the list of tables delimited by space
order_by varchar(128) NULL The sort order for the search query
param_domain varchar(64) NULL The table.column which has the domian information, to do business level validation checks
param_parent_domain varchar(64) NULL The table.column which has the parent domian information, to do business level validation checks
criteria varchar(64) NULL The default where clause for the query
Column(s) of "usm_security" Table
Name Datatype Null Option Comment
object_id varchar(64) NOT NULL Object ID for the resource
object_type varchar(128) NOT NULL
Type of the resource object
<i.e.>usm_report_data, usm_report_layout, usm_portal_template, usm_webservice, usm_launchpad, usm_asset, usm_guinode
owner_check bit NOT NULL Owner Check 0/1
acl_id varchar(64) NOT NULL ID for the access control list
Column(s) of "usm_server" Table
Name Datatype Null Option Comment
server_id int NOT NULL  
comment varchar(64) NULL  
display_name varchar(64) NULL  
host_name varchar(64) NULL  
timeout int NULL  
type varchar(256) NULL  
port_no int NULL  
login_id varchar(64) NULL  
password varbinary NULL  
comments varchar(64) NOT NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
Column(s) of "usm_service_desk_priority" Table
Name Datatype Null Option Comment
priority_id int NOT NULL  
description nvarchar(128) NULL  
Column(s) of "usm_service_desk_ticket" Table
Name Datatype Null Option Comment
service_desk_ticket_id int NOT NULL  
ticket_id int NOT NULL  
ticket_name nvarchar(128) NOT NULL  
server_id integer NULL Unique identifier for one slm server
priority_id int NOT NULL  
description nvarchar(255) NULL  
message nvarchar(255) NULL  
problem_type nvarchar(255) NULL  
status nvarchar(128) NULL  
start_date int NULL  
open_date int NULL  
resolve_date int NULL  
close_date int NULL  
Column(s) of "usm_service_event" Table
Name Datatype Null Option Comment
service_event_id integer NOT NULL Unique identifier
description nvarchar(255) NULL Description of the service event
start_time integer NULL Epoch start time of the service event
stop_time integer NULL Epoch stop time of the service event
created integer NULL Time of creation in epoch
modified integer NULL Time when last modified, in epoch
category int NULL
0 - Remove outage with comment - will not be used in r11
1- Comment only - previously provider responsible
3- Remove outage without comment - previously known as provider responsible
calendar_oid varchar(256) NULL Unique identity of the calendar
event_category_oid varchar(256) NULL Unique identity of the event category
onetime_event_oid varchar(20) NULL If the service event is exported from a calendar category and represents a onetime_event, this points to the given onetime event.
recurring_event_oid varchar(20) NULL If the service event is exported from a calendar category and is derived from a recurring event, this points to the recurring event. Otherwise it is NULL.
Column(s) of "usm_service_goal" Table
Name Datatype Null Option Comment
service_goal_id integer NOT NULL Uniquely identifies the
label nvarchar(100) NULL The label of the service goal
label_bundle_key varchar(50) NULL Bundle key for the label. Used if label is null
description nvarchar(255) NULL Description for service goal
descr_bundle_key varchar(50) NULL Bundle key for description. Used if description is null.
properties bit NULL
Gives the properties, in binary format

properties & 1 == 1 : required
properties & 2 == 1 : editable
properties & 4 == 1 : hidden
default_value varchar(255) NULL Default value for the service goal
minval varchar(255) NULL Minimum allowed value for service goal values
maxval varchar(255) NULL Maximum value for service goal values.
orientation bit NULL
#   0: no orientation
#   1: less than
#   2: less or equal
#   3: greater or equal
#   4: greater than
name nvarchar(100) NOT NULL
Purpose of the field is to have a string to match against for our data import system. When new metrics are added through the data import, we need this to check if the service goal is already defined. 
Column(s) of "usm_service_goal_values" Table
Name Datatype Null Option Comment
service_goal_id integer NOT NULL Uniquely identifies the
value varchar(50) NOT NULL An allowed service goal value
Column(s) of "usm_service_hours" Table
Name Datatype Null Option Comment
report_group_id int NOT NULL Unique identity for the report group
day_name nvarchar(15) NOT NULL
The valid day for the service hous

Values:

- monday
- tuesday
- wednesday
- thursday
- friday
- saturday
- sunday
start_time integer NULL The start time in seconds since 00.00
end_time integer NULL The end time in seconds since 00:00
created integer NULL Epoch time of creation
Column(s) of "usm_serviceconfig" Table
Name Datatype Null Option Comment
serviceconfig_id varchar(50) NOT NULL  
time_stamp datetime NULL  
comment varchar(64) NULL  
partition_id varchar(256) NULL  
sla_engine_id integer NULL Unique identifier for one slm server, in this case, the SLA engine doing the aggregation
sla_instance_id int NULL  
metric_instance_id int NULL Unique identifier
schema_id int NULL Unique identity of the schema
schema_instance_id varchar(50) NULL Unique identity of the schema instance/installed instance
contract_id int NULL Unique identity for the contract
requestor varchar(32) NOT NULL  
status int NULL  
slo_instance_id int NULL  
account_id varchar(50) NULL Unique ID of the account
metric_category_id integer NULL Unique identity identifying the metric category
subscription_detail_id integer NULL the unique id for each subscription record
comments nvarchar(64) NULL  
resource_name nvarchar(128) NULL resource name
Column(s) of "usm_settlement" Table
Name Datatype Null Option Comment
settlement_no integer NOT NULL Settlement ID
adjustment_id integer NULL
All adjustments are recorded here and then applied to the accounts when they are invoiced in a bill run.

When adjustment_type=0 (general adjustment) and value_type=0 (fixed amount):
"	enum_1 = billing cycle (0=onetime, 1=periodic, 2=every invoice)
"	enum_2 = periodic type (0=NA,1=daily,2=weekly,3=monthly,4=quarterly,5=yearly)

When adjustment_type=0 (general adjustment) and value_type=1 (percentage):
"	enum_1 = billing cycle (0=onetime, 2=every invoice)
"	enum_2 = periodic type (0=NA)
"	enum_3 = apply adjustment to (1=offering,2=rate column, 3=all charges, 4=total invoice amount)
"	enum_4 = select offering ( when enum_3=1 or 2, then this is the offering_id )
"	enum_5 = select rate column ( when enum_3=2, then this is the item_id of the column header rate item)
"	enum_6 = percent of ( when enum_3=2, then 0=Quantity, 1=UnitCost, 2=Cost)
domain varchar(50) NOT NULL  
settle_account varchar(50) NULL  
settle_domain varchar(50) NOT NULL  
settle_user nvarchar(128) NULL  
type integer NOT NULL  
status integer NOT NULL  
recorded_date date NOT NULL  
unsettled_date date NULL  
settled_date date NULL  
amount float NULL  
amount_settled float NULL  
show_on_invoice integer NOT NULL  
enum_1 integer NULL  
enum_2 integer NULL  
comments nvarchar(128) NULL description for the field. Field name "comment" has been changed to "comments" to support oracle
account_no varchar(50) NULL The account number associated to the billing_account.
Column(s) of "usm_sla_calendar" Table
Name Datatype Null Option Comment
calendar_id varchar(128) NOT NULL Outage Calendar ID (Calendar ID or Business Hour ID)
calendar_type tinyint NOT NULL Outage Calendar Type (Outage Event Group = 0/Business Hour=1/Outage Calendar = 2)
calendar_name nvarchar(128) NOT NULL Outage Calendar Name
calendar_desc nvarchar(512) NULL Outage Calendar Description
domain varchar(50) NULL The unique tenantid that identifies this organization/tenant
created_date datetime NULL created date
last_modified_date datetime NULL last modified date
Column(s) of "usm_sla_calendar_group" Table
Name Datatype Null Option Comment
parent_calendar_id varchar(128) NOT NULL Outage Calendar ID (Calendar ID or Business Hour ID)
calendar_id varchar(128) NOT NULL Outage Calendar ID (Calendar ID or Business Hour ID)
Column(s) of "usm_sla_config" Table
Name Datatype Null Option Comment
sla_config_id varchar(50) NOT NULL  
name varchar(64) NULL  
last_run datetime NULL  
port_no int NULL  
status int NULL  
param varchar(64) NULL  
data1 varchar(64) NULL  
data2 varchar(64) NULL  
data3 varchar(64) NULL  
data4 varchar(64) NULL  
host_id int NULL The identity of the host.
Column(s) of "usm_sla_event" Table
Name Datatype Null Option Comment
event_id varchar(128) NOT NULL Outage Event ID
event_type tinyint NOT NULL One Time Event = 1, Recurreing Event = 2
start_time bigint NOT NULL Start Time
end_time bigint NULL End Time
event_duration bigint NULL Durations in seconds, of one recurring occurrence for this recurrring event series.
event_time_zone varchar(64) NOT NULL Outage Event Time Zone
event_name nvarchar(256) NOT NULL Outage Event Name
event_pattern varchar(256) NULL Outage Event Pattern (y=yearly/m=monthly/w=weekly/d=daily/h=hourly/minute=minutely)
event_desc nvarchar(512) NULL Outage Event Description
created_time datetime NULL created time stamp
domain varchar(50) NULL The unique tenantid that identifies this organization/tenant
last_modified_date datetime NULL last modified date
Column(s) of "usm_sla_instance" Table
Name Datatype Null Option Comment
sla_instance_id int NOT NULL  
text_slo varchar(64) NULL  
aggregation_type varchar(64) NULL icaggregationtype is made single valued, hence use delimited sepreated list
tenant_id varchar(50) NULL The unique tenantid that identifies this organization/tenant
description varchar(128) NULL  
status int NULL  
package_type varchar(20) NULL  
schema_id int NULL The associated schema
last_update datetime NULL  
Column(s) of "usm_sla_metric_instance" Table
Name Datatype Null Option Comment
sla_metric_instance_id integer NOT NULL
Unique identity for the sla_metric_instance entity
sla_instance_id int NULL The identity of the associated sla instance
sla_config_id varchar(50) NULL The identity of the sla configuration
slo_instance_id int NULL The identity of the associated slo_instance
metric_instance_id int NULL Unique identifier for the associated metric instnace
use_calendar_events c(1) NULL To be removed
contract_id int NULL Unique identity for the contract
dm_profile_id int NULL  
Column(s) of "usm_slm_server" Table
Name Datatype Null Option Comment
server_id integer NOT NULL Unique identifier for one slm server
host_id int NULL The host on which this server runs.
server_type_id integer NULL Unique identity of the server type
Column(s) of "usm_slm_server_config" Table
Name Datatype Null Option Comment
server_config_id integer NOT NULL Unique identity for this configuration
name varchar(50) NULL Name of the configuration attribute
value nvarchar(1023) NULL Value of the configuration attribute
server_id integer NULL The slm server for which this configuration attribute applies.
Column(s) of "usm_slm_server_status" Table
Name Datatype Null Option Comment
server_status_id integer NOT NULL Unique identifier
value varchar(20) NULL
The status value. 
Values for the following statuses should be supported.
Suspended
Undefined
Normal
Warning
Stopped
Deleted(may not be used)
Minor
Major
Critical
How the values are represented, as int or strings are yet to be defined. Other status values may be defined
server_id integer NULL The server for which this status applies
type integer NULL
Type of status.

Column(s) of "usm_slm_server_status_type" Table
Name Datatype Null Option Comment
server_status_type_id integer NOT NULL Unique identifier
description nvarchar(255) NULL Description of the status type
Column(s) of "usm_slm_server_type" Table
Name Datatype Null Option Comment
server_type_id integer NOT NULL Unique identity of the server type
name varchar(100) NULL The name of the server type.
Column(s) of "usm_slm_server_type_spec" Table
Name Datatype Null Option Comment
slm_server_type_spec_id integer NOT NULL Specification of attributes for a server type.
attribute_name varchar(50) NULL The name of the attribute
type varchar(50) NULL  
label_bundle_key varchar(50) NULL The label bundle key, used to present the label if the label itself is NULL
label nvarchar(100) NULL The label of the attribute
default_value nvarchar(255) NULL The default value of the attribute
is_required c(1) NULL
'Y' - attribute is required
'N' or NULL, attribute is not required.
server_type_id integer NULL The associated server type for which this spec is valid.
Column(s) of "usm_slm_server_type_value" Table
Name Datatype Null Option Comment
slm_server_type_spec_id integer NOT NULL Specification of attributes for a server type.
value nvarchar(255) NOT NULL The legal value of the attribute.
Column(s) of "usm_slo_data" Table
Name Datatype Null Option Comment
time_stamp datetime NOT NULL  
sla_engine_id integer NULL  
pkg_id integer NULL  
app_user varchar(64) NULL  
state0 integer NULL  
category integer NULL  
state1 integer NULL  
state2 integer NULL  
status integer NULL  
value float NULL  
final integer NULL  
slo_instance_id int NULL  
contract_id int NULL  
host_id int NULL  
ts_sec int NULL  
Column(s) of "usm_slo_event" Table
Name Datatype Null Option Comment
time_stamp datetime NOT NULL  
sla_engine_id integer NULL  
text_id c(36) NULL  
locale c(4) NULL  
host_name varchar(128) NULL  
pkg_id integer NULL  
app_name nvarchar(128) NULL  
category integer NULL  
unit varchar(32) NULL  
interval integer NULL  
severity integer NULL  
threshold float NULL  
value float NULL  
app_user varchar(64) NULL  
final integer NULL  
contract_id int NULL  
host_id int NULL  
slo_instance_id int NULL  
ts_sec int NULL  
Column(s) of "usm_slo_instance" Table
Name Datatype Null Option Comment
slo_instance_id int NOT NULL  
check_interval varchar(10) NULL  
level int NULL  
operator varchar(8) NULL  
report_interval int NULL  
slo_type varchar(4) NULL  
threshold float NULL  
unit nvarchar(20) NULL  
group_user int NULL  
sla_instance_id int NULL THe sla instance to which this slo instance belongs
metric_category_id integer NULL Unique identity identifying the metric category
sla_config_id varchar(50) NULL The sla configuration
slo_template_id int NULL
Identity of the SLO template.

Values < 1.000.000 are statically defined.

Dynamically assigned values should start at 1.000.000.
slo_weight int NULL  
pkg_level int NULL  
Column(s) of "usm_slo_package" Table
Name Datatype Null Option Comment
slo_package_id int NOT NULL  
major_version varchar(20) NULL  
minor_version varchar(20) NULL  
name varchar(64) NULL  
package_name varchar(64) NULL  
schema_id int NULL The schema to which this package belongs.
aggregation_type varchar(50) NOT NULL icaggregationtype is made single valued, hence use delimited sepreated list
Column(s) of "usm_slo_template" Table
Name Datatype Null Option Comment
slo_template_id int NOT NULL
Identity of the SLO template.

Values < 1.000.000 are statically defined.

Dynamically assigned values should start at 1.000.000.
check_interval int NULL  
comment varchar(64) NULL  
description varchar(128) NULL  
level int NULL  
operator varchar(4) NULL  
report_interval int NULL  
threshold float NULL  
unit nvarchar(50) NULL  
warning_text varchar(64) NULL  
violation_text varchar(64) NULL  
group_user int NULL  
request_type int NULL  
aggregation_rule_id int NULL  
show_smreport int NULL  
metric_category_id integer NULL Unique identity identifying the metric category
slo_weight int NULL  
comments nvarchar(1024) NULL  
pkg_level int NULL  
Column(s) of "usm_slo_template_sla_config" Table
Name Datatype Null Option Comment
slo_template_id int NOT NULL
Identity of the SLO template.

Values < 1.000.000 are statically defined.

Dynamically assigned values should start at 1.000.000.
sla_config_id varchar(50) NOT NULL  
aggregation_type integer NOT NULL  
Column(s) of "usm_slo_threshold" Table
Name Datatype Null Option Comment
slo_threshold_id int NOT NULL  
slo_instance_id int NULL  
threshold float NULL  
threshold_type int NULL  
threshold_order int NULL  
Column(s) of "usm_sm_comp" Table
Name Datatype Null Option Comment
sm_request_id int NOT NULL Unique identity
sm_target varchar(64) NULL  
metric_instance_id int NULL Unique identifier
inst_host_id int NULL The identity of the host.
schema_comp_id int NULL Associated schema component
Column(s) of "usm_sm_event" Table
Name Datatype Null Option Comment
ts_sec int NOT NULL  
sla_engine_id integer NULL  
app_user varchar(64) NULL  
interval integer NULL  
value float NULL  
time_stamp datetime NULL  
data1 integer NULL  
data2 varchar(64) NULL  
sla_instance_id int NULL  
contract_id int NULL  
host_id int NULL  
slo_instance_id int NULL  
metric_category_id int NULL  
recurring_event_oid varchar(20) NULL Not used in r11
onetime_event_oid varchar(20) NULL Not used in r11
calendar_category_oid varchar(20) NULL Not used in r11
insert_time int NULL  
Column(s) of "usm_snmp_config" Table
Name Datatype Null Option Comment
target varchar(50) NOT NULL
destination host/network. 

Can contain one special value, named 'default' that applies to destinations not specified.
community varchar(50) NOT NULL the snmp community string
retries integer NOT NULL number of retries
timeout integer NOT NULL The timeout in seconds
netmask varchar(20) NULL if target is host, netmask is 255.255.255.255, else the target is a network.
snmp_version varchar(50) NOT NULL snmp protocol version
username varchar(100) NULL username if snmp version needs username authentications
password varchar(100) NULL password for authentication if needed
privacyPassword varchar(100) NOT NULL  
securityLevel varchar(256) NOT NULL  
Column(s) of "usm_statement" Table
Name Datatype Null Option Comment
statement_id integer NOT NULL unique id that identifies each invoice. This will change in the near future such that every statements record will be unqiue based on the account_no and the statement_id
statement_label nvarchar(128) NULL a unique invoice identifier, such as an invoice number, that is comprised of the tenant id, account_label, and the statement_id
account_type integer NOT NULL 0=Open Item, 1=Balance Forward. This is the same value of the billing_account.account_type that is stored here to at the time this invoice was created for that account
invoice_history_id integer NULL a pointer to the invoice_history record that this invoice is associated to. In other words, this tells iCanBill what bill run this invoice was created for
domain varchar(50) NOT NULL This is the tenant ID of the account
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
invoice_date date NULL the date the invoice was generated
status integer NULL 0=delete, 1=zero balance (or paid), 2=debit balance (or balance remaining), 3=credit balance
status_reason nvarchar(128) NULL currently not used
due_date date NULL the date payment is due for this invoice. This is set by taking the billing_account.days_due and adding it to the invoice_date
tax_amount float NULL currently not used
debit_amount float NULL the new debits on the invoice
credit_amount float NULL the new credits on this invoice
account_debit_amount float NULL the old debits from the account balance, from billing_account.debit_amount
account_credit_amount float NULL the old credits from the account balance, from billing_account.credit_amount
period_to date NULL the billing account
period_from date NULL the billing account
violations integer NULL the number of SLA violations that occured in this the invoiced billing period
purchase_order_no nvarchar(30) NULL retrieved from billing_account.purchase_order_no and stored here to display on the invoice
invoice_loc nvarchar(512) NULL the location of the invoice on the hard drive. If none is specified then the data for the invoice is always fetched from the database
comments nvarchar(128) NULL currently not used
account_no varchar(50) NULL The account number associated to the billing_account.
Column(s) of "usm_stylesheet" Table
Name Datatype Null Option Comment
stylesheet_id varchar(50) NOT NULL The unique id for the style sheet
name varchar(64) NULL Name of the stylesheet
url varchar(64) NULL The relative path for the stylesheet
type varchar(20) NULL The type of the style sheet, Eg: DashBoardItem etc
Column(s) of "usm_subscription_detail" Table
Name Datatype Null Option Comment
id integer NOT NULL the unique id for each subscription record
account_no varchar(50) NOT NULL The account number associated to the billing_account.
account_label nvarchar(128) NOT NULL the billing account label
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
offering_id integer NOT NULL the unique id for each offering.
rate_plan_id integer NOT NULL the unique id for each rate plan
item_id integer NOT NULL the unique id for each rate item
status integer NOT NULL 0=deleted, 1=pending, 2=active, 3=inactive, 4=cancelled. subsciptions to application rate items usually are first set to pending first until they are assigned to a resource. most subscriptions will be in the active state which means they will be invoiced. Inactive subscriptions are subscriptions that need to be invoiced before being cancelled.
subscription_type integer NOT NULL 0=subscription to general rate item such as a Rate rateitem, Numeric rateitem, Adjustment rateitem, etc. 1=subscription to an Application rate item, 2=subscription to an Agreement rate item, 3=a periodic adjustment
instance_name varchar(64) NULL name that can be associated to a particular subscription instance.
subscribed_date date NOT NULL the date the subscription was made
unsubscribed_date date NULL the date the subscription was unsubscribed
charge_date date NOT NULL the date that the subscription should begin getting charged.
last_charge_date date NULL the last date the subscription was charged up to. When first subscribing, this date is the same as the charge_date, and is then incremented every bill run this subscription is invoiced.
code nvarchar(64) NULL the codes of the rate items, rate plans or offerings will be persisted here during subscription
charge integer NULL 0=don't invoice this subscription, 1=invoice this subscription
installments integer NULL number installments this subscription was invoice for to date
tiered_item_id integer NULL charged tiered item ID
tiered_last_date date NULL last charge date for tiered item pointed to by tiered_item_id
text_1 nvarchar(50) NULL if subscription_type=1 then application id, if subscription_type=2 then contract ID, otherwise empty
text_2 nvarchar(50) NULL if subscription_type=1 then application name, if subscription_type=2 then sla package name, otherwise empty
text_3 nvarchar(50) NULL if subscription_type=1 then service config ID, otherwise empty
text_4 nvarchar(50) NULL currently not used
text_5 nvarchar(50) NULL see table comment
text_6 nvarchar(50) NULL This column is not used
text_7 nvarchar(50) NULL This column is not used
enum_1 integer NULL see table comment
enum_2 integer NULL see table comment
enum_3 integer NULL currently not used
enum_4 integer NULL This column is not used
enum_5 integer NULL This column is not used
numeric_1 float NULL see table comment
numeric_2 float NULL see table comment
request_id integer NULL This column consists of the Request Id associated to subscription
request_type integer NULL This column consists value what type of Request it is.
domain varchar(50) NOT NULL Domain to which this item belongs.
group_id int NOT NULL used to groups multiple subscription_detail rows ion a tree structure in the UI
sd_row int NULL The subscription detail row number within an offering, this number spans over all the rate plans within the offering.
Column(s) of "usm_subscription_mgmt" Table
Name Datatype Null Option Comment
id integer NOT NULL unique id for each subscription management record
parent_domain varchar(50) NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
type integer NOT NULL 0=date differential, 1=billing in advance, 4=suspension
scope integer NOT NULL 0=global, 2=account label
label nvarchar(128) NULL Account label when specific accounts are specified.
subscription_type integer NOT NULL 0=existing, 1=future, 2=both, 3=na
subscription_item integer NOT NULL 0=offering, 1=rate plan, 2=rate item. This specifies at what level the subscription mgmt should take effect
subscription_item_id integer NOT NULL The offerings.offering_id, rate_plans.rate_plan_id, or the rate_definition.item_id of an object depending on if subscription_item is 0,1, or 2 respecively.
status integer NOT NULL 0=deleted, 1=active, 2=inactive
status_date date NOT NULL the date the status changed
enum_1 integer NULL see table comment
enum_2 integer NULL see table comment
enum_3 integer NULL see table comment
enum_4 integer NULL see table comment
enum_5 integer NULL see table comment
enum_6 integer NULL see table comment
enum_7 integer NULL see table comment
date_1 date NULL see table comment
date_2 date NULL see table comment
date_3 date NULL see table comment
domain varchar(50) NULL Domain to which the this item belongs.
Column(s) of "usm_system_alert" Table
Name Datatype Null Option Comment
system_alert_id varchar(128) NOT NULL Unique id for the system alert message
host_name varchar(50) NULL The affected host name for the message
message nvarchar(1024) NULL The actual alert message
tenant_id varchar(50) NULL The domain which is logging the message
message_type varchar(50) NULL Type, INTERNAL, OS, NETWORK, STORAGE, THIRD_PARTY
other_info1 nvarchar(1024) NULL Additional information for the message
other_info2 nvarchar(1024) NULL Additional information for the message
other_info3 nvarchar(1024) NULL Additional information for the message
severity varchar(50) NULL Serverity: DOWN, CRITICAL, MAJOR, MINOR, INFORMATIONAL
source_name varchar(50) NULL The source for the message, generally the system id or the userid
time_stamp date NOT NULL The time stamp for the message
user_name nvarchar(128) NULL User logged in to the the system when message is generated
status int NOT NULL Field denotes state of a system alert. (Default should be 1 to indicate active alerts) – Soft delete should would have a value of 0, 2 should be used to ignore, 3 if the status of that particular request item was overridden.
Column(s) of "usm_system_change" Table
Name Datatype Null Option Comment
id varchar(128) NOT NULL non-displayable id used in the backend as a reference between tables.
name nvarchar(50) NOT NULL name of the transaction. For database events, it’s the table name i.e. billing_account, icuser etc. For LOGICAL transactions, it’s a plain-text name. This entry has a logical mapping to the iceventtype.icnsppath property in the Registry.
tran_level varchar(50) NOT NULL LOGICAL or DATABASE transaction.
timestamp date NOT NULL time stamp the transaction took place
type nvarchar(50) NOT NULL event causing this transaction entry. ADDED, MODIFIED, DELETED etc.
description nvarchar(256) NULL information about the event
host varchar(50) NULL hostname, which is responsible for this event
component_name nvarchar(50) NOT NULL component from which this event originated from. Registry/Billing/Metering/Logical etc.
nsp_path varchar(128) NOT NULL namespace in which the affected object resides
user_id nvarchar(100) NULL user who affected the change that caused this event
domain varchar(50) NULL domain to which the user belongs
object_id varchar(256) NULL object id of the affected object
httpsession_id nvarchar(50) NULL HTTP Session ID of the user
partial_event integer NOT NULL 1 indicates that this event does not contain further details. 0 indicates that this event contains more details that need to be fetched from transaction_details and transaction_details_ext table.
notified varchar(512) NULL
List to be notified
Should research more on this field
Column(s) of "usm_system_change_detail" Table
Name Datatype Null Option Comment
id varchar(128) NOT NULL non-displayable id used in the backend as a reference between tables.
name nvarchar(50) NOT NULL name of the property of the object or the field
data_type nvarchar(50) NULL data type of the field or property
old_value nvarchar(1024) NULL property value before modification or change
new_value nvarchar(1024) NULL property value after modification or change
multi_value integer NULL 0/1. If 0, this field is not a multi-value field.
Column(s) of "usm_system_change_detail_ext" Table
Name Datatype Null Option Comment
id varchar(128) NOT NULL non-displayable id used in the backend as a reference between tables.
name nvarchar(50) NOT NULL name of the property of the object or the field
age int NULL This column is not used
value nvarchar(256) NULL property value before or after modification
Column(s) of "usm_system_install" Table
Name Datatype Null Option Comment
system_install_id varchar(64) NOT NULL The unique id for the system install, this is the machine name on which the view is installed
comment varchar(64) NULL Comment on the system install, if any
domain_name varchar(64) NULL Not used
host_name varchar(64) NULL Name of the host for this system install
logon_reqd varchar(20) NULL 1 - logon reqd, 0 - not required Flag indicating if authentication need to be done on this system, if false then the authentication in not done, but just the userid is validated
name varchar(64) NULL Name of the system install
timeout int NULL Default session timeout in seconds for the system install
use_cache int NULL 1- cache enabled, 0 - disabled, specifies if caching is enabled/disabled
web_root varchar(256) NULL This is the installation path for the web application files
document_root varchar(256) NULL This is the path where the documents will be uploaded
port_no int NULL This is the default port where view will be running
log_messages int NULL Not used
servlet_name varchar(64) NULL The name of the servlet context
news_to_domains varchar(256) NULL Configuration on weather one can send to multiple domains; Values SELF, defualt is all domains
client_side_processing int NULL Flag to specify if the transformation is to be done, if 0 no transformation will be done and xml will be sent back to browser to do client transformation
concurrent_logon int NULL Indicates if a user can login from multiple machines, 1 - concurrent login allowed, 0 - not allowed
super_tenant_enabled int NULL Flag to indicate if Super tenant mode is available or not ; 1 - available, 0 - not available
login_property varchar(64) NULL This is the default property in the tenant table that will be used for login purposes, say tenant_name if you want login to be based on tenant name and not on tenantid
super_tenant_levels int NULL Indicates how many levels of super tenant is allowed, -1 for infinite levels
secret_question varchar(64) NULL This is the system level secret question if someone forgets a password etc, Eg: What is your mother maiden name? etc
pwd_policy_id varchar(50) NULL The unique identifier for the password policy
comments nvarchar(64) NULL This holds the comments, comment is removed for oracle support
Column(s) of "usm_task" Table
Name Datatype Null Option Comment
task_id varchar(50) NOT NULL The unique task id, which identifies the task
name nvarchar(128) NOT NULL The descriptive name of the task
comment varchar(64) NULL Any specific comments for additional data for this task
day_of_month int NULL Task execution day of month
day_of_week int NULL Task execution day of week
hour int NULL The hour which the task will be executed
minute int NULL The minute which the task will be executed
month int NULL The month which the task will be executed
status int NULL The status of the task, 1 - ACTIVE, 0 - INACTIVE
task_to_exec varchar(64) NULL The action, that need to be done as part of this task execution
type varchar(20) NULL Specifies the type of the task
year int NULL The year which the task will be executed
start_date datetime NULL The start date, if this is a repeative task
end_date datetime NULL The end date, if this is a repeative task
requestor varchar(64) NOT NULL Specifies which component made the request for this task
runtime_component_id varchar(50) NULL The runtime component handle which is responsible for the task
action_type int NULL Inidacte the type of the action
data1 varchar(64) NULL For external integration/implemenatation
data2 varchar(64) NULL For external integration/implemenatation
data3 varchar(64) NULL For external integration/implemenatation
data4 varchar(64) NULL For external integration/implemenatation
data5 varchar(64) NULL For external integration/implemenatation
interval int NULL Interval between one execution and the next
description ntext NULL The description of the task
action_description varchar(128) NULL The detailed description of this action
created_date datetime NULL The time recoreded for when the task is created
last_exec_date datetime NULL The last executed time for this lask
missed_action varchar(64) NULL The action, specifies what need to be done, if the task is missed
user_id varchar(50) NULL The userid , who created this task
modified_date datetime NULL The modified date for this task
guinode_id varchar(50) NULL Hand to guinode if a guinode is to be invoked as a result of this task
tenant_id varchar(50) NULL Handle to the tenant object if the task is organization based
time_zone_code varchar(64) NULL time zone code is the code for a particular time zone, Eg- EST, PST etc
comments nvarchar(64) NULL
description for the comment field.  field name has been changed to comments to support oracle
Column(s) of "usm_tenant_ext" Table
Name Datatype Null Option Comment
tenant_id varchar(50) NOT NULL The unique tenantid that identifies this organization/tenant
parent_tenant_id varchar(50) NOT NULL The handle to the parent tenant for a specific tenant, this determines the tree structure within tenants
tenant_name nvarchar(50) NOT NULL The readable name of the tenant
domain_type varchar(4) NOT NULL Specifies the type of the tenant, SP - Service Provider, ST - Super Tenant, TE - Tenant
status nvarchar(256) NOT NULL
Status of the tenant

0 Inactive(deleted), 1 active
login_domain varchar(64) NULL The login domain for a domanin based login, if the login is not tenant based
opened_date datetime NOT NULL The date when the tenant is created
closed_date datetime NULL The closed date, if this tenant is no longer active or deleted
email varchar(128) NULL The email address for the tenant
website varchar(128) NULL Tenants website address
description nvarchar(64) NULL The description of the tenant
federal_tax_payer_id nvarchar(32) NOT NULL This is the federal tax payer identification for financial purposes, only used to display, no logic associated
state_tax_payer_id nvarchar(32) NOT NULL
This is the state tax payer identification for financial purposes, only used to display, no logic associated
tax_region nvarchar(64) NOT NULL
specifies the region of taxing, for financial purposes, only used to display, no logic associated
date_format varchar(256) NULL The format of date display, configurable at the tenant level
time_format varchar(11) NULL The format of time display, configurable at the tenant level
decimal_format int NULL 0 period, 1 comma
single_account_mode int NULL 0 true, 1 false(default)
data1 nvarchar(32) NULL For external integration/implemenatation
data2 nvarchar(32) NULL For external integration/implemenatation
data3 nvarchar(32) NULL For external integration/implemenatation
data4 nvarchar(64) NULL For external integration/implemenatation
data5 nvarchar(64) NULL For external integration/implemenatation
data6 nvarchar(128) NULL For external integration/implemenatation
data7 nvarchar(128) NULL For external integration/implemenatation
currency_type_code varchar(3) NULL Handle to the currecy object
time_zone_code varchar(64) NULL Handle to the time zone object
location_uuid tinyint(16) NULL FK to ca_location table
company_uuid tinyint(16) NULL FK to ca_company table
organization_uuid tinyint(16) NULL FK to ca_organization table
path varchar(1024) NOT NULL
This specifies the path of the tenant with the parent hierarchy starting from sp teanant
contact_uuid tinyint(16) NULL
This holds the FK for the location contact for this tenant
logo nvarchar(255) NULL used to save the logo url for each tenant
Column(s) of "usm_tenant_ext_ldap_conf" Table
Name Datatype Null Option Comment
tenant_id varchar(50) NOT NULL The handle to the tenant, to indicate which tenant for this configuration
external_dir_type varchar(20) NULL The type of the external directory type, MSAD for Active Directory etc
ldap_host varchar(64) NULL The host name for the external LDAP
port_no int NULL The LDAP port number for the external LDAP
filter varchar(20) NULL The specific user attribute in iCan user that is mapped to the "cn" of the external user
user_base varchar(256) NULL The base DN for where the users will be added
bind_user varchar(64) NULL The user DN in external directory which will be used to connect to the external directory
password varbinary NULL Password to connect to the external directory, to do adminstrative task, like add user
external_ous varchar(128) NULL This is deprecated functionality
Column(s) of "usm_transaction" Table
Name Datatype Null Option Comment
account_no varchar(50) NOT NULL The account to which this transaction is associated.
id integer NOT NULL Integer that increments for each transaction associated to a particular account.
domain varchar(50) NOT NULL This is the tenant ID of the account
parent_domain varchar(50) NOT NULL This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider.
statement_id integer NOT NULL this is the invoice that this transaction appeared on. A -1 indicates that this has not be invoiced yet.
sequence_no integer NULL the ordering of transactions as they have been processed and the order in which they will show up on the invoice
type integer NOT NULL the type of transaction. 0=offering, 1=rate plan, 2=rate item, 3=adjustment, 4=payments, 5=message. Users can create and plugin there own types of transactions, and should use values greater then 10000.
post_date date NULL the date that the transaction was posted to the account.
status integer NOT NULL 0=deleted, 1=open
description nvarchar(1024) NOT NULL the description of the transaction
charge_type integer NOT NULL 0=credit, 1=debit, 2=default.
commit_phase integer NOT NULL 0=not committed, 1=committed. This is used for components that integrate with iCanBill to track transactions.
quantity float NOT NULL The quantity associated with the transaction.
quantity_type integer NOT NULL 0=quantity, 1=percent. Currently only 1 is supported.
unit_cost float NOT NULL is the unit cost used for calculations
unit_cost_text nvarchar(50) NOT NULL is the unit cost used for display. Used for resolving floating point errors.
unit_type nvarchar(50) NULL used for display only to show the type of unit of the transaction
cost float NOT NULL calculated from quantity x unit_cost
code nvarchar(50) NULL codes from the subscriptions are passed to this field. This can be overloaded by other transaction type plugins
enum_1 integer NULL See Table Comment
enum_2 integer NULL See Table Comment
enum_3 integer NULL See Table Comment
enum_4 integer NULL See Table Comment
enum_5 integer NULL See Table Comment
enum_6 integer NULL See Table Comment
enum_7 integer NULL See Table Comment
enum_8 integer NULL See Table Comment
text_1 nvarchar(50) NULL See Table Comment
text_2 nvarchar(50) NULL See Table Comment
text_3 nvarchar(50) NULL This column is not used
numeric_1 float NULL See Table Comment
date_1 date NULL See Table Comment
date_2 date NULL See Table Comment
date_3 date NULL This column consists of Invoice Date
prorate_value integer NULL See Table Comment
period_multiplier float NULL See Table Comment
num_periods integer NULL See Table Comment
advanced_periods integer NULL See Table Comment
period_type integer NULL See Table Comment
period_type_interval integer NULL See Table Comment
is_reverse integer NOT NULL 0=not a reverse transaction, 1=reverse transaction
reverse_tran_id integer NOT NULL This colulmn is deprecated will allways contains -1 as value.
suspension_id integer NULL id of the subscription_mgmt object that suspended this transaction
suspension_instance date NULL This column is not used
Column(s) of "usm_unittype" Table
Name Datatype Null Option Comment
unittype_id int NOT NULL Unique identity for this unit type
description varchar(128) NULL A description
metric_result varchar(20) NULL  
name varchar(20) NULL The name of the unit type
Column(s) of "usm_user" Table
Name Datatype Null Option Comment
user_id varchar(50) NOT NULL The unique userid, user id is of the form username@domain
domain varchar(50) NULL Handle to tenant object, specifying which organization this user belongs to
common_name varchar(128) NULL  
first_name varchar(128) NULL  
last_name varchar(64) NULL  
initials varchar(32) NOT NULL  
address varchar(128) NOT NULL  
city varchar(64) NOT NULL  
state varchar(128) NULL  
country varchar(64) NOT NULL  
postal_code varchar(128) NULL  
email varchar(128) NOT NULL  
telephone varchar(256) NOT NULL  
fax varchar(20) NULL  
mobile varchar(256) NOT NULL  
pager varchar(256) NOT NULL  
home_phone varchar(256) NOT NULL  
password varchar(128) NULL  
title varchar(64) NOT NULL  
description varchar(128) NOT NULL  
status nvarchar(256) NULL Status, 0- deleted user 1 - active user
manager varchar(64) NULL  
employee_type varchar(32) NOT NULL  
employee_number varchar(16) NULL  
department_number varchar(128) NULL  
secretary varchar(128) NULL  
organization varchar(64) NULL  
organization_unit varchar(128) NULL  
uid varchar(128) NULL  
car_licence varchar(16) NULL  
url varchar(128) NOT NULL  
external_ou varchar(256) NULL The path for the external LDAP user organization unit
external_dn varchar(256) NULL The external LDAP distinguished name if the user lies in an external LDAP
time_zone_code varchar(64) NULL handle to a timezone object
locale_code varchar(4) NULL Handle to the locale object
user_account_control int NULL  
useruid varchar(64) NULL  
Column(s) of "usm_user_query_history" Table
Name Datatype Null Option Comment
user_id nvarchar(100) NOT NULL User Unique ID
guinode_id varchar(128) NOT NULL Guinode unique ID
name nvarchar(128) NOT NULL Name of the user query
user_query ntext NOT NULL user search queries which is saved
shared_mode int NOT NULL default to 0 and 0 means "private". 1 means "shared"
description nvarchar(1024) NULL description of the saved queries
Column(s) of "usm_webservice" Table
Name Datatype Null Option Comment
webservice_id varchar(50) NOT NULL The unique id which identifies the webservice
display_name varchar(64) NULL The descriptive name of the web service
urn varchar(64) NULL The Uniform Resource name for the webservice
class varchar(64) NULL The java class for the webservice implementation
load_on_startup int NULL Specifies if this a system specific webservice and is added for the system to work. Example:
scope varchar(20) NULL Determines the scope of the webservice, Eg: Application scope etc
static int NULL Specifies if the implementation is static or not
is_system int NULL Specifies if this a system specific webservice and is added for the system to work. Example:
Column(s) of "usm_webservice_method" Table
Name Datatype Null Option Comment
webservice_method_id varchar(128) NOT NULL The unique method id for the webservice method implemenentation, This is the webserviceid.methodid
webservice_method_name varchar(64) NULL The descriptive name of the web service
method_name varchar(64) NULL The method id for the webservice method
is_system int NULL Specifies if this a system specific webservice and is added for the system to work. Example:
load_on_startup int NULL Specifies if this a system specific webservice and is added for the system to work. Example:
use_cache int NULL Specifies if the cache can be used for this method
output varchar(64) NULL Specifies the output format of the method, Eg: ISOAPObject etc
webservice_id varchar(50) NULL Handle to the webservice, which is responsible for this method
input varchar(512) NULL Specifies the input format of the method
optinal_input varchar(1024) NULL Specifies the optional input
Column(s) of "usm_webservice_sessions" Table
Name Datatype Null Option Comment
session_id varchar(64) NOT NULL session id
userid nvarchar(100) NOT NULL userid of the session
timestamp double precision NOT NULL Timestamp in milisecond for when the session is created
domain1 varchar(50) NULL user's tenant_id where he is logged into.
credentials ntext NOT NULL credentials of the user
proxy_userid nvarchar(100) NULL proxy user id
proxy_tenant_id varchar(50) NULL The unique tenantid that identifies this organization/tenant
Column(s) of "usm_wmi_classes" Table
Name Datatype Null Option Comment
server_id integer NOT NULL Unique identifier for one slm server
class_name varchar(255) NOT NULL WMI class name
Column(s) of "usm_wmi_expression" Table
Name Datatype Null Option Comment
expression_id int NOT NULL Unique identity for the expression
expression_name nvarchar(255) NOT NULL Name of the expression
expression_text varchar(4095) NOT NULL The expression text