Disallow Duplicate Constituent Codes to be Added

Don't allow users or processes such as Import, Global Change, etc., to add a duplicate Constituent Code. If that Constituent Code already exists, skip that instead of adding the same one again. There is no good way to clean up duplicated types of data in NXT and this table is one where (I don't think) there should ever be multiples of the same type.

  • Amelia Ketzle
  • Nov 12 2026
  • Attach files
  • Guest commented
    13 Nov 17:01

    Question - what do you do if, for example, a Current Board Member rotated off the board, but came back after # years? Using the dates only, we would have Current (date-date), Former (date-date), and then Current (new date).... creating duplication. Must be a better way.