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 column to.
  3. Click the Columns node.
    A grid is displayed on the right showing all columns and domains that have been added to this table definition.
  4. Click Add above the grid.
  5. In the Name field, type a name for the column.
    A column name can contain only alphanumeric characters and the underscore/ ( _ ) and cannot begin with a number.
  6. Select the column's SQL type from the SQL Type list.
  7. In the Common ID field, type an identification code for the column according to your agency's naming scheme.
    You will use the common ID throughout Infor Public Sector to identify this column, such as in formulas. Although the common ID is not required to be unique, making it unique will help you identify it later.
    If you plan to create keywords for your agency objects in the Keyword Manager, ensure that the common ID doesn't include any periods (.), as Infor Public Sector is unable to use periods in keyword names.
  8. Type a maximum character length for the column in the Length field.
  9. Specify any other information about the column.
    You can indicate that the column can accept a null value by selecting the Database accepts nulls check box or indicate that the column is a required value by selecting the Required by the Business Object check box. You can use the Create Search Order field to indicate that this column is displayed as a search field in any popup that is bound to its business object. You can use the Grid Search Order field to indicate that this column is displayed in the results grid in any popup that is bound to its business object. For more information on defining popups, see Defining a popup. You can also add a check constraint to the column.
  10. Click Save.
    Infor Public Sector assigns a key value to the column and adds the column to the table definition. 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 in the database.