Tables [dbo].[DOC_FLAGS]
Flagged Documents
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
RecIDint4NOT NULL1 - 1Key to the DOC_FLAGS table
Indexes IX_DOC_FLAGS_DOCUMENTIDDocumentIDint4NOT NULLPoints to Doc_Header.DocumentID for image flagged
TableNumberint4NOT NULL-2 if flag is not concerning a document, -1 if flag is for image in a batch, 0 if flag is for image on a patients chart, >=1 for batch in a file cabinet. The ID will be the file cabinet number.
UserCodeint4NOT NULLUsercode of user who flagged it. Sec_Users.usercode
CreateDatedatetime8NULL allowedDate document was flagged.
Flaggedint4NOT NULL((1))1 = Flag shows, 0 = Flag does not show