如何在不更改历史数据的情况下更新员工费用？ [英] How do I update staff charge out rate without changing historical data?

问题描述

我正在为我的公司创建一个时间表系统，它在一分钟就有了一个非常简单的布局。

我将工作人员的收费率乘以他们工作的时间。

每隔一段时间，工作人员就会得到一个提高他们的收费率的工资。

我想保留员工已经在项目上花费的计算值，并希望收费率从他们的费率增加之日起改变。

我怎么样？能够做到这一点？

I am creating a timesheet system for my company and its got a pretty simple layout at the minute.
I am multiplying the staff charge out rate to the hours they have worked on a job.
Every now and then staff gets a payrise which increases their charge out rate.
I want to keep the calculated values that staff has spent on the project already and want the charge out rate to change as from the date their rate increased.
How would I be able to do this?

推荐答案

你需要将它包含在设计Jenny中。 IE浏览器。您可以集中维护默认收费率，但每条收费记录都需要存储实际使用的费率。

You need to include it in the design Jenny. IE. You can maintain a Default charge-out rate centrally, but each charge record needs to store the actual rate used.

感谢您的回复！

我真的不低于..

所以我需要一张桌子来存储员工的费用，并在更改时为其添加新的费用？

Thanks for your reply!
I don''t really undersrand..
So I would need a table to store staff charge out rates, and add new charge out rates to it as they change?

我无法直接解释，因为我的信息很少，无论你在用什么/在里面工作。


你需要将收费率存储在某个与日期或时间无关的点上。这将是创建 日期或时间相关项目时要选择的（默认）值。如果每个工作人员都有一个记录，那么这样的记录将适合保持默认值。当创建使用这种费用的项目时，EG。工作人员在特定日期的某个特定时间完成工作，然后创建一个项目以反映必须包含从工作人员的记录中获取的费用值的项目，但是之后不会以任何方式与之相关联。因此，如果MoS的利率随后上升，该收费的记录仍将反映历史汇率。

I can''t explain much more directly as I have so little information as to what you''re working with/within.

You would need to store a charge-out rate somewhere at a point which is not date or time related. This would be the (default) value to pick up when creating an item which is date or time related. If each member of staff has a record then such a record would be appropriate for holding the default value. When an item is created that uses such a charge, EG. a job is done by that member of staff at a particular time on a particular date, then an item would be created to reflect that which would have to include a charge value which would be picked up from the record for the member of staff, but would not be linked to it in any way thereafter. Thus, if the MoS''s rate subsequently went up, the record for that charge would still reflect the historical rate.

这篇关于如何在不更改历史数据的情况下更新员工费用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！