How to Query Employee Names with Payroll Module

Yahoo Archive
1
Thanks for replying.
When I do count(*) on the Empbasic and PREMPMAS tables, the count is
different. Why? I will try using the empbasic table instead of the
prempmas table in my dashboard.

Thanks again.

--- In vantage@yahoogroups.com, "saab_barracuda" <chris.clunn@...>
wrote:
>
> Clinton,
> As long as you only need basic information (name, supervisor,
jcdept,
> address and phone, labor rate) you can use the EmpBasic table (from
> Shop Employee setup) rather than PREmpMas (from the Payroll
Employee
> setup). We use average pay rates by job title for the labor rates
so
> this isn't the actual pay rate. The EmpBasic is synchronized with
the
> PREmpMas table by the business logic so you get the same data. If
you
> need the Payroll specific information such as SSNs or pay rates,
you
> will need to use the PREmpMas table with hopefully a higher admin
> level of security.
>
> The only piece of data that I have found to be a problem is the
> Payroll ClassID. I find it usefully for the time card reports to
> separate out the hourly employee which are done daily vs. the
exempt
> and non-exempt employees done weekly. So rather than allow access
to
> the PREmpMas, I have rigged an update query in Access to copy the
> ClassID from the PREmpMas to ShortChar01 in the EmpBasic.
Obviously
> not the best method, however being on 8.00, I don't have BPM to do
the
> updates. The user defined fields are not affected by any business
> logic so I feel reasonably safe doing the updates through ODBC.
This
> keeps the firewall in place so only admin has access to PREmpMas.
We
> don't add new people that often and they let me know quickly when
they
> don't show on the time card reports so it seems to work well
enough. HTH
>
> Regards,
>
> Chris
>
>
> --- In vantage@yahoogroups.com, "mustardbuzzards" <c.edwards@>
wrote:
> >
> > Good Morning,
> >
> > I have the payroll module active. Need the ability to write BAQ
that
> > show employee name.
> >
> > How do you link the PREMPMAS table without giving up on security?
> > Is there way to populate/link/synchronize the empbasic table?
> >
> > Thanks
> > Clinton
> >
>
2
Good Morning,

I have the payroll module active. Need the ability to write BAQ that
show employee name.

How do you link the PREMPMAS table without giving up on security?
Is there way to populate/link/synchronize the empbasic table?

Thanks
Clinton
3
Clinton,
As long as you only need basic information (name, supervisor, jcdept,
address and phone, labor rate) you can use the EmpBasic table (from
Shop Employee setup) rather than PREmpMas (from the Payroll Employee
setup). We use average pay rates by job title for the labor rates so
this isn't the actual pay rate. The EmpBasic is synchronized with the
PREmpMas table by the business logic so you get the same data. If you
need the Payroll specific information such as SSNs or pay rates, you
will need to use the PREmpMas table with hopefully a higher admin
level of security.

The only piece of data that I have found to be a problem is the
Payroll ClassID. I find it usefully for the time card reports to
separate out the hourly employee which are done daily vs. the exempt
and non-exempt employees done weekly. So rather than allow access to
the PREmpMas, I have rigged an update query in Access to copy the
ClassID from the PREmpMas to ShortChar01 in the EmpBasic. Obviously
not the best method, however being on 8.00, I don't have BPM to do the
updates. The user defined fields are not affected by any business
logic so I feel reasonably safe doing the updates through ODBC. This
keeps the firewall in place so only admin has access to PREmpMas. We
don't add new people that often and they let me know quickly when they
don't show on the time card reports so it seems to work well enough. HTH

Regards,

Chris


--- In vantage@yahoogroups.com, "mustardbuzzards" <c.edwards@...> wrote:
>
> Good Morning,
>
> I have the payroll module active. Need the ability to write BAQ that
> show employee name.
>
> How do you link the PREMPMAS table without giving up on security?
> Is there way to populate/link/synchronize the empbasic table?
>
> Thanks
> Clinton
>