Keystone Timeclock Import Formats

From GivenHansco Keystone Help
Jump to navigation Jump to search

Time Clock Formats Supported by Import Timecards

About

Support Time Clock Setups

TimeForce

Features

Unlimited pay types
Can import department or workers compensation class

Sample timeclock file

Code,EmpID,Fname,Mname,Lname,ShiftName,Dept,Date,HrType,Hrs
Code,EmpID,Fname,Mname,Lname,Date,Dis
REG,CAND01,CHARLES,,ANDERSON,,07,06/04/2007,Worked,16.98
REG,CAND01,CHARLES,,ANDERSON,,07,06/05/2007,Worked,12.22
REG,CAND01,CHARLES,,ANDERSON,,07,06/06/2007,Worked,10.80
OT,CAND01,CHARLES,,ANDERSON,,07,06/06/2007,Worked,1.93
OT,CAND01,CHARLES,,ANDERSON,,07,06/07/2007,Worked,11.18
OT,CAND01,CHARLES,,ANDERSON,,07,06/08/2007,Worked,6.83
REG,LANT01,SCOTT,K,ANTLE,,14,06/07/2007,Worked,8.95
REG,LANT01,SCOTT,K,ANTLE,,14,06/08/2007,Worked,6.33
REG,XAUS01,ANTHONY,W,AUSTIN,,02,06/04/2007,Worked,10.97
REG,XAUS01,ANTHONY,W,AUSTIN,,02,06/05/2007,Worked,8.82
REG,XAUS01,ANTHONY,W,AUSTIN,,02,06/06/2007,Worked,10.77
REG,XAUS01,ANTHONY,W,AUSTIN,,02,06/07/2007,Worked,9.45
OT,XAUS01,ANTHONY,W,AUSTIN,,02,06/07/2007,Worked,2.37
OT,XAUS01,ANTHONY,W,AUSTIN,,02,06/08/2007,Worked,11.82
OT,XAUS01,ANTHONY,W,AUSTIN,,02,06/09/2007,Worked,4.97


Options

[WorkComp]
;setup workers comp class translations here as follows:
;<timeforce department value> = <keystone workers comp class>

[Department]
;setup department translations here as follows:
;<timeforce department value> = <keystone department>


TimeForce II

(Added for Keystone 2.5.10)

Features

Unlimited pay types
Can import department or workers compensation class

Field Defs

