DBNXXX –Vision Interface PHRST

Summary:

This program creates the vision Interface file (dbnXXX.dat) which is an enrollment/eligibility file for employees who have selected vision plan.

Output files:

DbnXXX.dat

Flat File:

Fixed Flat File Format *.dat

Flat File Output from Program
Output Description and Other Information
Vision Interface file
File Name / Retention in Number of Runs to keep
DbnXXX.dat / 3
File Disposition
Output will be picked up by the vendor from the FTP server.
Header Record – N/A
Detail Record:

File Layout

Field Name / Start
Position / End
Position / Length/Type (Char or Num) / Comments
Process date / 01 / 08 / 8 / mmddyyy
Client Name / 09 / 58 / 50 / ‘STATE OF DELAWARE’
Change Indicator / 59 / 59 / 1 / ‘A’ default
Member Id Number / 60 / 79 / 20 / blank
Last Name / 80 / 99 / 20
First Name / 100 / 114 / 15
Middle Initial / 115 / 115 / 1
Title / 116 / 118 / 3
Employee SSN / 119 / 127 / 9 / blank
Dependent SSN / 128– / 136 / 9 / blank
Sex / 137 / 137 / 1
Birth Date / 138 / 145 / 8 / mmddyyyy
Marital Status / 146 / 146 / 1 / 1 = Single
2= Married
Address 1 / 147 / 201 / 55
Address2 / 202 / 256 / 55
City / 257 / 281 / 25
State / 282 / 283 / 2
Zip / 284 / 292 / 9
Filler / 293 / 405 / 113 / blank
Medicare Number / 406 / 435 / 30 / blank
Medicare Part / 436 / 436 / 1 / blank
Coverage Effective date / 437 / 444 / 8 / mmddyyyy
Term Date / 445 / 452 / 8 / Termination date(Coverage_begin_dt -1)
Enrollment Reason / 453 / 462 / 10 / ‘199’ default
Group Number / 463 / 472 / 10
Relationship / 473 / 473 / 1 / 1 = Self
2= Spouse
3 = Student
4 = Dep Child
5 = Other
  • If relationship = ‘NP”, Relationship on file = ‘A’
  • If relationship = ‘ND”, Relationship on file = ‘B’
  • If relationship = ‘NS”, Relationship on file = ‘C’
  • If relationship = ‘CP”, Relationship on file = ‘D’
  • If relationship = ‘CD”, Relationship on file = ‘E’
If relationship = ‘CS”,
Relationship on file = ‘F’
Employee status / 474 / 475 / 2 / ‘EL’ default
Person type / 476 / 480 / 5 / 4 = Student
7 = Dependent
8 = Spouse
15 = Subscriber
21 = Spouse Prior
33 = Dependent Grandchild
222 = Disabled
  • If relationship = ‘CP’ , Type = ‘8’
  • If relationship = ‘NP’ , Type = ‘8’
  • If relationship = ‘CS’ , Type = ‘7’
  • if relationship = ‘CD’ , Type = ‘7’
  • If relationship = ‘ND’ , Type = ‘7’
  • if relationship = ‘NS’ , Type = ‘7’

Primary care date / 481 / 488 / 8 / blank
Health provider ID / 489 / 498 / 10
Record Count / 499 / 508 / 10
Employee ID / 509 / 519 / 11 / Employee ID
Department / 520 / 528 / 9 / Department ID
Filler / 529 / 536 / 8 / blank
Phone / 537 / 546 / 10
Filler / 547 / 1000 / 454 / blank
Trailer Record: N/A

Page 1 of 3