Placement Export File Insurance Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

1-4

1

record_type

String (4)

Value = CINS

File Number

5-13

2

file_number

Integer (9)

Unique number assigned to each account placed. Use this value for all data sent to AIM.

Insurance ID

14-22

3

insurance_id

Integer (9)

Unique number that identifies this insurance record.

Insured Name

23-72

4

InsuredName

String (50)

Insured person's name.

Insured Street1

73-200

5

InsuredStreet1

String (128)

Insured person's street address line 1.

Insured Street2

201-328

6

InsuredStreet2

String (128)

Insured person's street address line 2.

Insured City

329-378

7

InsuredCity

String (50)

Insured person's city.

Insured State

379-381

8

InsuredState

String (3)

Insured person's state.

Insured ZIP Code

382-391

9

InsuredZip

String (10)

Insured person's postal code.

Insured Phone

392-411

10

InsuredPhone

String (20)

Insured person's phone number.

Insured Birthday

412-419

11

InsuredBirthday

DateTime (CCYYMMDD)

Insured person's birthday.

Insured Sex

420

12

InsuredSex

String (1)

Insured person's gender (M or F).

Insured Employer

421-470

13

InsuredEmployer

String (50)

Name of Insured person's employer.

Auth Pmt to Provider

471

14

AuthPmtToProvider

String (1)

Indicates whether the insurance company authorized payments to the provider.

Accept Assignment

472

15

AcceptAssignment

String (1)

Indicates whether the insurance company accepts assignments.

Employer Health Plan

473-522

16

EmployerHealthPlan

String (50)

Description of employer's health plan.

Policy Number

523-572

17

PolicyNumber

String (50)

Insurance policy number.

Patient Relation to Insured

573-622

18

PatientRelationToInsured

String (50)

Insured's relationship to the patient.

Program

623-672

19

Program

String (50)

Insurance program name.

Group Number

673-722

20

GroupNumber

String (50)

Insurance group number.

Group Name

723-772

21

GroupName

String (50)

Insurance group name.

Carrier Name

773-872

22

CarrierName

String (100)

Insurance carrier's name.

Carrier Street1

873-1000

23

CarrierStreet1

String (128)

Insurance carrier's street address line 1.

Carrier Street2

1001-1128

24

CarrierStreet2

String (128)

Insurance carrier's street address line 2.

Carrier City

1129-1178

25

CarrierCity

String (50)

Insurance carrier's city.

Carrier State

1179-1181

26

CarrierState

String (3)

Insurance carrier's state.

Carrier ZIP Code

1182-1191

27

CarrierZip

String (10)

Insurance carrier's postal code.

Carrier Doc Provider Number

1192-1221

28

CarrierDocProviderNumber

String (30)

Insurance carrier's document provider number.

Carrier Ref Doc Provider Number

1222-1251

29

CarrierRefDocProviderNumber

String (30)

Insurance carrier's reference document provider number.

Country

1252-1379

30

Country

String (128)

Insured's person's country.

County

1380-1507

31

County

String (128)

Insured's person's county.

Filler

1508-3000

32

Filler

String (1493)

Filler for fixed file layout.