Domains: SYNONYMS

 

Domains: SYNONYMS

SYNONYMS domains are special, reserved domains in the system. You cannot officially add or delete synonym domains. You can add new synonym values that are presented to the user.
These work similar fashion like ALN domains. However, they let you add more values to be shown to user which corresponds to the built in internal values.  Creating Synonym domains and adding internal values are not possible via UI. However, database queries can be made to insert those.

Adding a new SYNONYM domain

Synonym domains cannot be created in DB. They need to be created in DB only.

The following query will create synonym domain with domainid as TESTSYNONYM, type as UPPER and length as 10.

insert into maxdomain
(domainid, description, domaintype, maxtype, length, scale, maxdomainid, internal)
values ('TESTSYNONYM', 'Testing Synonyms', 'SYNONYM', 'UPPER', 10, 0, nextval for MAXDOMAINSEQ, 1)

This can now be viewed in Maximo. However, since it does not have any internal values yet. Maximo wont let you add any values in it.

Adding a new internal values in a SYNONYM domain

Again internal values can only be added using db query. The following query will add an internal value of ABC and value of ABC.

insert into synonymdomain ( domainid, maxvalue, value, description, defaults,siteid, orgid, synonymdomainid, valueid)
values
('TESTSYNONYM', 'ABC', 'ABC', 'Testing', 1,null, null, nextval for SYNONYMDOMAINSEQ, 'ABC|A');

Now new values can be added in this domain using Maximo

Adding value in SYNONYM domain

This can be done using Maximo UI.

Open the domain and click New Row. Enter values and done.