Previous Topic: Conditions Based on the Attributes of the AssignerNext Topic: Conditions Based on the Attributes of the Business Unit of the Request


Conditions Based on the Attributes of the Business Unit

You can specify conditions based on the attributes of the business unit, as follows:

In both of these types of conditions, you can use the following attributes:

business unit type

country

currency

dateFormat

decimalFormat

description

email

federalTaxId

id

name

loginId

openedDate

parent

primaryContact

singleAccountMode

stateTaxId

status

taxRegion

timeFormat

timezone

type

website

data1, data2, data3, data4, data5, data6

The following attributes may require explanation:

Business unit type

Specifies the code for the type of the business unit. Valid values are:

TE - Tenant

ST - Super Tenant

SP -Service Provider

country

Specifies the country code for the business unit.

Enter the code for the country you want from the ca_country table.

An example follows: To list the code of a specific country (here, India) in that table, run the following query on the MDB from your database client:

Select id from ca_country where country='India'

The results show that the country code for India is 114.

To list all country codes for CA Service Catalog, run the following query on the MDB from your database client:

select id from ca_country
currency

Specifies the code for the currency unit (such as dollar, Euro, pound, and so forth) for the business unit.

Enter the value of the currency_type_code you want from the ca_currency_type table.

For example, run the following query on the MDB from your database client:

select currency_type_code from ca_currency_type
dateFormat

Specifies the date format for the business unit. Valid values are:

M/d/yyyy

M-d-yyyy

d/M/yyyy

d-M-yyyy

yyyy/M/d

yyyy-M-d

dd.MM.yyyy

decimalFormat

Specifies the decimal symbol for the business unit. Valid values are:

1 implies that the decimal symbol is a comma (,).

0 implies that the decimal symbol is a dot (.).

parent

Specifies the tenant_id of the parent business unit.

Enter the parent_tenant_id of the usm_tenant_ext table.

For example, run the following query on the MDB from your database client:

select parent_tenant_id from usm_tenant_ext
Single account mode

Specifies whether the business unit contains a single account only. Valid values are:

0 - The business unit users can have multiple accounts.

1- The business unit can have only a single account.

status

Specifies the status of the business unit (not the request). Valid values are:

0 = Inactive (Deleted)

1= Active (Open)

timeformat

Specifies the time format for the business unit. Valid values are:

HH:mm:ss

HH.mm.ss

Timezone

Specifies the code for the time zone (such as Eastern USA, Greenwich Mean Time, Amazon Time, and so forth) for the business unit.

Enter the time_zone_code from the ca_time_zone table.

For example, run the following query on the MDB from your database client:

select time_zone_code from ca_time_zone
data1, data2, data3...

Specify custom data fields, if applicable, that you have created and use.