This document describes the XML representation of the UCF's join list used to connect Controls to Metrics. Each of the elements, types, and attributes that make up the format are described in detail.

The URL for this join table is:

http://unifiedcompliance.com/NFI/XSDs/UCF_Metrics_Join_v2_1.xsd

The purpose of this join tables is to create a link between one or more records in the UCF Controls List to one or more records that are designated as Metrics. A join table is not necessary when there is a one-to-many relationship, and is necessary when there can be a one or more-to-many relationship.

There really isn't much information in each of the join lists, other than the two IDs joining the two tables together and the version of the release this date is valid for.

What makes the Metrics join list different than the other join lists is that the Metrics join list is used to connect the Controls list back to itself. The reason for this is that a Control can also be a Metric if it meets certain criteria. So, sometimes a Control will call out the use of a Metric, other times a Control might be a Metric. And then there are the rest of the times when a Control neither calls for a Metric nor is a Metric.

One item of development note that is critical - there won't be a roll forward change log for the join tables. Each release, developers will be required to completely replace the contents of the join tables.

UCF_Metrics_Join_Item (UCF_Metrics_Join_Item_Type)

The UCF_Metrics_Join_List is comprised of the UCF_Metrics_Join_Item containers. The UCF Metrics Item defines each individual "record" within the list. Each container is split into two key elements that must be present at all times:

• • UCF_Meta_Data

  • UCF_Basic_Info

UCF_Meta_Data (UCF_Meta_Data_Type)

For detailed documentation of Meta Data fields, please refer to the Meta Data documentation. Below is a list of the meta data fields that are included in the various join lists.

• • UCF_Metrics_Release_Version

UCF_Basic_Info (UCF_Basic_Info_Type)

The UCF_Basic_Info element in the join lists is slightly different than in any other list. It will contain exactly two elements of the ID type. Normally these elements would be found within the Meta Data portion of the XML table, but since this is a join table, they comprise the Basic Info for the join.

UCF_CE_ID (UCF_ID_Type)

This is the ID element that represents the record to be joined in the UCF Controls List.

UCF_Metric_ID (UCF_ID_Type)

This is the ID element that represents the record to be joined in the UCF Roles List.