Data Lake Table Index
Index of Tables
accounts Table
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
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 |
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) |
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
id |
bigint |
no |
(PK) Auto-generated record identifier |
account_locator |
char(26) |
no |
Identifier of the account the data is associated with (UULD) |
fieldName |
varchar(4096) |
no |
The key name of the extension data field |
fieldValue |
varchar(1024) |
yes |
The value of the extensions data field |
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
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 quotes’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 |
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 afterwhich the quote can no longer be accepted or issued |
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 |
quote_elements Table
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
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 |
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
id |
bigint |
no |
(PK) Auto-generated record identifier |
quote_locator |
char(26) |
no |
Identifier of the quote the element data is associated with (ULID) |
element_locator |
char(26) |
no |
Identifier of the element 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 |
Whether the data is static or not |
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 |
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
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 |
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
The Charges feature guide for more information
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
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) |
yes |
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 duration of the quote is expressed in |
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) |
yes |
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) |
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
id |
bigint |
no |
(PK) Auto-generated record identifier |
quote_locator |
char(26) |
no |
Identifier of the quote the coverage term is associated with (ULID) |
element_locator |
char(26) |
no |
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 |
varchar(1024) |
no |
The configured name of the coverage term |
option |
varchar(1024) |
no |
The selected option or value of the coverage term |
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
quote_locator |
char(26) |
no |
|
element_locator |
char(26) |
yes |
|
element_category |
varchar(128) |
yes |
|
element_type |
varchar(128) |
yes |
|
level |
varchar(128) |
no |
|
note |
varchar(1024) |
yes |
|
created_by |
char(36) |
yes |
|
created_time_utc |
datetime(6) |
no |
|
cleared_by |
char(36) |
yes |
|
cleared_time_utc |
datetime(6) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
account_locator |
char(26) |
no |
|
issued_transaction_locator |
char(26) |
no |
|
latest_term_locator |
char(26) |
no |
|
latest_segment_locator |
char(26) |
yes |
|
product_name |
varchar(128) |
no |
|
start_time_utc |
datetime(6) |
no |
|
end_time_utc |
datetime(6) |
no |
|
currency |
varchar(128) |
yes |
|
duration_basis |
varchar(32) |
yes |
|
timezone |
varchar(128) |
yes |
|
billing_level |
varchar(50) |
no |
|
created_time_utc |
datetime(6) |
no |
|
created_by |
char(36) |
no |
|
region |
varchar(128) |
yes |
|
auto_renewal_plan_name |
varchar(128) |
yes |
|
delinquency_plan_name |
varchar(128) |
yes |
|
policy_number |
varchar(128) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
static_locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
originating_transaction_locator |
char(26) |
no |
|
start_time_utc |
datetime(6) |
no |
|
end_time_utc |
datetime(6) |
no |
|
number |
int(11) |
no |
|
auto_renewal_locator |
char(26) |
yes |
|
previous_term_locator |
char(26) |
yes |
|
supersedes_term_locator |
char(26) |
yes |
|
term_number |
varchar(128) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
term_locator |
char(26) |
no |
|
effective_time_utc |
datetime(6) |
no |
|
transaction_state |
varchar(50) |
no |
|
category |
varchar(50) |
no |
|
type |
varchar(128) |
no |
|
created_by |
char(36) |
no |
|
created_time_utc |
datetime(6) |
no |
|
aggregate_transaction_locator |
char(26) |
yes |
|
base_transaction_locator |
char(26) |
yes |
|
issued_time_utc |
datetime(6) |
yes |
|
accepted_time_utc |
datetime(6) |
yes |
|
underwriting_status |
varchar(50) |
yes |
|
billing_trigger |
varchar(50) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
term_locator |
char(26) |
no |
|
start_time_utc |
datetime(6) |
no |
|
end_time_utc |
datetime(6) |
no |
|
duration |
decimal(19 |
yes |
|
NOT |
NULL |
yes |
|
duration_basis |
varchar(32) |
yes |
|
type |
varchar(50) |
no |
|
based_on |
char(26) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
id |
bigint |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
segment_locator |
char(26) |
no |
|
segment_element_locator |
char(26) |
no |
|
element_category |
varchar(128) |
yes |
|
element_type |
varchar(128) |
no |
|
is_static |
bool |
no |
|
field_name |
varchar(4096) |
no |
|
field_value |
varchar(1024) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
segment_locator |
char(26) |
no |
|
parent_locator |
char(26) |
yes |
|
category |
varchar(128) |
yes |
|
type |
varchar(128) |
no |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
segment_locator |
char(26) |
no |
|
parent_locator |
char(26) |
no |
|
child_locator |
char(26) |
no |
|
depth |
int |
no |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
account_locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
segment_locator |
char(26) |
no |
|
product_name |
varchar(128) |
no |
|
segment_element_locator |
char(26) |
no |
|
element_category |
varchar(128) |
yes |
|
element_type |
varchar(128) |
no |
|
start_time_utc |
datetime(6) |
no |
|
end_time_utc |
datetime(6) |
no |
|
duration |
decimal(19) |
yes |
|
DEFAULT |
NULL |
yes |
|
duration_basis |
varchar(32) |
yes |
|
charge_category |
varchar(128) |
no |
|
charge_type |
varchar(128) |
no |
|
amount |
decimal(19) |
yes |
|
NOT |
NULL |
yes |
|
rate |
decimal(19) |
yes |
|
NOT |
NULL |
yes |
|
reference_rate |
decimal(19) |
yes |
|
NOT |
NULL |
yes |
|
rate_difference |
decimal(19) |
yes |
|
NOT |
NULL |
yes |
|
tag |
varchar(128) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
id |
bigint |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
segment_locator |
char(26) |
no |
|
segment_element_locator |
char(26) |
no |
|
element_category |
varchar(128) |
yes |
|
element_type |
varchar(128) |
no |
|
name |
varchar(1024) |
no |
|
option |
varchar(1024) |
no |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
segment_locator |
char(26) |
yes |
|
segment_element_locator |
char(26) |
yes |
|
element_category |
varchar(128) |
yes |
|
element_type |
varchar(128) |
yes |
|
level |
varchar(128) |
no |
|
note |
varchar(1024) |
yes |
|
created_by |
char(36) |
yes |
|
created_time_utc |
datetime(6) |
no |
|
cleared_by |
char(36) |
yes |
|
cleared_time_utc |
datetime(6) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
term_locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
state |
varchar(50) |
no |
|
renewal_transaction_type |
varchar(128) |
no |
|
renewal_transaction_locator |
char(26) |
yes |
|
new_term_duration |
int(11) |
yes |
|
renewal_transaction_create_time_utc |
datetime(6) |
no |
|
renewal_transaction_created_time_utc |
datetime(6) |
yes |
|
renewal_transaction_accept_time_utc |
datetime(6) |
yes |
|
renewal_transaction_accepted_time_utc |
datetime(6) |
yes |
|
renewal_transaction_issue_time_utc |
datetime(6) |
yes |
|
renewal_transaction_issued_time_utc |
datetime(6) |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
locator |
char(26) |
no |
|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
action |
varchar(50) |
no |
|
data |
longtext |
yes |
|
effective_time_utc |
datetime(6) |
yes |
|
static_locator |
char(26) |
yes |
|
new_policy_end_time_utc |
datetime(6) |
yes |
|
trigger_billing_change |
bool |
yes |
|
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
Column Name |
Type |
Nullable |
Description |
|---|---|---|---|
policy_locator |
char(26) |
no |
|
transaction_locator |
char(26) |
no |
|
billing_plan_name |
varchar(128) |
yes |
|
billing_level |
varchar(128) |
yes |
|
installment_weights |
varchar(1024) |
yes |
|
installment_plan_name |
varchar(128) |
yes |
|
anchor_mode |
varchar(128) |
yes |
|
anchor_time_utc |
datetime(6) |
yes |
|
anchor_type |
varchar(128) |
yes |
|
cadence |
varchar(128) |
yes |
|
day_of_month |
varchar(128) |
yes |
|
day_of_week |
varchar(128) |
yes |
|
due_lead_days |
varchar(128) |
yes |
|
generate_lead_days |
varchar(128) |
yes |
|
max_installments_per_term |
int |
yes |
|
week_of_month |
varchar(128) |
yes |
|
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 |