Data Models
Compliance Management Data Model
The following diagram illustrates how families are related within the Compliance Management data models. In the following images, boxes represent entity families, and arrows represent relationship families that are configured in the baseline database.
Asset Has Inspection Plan Relationships
The Asset Has Inspection Plan family links an asset to an Inspection Plan.
The table below provides a description of the relationship definitions that exist for the Asset Has Inspection Plan Relationships family.
This family is not enabled for site filtering, which means that records in this family can be accessed by any user with the appropriate license and family privileges. For more information, refer to the Site Filtering section of the documentation.
| Predecessor | Successor | Cardinality |
|---|---|---|
| Equipment | Inspection Plan | One to One |
| Functional Location | Inspection Plan | One to One |
Has Compliance Recommendations Relationships
The Has Compliance Recommendations family links Compliance Recommendations to Inspection Plans. This family also links the Compliance Recommendation Revisions and Inspection Plan revisions.
The table below provides a description of the relationship definitions that exist for the Has Compliance Recommendations family.
This family is not enabled for site filtering, which means that records in this family can be accessed by any user with the appropriate license and family privileges. For more information, refer to the Site Filtering section of the documentation.
| Predecessor | Successor | Cardinality |
|---|---|---|
| Inspection Plan | Compliance Recommendation | One to Many |
| Inspection Plan Revision | Compliance Recommendation Revision | One to Many |
Has Inspection Plan Revision Relationships
The Has Inspection Plan Revision family is a relationship family that links the Inspection Plan to the Inspection Plan revision.
The table below provides a description of the relationship definitions that exist for the Has Inspection Plan Revision family.
This family is not enabled for site filtering, which means that records in this family can be accessed by any user with the appropriate license and family privileges. For more information, refer to the Site Filtering section of the documentation.
| Predecessor | Successor | Cardinality | Foreign Key |
|---|---|---|---|
| Inspection Plan | Inspection Plan Revision | One to Many | FK_HAIN_PR_INPL_INPL_R_N on the Inspection Plan Revision record. |
Implements Compliance Recommendation Relationships
The Implements Compliance Recommendations family links Compliance Recommendations to Inspection Tasks.
The table below provides a description of the relationship definitions that exist for the Implements Compliance Recommendation family.
This family is not enabled for site filtering, which means that records in this family can be accessed by any user with the appropriate license and family privileges. For more information, refer to the Site Filtering section of the documentation.
| Predecessor | Successor | Cardinality |
|---|---|---|
| Inspection Task | Compliance Recommendation | One to One |