Hail payroll geeks

Before I go traipsing off to write a UDF for this, can anyone tell me a more obvious way (within a payroll formula) to discern the first period/year that an employee assignment was processed in a payroll run?

Ta much.

Edited to add: no, emp_hire_date is not a reliable indicator in this situation!

If you have some idea of what date the person was first processed, then you can use "GET_PAYROLL_PERIOD".

Thanks for your response Peter, however the problem I have is that I don't necessarily know that date either.

This issue is around someone who is hired very late on in the pay period, and thereby gets processed for the first time in the following pay period.

However, I think I have a cunning plan for avoiding the need for a UDF - in normal situations I am looking for a balance at the appropriate date, which ordinarily is the period in which the employee was hired. That balance can be relied on to be non-zero, except when there was no processing done in that period - therefore, if I encounter a zero figure in that situation, I merely have to get the balance as at the following period.

Hi CT,

How are you referring to the balance in your formula? Do you only need to determine this in the first period they are processed?

Delboy

Del Boy,

Every month the formula looks for the balance as at the start of their hire date - most of the time we use a UDF to pass in the specified period end date. The only exception to this normally is where the employee is processed for the first time in the same period as the hire date, whereupon the function won't find an in-memory balance - in this case we refer to the DB item.

Ok...I was perhaps thinking you could use ASG_LAST_PROC_PERIOD_NUMBER (The period number the assignment was last processed) in some way? But that would only work in the first month of processing.

Delboy

Correct! :-D

Actually, given that this is loosely connected with the impending Civil Service Pension Reforms coming in April, you might have a kind of interest in this yer good self like!

Aaaah...I would defo be interested. Keep me up to date with your findings.

Delboy

Will do fella. Given the somewhat 'fluid' nature of the requirement (still not agreed, and the deadline is still 1st April, how appropriate is that) we are intending to break it up into 2 bits - First, is 'steady state and new starters', second bit is 'in year changes that trigger a recalculation' (that's the bit we don't know for sure yet).

We are hoping to be 'legal' by delivering the first bit in time for April, and the rest of it will be taken care of via retropay as and when we are able to deliver.

Just been checking the DB Items, all refer to previous or last period (the same) so nothing for first period, so I think you are off to UDF territiory