Billing
FAQ for Employers
Forms Library for Employers
Customer Service
 
 


Sample Electronic Billing and Collection Specifications
 
Standard Change (Billing) Format
 
Description: This file contains a single record type which describes the deduction amount to be made for a single employee. One record is present for each employee whose deduction is to change.
 
Label Record Position Type/Class Field Description
Group 001-003 X(03) 1alpha,2num
Company 004-008 X(05) 1alpha,4num
Employee ID 009-018 X(10) Employee ID or SS#
Dept. 019-022 X(04) Up to 4 Numeric
Location 023-026 X(04) Up to 4 Numeric
Reserved 027-029 X(03) Blank
Model Amount 030-036 S9(5)V99 Ex: 0001200=$1200
Deduction Mode 037-037 X(01) One letter Code; ex:
      W = weekly
Filler 038-038 X(01) Blank
Last, First Name 039-053 X(15) Employee Name on RPD Records
Filler 054-080 X(27) Blank
Record Size: 80 Bytes   Block Size:  8000
 
Standard Collection Format
 
Description: This file contains deduction amounts and other identifying information for each employee participating in the plan. One record per employee.
 
Label Record Position Type/Class Field Description
Group 001-003 X(03) 1alpha,2num
Company 004-008 X(05) 1alpha,4num
Employee ID 009-018 X(10) Employee ID or SS#
Dept. 019-022 X(04) Up to 4 Numeric
Location 023-026 X(04) Up to 4 Numeric
Model Amount 027-033 S9(5)V99 Ex: 0001200=$1200
Exception Code 034-038 X(05) 2 Characters, See Notes
SS# 039-047 X(09) Employee's SS# (Optional)
Last Name 048-062 X(15) Employee's Last Name (Required)
First Name 063-072 X(10) Employee's First Name (Optional)
Address 073-152 X(80) Blank (Optional)
Filler 153-160 X(08) Blank
Record Size 160 Bytes   Block Size: 2400

Record Type: Fixed
File Organization: Physical Seq.
Data Organization: Sequential by Employee ID
Media Types:
( ) 3480 Cartridge - 6250 BPI, ( ) 3 ½" Diskette, ASCII format
( ) Electronic Transfer


Billing File Notes

Changes from ING Employee Benefits include:

Starts (or restarts): A new deduction for an employee that was not on the previous billing statement. A restart occurs if an employee was on leave and we are notified that they returned to work.

Stops: Employees that contacted us to cancel coverage OR have terminated employment. EX: 0000000 appears in the deduction amount field.

Changes: Employees that increase or reduce premium amounts. (Employee adds policy, etc.)

Collection File Notes

The following exception codes can be used in this format:

(a)  blanks = process normally
(b)  LS - leave of absence (employee out for > 1 month)
(c)  CN - cancel policy (employee requests cancellation),
(d)  DB (employee terminated employment) if your payroll system         already has codes for the above exceptions, please notify us         (i.e., T=termination, etc.).

IMPORTANT: Please include employees with $0.00 amounts. If an employee is on vacation, short-term LOA etc., please include them with the $0.00 amount. If an employee terminates, please include the $0.00 amount one time and include a valid termination exception code.

Left Justify with trailing spaces if entire field is not used (or all spaces if field is blank). EXCEPTION: In amount field, right justify with preceding 0's if entire field is not used (no decimals).

Billing