usm_account

The entity which defines the enterprise level account.

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

Account is entity which can be billed. Service Level Contracts can be defined

Column Name Column Datatype Column Null Option Column Comment
account_id varchar(50) not null Unique ID of the account
status integer not null Account status - 0 open, 1 close
name nvarchar(64) not null Readable account name
label nvarchar(64) not null Readable account label
opened_date date not null Account open date, recorded date when opening the account
closed_date date with null Account close date, recorded date when closing the account
email nvarchar(128) with null Email contact for the account
website varchar(128) with null Website of the account
data1 nvarchar(32) with null For integration
data2 nvarchar(32) with null For integration
data3 nvarchar(32) with null For integration
contact_uuid byte(16) with null  
data4 nvarchar(64) with null For integration
data5 nvarchar(64) with null For integration
data6 nvarchar(64) with null For integration
data7 nvarchar(128) with 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) with null Time zone, for billing caluclations EG: EST, PST
location_uuid byte(16) with null Location, handle to the location table
single_user_mode integer with null  

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
account_id usm_billing_account account_no
account_id usm_account_app_user account_id
account_id usm_serviceconfig account_id
account_id usm_link_account_user account_id
account_id usm_contract account_id
account_id usm_link_rtapp_account account_id


Copyright © 2006 CA. All rights reserved.