Consent data model

The coverage data model shows how the data sets in the Coverage folder relate to one another. The data model determines the report behavior you can expect to see when you use the data sets to create reports.

Data model

Consent data model diagram
At the center of the diagram, you see the Individual Demographics data set. This data set represents the client.
Remember: Consent is the primary data set. You must use data items from this data set when you join Consent data sets in reports. The report displays a single row for each join.
Table 1. Consent data sets and their relationships
Data set relationship Description Report behavior
Individual Demographics ←→ Consent
  • A client has zero or more consent records.
  • The consent record is associated with one client.
  • A single row displays for each client consent.
  • If a client has consent records, the Consent data items display empty cells.
Consent ←→ Consent Attachments
  • A consent record has zero or more consent attachments.
  • The consent attachment is associated with one consent record.
  • A single row displays for each consent attachment.
  • If a consent record has no consent attachments, the Consent Attachment data items display empty cells.
Consent ←→ Individual Tags
  • A consent record is associated with zero or more individual tags.
  • An individual tag is associated with one or more consent records.
  • If a consent record is associated with multiple individual tags, a single row displays for each record.
  • If a consent record has no associated individual tags, the Individual Tags data items display empty cells.
Consent ←→ Individual Identification
  • A consent record is associated with zero or more individual identifications.
  • An individual identification is associated with one or more consent records.
  • If a consent record is associated with multiple individual identifications, a single row displays for each record.
  • If a consent record has no associated individual identifications, the Individual Identification data items display empty cells.
Consent ←→ Consent History
  • A consent record has zero or more consent history records.
  • The consent history is associated with one consent record.
  • A single row displays for each consent history record.
  • If a consent record has no consent history, the Consent Attachment data items display empty cells.
Individual Demographics ←→ Individuals in Programs
  • A client has zero or more programs.
  • The program is associated with one client.
  • If a client is associated with one or more programs, a single row displays for each program.
  • If a client has no associated programs, the Individuals in Programs data items display empty cells.
Individual Demographics ←→ Care Team
  • A client has zero or more care team members.
  • The care team is associated with one client.
  • A single row displays for each care team member for the client.
  • If a client has no care team members, the Care Team Member data items display empty cells.
Care Team ←→ Primary Care Team Member
  • A care team member is or is not a primary care team member.
  • A single row displays for each care team member for the client.
  • If a care team member does not fulfill the primary role on the care team, the Primary Care Team Member data items display empty cells.