Insurance
| Field | Type | Length | Allow Null | Natural Key | Description | |
|---|---|---|---|---|---|---|
| 1 | Record Type ID | String | Indicates the record type. For this record it will always be “Insurance”. | |||
| 2 | ID | ID | Surrogate Key | |||
| 3 | Patient ID | REF | Surrogate key to a patientCorresponds to a (Patient line in the same file set)’s ID value | |||
| 4 | Encounter ID | REF | Surrogate Key to an EncounterCorresponds to a (Encounter line in the same file set)’s ID value | |||
| 5 | Plan Identifier | String | 20 | |||
| 6 | Plan Name | String | 130 | practices key Identifier for a patient | ||
| 7 | Group Number | String | 20 | |||
| 8 | Group Name | String | 130 | |||
| 9 | Start Date | Date | ||||
| 10 | End Date | Date | ||||
| 11 | Medicare Card Number | String | 20 | |||
| 12 | Medicaid Case Name | String | 100 | |||
| 13 | Medicaid Case Number | String | 20 | |||
| 14 | Pharmacy Coverage | String | 20 | |||
| 15 | Comment | String | MAX | |||
| 16 | Sponsor | String | 130 | |||
| 17 | Policy number | String | 20 | |||
| 18 | Insurance Company Name | String | 120 | |||
| 19 | Insurance Company Address | String | 160 | |||
| 20 | Insurance Company City | String | 60 | |||
| 21 | Insurance Company State | String | 50 | |||
| 22 | Insurance Company Postal Code | String | 20 | |||
| 23 | Insurance Company Phone | String | 20 | |||
| 24 | Group EMP ID | String | 50 | |||
| 25 | Group EMP Name | String | 120 | |||
| 26 | Insured Name | String | 120 | |||
| 27 | Insured Address | String | 160 | |||
| 28 | Insured City | String | 50 | |||
| 29 | Insured State | String | 50 | |||
| 30 | Insured Postal Code | String | 20 | |||
| 31 | Insured Phone | String | 20 | |||
| 32 | Insured Alt Phone | String | 20 | |||
| 33 | Insured DOB | Date | ||||
| 34 | Insured SSN | String | 20 | |||
| 35 | Insured Gender | String | 20 | |||
| 36 | Plan Type Term | Term | code|name|namespace|family|ns desc | |||
| 37 | Rate Code Term | Term | code|name|namespace|family|ns desc | |||
| 38 | Status Term | Term | code|name|namespace|family|ns desc | |||
| 39 | Segment Term | Term | code|name|namespace|family|ns desc | |||
| 40 | Primary Caregiver ID | REF | Surrogate Key to a CaregiverCorresponds to a (Caregiver line in the same file set)’s ID value | |||
| 41 | Insured Relationship Term | Term | code|name|namespace|family|ns desc | |||
| 42 | Type Term | Term | code|name|namespace|family|ns desc | |||
| 43 | Patient Identifier | String | 128 | Used to look up existing patient. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for a patient | ||
| 44 | Patient Record Authority ID | REF | Surrogate Key to a Record Authority. | |||
| 45 | Encounter Identifier | String | 128 | Used to look up existing encounter. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for an encounter | ||
| 46 | Primary Caregiver Identifier | String | 64 | Used to look up existing caregiver. Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for a caregiver | ||
| 47 | Primary Caregiver Record Authority ID | REF | Surrogate Key to a Record Authority. | |||
| 48 | Inserted Audit Data | Audit | Audit data for when the record was inserted/created | |||
| 49 | Last Modified Audit Data | Audit | Audit data for when the record was last modified | |||
| 50 | Data Source | Data Source | 50|MAX | Code|Name. See Data Source Format - Source of the data |