What table are Employee calendar exceptions stored?

Kinetic ERP
, ,
1

I can’t seem to find the table these exceptions are stored in. Does anyone know ? My usual trick of using the field help doesn’t work in this case.

image
image1070×847 46.2 KB

2

Erp.EmpCal I think is what you want.

3

That doesn’t store the exceptions though

image
image1008×506 17.8 KB

4

Ok, you’ll have to link a few tables, but the data is stored in Erp.ProdCalDay

5

Huh, I tried that but I must have got the joins wrong. What do your joins look like?

6

Hi Evan,

It’s actually on the ResourceCal table

Cheers
Connor

7

image
image681×637 31.7 KB

image

8

Huh, that gets me zero results, were as ResourceCal gets me the item.

9

Sorry, I didn’t look closely at your original picture. My way gets you the calendar exceptions. Doing the ResourceCal gets you the employee specific exceptions. Would you need both for a full picture?

10

Not sure. Right now I was just trying to answer the question “Is there anywhere we can enter employee vacation in Epicor?”

I really don’t like how its just a bunch of checkboxes and not a time range but it can probably still work for what we need.

1 Like