11 Replies Latest reply: Feb 23, 2017 10:22 AM by Erick Dameron RSS

    Fiscal Year: Cannot find field

    Erick Dameron

      Hi All,

       

      I am getting this error whenever I try to load my Master Calendar for our Fiscal Year.

      "Cannot find field"

       

      Here is what my script looks like:

       

      Table 1:

      CCM:

      LOAD

          visitdate,

          visitid,

          client_id,

          service,

          staffid,

          provider,

          cpt_code,

          program,

          transfer_date,

          "rate",

          emp_status

      FROM [lib://Q-CCM (tbh_erickd)]

      (XmlSimple, table is [Envelope/Body/ExportDataSetResponse/ExportDataSetResult/diffgram/NewDataSet/Table]);

       

       

       

      // Master Calendar for fiscal year

       

      Calendar:

      Load Dual(fYear-1 &'/'& fYear, fYear) AS FYear,

        Dual(Month, fMonth) AS FMonth,

          *;

       

      Load Year + IF(Month>=$(vFM), 1,0) As fYear,

        Mod(Month-$(vFM),12)+1 As fMonth,

         *;

      Load Visitdate,

      Year(Visitdate) As Year,

      Month(Visitdate) as Month,

      Week(Visitdate) as Week,

       

       

      From Resident CCM;

       

       

      I apologize if this is elementary stuff, I have looked over the information here on the forum but it hasn't clicked just yet.

       

       

       

      Any wisdom would be greatly appreciated!

       

      Erick