Add SNM domain in maximo

The creation of domains isĀ  very easy except the SYNONYM domain, so I made a little tutorial for me and you..

Path: Maximo menu -> System configuration -> Platofrm configuration -> Domains (its easy but hard to remember)

This typeof domain is a bit special so you are not able to make it by easiest way (Add a new Domain).. okay.. could be easier but..

At first there is table with basic fields of SNM domain:

Field Description
Internal Value Specify the internal value for which you want a synonym.

For example, in the STATUS domain, if you want to create a synonym for WAPPR called WAPPR, you would specify the WAPPR internal value.

Value Specify the synonym value you want a user to see.

For example, WAPPR.

Description Type a description of the synonym to differentiate it from the existing value.

In the Synonym Domain , the Internal Value is used by the system and must be unique. The Value and its description are what users see.

First step

Check if domain name does not exists

select * from MAXDOMAIN where domainid='%DOMAINID%'

Second step

Create snm domain as record in mxdomain table

insert into MAXDOMAIN (domainid,description,domaintype,maxtype,length,scale,maxdomainid,internal) VALUES ('SNM_TEST', 'test synonym domain','SYNONYM','UPPER', 16, 0, NEXT VALUE FOR MAXDOMAINSEQ,0)

Create a value for snm domain in syndom table

INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DESCRIPTION, DEFAULTS, SYNONYMDOMAINID, VALUEID) VALUES ('SNM_TEST', 'OPEN','OPEN', 'Open', 1, NEXT VALUE FOR SYNONYMDOMAINSEQ, 'FAU_SYN_TEST|OPEN')

In this case we need a record with defined MAXVALUE , after that we are able to add any value with same MAXVALUE new by maximo web interface.