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 |