Configuring system tables

Access system tables in Studio if you are configuring new system tables. Access system tables in Product Designer, if you are adding, removing, or changing data in an existing system table.

All system tables must be defined in systables.xml. Only system tables listed in systables.xml appear in Studio and Product Designer. PolicyCenter loads system tables into the database at system startup. If you do not add the system table XML file name to the systables.xml file:

Studio does not recognize the file to be a resource.
Studio does not load the system table into the database.
Studio does not display the contents of the system table in the PolicyCenter interface.

If you add a system table with a Code column that references a product model pattern, Guidewire recommends that you use CodeIdentifier in that column.

If you want to control when PolicyCenter loads a particular system table, do not add the system table XML file name to systables.xml. You then can write your own code to load the system table into the database when the system table is needed.

Within systables.xml, you can specify the order in which to load the system table XML files by using the FileDefinition Priority attribute. As PolicyCenter loads the product model, it loads files with a lower priority value before files with a higher priority value; PolicyCenter loads files with the same priority value concurrently.

The loading order is critical if there are dependencies between system tables. For example, the line-specific class code system tables must be loaded prior to the industry codes system table. Therefore, Guidewire sets the priority value for the class code files lower than the priority value for the industry code file.

In Studio, you can see this in systables.xml. The bop_class_codes system table has a dependency on the class_code_basis system table. Therefore, bop_class_codes has priority of 1, and class_code_basis has priority 0.

<FileDefinition  Name= "class_code_basis.xml"  Priority= "0">
  ...
</FileDefinition>
...
<FileDefinition  Name= "bop_class_codes.xml"  Priority= "1">
  <Dependency  Name= "class_code_basis.xml">
    ...
  </Dependency>
</FileDefinition>