NXT allows a user to put an end-date on a solicit code, which is very handy. However, solicit codes with an end date still show as active on the Database View record. This is a major issue, where even if end-dates are not available in DB view, the solicit code should no longer be present.

Additionally, you cannot pull a list in NXT of what solicit codes have end dates - making it a huge pain to try and decipher which codes are actually active and not when pulling queries.

Why have a field available that doesn't talk properly with DB view and is unavailable to search on?