The Utilization data model shows how the data sets in the
Utilization 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
In the diagram, you see the Individual
Demographics data set. This data set represents the client.
Remember: Utilization is the primary data set. You must use data items from this data
set when you join Utilization data sets in reports. The report displays a single row for each join.
Table 1. Utilization data sets and their
relationships
| Data set relationship |
Description |
Report behavior |
| Individual Identification ←→ Utilization |
- An individual identification record is associated with one or more utilization records.
- A utilization record is associated with zero or more individual identification records.
|
- If a utilization record is associated with multiple individual identifications, a single row
displays for each individual identification.
- If a utilization record has no associated individual identifications, the individual
identification data items display empty cells.
|
| Utilization ←→ Individual Tags |
- A utilization record is associated with zero or more individual tags.
- An individual tag is associated with one or more utilization records.
|
- If a utilization record is associated with multiple individual tags, a single row displays for
each record.
- If a utilization record has no associated individual tags, the Individual Tags data items
display empty cells.
|
| Individual Demographics ←→ Utilization |
- A client has one or more utilization records.
- A utilization record associated with one client.
|
- If a client has multiple utilization records, a single row displays for each utilization.
- If a client has no utilization records, the Utilization data items display empty cells.
|
| Utilization ←→ Utilization By Program ←→ Individuals in Programs |
- A utilization record has zero or more associated programs.
- A program is associated with zero or more utilization records.
|
- If a utilization record is associated with multiple programs for a client, a single row displays
for each program.
- If a utilization record is not associated with any programs, the Utilization by Program and the
Individuals in Programs data items display empty cells.
- Use the Utilization and Individuals in Programs data sets to display utilization records with
and without associated individual programs.
- Use the Utilization by Program data set to display only utilizations with associated
programs.
|