VW_PCC_PatientContacts

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SynthMatchID bigint 8 √ null
source_system varchar 20 null
RelationshipDesc varchar 254 √ null
Gender char 1 √ null
Title varchar 15 √ null
FirstName varchar 50 null
LastName varchar 50 null
Address1 varchar 35 √ null
Address2 varchar 35 √ null
Address3 varchar 35 √ null
HomePhone varchar 35 √ null
CellPhone varchar 35 √ null
OfficePhone varchar 35 √ null
OfficeExtension varchar 5 √ null
OtherPhone varchar 35 √ null
PagePhone varchar 35 √ null
Fax varchar 35 √ null
City varchar 50 √ null
State varchar 3 √ null
ZipCode varchar 15 √ null
country varchar 254 √ null
Email varchar 75 √ null

View Definition

Possibly Referenced Tables/Views