Data field types

You can use the Data Dictionary to view the type of each object field. The following list describes some of the possible field types on an object:

Type

Description

array

Represents a one-to-many relationship. For example, consider the relationship between a contact and a set of addresses. There is no actual column in the database table that maps to the array. PolicyCenter stores this information in the metadata.

column

As the name specifies, it indicates a column in the database. Inside a column field, you can add tag subtypes to point out additional information about the field. The Data Dictionary displays such tags and their values.

foreign key

References a keyable entity. For example, Policy has a foreign key (AccountID) to the related account on the policy, found in the Account entity.

typekey

Represents a discrete value picked from a particular list, called a typelist.

virtual property

Indicates a derived property. PolicyCenter does not store virtual properties in the PolicyCenter physical database.

Note: Inside any field of the data model aside from virtual properties, you can add tags and optional corresponding values to point out additional information about the field. The Data Dictionary displays such tags and values.