File Layout
You name the work schedules input file when you import work schedules from Deltek Time and Expense.
Work Schedules File Layout
When you run the process, you create a CSV formatted file.
| # | Field Name | Length | Column # |
|---|---|---|---|
| 1 | Work Schedule Code | Char 10 | |
| 2 | Work Schedule Description (enclosed in double quotes) | Char 30 | |
| 3 | Schedule Date | DATETIME | |
| 4 | Day of Week Code | Char 3 | |
| 5 | Standard Hours | DECIMAL (8,2) | |
| 6 | Non-work flag | Char 1 | |
| 7 | Holiday flag | Char 1 | |
| 8 | Flexible flag | Char 1 |