Hello All,

Can someone please tell me what the difference is between user_type = 4 and user_type = 6?

I have noticed there are 2 rows for one employee and there are 2 differently formatted usernames in the username column.

In the cf_users table one username is a DOMAIN\username and another is username@email.com.

Example:

username               email                      password      user_type

JDoe@city.com      JDoe@city.com      NULL             4

DOMAIN\JDoe       JDoe@city.com      NULL             6

I would like to omit any 4 user_types and need to know how that will impact the data.

@████████, have you ever seen this?

Thanks!