1 Reply Latest reply: Feb 1, 2018 8:04 AM by Sunny Talwar RSS

    Help with LOAD SCRIPT

    Celia Seward

      Below is a portion of my load script:

      CPCFile:

      LOAD

          schoolid,

          therapistid,

          disciplineid,

          discipline,

          studentid,

          //tdate as DATE,

          date(tdate,'M/DD/YYYY') as DATE,

          "direct",

          IEPdirect,

          consult,

          consult*billrate as ConsultBilled,

          reeval,

          indirect,

          screen,

          eval,

          rti,

          other,

          individual,

          intervention,

          ei,

          billrate,

          schoolyear,

          grade,

          grpsz,

       

      The BOLDED parts are billed hours.  grpsz can be NULL or an integer.   if grpsz = 1, then I want to add the value of IEPdirect to individual and then set IEPdirect=0 and "direct"=0.   Let me say that if grpsz has a value other than NULL, then IEPdirect and "direct" will be greater than 0(zero).

       

      Any ideas for me?

       

      Thanks