This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 2 KB rforbes to previous
3 26-Nov-2021 10:22 1 KB rforbes to previous | to last
2 26-Nov-2021 10:22 1 KB rforbes to previous | to last
1 26-Nov-2021 10:22 942 bytes rforbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 14 changed 2 lines
* {{__PREV.WAGE_RATE__}} - The wage rate from the previous assignment where it had been different (note that this may not be the immediately preceding assignment detail)
* {{__PREV.WAGE_DATE__}} - The effective date when the wage was set to be the wage indicated on the passed assignment detail record.
* {{__PREV.''xxxx''__}} - Any field name from [P2K_HR_ASSIGNMENT_DETAILS]. The value returned will be the value from the immediately preceding effective record on that table. If there is no immediately preceding effective record, then [NULL] will be returned.
* {{__NEXT.''xxxx''__}} - Any field name from [P2K_HR_ASSIGNMENT_DETAILS]. The value returned will be the value from the immediately following effective record on that table. If there is no immediately followingeffective record, then [NULL] will be returned.
Special values:
* {{__PREV.WAGE_RATE__}} - The wage rate from the previous assignment where it had been different (note that this may not be the immediately preceding assignment detail). If no wage change has ever been made, [NULL] will be returned. If you want the value from the immediately preceding record instead of the previous value, you can obtain this with a recursive call as in:
** {{ p2k_pu.easd(p2k_pu.easd(__''ID''__,'PREV.ID'),'WAGE_RATE')}}
* {{__PREV.WAGE_DATE__}} - The effective date when the wage was set to be the wage indicated on the passed assignment detail record. If no wage change has ever been made, [NULL] will be returned