Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | Key to the Unfinished_Call table |
(2)![Foreign Keys FK_Unfinished_Call_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Unfinished_Call_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.IID |
| CreateDTTM | datetime | 8 | NULL allowed | | Record Created Date Time |
![Check Constraints CK_Unfinished_Call_PatientIsCaller_Yes_Or_No : ([PatientIsCaller]='N' OR [PatientIsCaller]='Y') Check Constraints CK_Unfinished_Call_PatientIsCaller_Yes_Or_No : ([PatientIsCaller]='N' OR [PatientIsCaller]='Y')](../../../../Images/c-constraint.png) | PatientIsCaller | [dbo].[BOOL] | 1 | NULL allowed | | Y- Indicates Patient called. N - Indicates User / Provider Called patient |
| Caller | varchar(255) | 255 | NULL allowed | | Caller Name |
 | RelationshipDE | [dbo].[dict_id] | 5 | NULL allowed | | Relation of the caller to patient. Link to Relationship_DE.ID |
| Phone1 | char(32) | 32 | NULL allowed | | Phone Number of caller |
 | TelephoneTypeDE1 | [dbo].[dict_id] | 5 | NULL allowed | | Telephone Type. Link to Telephone_Type_DE.ID |
| Phone2 | char(32) | 32 | NULL allowed | | Phone Number of caller |
 | TelephoneTypeDE2 | [dbo].[dict_id] | 5 | NULL allowed | | Telephone Type. Link to Telephone_Type_DE.ID |
| RouteToUser | [dbo].[uniqueid] | 9 | NULL allowed | | User ID of the user if Route to User option is selected as User. Else 0. Link to IDX_User.ID |
| RouteToTeamDE | [dbo].[uniqueid] | 9 | NULL allowed | | Team. Link to Team_DE.ID if Route to User option is selected as Team |
 | ReasonForCallDE | [dbo].[dict_id] | 5 | NULL allowed | | Reason for Calling. Link to Reason_For_Call_DE.ID |
 (5) | UserID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider / User ID |
 | Deleted | bit | 1 | NULL allowed | | Is Deleted |
| MessageText | varchar(max) | max | NULL allowed | | Comments |