usm_dependency

Persists the dependencies between offerings, and offerings to tenants.

Column Name Column Datatype Column Null Option Column 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) with 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 with 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) with 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 with null The id of the offering that is dependent on another offering
target_string_id varchar(128) with null The id of the tenant that is dependent on an offering
date_available date with null Currently not used.
date_unavailable date with null Currently not used.
status integer with null 0=deleted, 1=active
enum_1 integer with null Currently not used.
enum_2 integer with null Currently not used.
enum_3 integer with null Currently not used.
enum_4 integer with null Currently not used.
text_1 varchar(128) with null Currently not used.
text_2 varchar(128) with null Currently not used.

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.