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
