Tables [dbo].[Unfinished_Call]
Unfinished call information
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Unfinished_Call: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Unfinished_Call table
Indexes nix_Unfinished_Call_Deleted_UserID, xPatientID(2)Foreign Keys FK_Unfinished_Call_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.IID
CreateDTTMdatetime8NULL allowedRecord Created Date Time
Check Constraints CK_Unfinished_Call_PatientIsCaller_Yes_Or_No : ([PatientIsCaller]='N' OR [PatientIsCaller]='Y')PatientIsCaller[dbo].[BOOL]1NULL allowedY- Indicates Patient called. N - Indicates User / Provider Called patient
Callervarchar(255)255NULL allowedCaller Name
Indexes TWstat_Unfinished_Call_RelationshipDE_UserIDRelationshipDE[dbo].[dict_id]5NULL allowedRelation of the caller to patient. Link to Relationship_DE.ID
Phone1char(32)32NULL allowedPhone Number of caller
Indexes TWstat_Unfinished_Call_TelephoneTypeDE1_UserIDTelephoneTypeDE1[dbo].[dict_id]5NULL allowedTelephone Type. Link to Telephone_Type_DE.ID
Phone2char(32)32NULL allowedPhone Number of caller
Indexes TWstat_Unfinished_Call_TelephoneTypeDE2_UserIDTelephoneTypeDE2[dbo].[dict_id]5NULL allowedTelephone Type. Link to Telephone_Type_DE.ID
RouteToUser[dbo].[uniqueid]9NULL allowedUser ID of the user if Route to User option is selected as User. Else 0. Link to IDX_User.ID
RouteToTeamDE[dbo].[uniqueid]9NULL allowedTeam. Link to Team_DE.ID if Route to User option is selected as Team
Indexes TWstat_Unfinished_Call_ReasonForCallDE_UserIDReasonForCallDE[dbo].[dict_id]5NULL allowedReason for Calling. Link to Reason_For_Call_DE.ID
Cluster Key xUserID: UserIDIndexes nix_Unfinished_Call_Deleted_UserID, TWstat_Unfinished_Call_ReasonForCallDE_UserID, TWstat_Unfinished_Call_RelationshipDE_UserID, TWstat_Unfinished_Call_TelephoneTypeDE1_UserID, TWstat_Unfinished_Call_TelephoneTypeDE2_UserID(5)UserID[dbo].[uniqueid]9NOT NULLProvider / User ID
Indexes nix_Unfinished_Call_Deleted_UserIDDeletedbit1NULL allowedIs Deleted
MessageTextvarchar(max)maxNULL allowedComments