Standard Eligibility Format

All data files must be ASCII text files. NO EXCEL FILES WILL BE ACCEPTED

Formats Supported:

Field Name Field Length Required Notes

Record_Type

Action_Code

Carrier_Number

Group_Number

Group_Name

Plan_Number

Member_Number

ID_Suffix

SSN

Coverage_Code

Last_Name

First_Name

Middle_Intial

Address_1

Address_2

City

State

Zip

Gender

Birth_Date

Effective_Date

Term_Date

Sub_Group_ID

2

2

5

10

40

5

9

2

9

5

20

20

1

40

40

30

2

9

1

8

8

8

10

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

N

Y

N

Y

Y

Y

N

Y

Y

N

N

CH=Cardholder DP=Dependent

Blank=Add 01=Term 02=Change, 03=Reinstate 04=New Card

Assigned by Avesis

Assigned by Avesis

Customer Name

Assigned by Avesis

The Employee's SSN

01=Employee
02=Spouse
03=Dep 1
04=Dep 2
05=Dep 3
etc.

Individuals SSN

EE=Employee Only
DEP=Employee+1 Dep
CHD=Employee+Children
FAM=Family

 

 

 

 

 

 

 

 

M=Male
F=Female

mmddyyyy

mmddyyyy

mmddyyyy