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