Absence Reasons Data Import Template Guide

Last Updated: Sep 21, 2016 01:22PM EDT
This guide will walk through the available fields in the Absence Reasons Import Template and what they mean. The Import Template is broken down in highlighted sections based on what type of information you are trying to import.
 

Color Key

Dark Blue
Required fields for importing new employees
 
Light Blue
Employee general info and permissions
 
For best results, delete any blank columns from your template before uploading.

Import Template Guide

Description
Name of the absence reason.
 
External ID
This is the External ID or identifying code that you want associated with this absence reason type.
 
External ID 2
Additional External ID if needed.
 
Public to Employee
Do you want the employee to see this absence reason when creating an absence? Leaving this field blank will default to yes for new absence reasons. Put Y for yes. Put N for no.
 
Phone Menu #
This will determine where this absence reason will fall in the order of absence reason choices on the phone system. Example: Put 1 if you want it to be the first option.
 
Data Analysis Category
The name of the data analysis category that best matches your absence reason. Choose one of the options listed below: Association/Bargaining Unit
Bereavement
Field Trip Illness
Jury Duty
Military Leave
Personal Time Off
Professional Development
School Business
Unexcused Absence
Vacation
Workers Compensation
Other
 
School External ID
The external ID of the school you want this absence reason to be available to. For all schools use the district's external ID.
 
Employee Type Description
The name of the employee type you want this absence reason to be available to. To choose all employee types, leave this field blank.
 
Remove Employee Type
To remove the employee type from the list of employee types this absence reason is available to put a Y in this column.
 
Needs Approval
Does this absence reason require approval? Leaving this field blank will default to no for new absence reasons. Put Y for yes.
 
HoldUntilApproved
Do you want the absence management system to hold the absences for this absence reason until they are approved? Leaving this field blank will default to no for new absence reasons. Put Y for yes.
 
Enforce Balances
Do you want the system to enforce absence reason balances for this absence reason? Leaving this field blank will default to no for new absence reasons. Put Y for yes.
 
Is Bucket
To create this absence reason as a bucket put a Y in this column.
 
IsVacancyType
If you would like this reason to be created as a Vacancy Reason rather than an absence reason, put a Y in this column.
 
Parent External ID
If this absence reason is intended to be a list item in an existing absence reason bucket, then put the parent absence reason's eternal ID in this column.