Leave of Absence File
 Previous Top Next
 
The Leave of Absence (LOA) File (files with extension la.csv) provides the beginning date, the ending date, and a reason a leave of absence was taken by an optionee.

Insertions and Modifications
Upload file can contain both new records, and updates to existing records.
A row is uniquely identified by a combination of the Optionee ID and LOA Start Date.

If there is more than one record in the LOA file with the same Optionee ID and LOA Start Date, the system will assume that the last record is supposed to update the previous record(s).  The previous record(s) will be lost and no validation error will be reported.


Deletions
To delete a record, you can add a record in an acceptable .CSV file format that contains only the Optionee ID. Deletion records can be in the same file as insertion and modification records.


File Format
#
Field Name
P=Required
Field Type
Sample Field
Description
1
OptioneeID
P
Alpha-Numeric (40)
OP123
Links to Optionee Information
2
LOAStart Date
P
Date
graphicMM/DD/YYYY
1/1/2004
The start date of the leave of absence.
No quotation marks allowed
3
LOAEndDate
 
Date
graphicMM/DD/YYYY
6/12/2004
The end date of the leave of absence.
No quotation marks allowed
4
LOAReason
 
Alpha-Numeric (40)
Pregnancy
The description of the leave of absence.


Examples

To properly load, fields in each row of the file must be in the following sequence:

OptioneeID, LOAStartDate, LOAEndDate, LOAReason

An example of valid lines in an LOA file are as follows (note the LOAReason optional field is empty in the second example):

#OptioneeID, LOAStartDate, LOAEndDate, LOAReason
55647, 1/1/2004, 6/12/2004, “Pregnancy Leave”
OP222, 12/1/2005, 1/15/2006