Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you use this type of file to extract your data in data load?
SELECT "PhTheraChange"."PhNPI", "PhTheraChange"."GPIDrugGroup", "PhTheraChange"."GPIDrugClass", "PhTheraChange"."GPIDrugSubClass", "PhTheraChange"."GPIDrugNameCd", "PhTheraChange"."Product", "PhTheraChange"."TheraType", "PhTheraChange"."ReplaceNDC", "PhTheraChange"."NDC", "PhTheraChange"."Sig", "PhTheraChange"."ReplaceCCID", "PhTheraChange"."CCID", "PhTheraChange"."PhTCguid", "Physicians"."PhLName", "Physicians"."PhFName", "PhTheraChange"."InsID", "InsPlans"."InsName", "PhTheraChange"."FacID", "Facilities"."FacName", "FacGroupDefs"."FGName", "FacGroups"."FGID" FROM (((("Fac"."dbo"."PhTheraChange" "PhTheraChange" FULL OUTER JOIN "Fac"."dbo"."Physicians" "Physicians" ON "PhTheraChange"."PhNPI"="Physicians"."PhNPI") FULL OUTER JOIN "Fac"."dbo"."InsPlans" "InsPlans" ON "PhTheraChange"."InsID"="InsPlans"."InsID") INNER JOIN "Fac"."dbo"."Facilities" "Facilities" ON "PhTheraChange"."FacID"="Facilities"."FacID") INNER JOIN "Fac"."dbo"."FacGroups" "FacGroups" ON "PhTheraChange"."FacID"="FacGroups"."FacID") INNER JOIN "Fac"."dbo"."FacGroupDefs" "FacGroupDefs" ON "FacGroups"."FGID"="FacGroupDefs"."FGID" WHERE NOT ("PhTheraChange"."FacID"='mstr' OR "PhTheraChange"."FacID"='test') AND "FacGroups"."FGID"<>'CYCLE' ORDER BY "FacGroupDefs"."FGName", "PhTheraChange"."FacID", "PhTheraChange"."PhNPI", "PhTheraChange"."GPIDrugGroup", "PhTheraChange"."GPIDrugClass", "PhTheraChange"."GPIDrugSubClass", "PhTheraChange"."GPIDrugNameCd", "PhTheraChange"."ReplaceNDC", "PhTheraChange"."InsID"