Data model
Multivalued reference fields
Support for multivalued reference fields is extended on record profiles, data change requests, match, and reporting.
These enhancements are enabled by default in your Network instance.
Profiles
Multivalued fields can now be edited on record profiles. Previously, the fields were locked.
CDA fields
These CDA fields remain read-only on profiles:
-
all_degree_cda__v -
all_spec_cda__v -
all_spec_group_cda__v
Edit multivalued fields
When the profile page is in Edit mode, you can search for values, add, remove and sort values on the fields.
Click the Undo
icon to revert the change.
Add values
Values display on the field in the order that they are added.
A maximum of 50 values can be added to each field. When the limit is reached, the remaining values are dimmed and cannot be selected.
Sort values
You can change the order of the values so they are listed by priority.
Click the field and hover over a value to display the Handle 
icon. Use the icon to move the value into a different position in the list.
Data change requests
Data stewards can identify and manage changes to multivalued fields. Previously, the fields were read-only.
CDA fields
These CDA fields remain read-only on DCRs:
-
all_degree_cda__v -
all_spec_cda__v -
all_spec_group_cda__v
Identify changes
Before editing the field, Data Stewards can quickly identify the values that are requested to be changed.
-
New values - Highlighted in green color.
-
Removed values - Dimmed with a strikethrough.
-
Current values - Highlighted in gray color.
When Data Stewards click the Edit icon, the highlighting and strikethroughs are removed. Data Stewards can search for values, add, remove, and sort the values.
Sort values
Data Stewards can change the order of the values in the list.
To reorder the fields, click the Sort 
icon and choose one of the following options:
-
Order by Requested Value - (Default) Display the requested values at the beginning of the list.
-
Order by Current Value - Display the current value on the record at the beginning of the list. The newly requested values will move to the end of the list.
To manually reorder values so they are listed by priority, click the field and hover over a value to display the Handle icon. Use the icon to move the value into a different position in the list.
Submit DCRs from the Network API
Integration users can submit data change requests on custom multivalued reference fields.
A maximum of 50 values are supported for each field.
Exceeded limit
If the limit is exceeded, the changes for that field will be automatically rejected.
The following Resolution Note will be applied to the task:
System Rejected - Multivalued field's reference code count has exceeded the limit.
The result in the API will be CHANGE_REJECTED.
Reporting
Advanced reporting users can run queries on multivalued reference fields in the SQL Query Editor (Reports). Previously, when the fields were used, they were treated as a String.
New multivalued fields SQL functions
Use the following functions to query the fields:
-
multivalued_size - Query the number of values in a multivalued list. Returns an integer.
Syntax
multivalued_size(<multivalued field name>)
-
multivalued_index - Returns the position index (1-based) if the reference code is present in the list (or null if the value is not present).
Syntax
multivalued_index(<multivalued field name>, '<ref code>')
-
multivalued_value - Extract a single reference code at a given position (or null if no value is in the list at the position specified).
Syntax
multivalued_value(<multivalued field name>, index)
-
multivalued_has - Returns True or False if the list contains all the provided reference codes (order does not matter).
Syntax
multivalued_has(<multivalued field name>, '<ref code 1>', '<ref code 2>', ... )
-
multivalued_contains - Returns True or False if the list contains all the provided reference codes (order matters).
Syntax
multivalued_contains(<multivalued field name>, '<ref code 1>', '<ref code 2>', ...)
-
multivalued_anyOf - Returns True or False if the list contains any of the provided reference codes (order does not matter).
Syntax
multivalued_anyOf(<multivalued field name>, '<ref code 1>', '<ref code 2>', ...)
-
multivalued_firstOf - Returns the first reference code from the multivalued list from the given reference codes (order of arguments does not matter).
Syntax
multivalued_anyOf(<multivalued field name>, '<ref code 1>', '<ref code 2>', ...)
Match
Administrators and Data Managers can use multivalued fields in match rule configurations.
They are supported for the following:
-
Data Groups
-
Match Rule features
-
Match Rule feature sets
Multivalued fields can also be exported in match logs.
Cluster management
Updated cluster codes from Insight Health™ are available for Germany.
The new cluster version is Version 3.0.
The new cluster version is available by default if you have the country/provider combination enabled in your Network instance.
Update addresses
To update addresses with the latest cluster codes:
-
In the Admin console, click Data Model > Cluster Management.
-
Select the Germany / Insight Health cluster configuration.
-
In the Cluster Management Details section, expand the Cluster Version field and choose Version 3.
-
Save your changes.
-
Click Refresh Addresses to run a data maintenance job to ensure that all addresses for Germany have the latest cluster codes.