Add a New ALN Domain

You use the ALN Domain dialog box to add a new domain that uses one of the alphanumeric data types.

To create a new ALN domain:

Open the Domains (SP) application.
Click Add New Domain and select Add New ALN Domain.
In ALN Domain window, in the Domain field, enter a name for the domain.
In the Domain Description field, enter a short description.
In the Data Type field, enter a valid data type or click Select Value . The choices are: UPPER, LOWER, ALN, and LONGALN.
In the Length field, enter a length that is equal to or less than the length of the field that will use the domain. For example, if you are adding a domain for a field in the Assets (SP) application that has a length of 12, then specify a length of 12.

Since you can use a domain with multiple fields, the length you specify here must be less than or equal to the length of the shortest field you will use the domain with. For example, if you want to use the domain with three fields of lengths 8, 10, and 12, specify a length of 8 or less for the domain.

Note: If you specify a length greater than the field the domain is used in, you will not be able to assign the domain to the attribute in Database Configuration. Alternatively, you can specify a greater length here and later go to Database Configuration and change the length of the field that uses the domain.

Click New Row to add Domain values.
Fill in the Value and Description fields as appropriate.
The system by default applies domains at the system level. If you want a domain value to apply to a specific organization or site, enter the relevant values in the Organization and Site fields.

Note: Either leave the Organization and/or Site fields empty for all values (users in all organizations and sites can access them) or specify an organization and/or site for all values (only users in the specified organizations and/or sites can access them).

Not following the above recommendation can yield complicated outcomes. For example, if you enter a value RED with no organization specified, a value GREEN with Organization A specified, and a value BLUE with Organization B specified, then records in Organization A will only have access to GREEN. Records that are in Organization B will only have access to BLUE. Records that are in other organizations will only have access to RED. Once you specify an organization and/or site for one value, records in that organization and/or site will no longer have access to values that have no organization/site specified.

In the Customer field, select a customer to associate the domain with the customer and restrict use of the domain to objects that are associated with the customer.
Click New Row again to add more values, or click Close Details .
Click OK.

You have now added a new domain to the system database. However, you must still attach the domain to the object/attribute you want the domain to be used with, as well as other tasks.

Add a New ALN Domain

To create a new ALN domain:

See Also