 |

| 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).
|