Defines an organization/department which will contain users and accounts.
| Column Name | Column Datatype | Column Null Option | Column 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 |
| closed_date | date | with null | The closed date, if this tenant is no longer active or deleted |
| description | nvarchar(64) | with null | The description of the tenant |
| nvarchar(128) | with null | The email address for the tenant | |
| opened_date | date | not null | The date when the tenant is created |
| status | integer | not null | Status of the tenant
0 Inactive(deleted), 1 active |
| tenant_name | nvarchar(50) | not null | The readable name of the tenant |
| website | nvarchar(128) | with null | Tenants website address |
| single_account_mode | integer | with null | 0 true, 1 false(default) |
| decimal_format | integer | with null | 0 period, 1 comma |
| federal_tax_payer_id | nvarchar(32) | with null | |
| date_format | nvarchar(20) | with null | The format of date display, configurable at the tenant level |
| tax_region | nvarchar(64) | with null | |
| time_format | nvarchar(12) | with null | The format of time display, configurable at the tenant level |
| login_domain | nvarchar(64) | with null | The login domain for a domanin based login, if the login is not tenant based |
| domain_type | nvarchar(4) | not null | Specifies the type of the tenant, SP - Service Provider, ST - Super Tenant, TE - Tenant |
| pwd_policy_id | varchar(50) | with null | Handle to the tenant based password policy |
| data1 | nvarchar(32) | with null | For external integration/implementation |
| data2 | nvarchar(32) | with null | For external integration/implementation |
| state_tax_payer_id | nvarchar(32) | with null | |
| data3 | nvarchar(32) | with null | For external integration/implementation |
| data4 | nvarchar(64) | with null | For external integration/implementation |
| contact_uuid | byte(16) | with null | |
| data5 | nvarchar(64) | with null | For external integration/implementation |
| data6 | nvarchar(128) | with null | For external integration/implementation |
| data7 | nvarchar(128) | with null | For external integration/implementation |
| currency_type_code | varchar(3) | with null | Handle to the currency object |
| time_zone_code | varchar(64) | with null | Handle to the time zone object |
| location_uuid | byte(16) | with null | FK to ca_location table |
| company_uuid | byte(16) | with null | FK to ca_company table |
| path | varchar(1024) | with null | |
| organization_uuid | byte(16) | with null | FK to ca_organization table |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| tenant_id | usm_offering | domain |
| tenant_id | usm_note | domain |
| tenant_id | usm_subscription_detail | domain |
| tenant_id | usm_request | domain |
| tenant_id | usm_rate_plan | domain |
| tenant_id | usm_planning_set | domain |
| tenant_id | usm_fiscal_period | domain |
| tenant_id | usm_export | domain |
| tenant_id | usm_sla_instance | tenant_id |
| tenant_id | usm_role | domain |
| tenant_id | usm_dash | tenant_id |
| tenant_id | usm_cost_pool | domain |
| tenant_id | usm_contract | tenant_id |
| tenant_id | usm_configuration | domain |
| tenant_id | usm_billing_group | domain |
| tenant_id | usm_billing_account | domain |
| tenant_id | usm_account | tenant_id |
| tenant_id | usm_user | domain |
| tenant_id | usm_tenant_ext_ldap_conf | tenant_id |
| tenant_id | usm_tenant | parent_tenant_id |
| tenant_id | usm_plan_def | domain |
| tenant_id | usm_subscription_mgmt | domain |
| tenant_id | usm_plan_set | domain |