/ Disability Full File Export

Export Overview

I.Business Overview

This export file will contain eligibility data for member in Disability fund. A weekly Full file will be sent to TBD for claims processing.

File layout: Fixed length 650

Save as options: Text File

# Of Files Generated: 1 File

Data formatting:

Alphanumeric – left justified and padded with trailing spaces

Dates – YYYYMMDD format

Numeric fields – should be right justified and padded with leading spaces

II.Selection Criteria:

Each eligible member will have its own record. Fields with demographic information should be specific to the member. Example, member record will contain the member name, address, date of birth and gender. There will be no dependent info included on this file.

Select all members enrolled in following:

Fund / Plan
Disability / Disability

For type of file = Full File

  • The file must include all ACTIVE members as of the date of the export. ACTIVE is defined as Members whose Enrollment Termination date is > the As of Date or Blank.
  • Only members enrolled in Disability plans should be included.

III.Export Sections and Sequence

Records must be sorted in ascending order by SSN, then by Person code and then by record type, so that all the records for a single employee are grouped together in chronological order of date

Seq # / Record Type / Description/Selection Logic / Optional / Required
1 / Header / Uniquely identifies the export / R
2 / Detail / Person eligibility data / R
3 / Trailer / Tracking and verification information for the Export / R

IV.Export Parameters

GUI Label / Widget Type / Description (include default value) / Format
As of Date / Text Field / Date of the export – / MM/DD/YYYY

V.Steps to create export:

Step # / Description
1 / Run batch ……
2 / Go Admin->Export->Data->Create Export

VI.Record Layouts

Header

Start Position / Stop Position / Field Name / Length / Data Type / Required / Format / Value/Default / Description
1 / 1 / Record type / A/N / Y / 1 / Indicates header file
2 / 10 / Carrier / A/N / Y / 9010 / Assigned by APCS, Indicates this file is from OSEEGIB
11 / 35 / Address1 / A/N / N / 3545 NW 58th Street
36 / 60 / Address2 / A/N / N / Suite 110
61 / 80 / City / A/N / Oklahoma City
81 / 82 / State / A/N / N / OK
83 / 92 / Zip / A/N / N / 73112
93 / 102 / Phone / A/N / N / 405-717-8888
103 / 110 / Creation Date / N / Y / YYYYMMDD / Creation date of this file.
111 / 650 / Filler

Detail

