NEW HIRE FILE LAYOUT
FIELD NAME | FIELD TYPE |
|
FIELD POSITION | DESCRIPTION | MANDATORY /OPTIONAL |
1. FEIN | Numeric | 9 | 1-9 | Federal Employer Identification Number | M |
2. OKACCNUM | Numeric | 12 | 10-21 | Oklahoma Account ID Number (Left Justify, No Hyphens) | O |
3. CONAME | Character | 45 | 22-66 | Employer Company Name | M |
4. ERADDR1 | Character | 40 | 67-106 | Employer Payroll Processing Address 1 | M |
5. ERADDR2 | Character | 40 | 107-146 | Employer Payroll Processing Address 2 | O |
6. ERADDR3 | Character | 40 | 147-186 | Employer Payroll Processing Address 3 | O |
7. ERCITY | Character | 25 | 187-211 | Employer City | M |
8. ERSTATE | Character | 2 | 212-213 | Employer State | M |
9. ERZIPUS | Character | 9 | 214-222 | Employer US Zip Code (731156713 or 73115 (no hyphen)) | M |
10. ERCOCODE | Character | 2 | 223-224 | Employer Country Code | O |
11. ERCOUNTRY | Character | 25 | 225-249 | Employer Country Name | O |
12. ERZIPFORGN | Character | 15 | 250-264 | Employer Foreign Zip Code | O |
13. EROPADDR1 | Character | 40 | 265-304 | Employer Optional Address 1 | O |
14. EROPADDR2 | Character | 40 | 305-344 | Employer Optional Address 2 | O |
15. EROPADDR3 | Character | 40 | 345-384 | Employer Optional Address 3 | O |
16. EROPCITY | Character | 25 | 385-409 | Employer Optional City | O |
17. EROPSTATE | Character | 2 | 410-411 | Employer Optional State | O |
18. EROPZIPUS | Character | 9 | 412-420 | Employer Optional US Zip Code | O |
19. EROPCOCODE | Character | 2 | 421-422 | Employer Optional Country Code | O |
20. EROPCOUNTRY | Character | 25 | 423-447 | Employer Optional Country Name | O |
21. EROPZIPFORGN | Character | 15 | 448-462 | Employer Optional Foreign Zip Code | O |
22. ERPHONE | Character | 10 | 463-472 | Employer Phone (9995551234 (no hyphens)) | O |
23. EREXT | Character | 5 | 473-477 | Employer Extension Number | O |
24. EESSN | Numeric | 9 | 478-486 | Employee Social Security Number (111223333 (valid, no hyphens)) | M |
25. EEDOB | Date | 8 | 487-494 | Employee Date of Birth (19601006 (yyyymmdd format)) | O |
26. EEFNAME | Character | 16 | 495-510 | Employee First Name | M |
27. EEMNAME | Character | 16 | 511-526 | Employee Middle Name/Initial | O |
28. EELNAME | Character | 30 | 527-556 | Employee Last Name | M |
29 EEADDR1 | Character | 40 | 557-596 | Employee Address 1 | M |
30. EEADDR2 | Character | 40 | 597-636 | Employee Address 2 | O |
31. EEADDR3 | Character | 40 | 637-676 | Employee Address 3 | O |
32. EECITY | Character | 25 | 677-701 | Employee City | M |
33. EESTATE | Character | 2 | 702-703 | Employee State | M |
34. EEZIP | Character | 9 | 704-712 | Employee Zip Code (731156713 or 73115 (no hyphens)) | M |
35. EECOCODE | Character | 2 | 713-714 | Employee Country Code | O |
36. EECONAME | Character | 25 | 715-739 | Employee Country Name | O |
37. EEZIPFORGN | Character | 15 | 740-754 | Employee Foreign Zip Code | O |
38. EEOCCUP | Character | 45 | 755-799 | Employee Occupation | O |
39. EESALARY | Numeric | 8 | 800-807 | Employee Salary (00000950 or 950 (for $9.50) (Implied Decimal, right justify)) | O |
40. EESALCOD | Character | 1 | 808-808 | Employee Salary Code: H-Hourly, W-Weekly, M-Monthly, Y-Yearly, C-Commission | O |
41. EMPDATE | Date | 8 | 809-816 | Employee Date Work Started (20040131 (yyyymmdd format)) (NOT Greater than current date) | M |
42. HIRETYPE | Character | 1 | 817-817 | Type of Hire: N-New, R-Recall | O |
43. DEPINSUR | Character | 1 | 818-818 | Dependent Insurance Available: Y-Yes, N-No | O |
44. CURREMP | Character | 1 | 819-819 | Currently Employed: Y-Yes, N-No | O |
45. STATEOFHIR | Character | 2 | 820-821 | State of Hire | M |