| Id |
Primary key the unique identification of a row in the table. |
| IdCreator |
Foreign key to the table: User Identifies the user that created the row. |
| CreatedDate |
Date of today when the document was registered in the database. |
| IdDocumentType |
Foreign key to the table: DocumentType |
| IdDocumentState |
Foreign key to the table: DocumentState |
| Title |
A short text describing the subject of the document. The text is presented to the user to identify the document in the application interface. |
| Summary |
A long text giving a summary the contents of the document. |
| IdPublicAccess |
Foreign key to the table: PublicAccess |
| IdCase |
Foreign key to the table: Case |
| LogicIdentifier |
Contains a logical identifier of the document. This is the identifier presented to the user in the application interface. Often the id of the document is used but it could also be a string combined from several other fields. |
| CopyDate |
Date for copying the document to a person/institution. |
| CopyDescription |
Stores the Name of a person or an institution who received a copy. |
| IdCaseWorker |
Foreign key to the table: User |
| IdOrganisation |
Foreign key to the table: Organisation |
| InComingDate |
Date of today when the document was received. |
| ReminderDate |
Date for reminding the caseworker linked to the document. |
| IdCheckCode01 |
Foreign key to the table: Code Code that have the purpose of restricting the users access to only some cases and documents. The foreign key column references check codes. Only one instance of each check code type can be related to a document or case. |
| IdCheckCode02 |
Foreign key to the table: Code Code that have the purpose of restricting the users access to only some cases and documents. The foreign key column references check codes. Only one instance of each check code type can be related to a document or case. |
| IdPrimaryCode |
Foreign key to the table: Code Every case and document must be related to exactly one primary code (an instance of the primary code type), and only one code type can be the primary code type. The primary code on cases and documents are used to categorize them uniquely (as in the "save as" menu in the office client). |
| CaseSerialNumber |
Serial number assigned to documents within the case. |
| OnLoanDate |
Date for lending the document to a person. |
| OnLoanTo |
Name of a person who has lend the case. |
| IsDeleted |
Indication of whether the row is logically deleted |
| IdDeletedRow |
Foreign key to the table: Deletedrow Reference to further information for the logically deleted row |
| DemandReply |
If true an answer to the letter has to be send out. |
| DemandReceipt |
If true the letter demands a receipt to be send out at receipt. |
| IdPublishingType |
Foreign key to the table: PublishingType |
| ReceiptDeadline |
Deadline for the receipt document to be send out. |
| ReplyDeadline |
Deadline for the answering document to be send out. |
| IdDocumentCategory |
Foreign key to the table: DocumentCategory |
| ReScan |
When true, the document has to be rescanned. |
| StorageFormat |
A code definning the storage format of the document |
| NeutralTitle |
A neutral title for the document that is used when the document is published |
| CanBePublished |
Indicates if the document can be published |
| PublishedDate |
The date the document was published |
| IdPublishedBy |
Foreign key to the table: User Reference to User table for the user who published the document |
| IsAutomaticPublished |
This field tells if the document is automatically published |
| LogicIdentifiersuffix |
Last part of the LogicIdentifier |
| LogicIdentifierPrefix |
Fist part of the LogicIdentifier |