iSolved export is a Fixed Width Text file format, no header, consisting of 11 fields:
Name |
Required |
Type |
Size |
Start |
End |
Description |
|---|---|---|---|---|---|---|
| BCL_CODE | Yes | A/N | 4 | 1 | 4 | Company Number, Right Justified, Zero Filled |
| EMP_NUM |
Yes | Num | 4 | 5 | 8 | Employee Number |
| EMP_DIV | No | A/N | 2 | 9 | 10 | Employee Division Number |
| EHD_CODE | Yes | A/N | 2 | 11 | 12 | Earnings, Hours or Deduction Code |
| EHD_TYPE | Yes | A/N | 1 | 13 | 13 | H=Hours, $=Earnings, T=Tax, D=Deduction (Tax and Deduction types are not supported in the RealTime at this time) |
| AMOUNT | Yes | Num | 10 | 14 | 23 | Amount of Earnings or Hours formatted 9999999.99, Right Justified, Zero Filled |
| PLUS_MINUS | Yes | A/N | 1 | 24 | 24 | + or -, depending on positive or negative value of AMOUNT |
| RATE | No | Num | 8 | 25 | 32 | Pay Rate formatted 999.9999. Right Justified, Space Filled |
| LABOR_NUM | No | A/N | 12 | 33 | 44 | Labor or Department Number allocated. Left Justified, Space Filled |
| CLOCK_NUM | No | Num | 6 | 45 | 50 | Employee Clock/Badge Number. Left Justified, Space Filled |
| EMP_NAME/SSN | No | A/N | 30 | 51 | 80 | Employee Name or SSN. Left Justified, Space Filled |
SAMPLE FILE
SDAJ0280 01H0000040.00+000.0000 MIKE SMITH
SDAJ0282 01H0000044.00+000.0000 FRANCISCO LOPEZ
SDAJ0284 01H0000034.00+000.0000 BOB JONES
SDAJ0285 01H0000023.00+000.0000 ANWAR JUARES
SDAJ0289 01H0000015.00+000.0000 MARK SPENCER