Quarterly Contribution and Wage Report - File Layouts and Data Mapping

Identification Code

Constant 4.

1

1

4

Social Security Number

The employee's social security number. 

If not known, enter zeros in position 2-9 and 1 in position 10. If additional SSNs are unknown, increment the number in position 10 by 1.
For example:

• 0000000001

• 0000000002

• 0000000003

9

2-10

employee.ssn positions 1-3, employee.ssn positions 5-6, employee.ssn positions 8-11,

State Unemployment Insurance Account Number

The state-assigned employer organization code.

The MODES-4, “Missouri Quarterly Contribution and Wage Report,” sent each quarter, will have the account number printed in item 2. Do not include wages unless a 14-digit account number is assigned. FEIN and “applied for” accounts are not accepted. The account number is in this format: 345678-0-123-4567. Starting from left to right:

• The first six digits are called serial.

• The next digit is called sub-serial.

• The next three digits are called area.

• The next four digits are called industry.

• The 15th character is a blank or a space.

15

11-25

Entered on the MO Quarterly Contribution and Wage Report - Load page.

Quarter/Year

Quarter and year for which these earnings apply.

For example, earnings for the first quarter of 2011 are shown as 111.

3

26-28

Selected on the MO Quarterly Contribution and Wage Report - Load page.

First Name

The employee's first name.

9

29-37

employee.f_name[1,9]

Last Name

The employee's last name.

16

38-53

employee.l_name[1,16]

Earnings

The wages paid to employees are their gross before deductions, except for federally permitted cafeteria deductions. This also includes the reasonable cash value of any in-kind remuneration. Report the numerical value of this field with right justification and zero-filled using zeros only (no spaces or blanks). The decimal point is already assumed. It is advisable not to report employees with zero or negative earnings.

9

54-62

payroll.tearn_q

Probationary Code

Indicates whether the employee is on probation.

If the worker was employed on a test or trial basis and was employed no longer than 28 consecutive calendar days, the value of this code should equal 1. When this code is present, there also must be a separation date. The lack of one nullifies this code. If the worker is not probationary, this code is zero.

1

63

If the employee Separate Date on the empuser.state10 (page_no “32000”) minus the employee Hire Date employee.hire_date < 29, this field is set to 1, else it is set to 0.

Separation Date

The employee’s probationary date.

If this worker is a probationary worker separated from your employment, enter this date in MMDDYY format.

Example: 030123

If the worker is not probationary, enter zeroes. Only enter a separation date if the worker is probationary.

6

64-69

If the employee Separate Date – empuser.state10 (page_no “32000) is not null, it uses the Separate Date value in format MMDDYY. Else it is set to 000000.

Filler

Value is zeros.

3

70-72

000