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"
