Tables [dbo].[Injury_Information]
Special Billing Details
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Injury_Information_ID: IDIndexes TWstat_Injury_Information_InjuryTypeDE_ID, TWstat_Injury_Information_PlaceofInjuryDE_ID(2)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Injury_Information table
Indexes NIX_Injury_Information_EncounterID_INC_PlaceofInjuryDE_Comment, TWstat_Injury_Information_PlaceofInjuryDE_ID(2)Foreign Keys FK_Injury_Information_PlaceofInjuryDE_Place_of_Injury_DE_ID: [dbo].[Place_of_Injury_DE].PlaceofInjuryDEPlaceofInjuryDE[dbo].[dict_id]5NOT NULLLocation of injury - links to Place_of_injury_DE.ID
Indexes TWstat_Injury_Information_InjuryTypeDE_IDForeign Keys FK_Injury_Information_InjuryTypeDE_Injury_Type_DE_ID: [dbo].[Injury_Type_DE].InjuryTypeDEInjuryTypeDE[dbo].[dict_id]5NOT NULLSpecial Billing (Workers Comp, Auto, etc) - links to Injury_Type_DE.ID
Indexes TWstat_Injury_Information_InjuryDTInjuryDTdatetime8NOT NULLDate of Injury
Indexes NIX_Injury_Information_EncounterID_INC_PlaceofInjuryDE_Comment, TWstat_Injury_Information_Comment(2)Comment[dbo].[message]255NOT NULLGeneral comment field
Indexes NIX_Injury_Information_EncounterID_INC_PlaceofInjuryDE_CommentForeign Keys FK_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULL(0)EncounterID linked to this injury - links to Encounter.ID
AccountDescriptionvarchar(255)255NULL allowedGeneral description of account tied to this injury (Comp, Auto Claim, etc)
AccountNumbervarchar(20)20NULL allowedAccount number tied to this injury