http://www.improvizations.com/kronos-interface-design-strategy/ Who is this Bryan character anyway???...
6277
Sam Powers
fast.hrms
Feb 5, 2011 12:19 am
Hi Bryan, Could you please provide a link for my integration white paper? Thank you, ________________________________ From: "Taylor, Anne-Marie E."...
6276
Matevey, Jody A EALT
jamatevey
Feb 4, 2011 9:28 pm
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...
6275
Mike
micheljch
Feb 4, 2011 8:15 pm
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...
6274
Mike
micheljch
Feb 4, 2011 4:47 pm
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...
6273
Taylor, Anne-Marie E.
aetaylor21
Feb 4, 2011 3:58 pm
Forgive my ignorance but who is Bryan? ________________________________ From: kronos-fans@yahoogroups.com [mailto:kronos-fans@yahoogroups.com] On Behalf Of Sam...
6272
Matevey, Jody A EALT
jamatevey
Feb 4, 2011 3:55 pm
Hope this gets you close: Select w.EMPLOYEEID, PE.PUNCHDTM, sum(w.DURATIONSECSQTY/3600.00) as Hrs, p.NAME, la.LABORLEV1NM, la.LABORLEV2NM, la.LABORLEV3NM, ...
6271
Sean Flaherty
flahertysean
Feb 4, 2011 12:24 pm
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...
6270
Sam Powers
fast.hrms
Feb 4, 2011 12:23 pm
Ask Bryan for my white papers. I do lots of interfaces this way. ________________________________ From: "Taylor, Anne-Marie E." <aetaylor1@...> To:...
6269
Mike
micheljch
Feb 4, 2011 12:06 am
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,...
6268
Taylor, Anne-Marie E.
aetaylor21
Feb 4, 2011 12:06 am
Now you are talking! Thank you! ________________________________ From: kronos-fans@yahoogroups.com [mailto:kronos-fans@yahoogroups.com] On Behalf Of Eugene...
6267
Eugene Harrison
fast.hrms
Feb 3, 2011 9:45 pm
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...
6266
Taylor, Anne-Marie E.
aetaylor21
Feb 3, 2011 3:47 pm
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...
6265
Siva kumar
crypticsiva
Feb 3, 2011 12:15 pm
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 %...
6264
swilsher
Feb 3, 2011 12:15 pm
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...
6263
scoutint
Feb 2, 2011 11:15 pm
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...
6262
Taylor, Anne-Marie E.
aetaylor21
Feb 2, 2011 11:14 pm
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...
6261
Taylor, Anne-Marie E.
aetaylor21
Feb 2, 2011 9:38 pm
Thank you Myron I did end up using the substr function instead, you just have to rethink sql with WIM sometimes... ________________________________ From:...
6260
Prakash, Meghana
meghana.prakash
Feb 2, 2011 9:34 pm
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...
6259
Bob Whitehead
b.whitehead...
Feb 2, 2011 9:33 pm
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...
6258
Myron Oakes
myronoakes
Feb 2, 2011 9:33 pm
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...
6257
Sean Flaherty
flahertysean
Feb 2, 2011 6:11 pm
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 ...
6256
aetaylor1@...
aetaylor21
Feb 2, 2011 6:11 pm
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 ...
6255
jrmcnulty169
Feb 2, 2011 5:00 pm
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...
6254
mike_the_kronos_guy
mike_the_kro...
Feb 2, 2011 12:21 pm
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...
6253
mike_the_kronos_guy
mike_the_kro...
Feb 2, 2011 12:20 pm
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...
6252
vishnu v
vishnuicf
Feb 2, 2011 12:20 pm
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...
6251
Myron Oakes
myronoakes
Feb 1, 2011 7:36 pm
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...
6250
tara_tanaya
Feb 1, 2011 7:36 pm
Hi, i am not able to ping the clock from but able to ping Ip address from DOS. FYI - We are using DCM 5.2.8 Any suggestion???? Thanks, Tara...
6249
meg27613
Feb 1, 2011 7:36 pm
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...
