Skip to content

Instantly share code, notes, and snippets.

@Xodarap

Xodarap/Missing providers.SQL

Created February 8, 2016 22:27
Show Gist options
  • Save Xodarap/7af1ff027905d27c0bff to your computer and use it in GitHub Desktop.
Save Xodarap/7af1ff027905d27c0bff to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Missing providers.SQL
SELECT DISTINCT
doctors.NPI AS "Provider NPI",
users.ufname AS "Provider First Name",
users.ulname AS "Provider Last Name"
FROM
enc INNER JOIN doctors
ON enc.doctorID = doctors.doctorID
LEFT JOIN users
ON doctors.doctorID = users.uid
WHERE
enc.patientID <> 8663
AND enc.date BETWEEN {d '2015-01-01'} AND {d '2016-02-29'}
AND enc.deleteFlag = 0
and doctors.NPI not in
(1003848136,
1013245869,
1013903228,
1023086691,
1033126735,
1033129978,
1043250434,
1053318964,
1053319202,
1053414854,
1053547745,
1053568873,
1053670646,
1063418994,
1063467645,
1073511085,
1073581997,
1073893442,
1083646277,
1083851687,
1083857213,
1114216876,
1114973005,
1114986379,
1124266119,
1124266986,
1124292792,
1134125941,
1134174394,
1144270323,
1154304269,
1154537017,
1164503116,
1164667929,
1174557979,
1174758668,
1184670952,
1184700551,
1184720427,
1194828905,
1194917963,
1205138500,
1205927191,
1215035886,
1215041140,
1215139357,
1225057599,
1225284706,
1225296460,
1235218165,
1245205558,
1245470889,
1245495423,
1255355400,
1255561189,
1255565214,
1265491880,
1275587024,
1275636060,
1285705665,
1285737080,
1316026255,
1326061755,
1346430600,
1356587828,
1366539777,
1366618266,
1366675548,
1376541359,
1376665406,
1376675637,
1386670206,
1386673655,
1386687937,
1386758217,
1407816481,
1417947748,
1417985391,
1427050004,
1427218239,
1427282631,
1437102571,
1437337813,
1437448115,
1447273867,
1447484050,
1447493184,
1457327975,
1457349177,
1457370728,
1457443954,
1457772899,
1467743286,
1477758670,
1477799807,
1487622247,
1487644548,
1487668299,
1487760930,
1487813036,
1487860359,
1508810474,
1518055896,
1518108182,
1518126101,
1518928795,
1528256120,
1538165469,
1538329420,
1538428578,
1538428578,
1548213796,
1548575137,
1568492668,
1568531432,
1578582524,
1578643052,
1578739983,
1588769178,
1598713786,
1609002419,
1609017151,
1609073386,
1609272871,
1609862747,
1609877281,
1619108867,
1619991866,
1629042049,
1629046388,
1629064837,
1639171457,
1639328248,
1649405275,
1649466277,
1669602975,
1699741066,
1699919506,
1700906815,
1710120944,
1710907019,
1720010929,
1720033426,
1720089303,
1730383530,
1730403270,
1740281310,
1740506971,
1740586163,
1750371290,
1760488696,
1770502031,
1770589608,
1770704116,
1780618579,
1780629964,
1801864061,
1801867262,
1801881487,
1821012071,
1821082827,
1821099078,
1821140419,
1821249020,
1831130202,
1831166099,
1831320605,
1851392435,
1861400764,
1861487894,
1861584724,
1861711269,
1871662601,
1871804773,
1881822518,
1881826303,
1902016603,
1902842446,
1902970502,
1912277419,
1912929969,
1922075639,
1932101516,
1942355680,
1942377270,
1952360240,
1952365645,
1952511644,
1952545162,
1962400119,
1962599647,
1962632083,
1962739482,
1972739308,
1972760866,
1982671871,
1982692745,
1992034508,
1992808042,
1992983977,
1003848136,
1013245869,
1013903228,
1023086691,
1033126735,
1033129978,
1043250434,
1053318964,
1053319202,
1053414854,
1053547745,
1053568873,
1053670646,
1063418994,
1063467645,
1073511085,
1073581997,
1073893442,
1083646277,
1083851687,
1083857213,
1114216876,
1114218971,
1114973005,
1114986379,
1124266119,
1124266986,
1124292792,
1134125941,
1134174394,
1144270323,
1154304269,
1154537017,
1164503116,
1164667929,
1174557979,
1174758668,
1184670952,
1184700551,
1184720427,
1194828905,
1194917963,
1205138500,
1205927191,
1215035886,
1215041140,
1215139357,
1225057599,
1225284706,
1225296460,
1235218165,
1245205558,
1245470889,
1245495423,
1255355400,
1255561189,
1255565214,
1265491880,
1275587024,
1275636060,
1285705665,
1285737080,
1316026255,
1326061755,
1346430600,
1356587828,
1366539777,
1366618266,
1366675548,
1366741647,
1376541359,
1376665406,
1376675637,
1386670206,
1386687937,
1386758217,
1407816481,
1417392127,
1417947748,
1417985391,
1427050004,
1427190214,
1427218239,
1427282631,
1437102571,
1437337813,
1437448115,
1447273867,
1447484050,
1447493184,
1457327975,
1457349177,
1457370728,
1457443954,
1457772899,
1467743286,
1477758670,
1477799807,
1487075198,
1487622247,
1487644548,
1487668299,
1487760930,
1487813036,
1487860359,
1508810474,
1518055896,
1518108182,
1518126101,
1518928795,
1528256120,
1538165469,
1538329420,
1538428578,
1538428578,
1548213796,
1548575137,
1568492668,
1568531432,
1578582524,
1578643052,
1578739983,
1588769178,
1598713786,
1609002419,
1609017151,
1609073386,
1609272871,
1609862747,
1609877281,
1619108867,
1619991866,
1629042049,
1629046388,
1629064837,
1629198627,
1639171457,
1639328248,
1649405275,
1649466277,
1669583621,
1669602975,
1699741066,
1699919506,
1700906815,
1710120944,
1710907019,
1720010929,
1720033426,
1720089303,
1730383530,
1730403270,
1740281310,
1740506971,
1740586163,
1750371290,
1760488696,
1770502031,
1770589608,
1770704116,
1780618579,
1780629964,
1801864061,
1801867262,
1801881487,
1821012071,
1821082827,
1821099078,
1821140419,
1821249020,
1831130202,
1831145168,
1831166099,
1831320605,
1851392435,
1861400764,
1861487894,
1861584724,
1861711269,
1871662601,
1871804773,
1881822518,
1881826303,
1902016603,
1902842446,
1902970502,
1912277419,
1912929969,
1922075639,
1932101516,
1942355680,
1942377270,
1942404041,
1952360240,
1952365645,
1952511644,
1952545162,
1962400119,
1962599647,
1962632083,
1962667071,
1962739482,
1972739308,
1972760866,
1982671871,
1982692745,
1992034508,
1992808042,
1992983977)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment