Hours Import - Revision history

Joel at 18:35, 29 November 2022

2022-11-29T18:35:01Z

2022-11-29T18:32:45Z

2022-11-15T23:06:03Z

2022-02-15T18:22:15Z

2022-02-15T18:20:10Z

2020-05-08T18:25:32Z

2020-04-27T05:21:36Z

2018-05-30T16:20:34Z

2017-11-14T15:38:50Z

2017-10-26T14:36:23Z

@@ Line 41: / Line 41: @@
 |-
-| Worked Labor levels
+| Worked Labor Levels
 | The ID or name of the worked labor level prefixed with "Worked", e.g. Worked Department
 | The labor level ID, labor level description or the scheduler ID, e.g. Office

@@ Line 41: / Line 41: @@
 |-
-| Labor levels
+| Worked Labor levels
-| The ID or name of the labor level, e.g. Department
+| The ID or name of the worked labor level prefixed with "Worked", e.g. Worked Department
 | The labor level ID, labor level description or the scheduler ID, e.g. Office
 | No

@@ Line 38: / Line 38: @@
 | Comment
+|
 | No

@@ Line 45: / Line 45: @@
 ==Sample of Hours Import==
-|[[File:SBV Hours Import Sample.png]]
+[[File:SBV Hours Import Sample.png]]
 == See also ==
 * [[Import]]

@@ Line 41: / Line 41: @@
 |}
 == See also ==
 * [[Import]]

@@ Line 32: / Line 32: @@
 | Shift
 | Use the Shift ID for the data in this column. If this column is not provided then the shift based on the employee's shift history for the pay date is used.
 | No

@@ Line 1: / Line 1: @@
-The hours import allows you to add hours to the employee’s time card.
+The hours import allows you to add hours or amounts to the employee’s time card.
 An hours import is identified by the sheet name or file name containing the word "Hours".
@@ Line 25: / Line 25: @@
 | Pay Type / Hours
 | The pay type ID
-| The column header identifies the pay type. The data in each row represents the number of hours for the pay type. Please note that the Pay Type ID, the Pay Type Description and the Pay Type Payroll Code # 1 will all be used to find the pay type. Please ensure you use an identifier that will UNIQUELY identify the pay type.
+| The column header identifies the pay type. The data in each row represents the number of hours or the amount for the pay type. Please note that the Pay Type ID, the Pay Type Description and the Pay Type Payroll Code # 1 will all be used to find the pay type. Please ensure you use an identifier that will UNIQUELY identify the pay type. To identify that you want to import amounts, format the cell such that it starts with a $ sign. The Currency or Accounting formats will do this.
 | Yes
@@ Line 35: / Line 35: @@
 |}
 == See also ==
 * [[Import]]

@@ Line 30: / Line 30: @@
 |-
 | Shift
-| The shift ID
+| Shift
-| If this column is not provided then the shift based on the employee's shift history for the pay date is used.
+| Use the Shift ID for the data in this column. If this column is not provided then the shift based on the employee's shift history for the pay date is used.
 | No

← Older revision		Revision as of 15:38, 14 November 2017
Line 1:		Line 1:
−	The ~~employee~~ import allows you to add hours to the employee’s time card.	+	The hours import allows you to add hours to the employee’s time card.

	An hours import is identified by the sheet name or file name containing the word "Hours".		An hours import is identified by the sheet name or file name containing the word "Hours".