Return to
previous page
 
     
     
     
     
     
  Standard Eligibility Format
 

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

Formats Supported:

  • Vertical Bar Delimited
  • Fixed Width (please refer to the length of each field listed below)

 

Field Name
Field Length
Required
Notes
  Record_Type
2
Y
CH=Cardholder
DP=Dependent
  Action_Code
2
Y
Blank=Add
01=Term
02=Change,
03=Reinstate
04=New Card
  Carrier_Number
5
Y
Assigned by Avesis
  Group_Number
10
Y
Assigned by Avesis
  Group_Name
40
Y
Customer Name
  Plan_Number
5
Y
Assigned by Avesis
  Member_Number
9
Y
The Employee's SSN
  ID_Suffix
2
Y
01=Employee
02=Spouse
03=Dep 1
04=Dep 2
05=Dep 3
etc.
  SSN
9
Y
Individuals SSN
  Coverage_Code
5
Y
EE=Employee Only
DEP=Employee+1 Dep
CHD=Employee+Children
FAM=Family
  Last_Name
20
Y
 
  First_Name
20
Y
 
  Middle_Intial
1
N
 
  Address_1
40
Y
 
  Address_2
40
N
 
  City
30
Y
 
  State
2
Y
 
  Zip
9
Y
 
  Gender
1
N
M=Male
F=Female
  Birth_Date
8
Y
mmddyyyy
  Effective_Date
8
Y
mmddyyyy
  Term_Date
8
N
mmddyyyy
  Sub_Group_ID
10
N
 
 
 
   
     
 
Home | About Us | Contact Us