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

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

ESTAINFO


Beskrivelse ?

Estateinformation is the equivalent of the ContactInformation table but for estates. The table contains registration of which address information actually has been related to cases.

Størrelse (Antal rækker) ?

810

Indhold (Kolonner/variable) ?

Navn Indhold
Id Primary key the unique identification of a row in the table.
IsStatic Indicates whether or not the address information should be updated or not. The value is set to 1 (no updating) if the address information is attached to a document that is final or a case that is closed.
IdExternalRow Foreign key to the table: ExternalRow Points to further information about the register and identification of the row in the external register. Each row in the table has a link to a row in the ExternalRow table. As the address information in these tables is copied from registers it's necessary to keep this information updated in the event of changes made to the original information in the registers it derives from. The ExternalRow table makes this possible as it holds the information required to retrieve the current data from the registers. The actual search criteria are contained in a RowIdentifier (represented as a string). Only the search component that belongs to the register that the row derives from, has knowledge about the content of the RowIdentifier and how to parse it.
TitleCode Unique identification number of the area (matrikelnummer+matrikelbogstav). Copied from the TitleCode field in table Estate from the eDoc register or a field in an external register.
EstateCode Unique identification number of the estate (ejendomsnummer). Copied from the EstateCode field in table Estate from the eDoc register or a field in an external register.
MunicipalityCode Unique identification number of the municipality that the estate belongs to (kommunenummer). Copied from the MunicipalityCode field in table Estate from the eDoc register or a field in an external register.
OwnerAssociation Municipal owner association attached to the estate (kommuneejerlav). Copied from the MunicipalOwnerAssociation field in table OwnerAssociation from the eDoc register or a field in an external register.
RoadCode Unique identification number of the road associated with the location of the estate (vejkode). Copied from the RoadCode field in table Estate from the eDoc register or a field in an external register.
Location Location of the address (fuld adresse ekskl. postnummer, postdistrikt og land). Copied from the Location field in table Address from the eDoc register or a field in an external register.
PostalCode PostalCode of the address. Copied from the PostalCode field in table Address from the eDoc register or a field in an external register.
PostalDistrict PostalDistrict of the address. Copied from the PostalDistrict field in table Address from the eDoc register or a field in an external register.
Country The field contains the name of the country that the address is situated in. The information is copied from eDoc address-register or an external register see definition for table REGISTER. The field can contain data from conversion from Doc2000. This reference identifies the belonging estates to the conversion of data.
AddressComment Comments can be attached to the address in this field. Copied from the Comment field in table Address from the eDoc register or a field in an external register.
StreetName StreetName of the address. Copied from the StreetName field in table Address from the eDoc register or a field in an external register.
StreetBuildingIdentifier StreetBuildingIdentifier of the address. Copied from the StreetBuildingIdentifier field in table Address from the eDoc register or a field in an external register.
FloorIdentifier FloorIdentifier of the address. Copied from the FloorIdentifier field in table Address from the eDoc register or a field in an external register.
SuiteIdentifier SuiteIdentifier of the address. Copied from the SuiteIdentifier field in table Address from the eDoc register or a field in an external register.
CountryOwnerAssociation Country owner association attached to the estate (landsejerlav). Copied from the Name field in table OwnerAssociation from the eDoc register or a field in an external register.
CountryOwnerAssociationCode Country owner association code attached to the estate (landsejerlavskode). Copied from the CountryOwnerAssociationCode field in table OwnerAssociation from the eDoc register or a field in an external register.
OwnerAssociationCode Municipal owner association code attached to the estate (kommuneejerlavskode). Copied from the MunicipalOwnerAssociationCode field in table OwnerAssociation from the eDoc register or a field in an external register.