Table: Phone
Telephone Information for Patient and Patient Insurance Subscribers
| Name | Type | Description | Remarks |
|---|---|---|---|
| IsPrimary |
bit |
Indicator for whether this is the Primary Phone Number |
|
| PhoneExtension |
varchar(50) |
Phone Number Extension. |
|
| PhoneNumber |
varchar(50) |
Phone Number |
Phone numbers are stored as digits only (No punctuation) |
| PhoneTypeID |
int |
ID of Phone Type entry for the phone number. See GenLookup |
PhoneTypeID is a foreign key reference to the CatElementLU table of type 7 |
|
CallTimeID |
int |
ID of When To Call entry for the phone number. See GenLookup |
CallTimeID is a foreign key reference to the CatElementLU table of type 7 |