EHI Data Dictionary Tables
Reference for column types, default values and required fields
EHI Data Dictionary Tables
Column Name
Data Type
Default
Not Null
InsAddPhone
InsuranceName2
InsuredPolicyNo2
PatientRel1
InsuredLastName2
InsuredFirstName2
InsuredGroupNo2
Copay2
InsuredDOB2
Ins2AddL1
Ins2AddL2
Ins2AddCity
Ins2AddState
Ins2AddZip
Ins2AddPhone
ChartNo
FirstName
LastName
DOB
Phone
Reason
AppointmentDate
AppointmentTime
FacilityName
SchedulerName
AppointmentType
AppointmentStatus
EHI Data Dictionary Tables
Patients Table Schema
| Column Name | Data Types | Default | Not Null |
|---|---|---|---|
| ChartNo | int | NOT NULL | |
| FirstName | varchar | NOT NULL | |
| MiddleName | varchar | ||
| LastName | varchar | ||
| Gender | varchar | NOT NULL | |
| DateOfBirth | date | ||
| Address1 | varchar | NOT NULL | |
| Address2 | varchar | ||
| City | varchar | NOT NULL | |
| State | varchar | ||
| Zip | varchar | ||
| Phone | varchar | NOT NULL | |
| Fax | varchar | ||
| varchar | |||
| ReferredPhysician | int | 0 | |
| status | varchar | 'Y' | |
| MaritalStatus | varchar | ||
| Race | varchar | ||
| Ethnicity | varchar | ||
| InsuranceName | varchar | ||
| InsuredPolicyNo | varchar | NOT NULL | |
| PatientRel | varchar | NOT NULL | |
| InsuredLastName | varchar | ||
| InsuredFirstName | varchar | NOT NULL | |
| InsuredGroupNo | varchar | ||
| Copay | float | 0 | |
| InsuredDOB | datetime | NOT NULL | |
| InsAddL1 | varchar | NOT NULL | |
| InsAddL2 | varchar | ||
| InsAddCity | varchar | NOT NULL | |
| InsAddState | varchar | ||
| InsAddZip | varchar | ||
| InsAddPhone | varchar | NOT NULL | |
| InsuranceName2 | varchar | ||
| InsuredPolicyNo2 | varchar | ||
| PatientRel1 | varchar | ||
| InsuredLastName2 | varchar | ||
| InsuredFirstName2 | varchar | ||
| InsuredGroupNo2 | varchar | ||
| Copay2 | float | 0 | |
| InsuredDOB2 | datetime | ||
| Ins2AddL1 | varchar | ||
| Ins2AddL2 | varchar | ||
| Ins2AddCity | varchar | ||
| Ins2AddState | varchar | ||
| Ins2AddZip | varchar | ||
| Ins2AddPhone | varchar |
Appointments Table Schema
| Column Name | Data Types | Default | Not Null |
|---|---|---|---|
| ChartNo | int | ||
| FirstName | varchar | NOT NULL | |
| LastName | varchar | NOT NULL | |
| DOB | date | ||
| varchar | |||
| Phone | varchar | NOT NULL | |
| Reason | varchar | ||
| AppointmentDate | timestamp | CURRENT_TIMESTAMP | NOT NULL |
| AppointmentTime | varchar | ||
| FacilityName | int | NOT NULL | |
| SchedulerName | int | ||
| AppointmentType | int | 1 | |
| AppointmentStatus | int |