Placement Export File Patient Record

Latitude

Position

Col

Column Name

Format

Comment

Record Type

 1-4

1

record_type

String (4)

Value = CPAT

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.

Name

14-88

3

Name

String (75)

Name of the patient.

Street1

89-216

4

Street1

String (128)

Patient's street address line 1.

Street2

217-344

5

Street2

String (128)

Patient's street address line 2.

City

345-379

6

City

String (35)

Patient's city.

State

380-381

7

State

String (2)

Patient's state.

Zip code

382-396

8

ZipCode

String (15)

Patient's postal code.

Country

397-421

9

Country

String (25)

Patient's country.

Phone

422-441

10

Phone

String (20)

Patient's phone number.

SSN

442-456

11

SSN

String (15)

Patient's social security number.

Sex

457

12

Sex

String (1)

Patient's gender.

Age

458-466

13

Age

Integer (9)

Patient's age.

Date of Birth

467-474

14

DOB

DateTime (CCYYMMDD)

Patient's date of birth.

Marital Status

475

15

MaritalStatus

String (1)

Patient's marital status.

Employer Name

476-550

16

EmployerName

String (75)

Patient's employer's name.

Work Phone

551-570

17

WorkPhone

String (20)

Patient's work phone number.

Patient Rec Number

571-600

18

PatientRecNumber

String (30)

Patient's receiving number.

Guarantor Rec Number

601-630

19

GuarantorRecNumber

String (30)

Guarantor's receiving number.

Admission Date

631-638

20

AdmissionDate

DateTime (CCYYMMDD)

Patient's admission date.

Service Date

639-646

21

ServiceDate

DateTime (CCYYMMDD)

Patient's service date.

Discharge Date

647-654

22

DischargeDate

DateTime (CCYYMMDD)

Patient's discharge date.

Facility Name

655-729

23

FacilityName

String (75)

Medical facility name.

Facility Street1

730-857

24

FacilityStreet1

String (128)

Medical facility street address line 1.

Facility Street2

858-985

25

FacilityStreet2

String (128)

Medical facility street address line 2.

Facility City

986-1020

26

FacilityCity

String (35)

Medical facility city.

Facility State

1021-1025

27

FacilityState

String (5)

Medical facility state.

Facility Zip code

1026-1040

28

FacilityZipCode

String (15)

Medical facility postal code.

Facility Country

1041-1065

29

FacilityCountry

String (25)

Medical facility country.

Facility Phone

1066-1085

30

FacilityPhone

String (20)

Medical facility phone number.

Facility Fax

1086-1105

31

FacilityFax

String (20)

Medical facility fax number.

Doctor Name

1106-1180

32

DoctorName

String (75)

Doctor's name.

Doctor Phone

1181-1200

33

DoctorPhone

String (20)

Doctor's phone number.

Doctor Fax

1201-1220

34

DoctorFax

String (20)

Doctor's fax number.

Kin Name

1221-1295

35

KinName

String (75)

Next of kin's name.

Kin Street1

1296-1423

36

KinStreet1

String (128)

Next of kin's street address line 1.

Kin Street2

1424-1551

37

KinStreet2

String (128)

Next of kin's street address line 2.

Kin City

1552-1586

38

KinCity

String (35)

Next of kin's city.

Kin State

1587-1591

39

KinState

String (5)

Next of kin's state.

Kin Zip code

1592-1606

40

KinZipCode

String (15)

Next of kin's postal code.

Kin Country

1607-1631

41

KinCountry

String (25)

Next of kin's country.

Kin Phone

1632-1651

42

KinPhone

String (20)

Next of kin's phone number.

Filler

1652-3000

43

Filler

String (1349)

Filler for fixed file layout.