Skip to Content
0
Former Member
Jan 27, 2010 at 03:08 PM

Script to deduct hours taking a logn time to run

16 Views

Any suggestions on how I can make this faster? Thanks.

//== Deduct Holiday hours from Spread Regular Hours

//========================

//========================

*XDIM_MEMBERSET ENTITYST=<ALL>

*XDIM_MAXMEMBERS ENTITYST=25

*XDIM_GETINPUTSET ENTITYST

*APP STAFF_BUDGET

*XDIM_MEMBERSET ACCOUNTST=DITFLAG

*XDIM_MEMBERSET JOBCODE=NO_JOBCODE

*XDIM_MEMBERSET WEEKS=VARBUDYEAR.WKINP

*CRITERIA SIGNEDDATA=3

*ENDXDIM

*Select(%JustBudgetWeeks%,"ID","Weeks","[ParentH1]='varBudYear.AllWeeks'")

*XDIM_MEMBERSET Weeks=%JustBudgetWeeks%,varBudYear.WKINP

*XDIM_MEMBERSET DataSrcSt=Input_Base

*XDIM_MEMBERSET Time=varBudYear.INP

*XDIM_MEMBERSET ActionPlan=<ALL>

*XDIM_MEMBERSET Category=Budget

*XDIM_MEMBERSET JobCode=<ALL>

*XDIM_MEMBERSET AccountST=HRS_REGULAR,HRS_Holiday, HRS_Overtime

*WHEN ENTITYST.GROUP

*IS = "FPP"

*WHEN AccountSt

*IS="HRS_REGULAR"

*REC(EXPRESSION=GET(ACCOUNTST="HRS_REGULAR")-GET(ACCOUNTST="HRS_HOLIDAY"),ACCOUNTST="HRS_REGULAR")

*ENDWHEN

*REC(EXPRESSION=4,NOADD,AccountSt="DITFlag",ActionPlan="Base",Category="Budget",JobCode="No_JobCode",DataSrcSt="Input_Base",Time="varBudYear.INP",Weeks="varBudYear.WKINP")

*ENDWHEN

*COMMIT