Report: Relationship Field Values Uniqueness Test

Search our help articles

Description: This report tests for blanks and duplicates in two values commonly used to relate imported data to user data: SIS ID and email address. Duplicates in either of these values will prevent using the "Belongs To" (Many to One) relationship between InForm data and the Users table based on these values.

Roles that may benefit from this report:
LMS Admins: Can use this report to ensure data integrity and prevent issues when linking imported data to user accounts, enabling accurate reporting and analysis.

SIS Admins: Can verify the uniqueness of SIS IDs and email addresses, preventing errors in data relationships and ensuring reliable connections between user data and other datasets.

image-20240909-153951.png

Columns in Report:
Column Data Descriptions can also be found in the Data Dictionary in the help bar of IntelliBoard

Total number of Users

Total number of SIS IDs

Total count of unique SIS IDs

Total count of users that have an empty SIS ID field

Total number of users who have SIS IDs that are assigned to more than one user