Patient Info Table

Field Name

Description

Length

Data Type

Parent Table and Field

Import Types

AccountID

Code that Latitude assigned to identify the account. For new business imports, don't map this field. For maintenance imports, you must map this field to ensure that Exchange Manager locates the correct account.

4

Integer

Master/Number

NB, M

AdmissionDate

Patient admission date.

8

DateTime

None

NB, M

Age

Patient's age.

1

TinyInt

None

NB, M

City

Patient's city.

35

VarChar

None

NB, M

Country

Patient's country.

25

VarChar

None

NB, M

DischargeDate

Patient's discharge date.

8

DateTime

None

NB, M

DOB

Patient's date of birth.

8

DateTime

None

NB, M

DoctorFax

Doctor's fax number.

20

VarChar

None

NB, M

DoctorName

Doctor's name.

75

VarChar

None

NB, M

DoctorPhnoe

Doctor's phone number.

20

VarChar

None

NB, M

EmployerName

Patient's employer's name.

75

VarChar

None

NB, M

FacilityCity

Medical facility's city.

35

VarChar

None

NB, M

FacilityCountry

Medical facility's country.

25

VarChar

None

NB, M

FacilityFax

Medical facility's fax number.

20

VarChar

None

NB, M

FacilityName

Name of the medical facility.

75

VarChar

None

NB, M

FacilityPhone

Medical facility's phone number.

20

VarChar

None

NB, M

FacilityState

Medical facility's state.

5

VarChar

None

NB, M

FacilityStreet1

Medical facility's street address line 1.

128

VarChar

None

NB, M

FacilityStreet2

Medical facility's street address line 2.

128

VarChar

None

NB, M

FacilityZIPCode

Medical facility's ZIP Code.

15

VarChar

None

NB, M

GuarantorRecNumber

Code that identifies the payment guarantor.

30

VarChar

None

NB, M

KinCity

Next of kin's city.

35

VarChar

None

NB, M

KinCountry

Next of kin's country.

25

VarChar

None

NB, M

KinName

Name of the patient's next of kin.

75

VarChar

None

NB, M

KinPhone

Next of kin's phone number.

20

VarChar

None

NB, M

KinState

Next of kin's state.

5

VarChar

None

NB, M

KinStreet1

Next of kin's street address line 1.

128

VarChar

None

NB, M

KinStreet2

Next of kin's street address line 2.

128

VarChar

None

NB, M

KinZIPCode

Next of kin's ZIP Code.

15

VarChar

None

NB, M

MaritalStatus

Patient's marital status.

1

Char

None

NB, M

Name

Patient's name.

75

VarChar

None

NB, M

PatientRecNumber

Code that medical facility assigned to identify the patient record.

30

VarChar

None

NB, M

Phone

Patient's phone number.

20

VarChar

None

NB, M

ServiceDate

Date the patient received medical service.

8

DateTime

None

NB, M

Sex

Patient's gender.

1

Char

None

NB, M

SSN

Patient's social security number.

15

VarChar

None

NB, M

State

Patient's state of residence.

5

VarChar

None

NB, M

Street1

Patient's street address line 1.

128

VarChar

None

NB, M

Street2

Patient's street address line 2.

128

VarChar

None

NB, M

WorkPhone

Patient's work phone number.

20

VarChar

None

NB, M

ZIPCode

Patient's ZIP Code.

15

VarChar

None

NB, M

PatientRelationToGuarantor

Patient's relationship to the person guaranteeing payment for medical care.

25

VarChar

None

NB, M

PatientRelationToGuarantorAdditionalInfo

More information regarding the patient's relationship to the guarantor.

50

VarChar

None

NB, M

AccidentDate

Date the patient had an accident that required medical attention.

8

DateTime

None

NB, M

AccidentType

Type of accident that the patient had.

25

VarChar

None

NB, M

FinancialClass

Code that identifies the patient's primary insurance to bill first for services.

25

VarChar

None

NB, M

ImportProcedures

Code that identifies a specific surgical, medical, or diagnostic intervention.

25

VarChar

None

NB, M

LocationCode

Code that identifies the location where the patient received medical care.

25

VarChar

None

NB, M

Modifier

Code that identifies a medical service or procedure.

25

VarChar

None

NB, M

PatientType

Code assigned during the registration or admission process to identify the type of patient (for example, emergency or day surgery).

25

VarChar

None

NB, M

PlaceOfServiceCode

Code that identifies the place that rendered service to the patient.

25

VarChar

None

NB, M

ProcedureCode

Code that identifies the medical procedure that the patient received.

25

VarChar

None

NB, M

ServicingProviderCode

Code that identifies the health care provider.

25

VarChar

None

NB, M

DiagnosisCode1

Code that identifies the patient's medical diagnosis.

25

VarChar

None

NB, M

DiagnosisCode2

Code that identifies the patient's medical diagnosis.

25

VarChar

None

NB, M

DiagnosisCode3

Code that identifies the patient's medical diagnosis.

25

VarChar

None

NB, M

DoctorCode

Code that the medical facility assigned to identify the admitting doctor.

5

VarChar

None

NB, M

AttendingDoctorName

Name of the doctor who is rendering service to the patient.

75

VarChar

None

NB, M

AttendingDoctorPhone

Attending doctor's phone number.

20

VarChar

None

NB, M

AttendingDoctorFax

Attending doctor's fax number.

20

VarChar

None

NB, M

AttendingDoctorCode

Code that the medical facility assigned to identify the attending doctor.

5

VarChar

None

NB, M