Difference between revisions of "Casamaba Punch Import"

From sbv.wiki
Jump to: navigation, search
(Created page with "This imports punches from the Casamba software. A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba". {| class="wikitable" |- !...")
 
Line 1: Line 1:
This imports punches from the Casamba software. A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba".
+
This imports punches from the Casamba software.
 +
 
 +
A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba".
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 11: Line 13:
 
|-
 
|-
 
| Employee Identifier
 
| Employee Identifier
| Employee ID, Emp ID, ID, Employee Number, Clock_ID, Payroll_ID, SSN_ID
+
| Therapist
| This is used to uniquely identify the employee. Note the distinction with the clock ID, SSN, and Payroll ID fields is the “_”. With a multi-facility configuration you must also provide the Facility column.
+
| This is used to uniquely identify the employee by extracting the employee ID from between the open and end brackets. With a multi-facility configuration you must also provide the Facility column.
 
| Yes
 
| Yes
  
 
|-
 
|-
| Punch Date Time
+
| Punch Date
| Punch Date, Punch Time, Punch Date Time
+
| Activity Date
 
|
 
|
 
| Yes
 
| Yes
  
 
|-  
 
|-  
| Punch Type
+
| In and Out Punch Times
| Punch Type
+
| TimeInOut
| In, Out, Back From Break, Back From Lunch
+
|  
| No
+
| Yes
 
|}
 
|}
  

Revision as of 03:32, 2 May 2016

This imports punches from the Casamba software.

A Casamaba punch import is identified by the sheet name or file name containing the word "Casamba".

Column Type Identifiers Notes Required
Employee Identifier Therapist This is used to uniquely identify the employee by extracting the employee ID from between the open and end brackets. With a multi-facility configuration you must also provide the Facility column. Yes
Punch Date Activity Date Yes
In and Out Punch Times TimeInOut Yes

See also