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 |
Parent Topic: Import Work Schedules From Deltek Time and Expense