NE Quarterly Wage Report
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 |