brycecaruthers
5/19/2017 - 4:22 PM

Used this query in case 122391 to validate the many accounts I had to create through the process. There was a minimal amount of cleanup requ

Used this query in case 122391 to validate the many accounts I had to create through the process. There was a minimal amount of cleanup required for some duplicates that showed up

122391_CARite_User_Validation.sql
content_copyfile_download
SELECT l.refname, pc.lename, d.lednis, d.label1, pc.phone, u.accountemail, u.lomni, c.frn_phonecode_classid, pc.phonecodeid
FROM phonecode pc
	JOIN lskin l ON l.lskinid = pc.frn_lskinid
	JOIN dnis d ON d.dnisid = pc.outbound_frn_dnisid
	JOIN leuser u ON u.frn_phonecodeid = pc.phonecodeid
	JOIN phonecode_class_pc c ON c.frn_phonecodeid = pc.phonecodeid
WHERE /*pc.lename IN ('Asia Collins','Christina Michael','Dominick Small','Mario Morris','Michelle Evans','Michaelle Evans','Rachel Jackson','Rachel Thomas','Shonique','Tammy Jones','Wally Kulik')
	AND */pc.isactive = 1
	AND u.isactive = 1
	AND c.frn_phonecode_classid = 1526
	AND pc.phonecodeid IN (551077,560207,597477,597480,597481,597482,597483,597485,597486,597487,600019,600021,600022,601795,601797,601798,605447,605452,605453,605464,605465,605466,605468,605469,606391,606392,606394,606395,606396,610655,610659,610662,610663,610665,610668,610669,610672,610829,610980,610986,610987,610988,610989,610991,610992,610993,610994,610995,612105,612106,612107,612109,612110,612111,615378,615420,615425,615427,615430,615432,616212,616213,616215,616217,616218,616220,616221,622134,622136,622137,622138,622139,622140,622141,622142,622143,624289,624632,624635,624637,624639,624657,624660,624661,624662,624664,624674,625903,625905,625906,625907,625908,625909,625912,625917,625918,631468,632855,635595,635596,635597,635598,635599,635600,635601,635602,635603,635604,635605,635606,635607,635608,635980,635984,635985,635986,635987,635988,635989,635990,635991,636009,636010,636019,636329,636330,636331,636332,636336,636337,636338,636339,637127,637129,637130,637131,637138,637139,637140,637142,637143,637144,637145,637146,637147,637148,637149,637150,637152,637153)
ORDER BY l.refname, pc.lename