Seasonal Employees Start/End dates list

Kinetic ERP
, , ,
1

Hello everyone,

We have a some seasonal employees who work winters and quit summers at our company.
This means that they stop working here in spring time and start working here in the fall. They do this for several years.
So far, we’ve been adding new UD fields to keep track of when an employee starts and when they stop working. Right now we have five EmpBasic_UD_Start_Date#_c and five EmpBasic_UD_End_Date#_c fields, but someone is about to start their 6th year.
For example, this is how part of the Employee Maintenance screen looks right now:
image

Adding N amount of UD fields is not ideal and we need a better solution.

I was thinking about the following options:

  • We can use a UD table like UD03. I can add EmpID_c, WorkStart_c, and WorkEnd_c UD columns and dedicate the entire table to these dates. It seems like a waste of a table to store a list however.
  • I can create a really big nvarchar(10000) UD field for EmpBasic_UD and comma-separate the date ranges.

Does anyone have any other easy suggestions to store UD lists for Employees?

We’d like to keep track of these things and store them inside Epicor because we use the total length of employment for anniversary gifts and stuff.

Thank you for your time.

2

Unless you’re really close to running out of tables just use a UD table this is a perfect use for them. You could do the comma one but you might hate yourself later when they ask you for a report on these employees LOL.

2 Likes
3

Unless you’re really close to running out of tables just use a UD table this is a perfect use for them.

I feel like the UD table is the best solution so far. We are only using 1 or 2 of them as far as I know, so definitely not running out…
Thanks for your feedback.

You could do the comma one but you might hate yourself later when they ask you for a report on these employees LOL.

You’re right, that is the reason why I am hesitant to store them in a comma separated string :laughing:

4

As a kid (and an adult) I used to horde coloring markers this way too, especially my good ones. Have to let go and use those markers that’s what they are there for; to be used LOL