Tables [dbo].[Patient_Contact]
Patient's Contact demographic data (Emergency, Guarantor)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_PATIENT_CONTACT: PatientID\ContactTypeIndexes TWstat_Patient_Contact_ContactType_PatientID, TWstat_Patient_Contact_FirstName_PatientID_ContactType, TWstat_Patient_Contact_HomePhoneLast4_PatientID_ContactType, TWstat_Patient_Contact_LastName_PatientID_ContactType, TWstat_Patient_Contact_RelationshipDE_PatientID_ContactType, TWstat_Patient_Contact_WorkPhoneExchange_PatientID_ContactType(6)Foreign Keys FK_Patient_Contact_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes TWstat_Patient_Contact_RelationshipDE_PatientID_ContactTypeForeign Keys FK_Patient_Contact_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDERelationshipDE[dbo].[dict_id]5NOT NULLThe relationship to the Patient - FK to the Relationship_DE.ID
Indexes TWstat_Patient_Contact_LastName_PatientID_ContactTypeLastNamevarchar(35)35NOT NULLThe last name of the Contact
Indexes TWstat_Patient_Contact_FirstName_PatientID_ContactTypeFirstNamevarchar(35)35NOT NULLThe First name of the Contact
HomePhoneAreasmallint2NULL allowedThe Home telephone Area Code
HomePhoneExchangesmallint2NULL allowedThe Home telephone 3 digit exchange
Indexes TWstat_Patient_Contact_HomePhoneLast4_PatientID_ContactTypeHomePhoneLast4smallint2NULL allowedThe Home telephone last 4 digits
HomePhoneInternational[dbo].[int_phone]21NULL allowedInternation Home telephone number if contact is international
WorkPhoneAreasmallint2NULL allowedThe Work telephone Area Code
Indexes TWstat_Patient_Contact_WorkPhoneExchange_PatientID_ContactTypeWorkPhoneExchangesmallint2NULL allowedThe Work telephone 3 digit exchange
WorkPhoneLast4smallint2NULL allowedThe Work telephone last 4 digits
WorkPhoneInternational[dbo].[int_phone]21NULL allowedInternation Work telephone number if contact is international
WorkPhoneExtension[dbo].[extension]5NULL allowedThe Work telephone Extension
AddressLine1varchar(255)255NULL allowedThe First address Line
AddressLine2varchar(255)255NULL allowedThe second address line
Cluster Primary Key PK_PATIENT_CONTACT: PatientID\ContactTypeIndexes TWstat_Patient_Contact_ContactType_PatientID, TWstat_Patient_Contact_FirstName_PatientID_ContactType, TWstat_Patient_Contact_HomePhoneLast4_PatientID_ContactType, TWstat_Patient_Contact_LastName_PatientID_ContactType, TWstat_Patient_Contact_RelationshipDE_PatientID_ContactType, TWstat_Patient_Contact_WorkPhoneExchange_PatientID_ContactType(6)ContactTypevarchar(1)1NOT NULLContact type of E = Emergency G = Guarantor). The ContactType and the PatientID make up the PK for the record
DateofBirthdatetime8NOT NULL('1/1/1900')Contact date of Birth
Indexes TWstat_Patient_Contact_SexDEForeign Keys FK_Patient_Contact_Sex_DE: [dbo].[Sex_DE].SexDESexDE[dbo].[dict_id]5NOT NULL(0)Contact Gender - FK Sex_DE.ID
SSNvarchar(11)11NOT NULL('')Contact Social Security Number
Cityvarchar(35)35NOT NULL('')Contact City
Statevarchar(15)15NOT NULL('')Contact State
Zipvarchar(10)10NOT NULL('')Contact Zipcode
HomePhoneExtension[dbo].[extension]5NULL allowedThe Home telephone number extension