Søgning » ESDH-system (eDoc) » DOCUMENT

ESDH-system (eDoc)

Tabeloversigt ?
CONTINFO
DOCUMENT
"CASE"
COMMITTE
BUSINESS
ESTAINFO
PERSON
ADDRESS
AGENITEM
CODE
ORGANISA
WORKACTI
MEAGETYP
BUILCASE
DOCUVERS
"USER"
COSUBIND
MEETING
PERSCASE
REGISTER
WODEFACT
CASETYPE
CASEWOR
PUBLTYPE
WORKDEFI
BUILAUTH
BUILCERT
COMMMEMB
EXTESYST
HISTCASE
HISTDOCU
AGENTYPE
BUILINSP
CASEWORK
CODETYPE
COAGETYP
DECIPHRA
DISCCODE
ESTATE
HEEXTPAR
PERELTYP
AGITEVOT
BUSITYPE
COMEMROL
CORPTYPE
DOCUTYPE
EXTEROW
HEARING
HEARPART
POLIPART
POSTCODE
USERORGA
WORKFLOW
WODEFROL
WODEFTRA
WORKROLE
WORKTRAN
AGITETYP
AUTHORIT
BUCERTYP
BUINSTYP
BUSIADDR
BUSIPERS
CADOCSHO
CADOSHTY
CASEESTA
CAEXTSYS
CAPARCON
CASESHOR
CASHOTYP
CASESTAT
CIVISTAT
COMEROCA
CORRCONT
DOCUCATE
DOCUSHOR
DOSHOTYP
MATAITTY
PARTTYPE
PERSADDR
PECAREPE
PERSRELA
PUBLACCE
ADDRGROU
ADGROMEM
BUSIGROU
BUGROMEM
BUPERTYP
CASECODE
CASEPART
CASESTA
COCOSUIN
COMEMABS
COMEMPRE
DEPHRCOM
DELEROW
DOCUCODE
ESTAOWNE
HEARSTAT
PERSGROU
PEGROMEM
WORKFOLD
Kodetabel_ADDRESS_IsForeignAddress
Kodetabel_ADDRESS_IsDeleted
Kodetabel_AGENITEM_IsDirty
Kodetabel_AGENITEM_AllowRemoveFromMinute
Kodetabel_AGITETYP_IsDeleted
Kodetabel_AGENTYPE_IsPublishable
Kodetabel_AGENTYPE_IsDeleted
Kodetabel_AUTHORIT_IsDeleted
Kodetabel_BUCERTYP_IsDeleted
Kodetabel_BUINSTYP_IsDeleted
Kodetabel_BUSINESS_IsLegalUnit
Kodetabel_BUSINESS_IsDeleted
Kodetabel_BUSIADDR_IsPrimary
Kodetabel_BUSITYPE_IsDeleted
Kodetabel_CASE_IsPrinciple
Kodetabel_CASE_IsDeleted
Kodetabel_CADOSHTY_IsDeleted
CAPACOTY
Kodetabel_CASHOTYP_IsDeleted
Kodetabel_CASESTAT_IsDeleted
Kodetabel_CASETYPE_IsDeleted
Kodetabel_CASETYPE_ShowParticipantCivilCode
Kodetabel_CASETYPE_CopyPersonalCaseRelations
Kodetabel_CASEWORK_IsPrimary
Kodetabel_CASEWORK_OverWriteValue
Kodetabel_CASEWOR_OverWriteValue
Kodetabel_CASEWOR_IsDeleted
Kodetabel_CIVISTAT_IsDeleted
Kodetabel_CODE_IsUsable
Kodetabel_CODE_IsDeleted
Kodetabel_CODE_IsExternal
Kodetabel_COSUBIND_IsDeleted
Kodetabel_COSUBIND_IsExternal
Kodetabel_CODETYPE_IsSecurity
Kodetabel_CODETYPE_IsPrimary
Kodetabel_CODETYPE_IsHierarchy
Kodetabel_COMMITTE_IsDeleted
Kodetabel_COMMITTE_Notify
Kodetabel_COMMITTE_NotifyOnlyMembersAboutClosedAgenda
Kodetabel_COAGETYP_Default
Kodetabel_COMMMEMB_IsDeleted
Kodetabel_COMEMROL_IsDeleted
Kodetabel_COMEROCA_IsDeleted
Kodetabel_CONTINFO_IsStatic
Kodetabel_CONTINFO_IsAddressProtected
Kodetabel_CONTINFO_IsLegalUnit
Kodetabel_CORPTYPE_IsDeleted
COCONTYP
Kodetabel_DECIPHRA_IsDeleted
Kodetabel_DISCCODE_IsDeleted
Kodetabel_DOCUMENT_IsDeleted
Kodetabel_DOCUMENT_DemandReply
Kodetabel_DOCUMENT_DemandReceipt
Kodetabel_DOCUMENT_ReScan
Kodetabel_DOCUMENT_StorageFormat
Kodetabel_DOCUMENT_CanBePublished
Kodetabel_DOCUMENT_IsAutomaticPublished
Kodetabel_DOCUCATE_IsDeleted
DOCUCORR
Kodetabel_DOSHOTYP_IsDeleted
DOCUSTAT
Kodetabel_DOCUTYPE_IsDeleted
Kodetabel_DOCUVERS_CurrentVersion
Kodetabel_DOCUVERS_IsDeleted
Kodetabel_ESTAINFO_IsStatic
Kodetabel_EXTEROW_IsAutoUpdated
Kodetabel_EXTESYST_Enabled
Kodetabel_EXTESYST_IsFESDCompatible
Kodetabel_HEARING_Ended
Kodetabel_HEARSTAT_TaskStatusId
Kodetabel_MEETING_IsLocked
Kodetabel_MEETING_IsBeingEdited
Kodetabel_MEETING_PublishAgenda
Kodetabel_MEETING_PublishMinute
Kodetabel_MEAGETYP_IsDirty
Kodetabel_MEAGETYP_IsAgendaPublished
Kodetabel_MEAGETYP_IsMinutePublished
MEETSTAT
Kodetabel_ORGANISA_IsDeleted
Kodetabel_PARTTYPE_IsDeleted
Kodetabel_PERSON_IsAddressProtected
Kodetabel_PERSON_IsDeleted
Kodetabel_PERSADDR_IsPrimary
Kodetabel_PERELTYP_IsDeleted
Kodetabel_POLIPART_IsDeleted
Kodetabel_POSTCODE_IsDeleted
Kodetabel_PUBLACCE_IsDeleted
Kodetabel_PUBLTYPE_IsDeleted
Kodetabel_PUBLTYPE_IncludeDocumentContent
Kodetabel_PUBLTYPE_IncludeAppendix
Kodetabel_PUBLTYPE_IncludeCaseDocuments
Kodetabel_REGISTER_Async
Kodetabel_REGISTER_UseSecurity
Kodetabel_REGISTER_UseSharedLogin
Kodetabel_REGISTER_IsInternal
Kodetabel_USER_IsDeleted
Kodetabel_USERORGA_IsPrimary
VOTETYPE
Kodetabel_WORKACTI_HasLinkToCase
WOACTCAT
Kodetabel_WORKDEFI_IsDeleted
Kodetabel_WORKDEFI_IsBeingEdited
Kodetabel_WODEFACT_HasLinkToCase
DOCUVERS_342_UDDRAG
Tabel

DOCUMENT


Beskrivelse ?

Contains metadata about documents registered in eDoc.

Størrelse (Antal rækker) ?

61467

Indhold (Kolonner/variable) ?

Navn Indhold
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