Coverage data model

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

Data model

Coverage data model diagram
At the center of the diagram, you see the Individual Demographics data set. This data set represents the client.
Remember: Coverage is the primary data set. You must use data items from this data set when you join Coverage data sets in reports. The report displays a single row for each join.
Table 1. Coverage data sets and their relationships
Data set relationship Description Report behavior
Coverage ←→ Individual Identification
  • A coverage record is associated with zero or more individual identifications.
  • An individual identification is associated with one or more coverage records.
  • If a coverage record is associated with multiple individual identifications, a single row displays for each individual identification record.
  • If a coverage record has no associated individual identifications, the Individual Identification data items display empty cells.
Coverage ←→ Individual Tags
  • A coverage record is associated with zero or more individual tags.
  • An individual tag is associated with one or more coverage records.
  • If a coverage record is associated with multiple individual tags, a single row displays for each record.
  • If a coverage record has no associated individual tags, the Individual Tags data items display empty cells.
Individual Demographics ←→ Coverage
  • A client has one or more coverage records.
  • A coverage record is associated with one client.
  • Only clients with coverage records are displayed.
  • If a client has multiple coverage records, a single row displays for each record.
Individual Demographics ←→Touchpoint
  • A client has zero or more touchpoints.
  • A touchpoint is associated with one client.
  • If a client has one or more touchpoints, a single row displays for each record.
  • If a client has no touchpoints, the Touchpoint data items display empty cells.
Individual Demographics ←→ Care Team
  • A client has one or more care team members.
  • A care team is associated with one client.
  • Only clients with care team members are displayed.
  • If a client has no care team, the client is not displayed.
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.