Nah mate, we've cracked it without the need for a (new) UDF, cheers anyway.

Do tell

See page 1 of this thread, from about half way down!

being totally purist about this.....there is no danger that somoneone could be missed or suspended for a period

So they don't get paid period 1 so balance is zero

Is there a danger that they may not get paid in another period for some reason and the balance could also be zero in that period?

Sorry don't know the dimensions of the balance you are looking at

Hmm, you make a fair point, young man...

Basically the background is this:

Come April 2012, our Civil Service friends are being invited to cough up an extra wedge towards their pensions - the basis for the calculation in any given year is the annualised FTE salary + appropriate allowances as at the end of the previous year. So we have an annualised figure that somewhat perversely is held (on my current site anyway) as a _ASG_PROC_PTD balance; this gets recalculated every month (it's also used for the calculation of the employer's percentage every month, so has already been configured that way).

That's all well and good, but of course we need to cover new starters in-year also, who won't have a figure as at the previous 31st March - hence, we need to obtain the annualised figure as at their hire date - or, if they weren't paid in that period, then the following one.

I would think it highly unlikely (but not impossible) that someone could be on a suspended assignment their first full month, but by the same token it is possible that someone who was already an employee could just so happen to be suspended as at 31st March. So, I shall make appropriate enquiries on that matter.

As a follow-up to that post, I have now been able to confirm that they don't use 'suspend' type assignment statuses here.