Difference between revisions of "Punch Import"

From sbv.wiki
Jump to: navigation, search
(Created page with "This imports punches, typically from an existing system where the punch information matches the employee’s ID. Required Columns {| class="wikitable" |- | '''Column Type'''...")
 
Line 1: Line 1:
 
This imports punches, typically from an existing system where the punch information matches the employee’s ID.
 
This imports punches, typically from an existing system where the punch information matches the employee’s ID.
 
Required Columns
 
  
 
{| class="wikitable"
 
{| class="wikitable"
|-
 
|
 
'''Column Type'''
 
 
|
 
'''Identifiers'''
 
 
|
 
'''Notes'''
 
  
 
|-
 
|-
|
+
! Column Type
Employee ID
+
! Identifiers
 
+
! Notes
|
+
! Required
Employee ID, Emp ID, ID
+
 
+
|
+
 
+
 
+
 
|-
 
|-
 +
| Employee ID
 +
| Employee ID, Emp ID, ID
 
|
 
|
Punch Date Time
+
| Yes
 
+
|
+
Punch Date, Punch Time, Punch Date Time
+
 
+
|
+
 
+
  
 
|-
 
|-
 +
| Punch Date Time
 +
| Punch Date, Punch Time, Punch Date Time
 
|
 
|
Punch Type
+
|Yes
 
+
|
+
Punch Type
+
 
+
|
+
In, Out
+
  
 +
|-
 +
| Punch Type
 +
| Punch Type
 +
| In, Out
 +
| Yes
 
|}
 
|}

Revision as of 18:18, 10 June 2015

This imports punches, typically from an existing system where the punch information matches the employee’s ID.

Column Type Identifiers Notes Required
Employee ID Employee ID, Emp ID, ID Yes
Punch Date Time Punch Date, Punch Time, Punch Date Time Yes
Punch Type Punch Type In, Out Yes