Query to Check for Multiple/Duplicate Logins

The relevant query is as follows:

1. Get the person_id for the employee

    select person_id     from per_people_f

    where last_name like &LASTNAME

2. Now use the person_id in the following SQL

    select count(*) from wf_users

    where orig_system_id = &PERSON_ID

    and status = 'ACTIVE'

If count is greater than one, you got duplicates