User: 1 revision imported

2020-01-08T13:00:05Z

1 revision imported

en>User: 1 revision imported

2017-01-06T21:00:48Z

1 revision imported

New page

'''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===

<pre>
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
</pre>

===Options===

<pre>
[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>
</pre>

==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:
<pre>
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,,
</pre>

optionally with "NULL"
<pre>
1000,05/17/2012,BONUS,0,0.0000,100.0000,50,NULL,NULL
</pre>

optionally with header:
<pre>
"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,,
</pre>

With Rates:
<pre>
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,,
</pre>

==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:
<pre>
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,,
</pre>

With Rates:
<pre>
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,,
</pre>

==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===
#Pay Type
#Employee ID
#First Name
#Middle Name
#Last Name
#Shift Name (Not Used)
#Department
#Date
#Hour Type (Not Used)
#Hours
#Job ID (Optional)
#Budget Category (Optional)
#Detail Description (Optional)
#Override Rate (Optional)

===Sample timeclock file===

<pre>
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,,
</pre>

← Older revision	Revision as of 13:00, 8 January 2020
(No difference)

Keystone Timeclock Import Formats - Revision history

User: 1 revision imported

en>User: 1 revision imported