Defining a reference entity

You use a reference entity to store reference data for later access from within PolicyCenter without having to call out to an external application. For example, you can use reference entities to store:

Medical payment procedure codes, descriptions, and allowed amounts
Average reserve amounts, based on coverage and loss type
PIP aggregate limits, based on state and coverage type

You can populate a reference entity by importing its data, and then you can query it using Gosu expressions. If you do not want PolicyCenter to update the reference data, set setterScriptability = hidden during entity definition.

Important: You can use any entity type as a reference entity. However, if you use the entity solely for storing and querying reference data, then Guidewire recommends that you use a keyable entity.

Example

This example defines a read-only reference table named ExampleReferenceEntityExt.

<entity entity="ExampleReferenceEntityExt" table="exampleref" type="keyable" 
        setterScriptability="hidden">
  <column name="StringColumn" type="shorttext"/>
  <column name="IntegerColumn" type="integer"/>
  <column name="BooleanColumn" type="bit"/>
  <column name="TextColumn" type="longtext"/>
  <index name="internal1">
    <indexcol name="StringColumn" keyposition="1"/>
    <indexcol name="IntegerColumn" keyposition="2"/>
  </index>
</entity>