This content applies solely to Connected Underwriting, 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. |
The central custom data types and database entities in the Connected Underwriting P&C (CU P&C) 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 P&C solution and their relationships to each other.
This ERD covers three things. First, the diagram illustrates the main relationships between a case and case details in the CU P&C solution. Second, it provides a graphic overview of the tables used to reference all cases available in the CU P&C solution. Finally, it provides a graphic overview of reference rule data editable from the front end of the solution and reference case data that is not editable from the front end of the solution.
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.
This ERD illustrates the relationship between a submission and the submission's transactional and reference data.
This ERD illustrates the relationship between a submission and the submission's priority scoring and scoring tables.
This ERD illustrates the relationship between a submission and parties.
This ERD illustrates the relationship between a submission and alerts.
This ERD illustrates the relationship between a submission and message reference data.
This ERD illustrates the relationship between a submission and sanctions check information and results.
This ERD illustrates the relationship between a submission, task, associated task note data, and the transactional task data related to the submission.
This ERD illustrates the relationship between a submission, line of business, and risk information.
This ERD illustrates the relationship between a submission, mail poller, documents, and exceptions.
Data Relationships