Table: Patient

Name	Type	Description	Remarks
TITLE_DR
TITLE_MISS
TITLE_MR
TITLE_MRS
TITLE_MS
VOID_PATIENT

Name	Type	Description	Remarks
ActvitityId	int	GenLookup The list of Activities checked on the patient record.	ActivityId is a foreign key to CatElementLU of LookupType 1.
Addresses	int	The list of Addresses associated with the patient record.	PatientID is a foreign key to the Patient table. AddressID is a foreign key to the Address table.
Appointments
BirthDate	varchar(100)	Patient's Birth Date.
CommunicationPreference		The patient's specified preferred method of communication.	See CommunicationPrefenceType
CompanyID		The Company that the patient record is associated with.	CompanyID is a foreign key reference to the CompanyInfo table.
Deceased	bit	Indicates whether the patient is deceased.
Dependents
Diabetes	bit	Indicates whether the patient's Diabetes checkbox is checked.
Email	varchar(max)	Patient's email address.
emailFlag	bit	Indicates that the patient has no email address or has declined to provide it.
emailPromo	bit	Indicates that the patient's email address may be used for promotional purposes
emailRecall	bit	Indicates that the patient's email address may be used for recalls.
EMRPatientNum		The Patient number in an EMR system.
Ethnicity	int	The specified Ethnicity of the patient	Ethnicity is a foreign key reference to GenLookup of type 70.
Exams
FirstName	varchar(20)	Patient's First name
HomeOffice	varchar(8)	The Office Number for the patient's primary office. (The office where the patient record was created.)	HomeOffice is a foreign key refernce to the Office table.
ImageID	int	The identifier for the patient picture.	ImageID is a foreign key reference to the Images table.
InActive	bit	Indicates if the patient record has been marked as inactive.
IsBadAddress	bit	Indicates whether the patient's "Bad Address" checkbox is checked.
IsBadEmail	bit	Indicates whether the patient's "Bad Email" checkbox is checked.
IsBadPhoneNumber	bit	Indicates whether the patient's "Bad Phone Number" checkbox is checked.
IsDoNotSendMailOffers	bit	Indicates whether the patient's "Do not send Mail Offers" checkbox is checked.
IsHipaaInfo	bit	Indicates whether the patient's "HIPAA signature on file" checkbox is checked.
IsMigrated	bit	Indicates whether the patient record was migrated to AcuityLogic from another system.
LastExamDate	datetime	The date of the patient's most recent exam.
LastModified	datetime	The date/time that the patient record was last modified.
LastName	varchar(25)	Patient's Last name.
MaritalStatus
MaritalStatusID
MedicalRecordNum	varchar(25)	The Patient's Medical Record Number
MemberID	varchar(25)	The User Assigned Member ID.
Middle	varchar(1)	Patient's Middle Initial
OccupationID	int	GenLookup The Patient's Occupation	OccupationID is a foreign key reference to the CatElementLU table of type 2.
Orders
ExamOffice		The Office Number of the office where the patient's exam was recorded.
patient_no_old	int	Patient Number from Old System (for ECR Vault)
PatientUid	varchar(36)	Internal Unique Identifier assigned to the patient.
PreferredLanguage	int	The specified Preferred Language of the patient	PreferredLanguage is a foreign key reference to GenLookup of type 72.
Race	int	The specified Race of the patient	Race is a foreign key reference to GenLookup of type 71. Note: This column is no longer used as patient races are stored in the PatientRace table.
Races
ReferralID	int	GenLookup The Patient's method of referral.	ReferralID is a foreign key reference to the CatElementLU table of type 23. GenLookup
ResponsibleID		The Identifier for the Responsible Party for the current patient	ResponsibleID is a foreign key reference to the Patient table for the responsible party.
SendApptNotificationsViaEmail	bit	Indicates whether the patient's "Send Appt. Notifications Via Text" checkbox is checked.
SendApptNotificationsViaText	bit	Indicates whether the patient's "Send Appointment Notifications Via Text" checkbox is checked.
SendOrderNotificationsViaEmail	bit	Indicates whether the patient's "Send Order Notifications Via Email" checkbox is checked.
SendOrderNotificationsViaText	bit	Indicates whether the patient's "Send Order Notifications Via Text" checkbox is checked.
Sex	varchar(1)	Sex: M/F
Signature	bit	Indicates that the patient's signature is on file for insurance.
SpecialNeeds	bit	Indicates whether the patient's Special Needs checkbox is checked.
SSN	varchar(100)	Social Security Number
Title	int	GenLookup The Patient's Title	Title is a foreign key reference to the CatElementLU table of type 4.