Hi everyone - My workplace is using Kronos 6.2 and HR is asking if there is a way they can receive names of supervisors with outstanding time off requests (ESS...
All - - Hours-per-patient-day (hppd) measurement is huge in the Long Term Care (LTC) industry, as well as in hospitals, where staffing levels must be...
Tara, Each Clock is connected with a N/W cable and has an IP Address, what do u mean by Pinging the clock? Regards, Vishnu ... [Non-text portions of this...
Hi Tara, This may be a long-shot but something I have seen quite frequently in the past is a clock sharing an IP address with another PC/Printer/Device on the...
Hi Meg, This type of a customized report is a common request. I have a Crystal Reports version created for v5.2 I can send you if that helps. The SQL I am...
Assuming that the clock is not sharing the same IP Address with another device, than most likely is a firewall/web filter blocking DCM traffic. I have this...
I have tried using LIKE several ways, but I get the same error - has someone succeeded in getting LIKE to work in WIM? Select workgroup from phs_kronosdem ...
Try a trace route command (tracert) from a dos prompt and see if you can follow the path of the "ping". It might shed some light on some missing or incorrect ...
I'm not sure that LIKE can have a dynamically assigned variable (:variable) preceding the '%'. In the construct that you've got, if Empid's are all the same...
What is the error your getting? Look in the WIM results and it should show you the SQL statement as it's being submitted if it for Input. That may throw some...
Mike - Thank you! This is really helpful. Could you please send along the Crystal Reports version created for 5.2? I was able to run the query but am not...
Thank you Myron I did end up using the substr function instead, you just have to rethink sql with WIM sometimes... ________________________________ From:...
Thank you Bob this was the error: WIM-05177 Record# 1: ":empid_exp"- SQL error: ORA-00933: SQL command not properly ended SQL = select EMPID from PHS_KRONOSDEM...
We are currently upgrading from Kronos WTK 5.1 to WTK 6.1. Interested in what metrics are typically used to ensure the upgrade of data and other information...
I have been asked to customize the Location Schedule Monthly report to group data slightly different and to add counts by day and by job. Has anyone done...
Hi, Here the query seems incorrect. select EMPID from PHS_KRONOSDEM where EMPID like ':EMPID_IN%' COMPANY = 'SRH' and PRIM_JOB_IND= 'Y' I would rather append %...
Hi Bob, I had tried that also earlier but it also did not work. I think WIM has trouble determining the value of :variable% since it is using WIM + SQL and it...
Why not just do all you dml in a pre-open stored procedure variable? This way you never have to worry about what wim will do with your sql and never worry...
Now you are talking! Thank you! ________________________________ From: kronos-fans@yahoogroups.com [mailto:kronos-fans@yahoogroups.com] On Behalf Of Eugene...
WFC 6.1.11 on Microsoft SQL Server - haven't gone into production yet and just joined this forum today. I need a query that will provide the following info,...
Welcome to Kronos Fans and thanks for including your Kronos version and service pack level on your post. I am not much of a SQL pro but here are a couple...
Forgive my ignorance but who is Bryan? ________________________________ From: kronos-fans@yahoogroups.com [mailto:kronos-fans@yahoogroups.com] On Behalf Of Sam...
Thank you Sean for your offering. Unfortunately those queries aren't working for me. In the first one I get nulls in every labor level (?) and what I am...
Jody - That just about does it! I've tweaked it a bit here and there to give exactly what I was looking for but that was about 95%. Thank you! I only have...
Mike, a tsi.TMSHTITEMTYPEID=40 signifies a totaled span. A totaled span is a punch in-out. There are other items such as pay code additions and moves that...
