Difference between revisions of "Planned Absence Import"

From sbv.wiki
Jump to: navigation, search
(Created page with "The planned absence import adds planned absences to the employee’s [ Planned Absences] tab. Required Columns {| class="wikitable" |- | '''Column Type''' | '''Identifiers'...")
 
Line 1: Line 1:
 
The planned absence import adds planned absences to the employee’s [ Planned Absences] tab.
 
The planned absence import adds planned absences to the employee’s [ Planned Absences] tab.
  
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
+
  
 
|-
 
|-
|
+
| Shift
Shift
+
| Shift
 
+
| The shift of the schedule pattern. Uses the base schedule marked as the Default for that shift unless the sub shift is provided.
|
+
| Yes
Shift
+
 
+
|
+
The shift of the schedule pattern. Uses the base schedule marked as the Default for that shift unless the sub shift is provided.
+
  
 
|-
 
|-
|
+
| Day Of Week / Week Number
Day Of Week / Week Number
+
| 2 letter day of week followed by the week number
 
+
| For example, Su 1. The contents of the cell is the floor.
|
+
| Yes
2 letter day of week followed by the week number
+
 
+
|
+
For example, Su 1. The contents of the cell is the floor.
+
  
 
|}
 
|}

Revision as of 18:35, 10 June 2015

The planned absence import adds planned absences to the employee’s [ Planned Absences] tab.


Column Type Identifiers Notes Required
Employee ID Employee ID, Emp ID, ID The employee ID – a unique identifier for the employee Yes
Shift Shift The shift of the schedule pattern. Uses the base schedule marked as the Default for that shift unless the sub shift is provided. Yes
Day Of Week / Week Number 2 letter day of week followed by the week number For example, Su 1. The contents of the cell is the floor. Yes