BOM Type to Database Type Mappings

When a case model is deployed to ActiveMatrix BPM, the different BOM types are converted into the appropriate database types for use in the CREATE, UPDATE or DROP database scripts.

BOM Type Database Type
SQL Server Oracle DB2
Boolean tinyint number(1,0) smallint
Date datetime timestamp timestamp
Date Time datetime timestamp timestamp
Date Time and Time Zone datetime timestamp timestamp
Decimal (Floating Point) double binary_double double
Decimal (Fixed Point) numeric(p,s) number(p,s) numeric(p,s)/decimal
Integer (Signed) int number(10,0) integer
Integer (Fixed Length) numeric(p,0) number(p,0) numeric(p,0)/decimal
Duration nvarchar(255) nvarchar2(255) varchar(255)
ID nvarchar(255) nvarchar2(255) varchar(255)
Text Either:
  • nvarchar(n), if up to 4000 characters, or
  • nvarchar(max)
Either:
  • nvarchar2(n), if up to 4000 characters, or
  • nclob
Either:
  • varchar(n), if up to 4000 characters, or
  • clob
Time datetime timestamp timestamp
URI nvarchar(255) nvarchar2(255) varchar(255)