Add system table in Studio

About this task

Use Studio to add a new system table.

Procedure

  1. In Studio, create a file named entity.eti.
    1. In the Project window, navigate to configuration > config > Extensions > Entity.
    2. Right click the Entity node, and then select New > Entity from the menu.
    3. Enter the name of the entity, and select Extendable, Exportable, and Final.
    4. Add columns, typekeys, or other fields. For example, add a Jurisdiction typekey with the following values:

      Name

      Value

      name

      Jurisdiction

      typelist

      Jurisdiction

      nullok

      true

      Examine an entity definition for an existing system table in the configuration > config > Metadata > Entity folder for an example of how to define your system table entity.
  2. In Studio, create a file named entity.xml.
    1. In the Project window, navigate to configuration > config > resources > systables.
    2. Right click the systables node, and then select New > File from menu.
    3. Enter the name of the entity, including the .xml extension.
    4. Add the following elements to your new XML file, including elements for the table columns you defined in the entity. The following example includes a column for Jurisdiction: 
          <?xml version="1.0"?>
    <import xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:noNamespaceSchemaLocation="http://www.guidewire.com/cc/import/cc_import.xsd">
      <Jurisdiction/>
    </import>
    5. Save the XML file.
  3. In Studio, add a new FileDefinition element for your new system table to systables.xml:
    1. In the Project window, navigate to configuration > config > resources and open systables.xml.
    2. Add a FileDefinition element that provides a link between the system table XML file and the system table entity file. For example: 
          <FileDefinition Name="my_class_codes.xml" Priority="0">
        <Entity Type="MyClassCodes"/>
    </FileDefinition>
    3. If needed, add parameters to specify a verifier class and whether to manage the system table externally.
  4. Use Product Designer to fill in system table values, as follows:
    1. Log into Product Designer. If you are already logged in, log out and log in again to reload the PolicyCenter configuration values.
    2. Navigate to System Tables, and then locate and open your new system table XML file.
    3. Add rows to the system table using Product Designer.