To access the NE Quarterly Wage Report, select the following menu path: Human Resources -> State -> State -> NE Quarterly Wage Report.
Load
Select the quarter and year to load.
Purge
Select the quarter and year to purge. A confirmation prompt will be displayed asking to continue.
Reports
Enter the quarter and year, sort on name or social security number. Generate a hard copy or an electronic file.
File Layouts
|
Field |
Type |
Length |
Start Position |
End Position |
Status |
Comments |
|---|---|---|---|---|---|---|
|
Record Identifier |
A |
1 |
1 |
1 |
R |
This must contain the constant 'A'. |
|
Social Security Number |
N |
9 |
2 |
10 |
R |
This is the social security number without any dashes |
|
NE Employer Account Number |
N |
10 |
11 |
20 |
R |
This is the NE Employer Account Number. No dash or spaces. |
|
Reporting Period |
N |
3 |
21 |
23 |
R |
Enter year and quarter to which the report applies (ex. 132 for the 2nd quarter of 2013). |
|
First Initial |
A |
1 |
24 |
24 |
R |
Enter first initial of employee. |
|
Middle Initial |
A |
1 |
25 |
25 |
O |
Enter middle initial of employee. If N/A leave blank. |
|
Last Name |
A |
25 |
26 |
50 |
R |
Enter last name of employee. Left justify and fill with blanks. |
|
Total Wages |
N |
9 |
51 |
59 |
R |
Total wages this quarter for the employee. Enter as dollars and cents. Right justify and zero fill. Do not include a decimal (ex. $1512.45 would be 000151245) |
|
Blanks |
|
20 |
60 |
79 |
R |
Enter 20 blank spaces |
|
Source Code |
A |
1 |
80 |
80 |
R |
This must contain the constant 'T' Note: A carriage return is required at the end of each 80 byte employee record. |
Tables
qtrwagene– Stores quarterly wages
|
Field Name |
Field Type |
Description |
|---|---|---|
|
quarter |
(char(1), not null) |
Quarter |
|
yr |
(char(4), not null) |
Year |
|
empl_no |
(int, not null) |
Employee Number |
|
ssn |
(char(11), not null) |
Social Security |
|
l_name |
(char(30), not null) |
Last Name |
|
f_name |
(char(30), not null) |
First Name |
|
qtr_wage |
(decimal(10,2), not null) |
Amount for quarter |
|
m_name |
(char(30), null) |
Middle name |