Difference between revisions of "Hours Import"

From sbv.wiki
Jump to: navigation, search
(Created page with "The employee import allows you to add hours to the employee’s time card. Required Columns {| class="wikitable" |- | '''Column Type''' | '''Identifiers''' | '''Notes''' ...")
 
Line 1: Line 1:
 
The employee import allows you to add hours to the employee’s time card.
 
The employee import allows you to add hours to the employee’s time card.
  
Required Columns
 
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
|
+
! Column Type
'''Column Type'''
+
! Identifiers
 
+
! Notes
|
+
! Required
'''Identifiers'''
+
 
+
|
+
'''Notes'''
+
  
 
|-
 
|-
|
+
| Employee ID
Employee ID
+
| Employee ID, Emp ID, ID
 
+
| The employee ID – a unique identifier for the employee
|
+
|Yes
Employee ID, Emp ID, ID
+
 
+
|
+
The employee ID – a unique identifier for the employee
+
  
 
|-
 
|-
 +
| Pay Date
 +
| Pay Date, Date
 
|
 
|
Pay Date
+
| Yes
 
+
|
+
Pay Date, Date
+
 
+
|
+
 
+
  
 
|-
 
|-
|
+
| Pay Type / Hours
Pay Type / Hours
+
| The pay type ID
 
+
| The column header identifies the pay type. The data in each row represents the hours for the pay type.
|
+
| Yes
The pay type ID
+
 
+
|
+
The column header identifies the pay type. The data in each row represents the hours for the pay type.
+
 
+
 
|}
 
|}

Revision as of 18:40, 10 June 2015

The employee import allows you to add hours to the employee’s time card.


Column Type Identifiers Notes Required
Employee ID Employee ID, Emp ID, ID The employee ID – a unique identifier for the employee Yes
Pay Date Pay Date, Date Yes
Pay Type / Hours The pay type ID The column header identifies the pay type. The data in each row represents the hours for the pay type. Yes