Issue with CU_BIO_VW Resolved
The issue with CU_BIO_VW has been resolved as of 4/29/15. Name of type Primary will be displayed for user even if other name types exist for record.
We recently identified an issue with a table/record used in some private queries which results in people being excluded from reports. The issue affects queries which used the record CU_BIO_VW for names (first, middle, last) when a name of name type Primary isn’t the latest added/modified name in their record. Currently this applies to over 890 records at Baruch.
To determine if this issue could be affecting your query results you can check if the CU_BIO_VW record is used in your query. Within the Baruch Query Manager wiki space you can view the private queries we've created and documented at Baruch and check to see if the CU_BIO_VW record is listed among the records used in the query – see screen shot below for reference.
Query Managers can also check the query via Reporting Instance by looking at the “Query” tab to see if the record is included.
We have made a request to CUNY CIS to modify the CU_BIO_VW to reflect the latest effective dated Primary name regardless of other name types which may be included in the record. If this change is made this issue will be resolved. If it can’t be made we will likely need to modify the existing private queries using the CU_BIO_VW record.
We will follow up with updates on this issue.
Please follow up with any questions.