Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
| RecID | int | 4 | NOT NULL | 1 - 1 | | Key to the DOC_FLAGS table |
 | DocumentID | int | 4 | NOT NULL | | | Points to Doc_Header.DocumentID for image flagged |
| TableNumber | int | 4 | NOT 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. |
| UserCode | int | 4 | NOT NULL | | | Usercode of user who flagged it. Sec_Users.usercode |
| CreateDate | datetime | 8 | NULL allowed | | | Date document was flagged. |
| Flagged | int | 4 | NOT NULL | | ((1)) | 1 = Flag shows, 0 = Flag does not show |