Tables [dbo].[Service_Package_Comment_Acknowledgements]
Occupational Medicine Service Package Note Acknowledgements
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Service_Package_Comment_Acknowlegements: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Service_Package_Comment_Acknowlegements table
Cluster Key CIX_Service_Package_Comment_Acknowledgements_EncounterID: EncounterIDForeign Keys FK_Service_Package_Comment_Acknowlegements_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEnconter. Links to Encounter.ID
Foreign Keys FK_Service_Package_Comment_Acknowlegements_UserID: [dbo].[IDX_User].UserIDUserID[dbo].[uniqueid]9NOT NULLUser. Links to IDX_User.ID
FormLaunchdatetime8NOT NULLEncounter Summary dialog launch datetime
ClinicalNotesAcknowledgeddatetime8NOT NULL('01/01/1900')Clinician Notes marked as acknowledged datetime
NonClinicalNotesAcknowledgeddatetime8NOT NULL('01/01/1900')Non-Clinician Notes marked as acknowledged datetime