Example of an Entity Relationship Diagram for a Workflow Policy

The following figure displays the entity relationship diagram of four Workflow Policy components for a service request. It shows each of the components, their relations to one another, and the columns that are of interest as follows:

• There are four components: Service Request (S_SRV_REQ) labelled primary Workflow Policy component, Account (S_PARTY), Activity (S_EVT_ACT), and Account Agreements (S_DOC_AGREE).

• There is a direct relationship between Service Request and Account (via CST_OU_ID, foreign key).

• There is a direct relationship between between Service Request and Activity (via ROW_ID, primary key).

• There is an indirect relationship between Service Request and Account Agreements via the Account object (via the TARGET_OU_ID of S_DOC_AGREE referencing the ROW_ID of S_PARTY)