FORMATS: | TABULAR | HIERARCHICAL |
Tables |
Table |
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 |
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 |
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 |   |
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 |