Absentee BAQ/Dashboard

Hi Again Nathan,

I wrote the expression wrong....when corrected,
returned dates....for most everyone. Some people don't have dates at all.

At 01:15 PM 2/22/2010, you wrote:
>
>
>Have not tried this myself but I'd do a BAQ something like:
>
>for each EmpBasic no-lock , each LaborHed
>outer-join where ( LaborHed.ClockInDate <= TODAY
>+ 0 AND LaborHed.ClockInDate >= TODAY + -7) and
>(EmpBasic.Company = LaborHed.Company and
>EmpBasic.EmpID = LaborHed.EmployeeNum) no-lock.
>
>The outer join will tell you who has no records for a given day...
>
>Good luck,
>
>NB
>
>--- In
><mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com,
>"Bob" <rcarlson@...> wrote:
> >
> > Using Vantage 803xxx and not having the
> payroll module has anyone developed a BAQ or
> Dashboard which could report Absenteeism?
> >
>
>



[Non-text portions of this message have been removed]
Using Vantage 803xxx and not having the payroll module has anyone developed a BAQ or Dashboard which could report Absenteeism?
Bob,

We do not use the payroll module either. Our shop supervisors use the
Shop Tracker tabs Who is Here and Who is Not Here. We do have a report
titled Daily Production Labor which was used during our transition time
to track which employees were failing to clock in and out correctly.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bob
Sent: Monday, February 22, 2010 12:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Absentee BAQ/Dashboard





Using Vantage 803xxx and not having the payroll module has anyone
developed a BAQ or Dashboard which could report Absenteeism?





[Non-text portions of this message have been removed]
Have not tried this myself but I'd do a BAQ something like:

for each EmpBasic no-lock , each LaborHed outer-join where ( LaborHed.ClockInDate <= TODAY + 0 AND LaborHed.ClockInDate >= TODAY + -7) and (EmpBasic.Company = LaborHed.Company and EmpBasic.EmpID = LaborHed.EmployeeNum) no-lock.

The outer join will tell you who has no records for a given day...

Good luck,

NB

--- In vantage@yahoogroups.com, "Bob" <rcarlson@...> wrote:
>
> Using Vantage 803xxx and not having the payroll module has anyone developed a BAQ or Dashboard which could report Absenteeism?
>
Hi Nathan,

Right idea but does not return a date reference
at the record level. All I know is that the day
or days were within the date range of the "today -1 thru -7"

I added a filter to get active employees only....

"for each EmpBasic where ( EmpBasic.EmpStatus =
'A') no-lock , each LaborHed outer-join where
( LaborHed.ClockInDate = TODAY + 0
AND LaborHed.ClockInDate = TODAY + 7) and
(EmpBasic.EmpID = LaborHed.EmployeeNum and
EmpBasic.Company = LaborHed.Company) no-lock ."




At 01:15 PM 2/22/2010, you wrote:
>
>
>Have not tried this myself but I'd do a BAQ something like:
>
>for each EmpBasic no-lock , each LaborHed
>outer-join where ( LaborHed.ClockInDate <= TODAY
>+ 0 AND LaborHed.ClockInDate >= TODAY + -7) and
>(EmpBasic.Company = LaborHed.Company and
>EmpBasic.EmpID = LaborHed.EmployeeNum) no-lock.
>
>The outer join will tell you who has no records for a given day...
>
>Good luck,
>
>NB
>
>--- In
><mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com,
>"Bob" <rcarlson@...> wrote:
> >
> > Using Vantage 803xxx and not having the
> payroll module has anyone developed a BAQ or
> Dashboard which could report Absenteeism?
> >
>
>



[Non-text portions of this message have been removed]