 |

|
Paper Billing Sample Company - Billing Specifications
|
| |
| Background: These specifications are for the voluntary
insurance deductions for the employees of Sample Company. We will
provide a change tape (e.g. monthly), prior to the first deduction
in that billing period. Sample Company deductions are taken (e.g.
weekly). |
| |
| File Name: |
RELIASTAR STANDARD CHANGE 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 amount is to change. Updates: starts, stops
& changes |
| Media: |
( ) 3480 Cartridge - 6250 BPI
(format 028) |
| |
( ) 3 ½" Diskette,
ASCII format (format 029) |
| |
( ) Electronic Transfer (format
029) |
| Labels: |
(x) Standard OS |
| File Organization: |
(x) Physical Seq. |
| Record Type: |
(x) Fixed |
| Block Size: |
(x) 8000 |
| Data Organization: |
(x) Sequential by
employee ID# |
|
| |
|
Standard Change (Billing) Format
|
| |
| Label |
Record
Position |
Type/Class |
Field
Description |
| Group |
001-003 |
X(03) |
One Char; 2 Numeric fixed field |
| Company |
004-008 |
X(05) |
One Char; 4Numeric fixed field |
| Employee ID |
009-018 |
X(10) |
Employee ID or SS# |
| Dept. |
019-022 |
X(04) |
Up to 4 characters |
| Location |
023-026 |
X(04) |
Up to 4 characters |
| Reserved |
027-029 |
x(03) |
Blank fill if not used |
| Model Amount |
030-036 |
S9(5)V99 |
EX: 0001200 = $12.00 |
| Deduction
Mode |
037-037 |
X(01) |
E.g. W = weekly |
| Filler |
038-038 |
x(01) |
Blank fill, not used |
| Last, First Name |
039-053 |
x(15) |
Employee name on ReliaStar
records |
| Filler |
054-080 |
X(27) |
Blank fill, not
used |
|
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 contact us to cancel
coverage OR have terminated employment. EX: 0000000 appears in the deduction
amount field.
- Changes: Employees that increase or reduce
premium amounts. EX: Employees that add spouse/dependent coverage.
Sample Company - Remittance Specifications
Background: The specifications are for the voluntary
insurance deductions for the employees of Sample Company. Sample Company
will send the file (e.g. Monthly) after the final deduction of the billing
cycle has been taken.
| File Name: |
RELIASTAR STANDARD COLLECTION FILE |
| Description: |
This file contains deduction amounts
and other identifying information for each employee participating
in the plan. One record per employee |
| Media: |
( ) 3480 Cartridge - 6250 BPI (format
001) |
| |
( ) 3 ½" Diskette, ASCII
format (format 001) |
| |
( ) Electronic Transfer (format 001) |
| Labels: |
(x) Standard OS |
| File Organization: |
(x) Physical Seq. |
| Record Type: |
(x) Fixed |
| Record Size: |
(x) 160 Bytes |
| Block Size: |
(x) 2400 |
| Data Organization: |
(x) Sequential by employee ID# |
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 - direct bill (employee terminated employment)
If your payroll system already has codes for the
above exceptions, please notify us (i.e., T-Termination, L-Leave of absence,
etc.)
| Label |
Record Position |
Type/Class |
Field Description |
| Group |
001-003 |
X(03) |
One Char; 2 Numeric |
| Company |
004-008 |
X(05) |
One Char; 4 Numeric fixed field |
| Employee ID |
009-018 |
X(10) |
Employee ID or SS# |
| Dept. |
019-022 |
X(04) |
Up to 4 characters |
| Location |
023-026 |
X(04) |
Up to 4 characters |
| Amount |
027-033 |
S9(5)V99 |
EX: 0001200 = $12.00 |
| Exception Code |
034-038 |
X(05) |
2 characters; see notes |
| SSN# |
039-047 |
X(09) |
Emp's SS# (Optional) |
| Last Name |
048-062 |
x(15) |
Emp's last name (Required) |
| First Name |
063-072 |
x(10) |
Emp's first name (Optional) |
| Address |
037-152 |
X(08) |
Blank fill, (Optional) |
| Filler |
153-160 |
X(08) |
Blank fill, (Optional) |
IMPORTANT - Please include employees with $0.00
amounts. If an employee is on vacation, short term leave of absence, etc.,
please include them with the $0.00 amount. If an employee terminates,
please include the $0.00 amount 1 time and include a valid termination
exception code.
Please remit electronic file without a header row.
Please contact a payroll coordinator with any questions you might have
regarding electronic specifications by contacting
our customer service line at 1 800 537-5024, or by calling or emailing
one of the payroll coordinators listed below.
| Region |
Sales Contacts |
Payroll Coordinators |
| West |
Rob Fulton,
Kelly Patterson |
Liz
Buller,
612-372-1805 |
| Southwest |
Chris Allen,
Terra Trogstad |
Jennifer
Jarvi,
612-372-1849 |
| Midwest |
Dan Robson,
Lisa Nelson |
Jennifer
Jarvi,
612-372-1849 |
| Upper Midwest |
Brent Cotton,
Nicholas Kutscheid |
Jennifer
Jarvi,
612-372-1849 |
| Southeast |
Peter Crahan,
Tiffaney Taylor |
Liz
Buller,
612-372-1805 |
Florida
North Carolina |
Billy Ward,
Lisa Nelson |
Liz
Buller,
612-372-1805 |
| Northeast |
Joe Beasley,
Neil Pelletier |
Beth
Swedberg,
612-342-7756 |
| East |
Will McGeehan,
Maria Awald |
Beth
Swedberg,
612-342-7756 |
| Electronic Cases |
Regional Sales
Coordinator |
|
|