This is okay since CUs are unique by CODE, SUBTYPE and TABLENAME in the MM_CU_LIBRARY table. But there is one caveat. In the MM_WMS_COMPATIBLE_UNIT_LIBRARY table in the Process Framework database CUs are only unique by CODE. This can cause issues with how the description is displayed. I created a KB article that explains this and how to avoid the issue. Here's the link: Solution - Designer – CU Description Display Discrepancy. Please review this and let me know if you have any questions.
Very helpful. Thanks Kevin!