insert missing visit types

--UPDATE
UPDATE CHOICES.PROVIDERS P
   SET P.EXTERNALID2 = (SELECT u.UID_
                         FROM  DB_NYCWMC.USERS U
                        WHERE P.FIRSTNAME = U.UFNAME AND P.LASTNAME = U.ULNAME)
 WHERE EXISTS (
    SELECT 1
      FROM DB_NYCWMC.USERS U
     WHERE P.FIRSTNAME = U.UFNAME AND P.LASTNAME = U.ULNAME );


--INSERT
INSERT INTO CHOICES.PROVIDERS(USERNAME, FIRSTNAME, LASTNAME, TITLE, PROVIDERTYPEID, SPECIALTYID, DISABLED, EXTERNALID2)
SELECT DISTINCT UNAME,  UFNAME,  ULNAME,  U.VMID,  1,  1, 1, uid_
FROM DB_NYCWMC.USERS U
INNER JOIN DB_NYCWMC.ENC EC ON u.UID_ = EC.DOCTORID
LEFT JOIN CHOICES.PROVIDERS P
ON U.UFNAME = P.FIRSTNAME  AND  U.ULNAME = P.LASTNAME
WHERE p.providersid IS NULL;

-- INSERT BROKEN FK
INSERT INTO CHOICES.PROVIDERS(USERNAME, FIRSTNAME, LASTNAME, TITLE, PROVIDERTYPEID, SPECIALTYID, DISABLED, EXTERNALID2)

SELECT DISTINCT 'PROVIDER ' || ec.doctorid as USERNAME,  'PROVIDER ' || ec.doctorid as FIRSTNAME,  'PROVIDER ' || ec.doctorid as LASTNAME,  'PROVIDER ' || ec.doctorid as TITLE,  1 as PROVIDERTYPEID,  1 as SPECIALTYID,  1 as DISABLED, ec.doctorid AS EXTERNALID2
FROM DB_NYCWMC.ENC EC
LEFT JOIN DB_NYCWMC.USERS U ON u.UID_ = EC.DOCTORID
LEFT JOIN CHOICES.PROVIDERS P ON U.UFNAME = P.FIRSTNAME  AND  U.ULNAME = P.LASTNAME
WHERE p.providersid IS NULL AND u.uid_ IS NULL;