This section discusses relationships between Items in IMSMA and also provides instructions on how to create a specific report/sub-reports. The reports discussed so far in this training module have been based on a single data source. In this part of the training module, you will learn to create more complex reports that reference multiple data sources. Some items are dependent on the existence of another item. This type of relationship is referred to as a direct relationship. For example, an accident, land, activity, education, QM, or victim has a direct relationship to the location to which it is associated. The accident, land, activity, education, QM, or victim cannot exist unless it is associated with a location. This direct relationship is enforced in IMSMA via the reconciliation process.</p> [[Image:iRep11iRep13.png|center|500px|''Figure 1113. Location and item records directly associated with itlocation_guid'']]
<div align="center">
''Figure 1113. Location and item records directly associated with itlocation_guid''
</div>
Direct relationships also exist when subsets The location_guid field in the item table contains the guid of data are contained within an the location to which the itemrecord is associated. [[:Image:iRep14. For png|Figure 14]] shows an example, an education may have education details such as of a location and the education type, total audience, accident and percentage of women and menland that are associated to the location. The education details data requires Notice that the location_guid value (1234-1234) in the education accident and land are identical to existthe location_guid of the location.
The following sections will describe the process for creating reports on items that have a direct relationship between them. ===Location and Associated Items===__NOEDITSECTION__A report of locations and associated items requires you to create an iReport sub-report. A sub-report is a report that is contained within another report. A report on locations and its associated item records will require you to create a report and a sub-report. The main report will contain the data for the location. For each associated item that you would like to include, you will need to create a sub-report. [[Image:iRep12iRep14.png|center|500px|''Figure 1214. Location and associated item recordslocation_guid example'']]
<div align="center">
''Figure 1214. Location and associated item recordslocation_guid example''
</div>
All records ===Direct Relationships===This section discusses relationships between Items in IMSMA and also provides instructions on how to create a specific report/sub-reports. The reports discussed so far in this training module have been based on a ''guid''single data source. A ''guid'' is a unique value In this part of the training module, you will learn to create more complex reports that identifies reference multiple data sources. Some items are dependent on the record in the IMSMA databaseexistence of another item. Because the guid is lengthy and comprised This type of alphanumeric characters, it relationship is typically not a useful value referred to display in as a reportdirect relationship. HoweverFor example, an accident, land, activity, education, QM, or victim has a direct relationship to the guid location to which it is necessary in determining which item records have associated. The accident, land, activity, education, QM, or victim cannot exist unless it is associated with a location. This direct relationshipis enforced in IMSMA via the reconciliation process. </p>
All accidents, land, activities, educations, QMs, and victims are associated with a single location. The information about the location to which an item record is associated is stored in the location_guid field of the item table and corresponds to the location_guid of the location to which it is associated ([[:Image:iRep03.png|Figure 13]]). [[Image:iRep13iRep11.png|center|500px|''Figure 1311. location_guidLocation and item records directly associated with it'']]
<div align="center">
''Figure 1311. location_guidLocation and item records directly associated with it''
</div>
The location_guid field in the item table contains the guid Direct relationships also exist when subsets of the location to which the data are contained within an item record is associated. [[:Image:iRep14.png|Figure 14]] shows For example, an example education may have education details such as the education type, total audience, and percentage of a location and the accident women and land that are associated to the locationmen. Notice that The education details data requires the location_guid value (1234-1234) in the accident and land are identical education to the location_guid of the locationexist.
[[Image:iRep14.png|center|500px|''Figure 14. location_guid example'']]
<div align="center">
''Figure 14. location_guid example''
</div>
===Items with Data Subsets===
Certain items have subsets of data that are contained within them. For example, an education may have education details such as the education type, total audience, and percentage of women and men. The education details data requires the education to exist. Table 3. Parent/child relationships lists the items and the data subsets that depend on them.