1. employeecode (Alphanumeric, not NULL)
2. timecard_date (MM/DD/YYYY)
3. advancedmappingexportcode (Alphanumeric, not NULL (Pay Type)
4. hours_worked (Decimal round to 2 decimal places, 0 filled)
5. effective_rate (Decimal round to 2 decimal places, 0 filled)
6. pay (Decimal round to 4 decimal places, 0 filled)
7. departmentexportcode (alphanumeric, optional, NULL or empty string OK)
8. jobexportcode (alphanumeric, optional, NULL or empty string OK)
9. taskexportcode (alphanumeric, optional, NULL or empty string OK)

Pay Calculation

  • If Pay is not 0:
    • Pay is used for total pay
      • If Hours are zero, rate is set to 0
      • If Hours are not 0 then rate is Pay/Hours
  • If Pay is 0
    • If rate is not 0 then rate is used and pay is rate X hours
    • If Rate is 0 then standard employee rate applies and pay is standard rate X hours

Sample timeclock file

Without Rates: 

1000,05/19/2012,VAC,8.00,0.0000,0.0000,50,,
1000,05/14/2012,REG,2.50,0.0000,0.0000,50,,
1000,05/15/2012,REG,9.0000,0.0000,0.0000,50,,
1000,05/15/2012,REG,10.00,0.0000,0.0000,50,,
1000,05/16/2012,REG,11.00,0.0000,0.0000,50,,
1000,05/17/2012,REG,7.50,0.0000,0.0000,50,,
1000,05/17/2012,OT,3.50,0.0000,0.0000,50,,
1000,05/17/2012,BONUS,0,0.0000,100.0000,50,,

optionally with "NULL" 

1000,05/17/2012,BONUS,0,0.0000,100.0000,50,NULL,NULL

optionally with header: 

"EmpID","Date","PayType","Hours","Rate","Pay","Dept","Job","Task"
1000,05/19/2012,VAC,8.00,0.0000,0.0000,50,,
1000,05/14/2012,REG,2.50,0.0000,0.0000,50,,


With Rates: 

1002,05/19/2012,VAC,8.00,10.0000,0.0000,50,ME361,02900
1002,05/17/2012,BONUS,0,0.0000,100.0000,50,,
1002,05/14/2012,REG,2.50,10.0000,0.0000,50,ME361,MAINT
1002,05/15/2012,REG,9.0000,10.0000,0.0000,50,,
1002,05/15/2012,REG,10.00,10.0000,0.0000,50,,
1002,05/16/2012,REG,11.00,10.0000,0.0000,50,,
1002,05/17/2012,REG,7.50,10.0000,0.0000,50,,
1002,05/17/2012,OT,3.50,15.0000,0.0000,50,,

GPS

(Added in 2.6.4 - Similar TimeForce II with Plant, no Job Cost)

Features

Unlimited pay types
Can import department AND Plant
No Job Cost

Field Defs

1. employeecode (Alphanumeric, not NULL)
2. timecard_date (MM/DD/YYYY)
3. advancedmappingexportcode (Alphanumeric, not NULL (Pay Type)
4. hours_worked (Decimal round to 2 decimal places, 0 filled)
5. effective_rate (Decimal round to 2 decimal places, 0 filled)
6. pay (Decimal round to 4 decimal places, 0 filled)
7. departmentcode (alphanumeric, optional, NULL or empty string OK)
8. plant

Pay Calculation

  • If Pay is not 0:
    • Pay is used for total pay
      • If Hours are zero, rate is set to 0
      • If Hours are not 0 then rate is Pay/Hours
  • If Pay is 0
    • If rate is not 0 then rate is used and pay is rate X hours
    • If Rate is 0 then standard employee rate applies and pay is standard rate X hours

Sample timeclock file

Without Rates: 

1000,05/19/2012,VAC,8.00,0.0000,0.0000,50,,
1000,05/14/2012,REG,2.50,0.0000,0.0000,50,,
1000,05/15/2012,REG,9.0000,0.0000,0.0000,50,,
1000,05/15/2012,REG,10.00,0.0000,0.0000,50,,
1000,05/16/2012,REG,11.00,0.0000,0.0000,50,,
1000,05/17/2012,REG,7.50,0.0000,0.0000,50,,
1000,05/17/2012,OT,3.50,0.0000,0.0000,50,,
1000,05/17/2012,BONUS,0,0.0000,100.0000,50,,

With Rates: 

1002,05/19/2012,VAC,8.00,10.0000,0.0000,50,ME361,02900
1002,05/17/2012,BONUS,0,0.0000,100.0000,50,,
1002,05/14/2012,REG,2.50,10.0000,0.0000,50,ME361,MAINT
1002,05/15/2012,REG,9.0000,10.0000,0.0000,50,,
1002,05/15/2012,REG,10.00,10.0000,0.0000,50,,
1002,05/16/2012,REG,11.00,10.0000,0.0000,50,,
1002,05/17/2012,REG,7.50,10.0000,0.0000,50,,
1002,05/17/2012,OT,3.50,15.0000,0.0000,50,,


Generic

Features

Unlimited pay types
Can import department or workers compensation class
Can Import Job / Budget Category
Can Import Description
Can Import Pay Rate

NOTE: This format is a variation of the original Time Force format. This option will handle records that don't include the Job, Description and Rate fields.

Fields

  1. Pay Type
  2. Employee ID
  3. First Name
  4. Middle Name
  5. Last Name
  6. Shift Name (Not Used)
  7. Department
  8. Date
  9. Hour Type (Not Used)
  10. Hours
  11. Job ID (Optional)
  12. Budget Category (Optional)
  13. Detail Description (Optional)
  14. Override Rate (Optional)

Sample timeclock file

Code,EmpID,Fname,Mname,Lname,ShiftName,Dept,Date,HrType,Hrs,JobID,BudCat
REG,1000,John, ,Smith, ,,3/15/2010,Worked,4,019495,00600,NORTHX2,22.22
REG,1000,John, ,Smith, ,,3/15/2010,Worked,3.5,LB1986,MAINT
REG,1000,John, ,Smith, ,,3/16/2010,Worked,3,019495,00600
REG,1000,John, ,Smith, ,,3/17/2010,Worked,7,019495,00600
REG,1000,John, ,Smith, ,,3/18/2010,Worked,8,019495,00600
OT,1000,John, ,Smith, ,,3/18/2010,Worked,1,019495,00600
REG,1000,John, ,Smith, ,,3/19/2010,Worked,3,019495,00600
REG,1000,John, ,Smith, ,,3/20/2010,Worked,3.5,019495,00600
REG,1000,John, ,Smith, ,,3/15/2010,Worked,3.5,019495,02900
REG,1000,John, ,Smith, ,,3/16/2010,Worked,2,019495,02900
REG,1000,John, ,Smith, ,,3/17/2010,Worked,1,019495,02900
REG,1001,Larry, ,Baker, ,,3/17/2010,Worked,3,LB1986,MAINT
REG,1001,Larry, ,Baker, ,,3/18/2010,Worked,5,LB1986,MAINT
REG,1001,Larry, ,Baker, ,,3/19/2010,Worked,5,LB1986,MAINT
REG,1001,Larry, ,Baker, ,,3/20/2010,Worked,5,LB1986,MAINT
REG,1001,Larry, ,Baker, ,,3/20/2010,Worked,15,,
REG,1002,George, ,White, ,,3/15/2010,Worked,4,019495,00600
REG,1002,George, ,White, ,,3/15/2010,Worked,2,LB1986,MAINT
OT,1002,George, ,White, ,,3/15/2010,Worked,2,LB1986,MAINT
REG,1002,George, ,White, ,,3/16/2010,Worked,3,LB1986,MAINT
REG,1002,George, ,White, ,,3/17/2010,Worked,5,LB1986,MAINT
REG,1002,George, ,White, ,,3/18/2010,Worked,5,LB1986,MAINT
REG,1002,George, ,White, ,,3/20/2010,Worked,5,,
OT,1002,George, ,White, ,,3/20/2010,Worked,13,LB1986,MAINT
REG,1005,Suzie, ,Queen, ,,3/15/2010,Worked,2,019495,00600
REG,1005,Suzie, ,Queen, ,,3/16/2010,Worked,4,019495,00600
REG,1005,Suzie, ,Queen, ,,3/20/2010,Worked,6,019495,00600
REG,2000,John, ,Walker, ,,3/20/2010,Worked,12,,
REG,2002,Chris, ,Smith, ,,3/20/2010,Worked,22,,
REG,3000,Tony, ,Brown, ,,3/20/2010,Worked,15,,
SAL,1003,Michael, ,Jones, ,,3/20/2010,Worked,86.67,,,EastSide,50.50
SAL,2005,Harold, ,Stone, ,,3/20/2010,Worked,86.67,,
Retrieved from "http://104.43.204.248/wiki/index.php?title=Keystone_Timeclock_Import_Formats&oldid=343"