Time off and accruals tables?

The table that has the available hours for PTO is Lawson_TAEEMASTER.  Hours used we have Pay Groups for them under the Lawson_PRTIME table

TAEMPTRANS has transactions from the LP systsm.

Are you using Lawson's time entry system? If so, you should be able to find the tables in several ways. You can look at either Lawson's technical or data file text.

If you have addins, you can find the table name by performing a ctrl + shift+O on the form and then enter the 3 character prefix into addins and it will return the table name.

Let's try that again:

[code] rngdbdump -cnt gen filedef -f Prefix FileName | lashow [/code] from LID

Or [code] rngdbdump -cnt gen filedef -f Prefix FileName > filename.txt [/code]

Thanks everyone.
This should be enough to get me started.

Margie - I don't know if we're using Lawson's time-entry system.
I know we are going to use Kronos for time-keeping, but I'm not familiar with the rest of it (it is still being designed).

I'm new to Lawson (since last October) and have spent all of my time since then writing IPAs - mostly dealing with Landmark data.

Thanks again everyone.

If you are using KRONOS then you most like are not using Lawson time entry. I only asked that because of your statement regarding "approved" time off.

I guess I still don't know where approved time-off data is stored.
Can anyone point me in the right direction.

Thanks again,
Bryant

It depends on how you code it. Usage can be pulled from any accrual plan. If you use a different pay code/service code for approved vs. unapproved, you can pull based on those values.