Defining a table

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the product family that you want to define a table for.
  3. Right-click the product family node and select Add Table Definition.
  4. In the Name field, type a name for the table according to your agency's naming scheme.
    A table name can contain only alphanumeric characters and the underscore ( _ ) and cannot begin with a number.
  5. Select the type of table this will be from the Type list.
    Table types define the core/ functions of a table. When you save this table definition, Infor Public Sector automatically adds some columns and constraints to the table based on the type of table you are creating. Most tables you define will have a table type of Table.
  6. In the Common ID field, type an identification code for this table according to your agency's naming scheme.
    You will use this common ID throughout Infor Public Sector to access and manipulate the table through its business object. 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 (.), asInfor Public Sector is unable to use periods in keyword names.
  7. Specify any other information about the table.
    You can select the Has Null Record check box to direct Infor Public Sector to add a null record for this table when it generates it in the database. The null record contains a 1 in the primary key column and blank values in all other required columns.
  8. Click Save.
    Infor Public Sector adds the table definition to the product family and automatically adds ADDBY, ADDDTTM, MODBY, and MODDTTM columns to the table definition. Infor Public Sector also adds a primary key column and constraint, which uniquely identify the table.
  9. Define other table information.
    You can add columns, add check constraints, add foreign key constraints, add unique key constraints, and add indexes for the table definition.
  10. Generate the table in the database.
    Infor Public Sector does not automatically generate tables in your database from your table definitions. You must manually direct Infor Public Sector to generate your database tables.