Tables [dbo].[PATIENTS_EDIT]
Patient Demographics
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_PATIENTS: PatientIDIndexes IX_PATIENTS_EDITPatientIDint4NOT NULLKey to the Patients_Edit table. Will match works.dbo.person
PhotoIDFileNamevarchar(50)50NULL allowedPatient profile picture. This is the filename of the photo.
PhotoIDPathvarchar(50)50NULL allowedThis is the path to the profile picture.
CheckedOuttinyint1NOT NULL((0))UNUSED
ChartIDvarchar(25)25NULL allowedUNUSED. works.dbo.patient_iorg.organizationmrn is used instead.
Indexes IX_PATIENTS_SSNSSNvarchar(11)11NULL allowedUNUSED. works.dbo.person.ssn is used instead.
Indexes IX_PATIENTS_EDIT_LASTNAME, IX_PATIENTS_LASTNAME(2)LastNamevarchar(35)35NULL allowedUNUSED. works.dbo.person.lastname is used instead.
Indexes IX_PATIENTS_FIRSTNAMEFirstNamevarchar(35)35NULL allowedUNUSED. works.dbo.person.firstname is used instead.
MIvarchar(35)35NULL allowedUNUSED. works.dbo.person.middlename is used instead.
Address1varchar(40)40NULL allowedUNUSED. works.dbo.person_address.AddressLine1 is used instead for the users HOME address.
Address2varchar(40)40NULL allowedUNUSED. works.dbo.person_address.AddressLine2 is used instead for the users HOME address.
Cityvarchar(20)20NULL allowedUNUSED. works.dbo.person_address.City is used instead for the users HOME address.
Statevarchar(2)2NULL allowedUNUSED. works.dbo.person_address.State is used instead for the users HOME address.
Zipvarchar(10)10NULL allowedUNUSED. works.dbo.person_address.Zipcode is used instead for the users HOME address.
Phonevarchar(14)14NULL allowedUNUSED
DOBdatetime8NULL allowedUNUSED. works.dbo.person.dateofbirth is used instead.
BankerBoxvarchar(25)25NULL allowedUNUSED
OriginalChartDatesmalldatetime4NULL allowedDate chart created
Indexes IX_PATIENTS_ACCOUNTAccountvarchar(25)25NULL allowedUNUSED
FilterIDint4NOT NULL((0))UNUSED
Sexvarchar(1)1NULL allowedUNUSED. works.dbo.sex_de.entrymnemonic is used as sex instead.
Statusvarchar(10)10NULL allowedUNUSED. works.dbo.patient_member.isinactiveflag is used instead.
InsPlanIDvarchar(15)15NULL allowedUNUSED. works.dbo.Insurance_Class_de.ID is used instead for patients primary insurance.
InsPlanDescvarchar(50)50NULL allowedUNUSED. works.dbo.Insurance_Class_de.Entryname is used instead for patients primary insurance.
GroupNumbervarchar(15)15NULL allowedUNUSED
CardHolderIDvarchar(18)18NULL allowedUNUSED
CardHolderLastNamevarchar(35)35NULL allowedUNUSED
CardHolderFirstNamevarchar(35)35NULL allowedUNUSED
CardHolderMiddleNamevarchar(35)35NULL allowedUNUSED
RelToCardHoldervarchar(15)15NULL allowedUNUSED
PersonCodechar(3)3NULL allowedUNUSED
LanguageCodechar(2)2NULL allowedUNUSED
LastChangedatetime8NULL allowedLast Edit Date
ChartGroupint4NOT NULL((0))UNUSED
AlertstextmaxNULL allowedAlert text for a patient.
NotestextmaxNULL allowedUNUSED
Provider1int4NOT NULL((0))UNUSED
Provider2int4NOT NULL((0))UNUSED
Provider3int4NOT NULL((0))UNUSED
Provider4int4NOT NULL((0))UNUSED
Provider5int4NOT NULL((0))UNUSED
Provider6int4NOT NULL((0))UNUSED
Provider7int4NOT NULL((0))UNUSED
Provider8int4NOT NULL((0))UNUSED
Provider9int4NOT NULL((0))UNUSED
ReferralInfotextmaxNULL allowedUNUSED
User01varchar(50)50NULL allowedUNUSED
User02varchar(50)50NULL allowedUNUSED
User03varchar(50)50NULL allowedUNUSED
User04varchar(50)50NULL allowedUNUSED
User05varchar(50)50NULL allowedUNUSED
OrgNumbervarchar(25)25NOT NULL('')UNUSED. works.dbo.patient_iorg.internalorganization is used instead.
CardHolderAddress1varchar(40)40NULL allowed('')UNUSED
CardHolderAddress2varchar(40)40NULL allowed('')UNUSED
CardHolderCityvarchar(20)20NOT NULL('')UNUSED
CardHolderStatevarchar(2)2NOT NULL('')UNUSED
CardHolderZipvarchar(10)10NOT NULL('')UNUSED
InsCompanyIDvarchar(50)50NULL allowedUNUSED
InsPlanTypevarchar(3)3NULL allowedUNUSED
InsPlanID2varchar(15)15NULL allowedUNUSED. works.dbo.Insurance_Class_de.ID is used instead for patients secondary insurance.
InsPlanDesc2varchar(50)50NULL allowedUNUSED. works.dbo.Insurance_Class_de.Entryname is used instead for patients secondary insurance.
GroupNumber2varchar(15)15NULL allowedUNUSED
CardHolderID2varchar(18)18NULL allowedUNUSED
CardHolderLastName2varchar(35)35NULL allowedUNUSED
CardHolderFirstName2varchar(35)35NULL allowedUNUSED
CardHolderMiddleName2varchar(35)35NULL allowedUNUSED
RelToCardHolder2varchar(15)15NULL allowedUNUSED
PersonCode2varchar(3)3NULL allowedUNUSED
LanguageCode2varchar(2)2NULL allowedUNUSED
CardHolderAddress12varchar(40)40NULL allowed('')UNUSED
CardHolderAddress22varchar(40)40NULL allowed('')UNUSED
CardHolderCity2varchar(20)20NOT NULL('')UNUSED
CardHolderState2varchar(2)2NOT NULL('')UNUSED
CardHolderZip2varchar(10)10NOT NULL('')UNUSED
InsCompanyID2varchar(50)50NULL allowedUNUSED
InsPlanType2varchar(3)3NULL allowedUNUSED
Emailvarchar(100)100NULL allowedUNUSED
AutoConfirmEmailint4NOT NULL((0))UNUSED