Customizing › How to Add Custom Fields to the User Interface › Additional Data Fields

Additional Data Fields

The Business Unit, Account, and User schemas in the CA Service Catalog database tables provide additional data fields. By default, these fields do not have labels, meaning that they do not appear on the CA Service Catalog user interface. You can optionally expose an additional data field on the user interface by adding a label for the field in the custom.xml file.

The additional data fields and their data types follow.

• The additional data fields (and their types) for business units in the usm_tenant table follow:

  data1: nvarchar(32)
  data2: nvarchar(32)
  data3: nvarchar(32)
  data4: nvarchar(64)
  data5: nvarchar(64)
  data6: nvarchar(128)
  data7: nvarchar(128)

• The additional data fields (and their types) for accounts in the usm_account table follow:

  data1: nvarchar(32)
  data2: nvarchar(32)
  data3: nvarchar(32)
  data4: nvarchar(64)
  data5: nvarchar(64)
  data6: nvarchar(64)
  data7: nvarchar(128)

• The additional data fields (and their types) for users in the usm_contact_extension table follow:

  data1: nvarchar(512)
  data2: nvarchar(512)
  data3: nvarchar(512)
  data4: nvarchar(512)
  data5: nvarchar(512)
  data6: nvarchar(512)
  data7: nvarchar(512)