- Contents
Exchange Manager Help
Patient Info Table
The Patient Info table contains patient information for accounts. Each account can have one patient record only.
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 |