Data Lake Table Index
Index of Tables
Policy Service Entity Tables
Billing Service Entity Tables
Claims Service Entity Tables
Aux Data Service Entity Tables
Moratoriums Entity Tables
Policy Service Entity Tables
accounts Table
See the Accounts API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the account (ULID) |
account_state |
varchar(32) |
no |
Current state of the account |
billing_level |
varchar(50) |
no |
Level at which billing within the account takes place. Value may be |
type |
varchar(128) |
no |
The account type per the tenant configuration |
region |
varchar(128) |
yes |
The region assigned to the account (if any) |
auto_renewal_plan_name |
varchar(128) |
yes |
Name of the account’s auto-renewal plan (if any) |
delinquency_plan_name |
varchar(128) |
yes |
Name of the account’s delinquency plan (if any) |
excess_credit_plan_name |
varchar(128) |
yes |
Name of the account’s excess credit plan (if any) |
shortfall_tolerance_plan_name |
varchar(128) |
yes |
Name of the account’s shortfall tolerance plan (if any) |
account_number |
varchar(128) |
yes |
The custom number assigned to the account (if any) |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
account_data_extensions Table
See the Accounts API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
account_locator |
char(26) |
no |
(PK) Identifier of the account the data is associated with (UULD) |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quotes Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the quote (UULD) |
account_locator |
char(26) |
no |
Unique identifier of the quote’s parent account (UULD) |
group_locator |
char(26) |
no |
Unique identifier of the group the quote belongs to (UULD) |
product_name |
varchar(128) |
yes |
The name of the configured product the quote is based on |
quote_state |
varchar(50) |
no |
The state in which the quote currently resides |
billing_level |
varchar(50) |
no |
Level at which billing within the account takes place |
policy_locator |
char(26) |
yes |
The identifier of the resultant policy (if quote has been issued) |
quick_quote_locator |
char(26) |
yes |
The identifier of the originating quick quote (if any) |
region |
varchar(128) |
yes |
The region assigned to the quote (if any) |
auto_renewal_plan_name |
varchar(128) |
yes |
Name of the quote’s auto-renewal plan (if any) |
delinquency_plan_name |
varchar(128) |
yes |
Name of the quote’s delinquency plan (if any) |
issued_time_utc |
datetime(6) |
yes |
Timestamp the quote was issued |
start_time_utc |
datetime(6) |
yes |
Timestamp quote is effective as of |
end_time_utc |
datetime(6) |
yes |
Timestamp quote coverage ends |
accepted_time_utc |
datetime(6) |
yes |
Timestamp the quote was moved to the accepted state |
created_at_utc |
datetime(6) |
no |
Timestamp the quote was created |
created_by |
char(36) |
no |
The identifier of the user that created the quote |
currency |
varchar(128) |
yes |
Currency the quote was written in |
duration |
decimal(19,15) |
yes |
The number of units of duration_basis the quote spans |
duration_basis |
varchar(32) |
yes |
The units of time that the duration of the quote is expressed in |
timezone |
varchar(128) |
yes |
The timezone the quote was written in |
expiration_time_utc |
datetime(6) |
yes |
The timestamp after which the quote can no longer be accepted or issued |
underwriting_status |
varchar(50) |
yes |
The outcome of the underwriting process (if completed) |
quote_number |
varchar(128) |
yes |
The custom number assigned to the quote (if any) |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quote_data_extensions Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
quote_locator |
char(26) |
no |
Identifier of the quote the element data is associated with (ULID) |
element_locator |
char(26) |
no |
(PK) Identifier of the element the data is associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the element type is based on |
element_type |
varchar(128) |
no |
The configured type the element is based on |
is_static |
bool |
no |
(PK) Whether the data is static or not |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quote_elements Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the quote element (ULID) |
quote_locator |
char(26) |
no |
Identifier of the quote the element is associated with (ULID) |
parent_locator |
char(26) |
yes |
Identifier of the parent element immediately above in the quotes data hierarchy |
category |
varchar(128) |
yes |
The category the element type is based on |
type |
varchar(128) |
no |
The configured type the element is based on |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quote_element_tree Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
quote_locator |
char(26) |
no |
Identifier of the quote the element is associated with (ULID) |
parent_locator |
char(26) |
no |
Identifier of the element immediately above in the quote’s data hierarchy (ULID) |
child_locator |
char(26) |
no |
Identifier of an element immediately below in the quote’s data hierarchy (ULID) |
depth |
int |
no |
The number of levels of child elements below in the quote’s data hierarchy |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quote_element_charges Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the quote charge (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the charge is associated with (ULID) |
quote_locator |
char(26) |
no |
Identifier of the quote the charge is associated with (ULID) |
product_name |
varchar(128) |
no |
The name of the configured product the quote is based on |
element_locator |
char(26) |
no |
Identifier of the element the charge is directly associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the element type is based on |
element_type |
varchar(128) |
no |
The configured type the element is based on |
start_time_utc |
datetime(6) |
no |
Start of the period covered by the charge |
end_time_utc |
datetime(6) |
no |
End of the period covered by the charge |
duration |
decimal(19,15) |
yes |
The number of units of |
duration_basis |
varchar(32) |
yes |
The units of time that the |
charge_category |
varchar(128) |
no |
The category the charge type is based on |
charge_type |
varchar(128) |
no |
The configured type the charge is based on |
amount |
decimal(19,3) |
no |
The amount of the charge |
rate |
decimal(19,10) |
no |
Rate describes the amount per unit time (rate * duration = amount) |
reference_rate |
decimal(19,10) |
no |
The reference rate for the charge returned in the rater (if any) |
tag |
varchar(128) |
yes |
The tag for the charge returned in the rater (if any) |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quote_coverage_terms Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
quote_locator |
char(26) |
no |
Identifier of the quote the coverage term is associated with (ULID) |
element_locator |
char(26) |
no |
(PK) Identifier of the element the coverage term is associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the associated element type is based on |
element_type |
varchar(128) |
no |
The configured type the associated element is based on |
name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
name |
varchar(1024) |
no |
The configured name of the coverage term |
option |
varchar(1024) |
no |
The selected option or value of the coverage term |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
quote_element_underwriting_flags Table
See the Quotes API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the underwriting flag for the quote element (ULID) |
quote_locator |
char(26) |
no |
Identifier of the quote the underwriting flag is associated with (ULID) |
element_locator |
char(26) |
yes |
Identifier of the quote element the underwriting flag is associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the associated element type is based on |
element_type |
varchar(128) |
yes |
The configured type the associated element is based on |
level |
varchar(128) |
no |
The level of the underwriting flag, with possible values listed as |
note |
varchar(1024) |
yes |
The custom note associated with the underwriting flag |
created_by |
char(36) |
yes |
Identifier of the user that created the underwriting flag (UUID) |
created_time_utc |
datetime(6) |
no |
Time in UTC the underwriting flag was created |
cleared_by |
char(36) |
yes |
Identifier of the user that cleared the underwriting flag (UUID) |
cleared_time_utc |
datetime(6) |
yes |
Time in UTC the underwriting flag was cleared |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policies Table
See the Policies API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the policy (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the policy is associated with (ULID) |
issued_transaction_locator |
char(26) |
no |
Identifier of the transaction that issued the policy (ULID) |
latest_term_locator |
char(26) |
no |
Identifier of the latest term for the policy (ULID) |
latest_segment_locator |
char(26) |
yes |
Identifier of the latest segment for the policy (ULID) |
product_name |
varchar(128) |
no |
Name of the product associated with the policy |
start_time_utc |
datetime(6) |
no |
Time in UTC the policy goes into effect |
end_time_utc |
datetime(6) |
no |
Time in UTC the policy is no longer effective |
currency |
varchar(128) |
yes |
Currency the policy was written in |
duration_basis |
varchar(32) |
yes |
The units of time that the duration of the policy is expressed in |
timezone |
varchar(128) |
yes |
The timezone the policy was written in |
billing_level |
varchar(50) |
no |
Level at which billing for the policy takes place. Value may be |
created_time_utc |
datetime(6) |
no |
Time in UTC the policy was created |
created_by |
char(36) |
no |
Identifier of the user that created the policy (UUID) |
region |
varchar(128) |
yes |
The region assigned to the policy (if any) |
auto_renewal_plan_name |
varchar(128) |
yes |
Name of the policy’s auto-renewal plan (if any) |
delinquency_plan_name |
varchar(128) |
yes |
Name of the policy’s delinquency plan (if any) |
policy_number |
varchar(128) |
yes |
The custom number assigned to the policy (if any) |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
terms Table
See the Policy Terms API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the term (UUID) |
static_locator |
char(26) |
no |
Static identifier of the term that persists across changes (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the term is associated with (ULID) |
originating_transaction_locator |
char(26) |
no |
Identifier of the transaction the term is associated with (ULID) |
start_time_utc |
datetime(6) |
no |
Time in UTC the term is effective |
end_time_utc |
datetime(6) |
no |
Time in UTC the term is no longer effective |
number |
int(11) |
no |
Sequential number of the term within the policy |
auto_renewal_locator |
char(26) |
yes |
Identifier of the auto-renewal associated with the term (ULID), if any |
previous_term_locator |
char(26) |
yes |
Identifier of the term that preceded this term (ULID), if any |
supersedes_term_locator |
char(26) |
yes |
Identifier of the term that this term supersedes (ULID), if any |
term_number |
varchar(128) |
yes |
The custom number assigned to the term, if any |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
transactions Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the transaction (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the transaction is associated with (ULID) |
term_locator |
char(26) |
no |
Identifier of the term the transaction is associated with (ULID) |
effective_time_utc |
datetime(6) |
no |
Time in UTC the transaction becomes effective |
transaction_state |
varchar(50) |
no |
Current state of the transaction |
category |
varchar(50) |
no |
Category of the transaction |
type |
varchar(128) |
no |
The configured type of the transaction |
created_by |
char(36) |
no |
Identifier of the user that created the transaction (UUID) |
created_time_utc |
datetime(6) |
no |
Time in UTC the transaction was created |
aggregate_transaction_locator |
char(26) |
yes |
Identifier of the aggregate transaction this transaction is part of (ULID), if any |
base_transaction_locator |
char(26) |
yes |
Identifier of the transaction this transaction is derived from (ULID), if any |
issued_time_utc |
datetime(6) |
yes |
Time in UTC the transaction was issued |
accepted_time_utc |
datetime(6) |
yes |
Time in UTC the transaction was accepted |
underwriting_status |
varchar(50) |
yes |
The outcome of the underwriting process (if completed) |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
segments Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the segment (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the segment is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction that created the segment (ULID) |
term_locator |
char(26) |
no |
Identifier of the term the segment is associated with (ULID) |
start_time_utc |
datetime(6) |
no |
Time in UTC the segment begins |
end_time_utc |
datetime(6) |
no |
Time in UTC the segment ends |
duration |
decimal(19,15) |
no |
The number of units of |
duration_basis |
varchar(32) |
yes |
The units of time that the duration of the segment is expressed in |
type |
varchar(50) |
no |
The type of segment |
based_on |
char(26) |
yes |
Identifier of the segment this segment is based on (ULID), if any |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_data_extensions Table
See the Policies API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
policy_locator |
char(26) |
no |
Identifier of the policy the element data is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the element data is associated with (ULID) |
segment_locator |
char(26) |
no |
Identifier of the segment the element data is associated with (ULID) |
segment_element_locator |
char(26) |
no |
(PK) Identifier of the element the data is associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the element type is based on |
element_type |
varchar(128) |
no |
The configured type the element is based on |
is_static |
bool |
no |
(PK) Whether the data is static or not |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_segment_elements Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the segment element (UUID) |
policy_locator |
char(26) |
no |
Identifier of the policy the segment element is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the segment element is associated with (ULID) |
segment_locator |
char(26) |
no |
Identifier of the segment the element is associated with (ULID) |
parent_locator |
char(26) |
yes |
Identifier of the parent element immediately above in the policy data hierarchy (ULID) |
static_locator |
char(26) |
no |
Static identifier of the segment element that persists across changes (ULID) |
category |
varchar(128) |
yes |
The element category the element type is based on |
type |
varchar(128) |
no |
The configured type the element is based on |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_element_tree Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
policy_locator |
char(26) |
no |
Identifier of the policy the element tree is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the element tree is associated with (ULID) |
segment_locator |
char(26) |
no |
(PK) Identifier of the segment the element tree is associated with (ULID) |
parent_locator |
char(26) |
no |
(PK) Identifier of the element immediately above in the policy’s data hierarchy (ULID) |
child_locator |
char(26) |
no |
(PK) Identifier of an element immediately below in the policy’s data hierarchy (ULID) |
depth |
int |
no |
The number of levels of child elements below in the policy’s data hierarchy |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_element_charges Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the charge (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the charge is associated with (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the charge is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the charge is associated with (ULID) |
segment_locator |
char(26) |
no |
Identifier of the segment the charge is associated with (ULID) |
product_name |
varchar(128) |
no |
The name of the configured product the policy is based on |
segment_element_locator |
char(26) |
no |
Identifier of the segment element the charge is directly associated with (ULID) |
element_static_locator |
char(26) |
yes |
Static identifier of the element that persists across changes (ULID) |
element_category |
varchar(128) |
yes |
The category the element type is based on |
element_type |
varchar(128) |
no |
The configured type the element is based on |
start_time_utc |
datetime(6) |
no |
Time in UTC the period covered by the charge begins |
end_time_utc |
datetime(6) |
no |
Time in UTC the period covered by the charge ends |
duration |
decimal(19,15) |
yes |
The number of units of |
duration_basis |
varchar(32) |
yes |
The units of time that the |
charge_category |
varchar(128) |
no |
The category the charge type is based on |
charge_type |
varchar(128) |
no |
The configured type the charge is based on |
amount |
decimal(19,3) |
no |
The amount of the charge |
rate |
decimal(19,10) |
no |
Rate describes the amount per unit time (rate * duration = amount) |
reference_rate |
decimal(19,10) |
no |
The reference rate for the charge returned in the rater (if any) |
rate_difference |
decimal(19,10) |
no |
The difference between the rate and reference rate (if any) |
reversal_of_locator |
char(26) |
yes |
Identifier of the charge reversed by this charge (if any) |
tag |
varchar(128) |
yes |
The tag for the charge returned in the rater (if any) |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_coverage_terms Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
policy_locator |
char(26) |
no |
Identifier of the policy the element data is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the element data is associated with (ULID) |
segment_locator |
char(26) |
no |
Identifier of the segment the element data is associated with (ULID) |
segment_element_locator |
char(26) |
no |
(PK) Identifier of the element the coverage term is associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the associated element type is based on |
element_type |
varchar(128) |
no |
The configured type the associated element is based on |
name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
name |
varchar(1024) |
no |
The configured name of the coverage term |
option |
varchar(1024) |
no |
The selected option or value of the coverage term |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_element_underwriting_flags Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the underwriting flag (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the underwriting flag is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the underwriting flag is associated with (ULID) |
segment_locator |
char(26) |
yes |
Identifier of the segment the underwriting flag is associated with (ULID) |
segment_element_locator |
char(26) |
yes |
Identifier of the policy element the underwriting flag is associated with (ULID) |
element_category |
varchar(128) |
yes |
The category the associated element type is based on |
element_type |
varchar(128) |
yes |
The configured type the associated element is based on |
level |
varchar(128) |
no |
The level of the underwriting flag |
note |
varchar(1024) |
yes |
The custom note associated with the underwriting flag |
created_by |
char(36) |
yes |
Identifier of the user that created the underwriting flag (UUID) |
created_time_utc |
datetime(6) |
no |
Time in UTC the underwriting flag was created |
cleared_by |
char(36) |
yes |
Identifier of the user that cleared the underwriting flag (UUID) |
cleared_time_utc |
datetime(6) |
yes |
Time in UTC the underwriting flag was cleared |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_auto_renewals Table
See the Policy Auto-Renewal API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the policy auto-renewal (ULID) |
term_locator |
char(26) |
no |
Identifier of the term the auto-renewal is associated with (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the auto-renewal is associated with (ULID) |
state |
varchar(50) |
no |
Current state of the auto-renewal |
renewal_transaction_type |
varchar(128) |
no |
The configured type of the renewal transaction |
renewal_transaction_locator |
char(26) |
yes |
Identifier of the renewal transaction (ULID), if created |
new_term_duration |
int(11) |
yes |
Duration of the new term in units of the policy’s |
renewal_transaction_create_time_utc |
datetime(6) |
no |
Time in UTC scheduled for the renewal transaction creation |
renewal_transaction_created_time_utc |
datetime(6) |
yes |
Time in UTC the renewal transaction was created |
renewal_transaction_accept_time_utc |
datetime(6) |
yes |
Time in UTC scheduled for the renewal transaction acceptance |
renewal_transaction_accepted_time_utc |
datetime(6) |
yes |
Time in UTC the renewal transaction was accepted |
renewal_transaction_issue_time_utc |
datetime(6) |
yes |
Time in UTC scheduled for the renewal transaction issuance |
renewal_transaction_issued_time_utc |
datetime(6) |
yes |
Time in UTC the renewal transaction was issued |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_transaction_change_instructions Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the change instruction (ULID) |
policy_locator |
char(26) |
no |
Identifier of the policy the change instruction is associated with (ULID) |
transaction_locator |
char(26) |
no |
Identifier of the transaction the change instruction is associated with (ULID) |
action |
varchar(50) |
no |
The action to be performed by the change instruction |
data |
longtext |
yes |
Structured data defining the change instruction details |
effective_time_utc |
datetime(6) |
yes |
Time in UTC the change instruction becomes effective |
static_locator |
char(26) |
yes |
Static identifier of the element the change instruction applies to (ULID), if applicable |
new_policy_end_time_utc |
datetime(6) |
yes |
Time in UTC the policy ends, if the change instruction modifies it |
trigger_billing_change |
bool |
yes |
Indicates whether the change instruction should trigger billing changes |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
policy_preferences Table
See the Policy Transactions API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
policy_locator |
char(26) |
no |
Identifier of the policy the preferences are associated with (ULID) |
transaction_locator |
char(26) |
no |
(PK) Identifier of the transaction the preferences are associated with (ULID) |
billing_plan_name |
varchar(128) |
yes |
Name of the billing plan assigned to the policy, if any |
billing_level |
varchar(128) |
yes |
Level at which billing for the policy takes place ( |
installment_weights |
varchar(1024) |
yes |
Custom weights for installment amounts, if specified |
installment_plan_name |
varchar(128) |
yes |
Name of the installment plan assigned to the policy, if any |
anchor_mode |
varchar(128) |
yes |
Mode for anchoring installment generation timing |
anchor_time_utc |
datetime(6) |
yes |
Time in UTC to anchor installment generation, if applicable |
anchor_type |
varchar(128) |
yes |
Type of anchor for installment generation timing |
cadence |
varchar(128) |
yes |
Frequency of installment generation (e.g., |
day_of_month |
varchar(128) |
yes |
Day of the month for installment generation, if applicable |
day_of_week |
varchar(128) |
yes |
Day of the week for installment generation, if applicable |
due_lead_days |
varchar(128) |
yes |
Number of days before due date that invoices are generated |
generate_lead_days |
varchar(128) |
yes |
Number of days in advance to generate installments |
max_installments_per_term |
int |
yes |
Maximum number of installments allowed per term, if specified |
week_of_month |
varchar(128) |
yes |
Week of the month for installment generation, if applicable |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
Billing Service Entity Tables
installments Table
See the Installments API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the installment (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the installment is associated with (ULID) |
due_time_utc |
datetime(6) |
no |
Time in UTC the installment payment is due |
generate_time_utc |
datetime(6) |
no |
Time in UTC the installment was generated |
currency |
varchar(128) |
no |
Currency of the installment |
timezone |
varchar(128) |
no |
Timezone in which the installment was generated |
coverage_duration |
decimal(19,3) |
no |
Duration of coverage represented by the installment |
coverage_start_time_utc |
datetime(6) |
no |
Time in UTC when coverage for the installment begins |
coverage_end_time_utc |
datetime(6) |
no |
Time in UTC when coverage for the installment ends |
installment_duration |
decimal(19,3) |
no |
Duration of the installment period |
installment_start_time_utc |
datetime(6) |
no |
Time in UTC when the installment period begins |
installment_end_time_utc |
datetime(6) |
no |
Time in UTC when the installment period ends |
installment_frame_index |
int(11) |
no |
Index of the installment within the billing frame sequence |
created_by |
char(36) |
no |
Identifier of the user that created the installment (UUID) |
created_at_utc |
datetime(6) |
no |
Time in UTC the installment was created |
updated_by |
char(36) |
no |
Identifier of the user that last updated the installment (UUID) |
updated_at_utc |
datetime(6) |
no |
Time in UTC the installment was last updated |
invoice_locator |
char(26) |
yes |
Identifier of the invoice the installment is associated with (ULID), if any |
policy_locator |
char(26) |
yes |
Identifier of the policy the installment is associated with (ULID), if any |
quote_locator |
char(26) |
yes |
Identifier of the quote the installment is associated with (ULID), if any |
transaction_locator |
char(26) |
yes |
Identifier of the transaction that triggered the installment (ULID), if any |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
installment_items Table
See the Installments API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the installment item (ULID) |
installment_locator |
char(26) |
no |
Identifier of the installment the installment item is associated with (ULID) |
charge_locator |
char(26) |
no |
Identifier of the charge the installment item is associated with (ULID) |
segment_element_locator |
char(26) |
no |
Identifier of the segment element the installment item is associated with (ULID) |
charge_category |
varchar(128) |
no |
Category of the associated charge |
charge_type |
varchar(128) |
no |
Type of the associated charge |
amount |
decimal(19,3) |
no |
Amount of the installment item |
created_time_utc |
datetime(6) |
no |
Time in UTC the installment item was created |
created_by |
char(36) |
yes |
Identifier of the user that created the installment item (UUID) |
element_static_locator |
char(26) |
no |
Static identifier of the associated segment element (ULID) |
invoice_item_locator |
char(26) |
yes |
Identifier of the associated invoice item (ULID), if any |
reversal_of_locator |
char(26) |
yes |
Identifier of the installment item reversed by this installment item (ULID), if any |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
invoices Table
See the Invoices API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the invoice (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the invoice is associated with (ULID) |
start_time_utc |
datetime(6) |
no |
Time in UTC when the invoice period begins |
end_time_utc |
datetime(6) |
no |
Time in UTC when the invoice period ends |
due_time_utc |
datetime(6) |
no |
Time in UTC when the invoice is due |
generated_time_utc |
datetime(6) |
no |
Time in UTC the invoice was generated |
currency |
varchar(128) |
no |
Currency of the invoice |
timezone |
varchar(128) |
no |
Timezone in which the invoice was generated |
invoice_state |
varchar(50) |
no |
Current state of the invoice |
invoice_number |
varchar(128) |
yes |
The custom number assigned to the invoice, if any |
total_amount |
decimal(19,3) |
yes |
Total amount of the invoice |
total_remaining_amount |
decimal(19,3) |
yes |
Remaining unpaid amount of the invoice |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
invoice_items Table
See the Invoices API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the invoice item (ULID) |
invoice_locator |
char(26) |
no |
Identifier of the invoice the item is associated with (ULID) |
timezone |
varchar(128) |
no |
Timezone for the invoice item |
amount |
decimal(19,3) |
yes |
Amount of the invoice item |
charge_category |
varchar(128) |
no |
Category of the associated charge |
charge_type |
varchar(128) |
no |
Configured type of the associated charge |
policy_locator |
char(26) |
yes |
Identifier of the policy the invoice item is associated with (ULID), if any |
quote_locator |
char(26) |
yes |
Identifier of the quote the invoice item is associated with (ULID), if any |
element_static_locator |
char(26) |
yes |
Static identifier of the element associated with the invoice item (ULID), if any |
remaining_amount |
decimal(19,3) |
yes |
Remaining unpaid amount of the invoice item |
settlement_time_utc |
datetime(6) |
yes |
Time in UTC when the invoice item was fully settled |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
payments Table
See the Payments API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the payment (UUID) |
currency |
varchar(128) |
no |
Currency of the payment |
payment_state |
varchar(30) |
no |
Current state of the payment |
amount |
decimal(19,3) |
yes |
Amount of the payment |
type |
varchar(128) |
no |
The configured type of the payment |
created_by |
char(36) |
no |
Identifier of the user that created the payment (UUID) |
created_at_utc |
datetime(6) |
no |
Time in UTC the payment was created |
account_locator |
char(26) |
yes |
Identifier of the account the payment is associated with (ULID), if any |
ext_cash_trx_locator |
char(26) |
yes |
Identifier of the external cash transaction (ULID), if any |
posted_at_utc |
datetime(6) |
yes |
Time in UTC the payment was posted |
remaining_amount |
decimal(19,3) |
yes |
Remaining unapplied amount of the payment |
reversal_reason |
varchar(1024) |
yes |
Reason for the payment reversal, if reversed |
reversed_at_utc |
datetime(6) |
yes |
Time in UTC the payment was reversed |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
payment_data_extensions Table
See the Payments API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
payment_locator |
char(26) |
no |
(PK) Identifier of the payment the extension data is associated with (ULID) |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
disbursements Table
See the Disbursements API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the disbursement (UUID) |
currency |
varchar(128) |
no |
Currency of the disbursement |
disbursement_state |
varchar(30) |
no |
Current state of the disbursement |
amount |
decimal(19,3) |
yes |
Amount of the disbursement |
type |
varchar(128) |
no |
The configured type of the disbursement |
created_by |
char(36) |
no |
Identifier of the user that created the disbursement (UUID) |
created_at_utc |
datetime(6) |
no |
Time in UTC the disbursement was created |
account_locator |
char(26) |
yes |
Identifier of the account the disbursement is associated with (ULID), if any |
ext_cash_trx_locator |
char(26) |
yes |
Identifier of the external cash transaction (ULID), if any |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
disbursement_data_extensions Table
See the Disbursements API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
disbursement_locator |
char(26) |
no |
(PK) Identifier of the disbursement the extension data is associated with (ULID) |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
delinquencies Table
See the Delinquency API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the delinquency (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the delinquency is associated with (ULID) |
timezone |
varchar(128) |
no |
Timezone for the delinquency |
delinquency_state |
varchar(52) |
no |
Current state of the delinquency |
advance_lapse_to |
varchar(128) |
no |
The state to which the system should automatically advance the lapse transaction |
grace_period_days |
int(11) |
no |
Number of days in the grace period before lapse |
lapse_transaction_type |
varchar(128) |
no |
The configured type of lapse transaction to be created |
delinquency_level |
varchar(128) |
yes |
Level at which the delinquency is applied. Value may be |
created_at_utc |
datetime(6) |
no |
Time in UTC the delinquency was created |
updated_at_utc |
datetime(6) |
no |
Time in UTC the delinquency was last updated |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
grace_end_at_utc |
datetime(6) |
yes |
Time in UTC when the grace period ends |
grace_started_at_utc |
datetime(6) |
yes |
Time in UTC when the grace period started |
lapse_transaction_effective_date_utc |
datetime(6) |
yes |
Effective date in UTC for the lapse transaction, if applicable |
billing_holds Table
See the Billing Holds API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the billing hold (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the billing hold is associated with (ULID) |
hold_state |
varchar(50) |
no |
Current state of the billing hold |
target_type |
varchar(50) |
no |
The type of entity the billing hold applies to |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
write_offs Table
See the Write-Offs API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the write-off (ULID) |
account_locator |
char(26) |
no |
Identifier of the account the write-off is associated with (ULID) |
currency |
varchar(128) |
no |
Currency of the write-off |
write_off_state |
varchar(30) |
no |
Current state of the write-off |
amount |
decimal(19,3) |
no |
Amount of the write-off |
credit_type |
varchar(128) |
no |
Type of credit associated with the write-off |
created_by |
char(36) |
no |
Identifier of the user that created the write-off (UUID) |
created_at_utc |
datetime(6) |
no |
Time in UTC the write-off was created |
reversal_reason |
varchar(1024) |
yes |
Reason for the write-off reversal, if reversed |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
credit_items Table
See the Credits API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
credit_locator |
char(26) |
no |
(PK) Identifier of the associated credit (ULID), with referenced entity defined by |
credit_type |
varchar(128) |
no |
Type of the associated credit, with possible values listed as |
container_locator |
char(26) |
no |
(PK) Identifier of the associated source or target container (ULID), with referenced entity defined by |
container_type |
varchar(128) |
no |
(PK) Type of the associated container, with possible values listed as |
amount |
decimal(19,3) |
yes |
Amount of the credit item |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
credit_distributions Table
See the Credit Distribution API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the credit distribution (ULID) |
account_locator |
char(26) |
no |
Identifier of the associated account (ULID) |
currency |
varchar(128) |
no |
Currency of the credit distribution |
credit_distribution_state |
varchar(30) |
no |
State in which the credit distribution currently resides, with possible values listed as |
amount |
decimal(19,3) |
no |
Amount of the credit distribution |
created_time_utc |
datetime(6) |
no |
Time in UTC the credit distribution was created |
created_by |
char(36) |
yes |
Identifier of the user that created the credit distribution (UUID) |
execution_time_utc |
datetime(6) |
yes |
Time in UTC the credit distribution was executed |
reversal_reason |
varchar(1024) |
yes |
Reason for the credit distribution reversal |
reversal_time_utc |
datetime(6) |
yes |
Time in UTC the credit distribution was reversed |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
Claims Service Entity Tables
fnols Table
See the FNOL API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the first notice of loss or FNOL (UUID) |
type |
varchar(128) |
no |
The configured type of the FNOL |
fnol_state |
varchar(128) |
no |
Current state of the FNOL |
account_locator |
char(26) |
yes |
Identifier of the account the FNOL is associated with (ULID), if any |
policy_locator |
char(26) |
yes |
Identifier of the policy the FNOL is associated with (ULID), if any |
segment_locator |
char(26) |
yes |
Identifier of the segment the FNOL is associated with (ULID), if any |
region |
varchar(128) |
yes |
The region assigned to the FNOL, if any |
fnol_number |
varchar(128) |
yes |
The custom number assigned to the FNOL, if any |
created_by |
char(36) |
no |
Identifier of the user that created the FNOL (UUID) |
created_at_utc |
datetime(6) |
no |
Time in UTC the FNOL was created |
updated_by |
char(36) |
yes |
Identifier of the user that last updated the FNOL (UUID) |
updated_at_utc |
datetime(6) |
yes |
Time in UTC the FNOL was last updated |
incident_time_utc |
datetime(6) |
yes |
Time in UTC when the incident occurred |
incident_timezone |
varchar(126) |
yes |
Timezone in which the incident occurred |
incident_summary |
longtext |
yes |
Summary description of the incident |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
fnol_data_extensions Table
See the FNOL API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
fnol_locator |
char(26) |
no |
(PK) Identifier of the FNOL the extension data is associated with (ULID) |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
claims Table
See the FNOL API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
char(26) |
no |
(PK) Unique identifier of the claim (ULID) |
type |
varchar(128) |
no |
The configured type of the claim |
fnol_locator |
char(26) |
yes |
Identifier of the FNOL the claim is associated with (ULID) |
created_by |
char(36) |
no |
Identifier of the user that created the claim (UUID) |
created_at_utc |
datetime(6) |
no |
Time in UTC the claim was created |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
claim_data_extensions Table
See the FNOL API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
claim_locator |
char(26) |
no |
(PK) Identifier of the claim the extension data is associated with (ULID) |
field_name_md5 |
char(32) |
no |
(PK) The MD5 hash of the |
field_name |
varchar(4096) |
no |
The key name of the extension data field |
field_value |
varchar(1024) |
yes |
The value of the extensions data field |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
Aux Data Service Entity Tables
aux_data Table
See the Aux Data API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
locator |
varchar(64) |
no |
(PK) User-defined identifier for grouping aux data keys (e.g., an entity locator or |
key_name |
varchar(126) |
no |
(PK) Name of the aux data key, unique within the given |
var_value |
longtext |
no |
Value assigned to the aux data key, stored as text |
ui_type |
varchar(64) |
no |
Indicates how the aux data should appear in the UI; value may be |
created_time_utc |
datetime(6) |
no |
Time in UTC the aux data was created |
updated_time_utc |
datetime(6) |
no |
Time in UTC the aux data was last updated |
updated_by |
char(36) |
yes |
Identifier of the user who created the aux data (UUID) |
expiration_time_utc |
datetime(6) |
yes |
Time in UTC the aux data expires |
aux_data_settings_name |
varchar(128) |
yes |
Name of the settings that apply to the aux data |
deleted |
tinyint(1) |
yes |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
Moratoriums Entity Tables
moratoriums Table
See the Moratoriums API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
moratorium_name |
varchar(128) |
no |
(PK) Unique name of the moratorium |
moratorium_type |
varchar(128) |
no |
The type of the moratorium |
description |
varchar(512) |
yes |
The description of the moratorium |
application_mode |
varchar(128) |
no |
Indicates whether the moratorium applies to all eligible policies or whether there is an option to opt in or out. Value may be |
effective_time_utc |
datetime(6) |
no |
Time in UTC the moratorium takes effect |
end_time_utc |
datetime(6) |
yes |
Time in UTC the moratorium ends |
is_effective_time_waived |
tinyint(1) |
yes |
Indicates whether eligible policies issued after the moratorium effective time are affected |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
moratorium_elections Table
See the Moratoriums API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
moratorium_name |
varchar(128) |
no |
(PK) Unique name of the moratorium |
entity_type |
varchar(128) |
no |
(PK) The type of the entity associated with the moratorium election. Value may be |
entity_locator |
char(26) |
no |
(PK) The locator of the entity associated with the moratorium election (ULID) |
election |
varchar(128) |
no |
The election made for the moratorium. Value may be |
is_deleted |
tinyint(1) |
no |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |
moratorium_statuses Table
See the Moratoriums API for reference.
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
tenant_locator |
char(36) |
no |
(PK) Unique identifier of the tenant (UUID) |
moratorium_name |
varchar(128) |
no |
(PK) Unique name of the moratorium |
entity_type |
varchar(128) |
no |
(PK) The type of the entity associated with the moratorium status. Value may be |
entity_locator |
char(26) |
no |
(PK) The locator of the entity associated with the moratorium status (ULID) |
is_applicable |
tinyint(1) |
no |
Indicates whether the moratorium is applicable to the associated entity |
is_eligible |
tinyint(1) |
no |
Indicates whether the associated entity is eligible for the moratorium |
is_in_scope |
tinyint(1) |
no |
Indicates whether the associated entity is governed by the moratorium based on both applicability and eligibility |
application_mode |
varchar(128) |
no |
Indicates whether the moratorium applies to all eligible policies or whether there is an option to opt in or out. Value may be |
is_deleted |
tinyint(1) |
no |
Indicates whether the record has been deleted |
datalake_created_timestamp |
datetime(6) |
no |
Time in UTC the record was created |
datalake_updated_timestamp |
datetime(6) |
no |
Time in UTC the record was last updated |