Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
  | PatientID | int | 4 | NOT NULL | | Key to the Patients_Edit table. Will match works.dbo.person |
| PhotoIDFileName | varchar(50) | 50 | NULL allowed | | Patient profile picture. This is the filename of the photo. |
| PhotoIDPath | varchar(50) | 50 | NULL allowed | | This is the path to the profile picture. |
| CheckedOut | tinyint | 1 | NOT NULL | ((0)) | UNUSED |
| ChartID | varchar(25) | 25 | NULL allowed | | UNUSED. works.dbo.patient_iorg.organizationmrn is used instead. |
 | SSN | varchar(11) | 11 | NULL allowed | | UNUSED. works.dbo.person.ssn is used instead. |
(2) | LastName | varchar(35) | 35 | NULL allowed | | UNUSED. works.dbo.person.lastname is used instead. |
 | FirstName | varchar(35) | 35 | NULL allowed | | UNUSED. works.dbo.person.firstname is used instead. |
| MI | varchar(35) | 35 | NULL allowed | | UNUSED. works.dbo.person.middlename is used instead. |
| Address1 | varchar(40) | 40 | NULL allowed | | UNUSED. works.dbo.person_address.AddressLine1 is used instead for the users HOME address. |
| Address2 | varchar(40) | 40 | NULL allowed | | UNUSED. works.dbo.person_address.AddressLine2 is used instead for the users HOME address. |
| City | varchar(20) | 20 | NULL allowed | | UNUSED. works.dbo.person_address.City is used instead for the users HOME address. |
| State | varchar(2) | 2 | NULL allowed | | UNUSED. works.dbo.person_address.State is used instead for the users HOME address. |
| Zip | varchar(10) | 10 | NULL allowed | | UNUSED. works.dbo.person_address.Zipcode is used instead for the users HOME address. |
| Phone | varchar(14) | 14 | NULL allowed | | UNUSED |
| DOB | datetime | 8 | NULL allowed | | UNUSED. works.dbo.person.dateofbirth is used instead. |
| BankerBox | varchar(25) | 25 | NULL allowed | | UNUSED |
| OriginalChartDate | smalldatetime | 4 | NULL allowed | | Date chart created |
 | Account | varchar(25) | 25 | NULL allowed | | UNUSED |
| FilterID | int | 4 | NOT NULL | ((0)) | UNUSED |
| Sex | varchar(1) | 1 | NULL allowed | | UNUSED. works.dbo.sex_de.entrymnemonic is used as sex instead. |
| Status | varchar(10) | 10 | NULL allowed | | UNUSED. works.dbo.patient_member.isinactiveflag is used instead. |
| InsPlanID | varchar(15) | 15 | NULL allowed | | UNUSED. works.dbo.Insurance_Class_de.ID is used instead for patients primary insurance. |
| InsPlanDesc | varchar(50) | 50 | NULL allowed | | UNUSED. works.dbo.Insurance_Class_de.Entryname is used instead for patients primary insurance. |
| GroupNumber | varchar(15) | 15 | NULL allowed | | UNUSED |
| CardHolderID | varchar(18) | 18 | NULL allowed | | UNUSED |
| CardHolderLastName | varchar(35) | 35 | NULL allowed | | UNUSED |
| CardHolderFirstName | varchar(35) | 35 | NULL allowed | | UNUSED |
| CardHolderMiddleName | varchar(35) | 35 | NULL allowed | | UNUSED |
| RelToCardHolder | varchar(15) | 15 | NULL allowed | | UNUSED |
| PersonCode | char(3) | 3 | NULL allowed | | UNUSED |
| LanguageCode | char(2) | 2 | NULL allowed | | UNUSED |
| LastChange | datetime | 8 | NULL allowed | | Last Edit Date |
| ChartGroup | int | 4 | NOT NULL | ((0)) | UNUSED |
| Alerts | text | max | NULL allowed | | Alert text for a patient. |
| Notes | text | max | NULL allowed | | UNUSED |
| Provider1 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider2 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider3 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider4 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider5 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider6 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider7 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider8 | int | 4 | NOT NULL | ((0)) | UNUSED |
| Provider9 | int | 4 | NOT NULL | ((0)) | UNUSED |
| ReferralInfo | text | max | NULL allowed | | UNUSED |
| User01 | varchar(50) | 50 | NULL allowed | | UNUSED |
| User02 | varchar(50) | 50 | NULL allowed | | UNUSED |
| User03 | varchar(50) | 50 | NULL allowed | | UNUSED |
| User04 | varchar(50) | 50 | NULL allowed | | UNUSED |
| User05 | varchar(50) | 50 | NULL allowed | | UNUSED |
| OrgNumber | varchar(25) | 25 | NOT NULL | ('') | UNUSED. works.dbo.patient_iorg.internalorganization is used instead. |
| CardHolderAddress1 | varchar(40) | 40 | NULL allowed | ('') | UNUSED |
| CardHolderAddress2 | varchar(40) | 40 | NULL allowed | ('') | UNUSED |
| CardHolderCity | varchar(20) | 20 | NOT NULL | ('') | UNUSED |
| CardHolderState | varchar(2) | 2 | NOT NULL | ('') | UNUSED |
| CardHolderZip | varchar(10) | 10 | NOT NULL | ('') | UNUSED |
| InsCompanyID | varchar(50) | 50 | NULL allowed | | UNUSED |
| InsPlanType | varchar(3) | 3 | NULL allowed | | UNUSED |
| InsPlanID2 | varchar(15) | 15 | NULL allowed | | UNUSED. works.dbo.Insurance_Class_de.ID is used instead for patients secondary insurance. |
| InsPlanDesc2 | varchar(50) | 50 | NULL allowed | | UNUSED. works.dbo.Insurance_Class_de.Entryname is used instead for patients secondary insurance. |
| GroupNumber2 | varchar(15) | 15 | NULL allowed | | UNUSED |
| CardHolderID2 | varchar(18) | 18 | NULL allowed | | UNUSED |
| CardHolderLastName2 | varchar(35) | 35 | NULL allowed | | UNUSED |
| CardHolderFirstName2 | varchar(35) | 35 | NULL allowed | | UNUSED |
| CardHolderMiddleName2 | varchar(35) | 35 | NULL allowed | | UNUSED |
| RelToCardHolder2 | varchar(15) | 15 | NULL allowed | | UNUSED |
| PersonCode2 | varchar(3) | 3 | NULL allowed | | UNUSED |
| LanguageCode2 | varchar(2) | 2 | NULL allowed | | UNUSED |
| CardHolderAddress12 | varchar(40) | 40 | NULL allowed | ('') | UNUSED |
| CardHolderAddress22 | varchar(40) | 40 | NULL allowed | ('') | UNUSED |
| CardHolderCity2 | varchar(20) | 20 | NOT NULL | ('') | UNUSED |
| CardHolderState2 | varchar(2) | 2 | NOT NULL | ('') | UNUSED |
| CardHolderZip2 | varchar(10) | 10 | NOT NULL | ('') | UNUSED |
| InsCompanyID2 | varchar(50) | 50 | NULL allowed | | UNUSED |
| InsPlanType2 | varchar(3) | 3 | NULL allowed | | UNUSED |
| Email | varchar(100) | 100 | NULL allowed | | UNUSED |
| AutoConfirmEmail | int | 4 | NOT NULL | ((0)) | UNUSED |