This document describes the XML representation of the UCF's join list between the Tasks and Records lists. 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_Rec_Cat_to_Gen_Prot_Data_Fields_Join_v2_1.xsd

The purpose of this join tables is to create a link between one or more records in the UCF Records Category List to one or more records in the UCF Controls List. 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.

UCF_Join_Item (UCF_Join_Item_Type)

The UCF_Rec_Cat_to_Gen_Prot_Data_Fields_Join_List is comprised of the UCF_Join_Item containers. The UCF_Join_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_References

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_Join_Release_Version

  • UCF_Join_ID (ucf:UCF_ID2_Type)

  • UCF_Join_Live_Status (xs:integer)

UCF_References (UCF_Reference_Type)

The UCF_References 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_Record_ID (UCF_ID_Type)

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