ASCII Text Files Reporting Instructions
|
Below are the instructions for uploading New-Hire data to the Alabama Department of Labor by an ASCII text file. Create a New Hire Upload File following the format below. Proceed to upload and submit your file. Once the file is processed you will be redirected to a confirmation screen that will show completed and rejected records. If you are submitting test data then click the cancel button after viewing your completed and rejected records. If you are submitting live data in a file that is free of errors, confirm your results to complete your New Hire Upload Report. ASCII text files should be submitted twice a month, not less than twelve (12) days and not more than sixteen (16) days apart. Questions regarding the upload of ASCII text files should be directed to Ramona Jordan at (334) 206-6028. FOR ALABAMA NEW HIRE DATA PUNCTUATION MARKS SHOULD NOT BE USED IN ANY FIELDS, EXCEPT AS NOTED BELOW. |
LOCATION |
FIELD |
LENGTH |
DESCRIPTION & REMARKS |
1-9 |
Social Security Number |
9 |
Employee's Social Security Number |
10-19 |
Account Number** |
10 |
Ten-digit UC Tax Account Number |
20-25 |
Activity Date |
6 |
First day of work or date of job refusal (MMDDYY) NOTE: This date should be the first day the employee did or would have physically reported to worked |
26 |
Indicator |
1 |
Enter "N" - New Hire |
27-53 |
Employee's Name |
27 |
Last/First/Middle Initial |
54-83 |
Employee's Street Address |
30 |
Employee's Mailing Address |
84-103 |
Employee's City Name |
20 |
City Name of Employee's Address |
104-105 |
Employee's State Name |
2 |
State Name of Employee's Address |
106-114 |
Employee's ZIP + 4 ZIP Code |
9 |
Nine-Digit ZIP Code of Employee's
Address (If Last 4 Digits Are Unknown, Enter 0's) |
115-123 |
Employer's FEIN |
9 |
Nine-Digit Federal Identification Number |
124-143 |
Employer Name |
20 |
Employer's Name (Abbreviate when possible) |
144-157 |
Employer Address |
14 |
Employer's Address |
158-168 |
Employer City |
11 |
Employer's City |
169-170 |
Employer State |
2 |
Employer's State |
171-175 |
Employer ZIP |
5 |
Employer's 5 digit Zip Code |
176-200 |
Blanks |
25 |
In-House Use |
** Alabama Department of Labor Unemployment Compensation Tax Account Number recorded in the upper right corner of the UCCR4 and UC10R forms. If not applicable, enter 0's. |