Specifies whether Certinia Record Types should be exposed as separate tables.

Data Type

bool

Default Value

false

Remarks

Each Certinia object can have multiple record types, which categorize records within an object based on business processes. For example, the Account object may include record types such as Partner, Customer, and Supplier, each with distinct page layouts, business processes, and picklist values.

By default, record types are not exposed as separate tables, and all records appear within a single table. When ExposeConceptualEntities is set to true, the driver creates additional tables for each record type, allowing direct access to categorized data. This feature simplifies queries by allowing users to retrieve records of a specific type without filtering within a single table.

Usage Considerations

Metadata Complexity: Enabling this property may significantly increase the number of tables in the schema. Large Certinia instances with many record types could experience longer metadata retrieval times.

Schema Changes: If Certinia administrators add or remove record types, the available tables will change dynamically, which may require adjustments in queries and integrations.

Query Optimization: While this feature simplifies record retrieval, users can still achieve the same results using filters on the standard object table. For example, SELECT * FROM Account WHERE RecordType = 'Partner'

This property is useful when working with complex Certinia implementations where record types are heavily used to segment business processes, and users need a more structured way to access specific record categories. Enabling this setting can provide clearer schema organization at the cost of increased metadata complexity.