Start Position / Stop Position / Field Name / Vitech Length / Data Type / Required / Format / Value/
Default / Description
1 / 1 / Record type / 1 / A/N / Y / F for full file / Indicate if the record type is an Add record or a change record.
2 / 10 / Carrier / 9 / A/N / Y / 9010 / 9010 Hard coded for every record, stands for OSEEGIB
11 / 20 / Account / 10 / A/N / Y / 40 = State,
42 = Ed,
43 = Local Government / Indicates Group Association. Leave Blank for dependent records
21 / 30 / Group / 10 / A/N / Y / Member’s employer code
31 / 39 / Member_Id / 9 / A/N / Y / Unique Identifier for member record. If member has specified to use member code, then member code, else the member's SSN
40 / 41 / Person Code / 2 / A/N / Y / Default = 00 (member) / Unique identifier for this person record as he/she relates to the member. Member Custom field
42 / 43 / Relationship / 2 / A/N / N / Not Used
44 / 93 / Last Name / 50 / A/N / Y / The last name of this person record.
94 / 143 / First Name / 50 / A/N / Y / The first name of this person record.
144 / 144 / Middle Initial / 1 / A/N / Y / The middle initial of this person record.
145 / 145 / Sex / 1 / A/N / Y / The sex of this person record.
146 / 153 / Date of Birth / 8 / N / Y / YYYYMMDD / The birth date of this person record.
154 / 161 / Effective Date / 8 / N / Y / YYYYMMDD / The effective date for this person's coverage
162 / 169 / Termination Date / 8 / N / N / No term on a Full File – not used
170 / 229 / Address1 / 60 / A/N / Y / Member Address_Line1.
230 / 259 / Address2 / 30 / A/N / Y / Member Address_Line2.
260 / 309 / City / 50 / A/N / Y / Member City
310 / 311 / State / 2 / A/N / Y / Member State
312 / 321 / Zip / 9 / A/N / Y / Member Zip
322 / 331 / Primary Phone / 10 / A/N / Y / Member Primary Phone
332 / 332 / Alt Ins Indicator / 1 / A/N / N / From Member Info Tab – Not used
333 / 342 / Alt Ins Code / 10 / A/N / N / From Member Info Tab – Not used
343 / 360 / Alt Ins ID / 18 / A/N / N / From Member Info Tab – Not used
361 / 369 / Alt physician Id / N / Provider ID- Not used
370 / 379 / Status / 10 / A/N / Y / Always = A (Active) / Member Status – defaulted to A
380 / 389 / Plan Code / 10 / A/N / Y / Always =
22(Disability) / Defaulted to 22
390 / 397 / Plan Eff Date / 8 / N / N / From Member Info Tab – Not used
398 / 398 / New card Flag / 1 / A/N / N / From Member Info Tab – Not used
399 / 400 / Martial Status / 2 / A/N / Y / The marital status of member
401 / 410 / Alt Phone / 10 / A/N / N / The Alt phone of member if not populated, should be = 0000000000
411 / 418 / Hire Date / 8 / N / N / YYYYMMDD / Not used
419 / 427 / Dependent Social / 9 / A/N / N / Not used
428 / 428 / ID Handicap Code / 1 / A/N / N / Not used
429 / 429 / Student Code / 1 / A/N / N / Not used
430 / 439 / Tier code / 10 / A/N / Y / Default = M (member only) / Code indicating who is enrolled in reported benefit
440 / 449 / Division / 10 / A/N / Y / Member's employer-division code
450 / 457 / Alt Ins From Date / 8 / N / N / Member Info Tab – Not used
458 / 465 / Alt Ins Thru Date / 8 / N / N / Member Info Tab – Not used.
466 / 466 / Pen Claim / 1 / A/N / N / Y or N / Member Info Tab – Not used
467 / 467 / Pre Ex / 1 / A/N / N / Y or N / Member Info Tab – Not used
468 / 478 / HCIN / 11 / A/N / N / Member Info Tab – Not used
479 / 488 / From Group / 10 / A/N / N / Member Info Tab – Not used
489 / 498 / From Account / 10 / A/N / N / Member Info Tab – Not used
499 / 509 / From Member_ID / 11 / A/N / N / Member Info Tab – Not used
510 / 517 / Original Eff Date / 8 / N / N / YYYYMMDD / Member Info Tab – Not used
518 / 525 / Dental Penalty / 8 / N / N / YYYYMMDD / Member Info Tab – Not used
526 / 533 / Life Insurance Amt / 8 / N / N / 999999.99 / Elected Amount Of Life Insurance – Not used
534 / 548 / Country / 15 / A/N / Y / Country of the Address
549 / 650 / Filler / For future Additions.

Trailer

Start Position / Stop Position / Field Name / Length / Vitech Length / Data Type / Required / Format / Value/ Default / Description
1 / 1 / Record Type / 1 / 1 / A/N / 9 / Indicates trailer record
2 / 10 / Carrier / 9 / 9 / A/N / TBD
11 / 19 / Total records / 9 / 9 / N / Total number of member records
(Do NOT include header and trailer)
20 / 28 / Total Adds / 9 / 9 / N / Total Number of Add Records – does not apply
29 / 37 / Total Changes / 9 / 9 / N / Total Number of Change Records – does not apply
38 / 46 / Total Move History / 9 / 9 / N / Number of Records performing a History Move – does not apply
47 / 650 / Filler

VII.Contact Information

Name / Phone / E-Mail
Stacey Felix / 405-717-8910 /

VIII.Open Issues

# / Author / Date Opened / Issue / Resolution / Date Closed

IX.Assumptions

# / Author / Assumptions

IX.Document Change Log

Date of change / Author / Change Description
6/27/2002 / Daisy Shah / Document Created
8/2/2002 / Daisy Shah / Updated for layout changes
8/7/2002 / Daisy Shah / Update for Tier code logic
08/10/2016 / Stacey Felix / Updating entire doc to create a layout for new Disability Full File

X.Sign-off

Reviewed by:Date:

Approved by:Date:

Page 1 of 7 / 02/16/2019