Tables [dbo].[Service_Package_Comment]
Occupational Medicine Service Package Comments
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_Service_Package_Comment: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Service_Package_Comment table
Cluster Key CIX_Service_Package_Comment_EncounterServicePackageID: EncounterServicePackageIDForeign Keys FK_Service_Package_Comment_EncounterServicePackageID: [dbo].[Encounter_Service_Package].EncounterServicePackageIDEncounterServicePackageID[dbo].[uniqueid]9NOT NULLService Package. Link to Encounter_Service_Package.ID
CommentNumberExtvarchar(60)60NOT NULLExternal identifier for Comment Number
CommentCategorychar(1)1NOT NULL'C' for clinical; 'N' for non-clinical
Commentvarchar(max)maxNOT NULLActual comments