Data Relationships

This content applies solely to Connected Underwriting Life, which must be purchased separately from the Appian base platform. This content was written for Appian 23.4 and may not reflect the interfaces or functionality of other Appian versions.

Introduction

The central custom data types and database entities in Connected Underwriting Life Workbench (CU Life) solution are associated with the case record. Understanding the relationships between these entities can help you understand how the data in the application work together.

The entity relationship diagrams (ERD) on this page illustrate the main entities used in the CU Life solution and their relationships to each other.

Case Entity Relationship Diagram

This ERD covers three things. First, the diagram illustrates the main relationships between a case and case details in the CU Life solution. Second, it provides a graphic overview of the tables used for the reference list of all cases available in the CU Life solution. Finally, it provides a graphic overview of reference rule data editable from the frontend of the solution and reference case data that not editable from the frontend of the solution.

ERD drill-downs

This section includes drill-down views of each major relationship group in the Case Entity Relationship Diagram. The following legend uses diagram symbols, notations, and colors to indicate the different relationship types illustrated.

cu_life_erd_legend

Basic Case and Coverage ERD

This ERD illustrates the relationship between a case and coverage information.

images/cu_basic_case_and_coverage_information.png

Case and Case Parties ERD

This ERD illustrates the relationship between a case and case parties.

Case and Case Risk ERD

This ERD illustrates the relationship between a case and case risk information.

images/cu_life_case_risk_information.png

Risk Factor Tagging ERD

This ERD illustrates the relationship between a case, case requirements, and risk factor tagging.

Case and Case Completion ERD

This ERD illustrates the relationship between a case and case completion details.

images/cu_life_case_completion_details.png

Case and Miscellaneous Case Information ERD

This ERD illustrates the relationship between a case and miscellaneous case information.

images/cu_miscellaneous_case_information.png

Case and Documents ERD

This ERD illustrates the relationship between a case, case documents, and case requirements.

images/cu_life_documents_and_requirements.png

CU Life Add-On Modules ERDs

These ERs illustrate the relationship between a case and the following add-on modules that integrate with the CU Life solution:

images/cu_add_on_modules_data_relationships.png

Feedback

Was this page helpful?