Adding a domain to a table definition

After you've added a table definition, you'll want to add columns to it. You can either define your own columns or add predefined columns, called domains. A domain is a template for a column that is displayed frequently throughout Infor Public Sector. Using a domain instead of defining the same column in several tables reduces the amount of data that you must enter and ensures that the column is always formatted in the same way.

Infor Public Sector automatically adds ADDBY (added by), ADDDTTM (add date and time), MODBY (modified by), and MODDTTM (modified date and time) domains when you add the table definition. You can add other domains as required.

Note: If the column is specific to the current table definition and not one that has already been defined, you'll want to add the column manually instead of adding a domain.

See Adding a column to a table definition.

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the Columns node for the table definition that you want to add the domain to.
  3. Click the Columns node.
    A grid is displayed on the right showing the four standard domains that are automatically added to every table definition.
  4. Click Add above the grid.
  5. From the Dom list, select the domain that you want to use for this column.
    Infor Public Sector automatically fills out some of the information about the column, including its name, common ID, and SQL type.
  6. Specify any other information about the column.
    You can provide additional information about the domain in the Description field. You can also add a check constraint to the domain.
  7. Click Save.
    Infor Public Sector assigns a key value to the column and adds the column to the table definition. Infor Public Sector saves any changes you made to the domain to the current column only, not to the domain itself. The new column is displayed in the Columns grid. Note that changing or deleting an existing column will cause errors wherever it has already been used. If you change or delete a column, you must update any references to it throughout your system. Also note that the column is added to the table definition, not to the table itself. To add the column to the table, you must generate the table to the database.