The export file for this program is a fixed-length
ASCII file delimited by a CR/LF pair.
| Field Name |
Length |
Positions |
Data Format |
Comments |
Record Type |
1 |
1 |
Alpha
Numeric |
Always
the single character "D" |
| Employee Clock Number |
6 |
2
- 7 |
Alpha
Numeric |
The
six-character employee CLOCK number |
| Alternate Rate Designator |
1 |
8 |
Numeric |
Pay
hours at alternate RATE (2 or 3) |
| Regular Hours |
6 |
9
- 14 |
Numeric |
Regular
hours worked |
| Overtime Hours |
5 |
15
- 19 |
Numeric |
Overtime
hours worked |
| Other Hours |
7 |
20
- 26 |
Numeric |
Other
hours worked |
| Other Hours Pay Code |
2 |
27
- 28 |
Numeric |
Pay
code associated with Other Hours above |
Earnings Amt 1 |
8 |
29
- 36 |
Numeric |
Earnings
for this period |
| Earnings Pay Code 1 |
2 |
37
- 38 |
Numeric |
Associated
pay code for Earnings Amt 1 above |
| Earnings Amt 2 |
8 |
39
- 46 |
Numeric |
Earnings
for this period |
| Earnings Pay Code 2 |
2 |
47
- 48 |
Numeric |
Associated
pay code for Earnings Amt 2 above |
| Exception Rate |
6 |
49
-54 |
Numeric |
Special
rate for entered hours |
| Exception Department |
6 |
55
- 60 |
Alpha
Numeric |
Department
allocation for earnings (if different
than reg) |
| Shift Premium |
1 |
61 |
Numeric |
Shift
Number in which hours were worked |
| Exception Frequency |
1 |
62 |
Alpha
Numeric |
Exception
tax frequency for this entire check |
| Batch Number |
3 |
63
- 65 |
Numeric |
(N/A) |
| Set Check Department |
1 |
66
- 67 |
Alpha
Numeric |
(N/A) |
| Carriage Return/Line Feed |
2 |
67
- 68 |
Alpha
Numeric |
Valid
Entry is \r\n |
Total Record Length |
68 |
(N/A) |
(N/A) |
(N/A) |
