AZ Quarterly Unemployment Tax Wage Report
Report Specific Set-up
Prior to using the report application the user will have to enter the UI Tax Employer Number in the Human Resources Profile – State Window (see the Human Resources Profile – State Window section under Setting Up appllication for AZ State Reporting above). In addition, a UI tax-approved branch number (or three zeros if there is no branch number) must be entered in the Human Resources Profile – State Window.
Quarterly Wage Table Maintenance
To access the AZ Quarterly Unemployment Report select the following menu path: Human Resources -> State -> AZ Quarterly Unemployment Tax Wage Report.
The AZ Quarterly Wage Report displays a list of employees and the wage information for the report.
Update the AZ Quarterly Wage Report's data
Use the fields available in the Search Criteria at the top of the report's main screen to display the employee records that you want to change, or select a line in the list, then click the OK button to get into the Employee Information section at the bottom of the main screen. Notice that you can only change two fields: Employee Wages, and Taxable Wages fields. Either of these fields will accept amounts greater than zero.
Add an employee to the AZ Quarterly Wage table
Click the New icon at the top left corner of the report's main screen.
AZ Quarterly Wage Table Fields
Field Name | Table field | Data source |
|---|---|---|
Report Quarter | rpt_qtr | The quarter for which the record was created |
Report Year | rpt_yr | The year for which the record was created |
Employee ID | empl_no | Employee number from employee’s record. |
SSN | ssn | Social security number from employee’s record. |
First Name | f_name | First name from employee’s record (excluding the middle name). |
Middle Name | m_name | Middle name from employee’s record. |
Last Name | l_name | Last name from employee’s record. |
Generation | generation | Generation name retrieved from employee’s record. |
Wages | wages | Employee’s quarterly state wages |
Taxable Wages | tax_wages | Employee’s taxable quarterly state wages |
Load Quarterly Wage Table Entries
You can load the required data for all the qualified employees, from the appropriate files, and append all employee data into the AZ quarterly wage table.
Click Load.
In the Load Criteria section, select the year and quarter to load.
Click OK.
If records already exist and you want to reload records, click Yes on the confirmation message.
Purging Quarterly Wage Table Entries
You may delete all the data records for any given quarter and year, from the AZ quarterly wage table.
Click Purge.
In the Purge Criteria section, select the year and quarter to delete.
Click the OK button.
To continue with the purge, click Yes on the confirmation message.
Generating Reports and Files
Click Reports.
Select the report type – either 'Hard Copy' (printed report) or 'Magnetic Media' (file for submission to the state).
In the Report Criteria, select the year and quarter for the report.
Click OK.
If you selected to output the hard copy report and you have permission to view social security numbers on reports, the following message will be displayed:
Click Yes to print the Social Security numbers on the report, otherwise the Social Security numbers will be printed in the masked format.
Select the destination for the report. The report destination page for the Magnetic Media option is displayed.
The program will extract and report information for each employee who has received the specified type of reportable wages during the reporting quarter.
The Hard Copy option produces a listing of the wages paid for all employees. The employees will be ordered by last name, then first name.
The Magnetic Media option produces a fixed length file containing each reportable employee using the record layout in the federal MMREF-1 format specified by the Arizona Department of Economic Security. The name of the file created is "qtrwage.tap". The default location for this file is the directory associated with the FASTAPDIR environmental variable. Employees with no wages will not be included in the magnetic media file.
To view the log, click the Documents icon on the main AZ Quarterly Unemployment Tax Wage Report page, and then select the file name of the log and click OK.
Report Layouts
The hard copy report is formatted according to the AZ Quarterly Unemployment Tax Wage Report requirements.
AZ Quarterly Unemployment Tax Wage Report Magnetic Media Layout
"RS" record type: State Record
Field | Begin | Location | Type | Description: S: for source of data |
|---|---|---|---|---|
Record ID | 1 | 1-2 | X(2) | ‘RS’ |
State Code | 3 | 3-4 | X(2) | ‘04’ |
UI Tax ID | 5 | 5-9 | X(5) | ‘UITAX’ |
SSN | 10 | 10-18 | X(9) | Employee’s SSN without ‘-’. If not available, fill ‘1’ with 8 spaces. S: employee.ssn |
First Name | 19 | 19-33 | X(15) | Employee’s first name. S: employee.f_name |
Middle Name | 34 | 34-48 | X(15) | Employee’s middle name. S: employee.m_name |
Last Name | 49 | 49-68 | X(20) | Employee’s last name. S: employee.l_name |
Suffix | 69 | 69-72 | X(4) | Generation code, like Jr, Sr. S: employee.name_suffix |
Location Address | 73 | 73-94 | X(22) | Employee’s address. S: employee.addr |
Deliver Address | 95 | 95-116 | X(22) | Employee’s address. S: employee.addr |
City | 117 | 117-138 | X(22) | Employee’s city. S: employee.city |
State | 139 | 139-140 | X(2) | Employee’s state numeric code from Appendix A of the Arizona Magnetic Media Employer Filing (MMREF-1) Guidelines S: employee.state_id |
Zip Code | 141 | 141-145 | X(5) | 5 digit postal zip code S: employee..zip |
Zip Code Ext. | 146 | 146-149 | X(4) | 4 digit extension of the zip code S: employee..zip |
Blank | 150 | 150-196 |
| Blank, Not used by AZ. |
Reporting Period | 197 | 197-202 | X(6) | The user enters the quarter and the 4 digit year at the reporting time. The program will determine the last month of the quarter and concatenate them as ‘MMYYYY’. S: User input. |
Quarterly Total Wage | 203 | 203-213 | N(11) | Total gross from the earnings screen. 2 decimal positions implied. No sign. No decimal point. S: payroll.tearn_q |
Quarterly Taxable Wage | 214 | 214-224 | N(11) | Total fed tax gross from the earnings screen. 2 decimal positions implied. No sign. No decimal point. S: payroll.ftearn_q |
Blanks | 225 | 225-247 |
| Blank |
UI Tax Employer NO | 248 | 248-254 | X(7) | 7 digit number assigned by UI Tax Section. User enters in the HRM profile State Screen. S: hrmstate.state2[1,7]. |
Branch Number | 255 | 255-257 | X(3) | 3 digit branch number. User enters in the HRM profile State Screen. Program will fill with “000” if there is no branch number. S: hrmstate.state3[1,3] |
Blanks | 258 | 258-512 |
| Blank |
"RF" record type: Final Record (Not required)
A final record will be appended to the RS records as the last record in the diskette file.
Field | Begin | Location | Type | Description S: for source of data |
|---|---|---|---|---|
Record ID | 1 | 1-2 | X(2) | 'RF' |
Blank | 3 | 3-512 | Blank |