| FileMan FileNo | FileMan Filename | Package | 
|---|---|---|
| 9000004 | MEDICAID ELIGIBLE | IHS Patient | 
| Package | Total | FileMan Files | 
|---|---|---|
| Third Party Billing | 2 | 3P BILL(#9002274.4)[#9002274.4013(.06)] 3P CLAIM DATA(#9002274.3)[#9002274.3013(.06)] | 
| IHS Patient | 1 | MEDICAID CLAIMS(#9000004.01)[.02] | 
| Package | Total | FileMan Files | 
|---|---|---|
| Utility Tables | 3 | EMPLOYER GROUP INSURANCE(#9999999.77)[.17] INSURER(#9999999.18)[.02, .11] RELATIONSHIP(#9999999.36)[.06] | 
| IHS Patient | 2 | POLICY HOLDER(#9000003.1)[.09] PATIENT(#9000001)[.01] | 
| Kernel | 1 | STATE(#5)[.04] | 
| Field # | Name | Loc | Type | Details | 
|---|---|---|---|---|
| .01 | PATIENT NAME | 0;1 | POINTER TO PATIENT FILE (#9000001) | ************************REQUIRED FIELD************************PATIENT(#9000001) 
 | 
| .02 | INSURER POINTER | 0;2 | POINTER TO INSURER FILE (#9999999.18) | ************************REQUIRED FIELD************************INSURER(#9999999.18) 
 | 
| .03 | MEDICAID NUMBER | 0;3 | FREE TEXT | ************************REQUIRED FIELD************************ 
 | 
| .04 | STATE | 0;4 | POINTER TO STATE FILE (#5) | ************************REQUIRED FIELD************************STATE(#5) 
 | 
| .05 | NAME OF INSURED | 0;5 | FREE TEXT | 
 | 
| .06 | RELATIONSHIP TO INSURED | 0;6 | POINTER TO RELATIONSHIP FILE (#9999999.36) | RELATIONSHIP(#9999999.36) 
 | 
| .07 | SEX OF INSURED | 0;7 | SET | 
 
 | 
| .08 | DATE OF LAST UPDATE | 0;8 | DATE | 
 | 
| .09 | POLICY HOLDER | 0;9 | POINTER TO POLICY HOLDER FILE (#9000003.1) | POLICY HOLDER(#9000003.1) 
 | 
| .11 | PLAN NAME | 0;10 | POINTER TO INSURER FILE (#9999999.18) | INSURER(#9999999.18) 
 | 
| .12 | RATE CODE | 0;11 | FREE TEXT | 
 | 
| .13 | CASE NUMBER | 0;13 | FREE TEXT | 
 | 
| .14 | PRIMARY CARE PROVIDER | 0;14 | FREE TEXT | 
 | 
| .15 | MEDICAID CARD COPY ON FILE | 0;15 | SET | 
 
 | 
| .16 | DATE MCD CC WAS OBTAINED | 0;16 | DATE | 
 | 
| .17 | GROUP NAME | 0;17 | POINTER TO EMPLOYER GROUP INSURANCE FILE (#9999999.77) | EMPLOYER GROUP INSURANCE(#9999999.77) 
 | 
| 1101 | ELIGIBILITY DATES | 11;0 | DATE Multiple #9000004.11 | 9000004.11 | 
| 2101 | MEDICAID NAME | 21;1 | FREE TEXT | 
 | 
| 2102 | MEDICAID DATE OF BIRTH | 21;2 | DATE | 
 |