Søgning » Det Fælles Datagrundlag » tblEOReconciliationStatementHeader

Det Fælles Datagrundlag

Tabeloversigt ?
tblJobReferralNotification
ActivityCoreItemHistory
tblCourseEnrollmentUnemploymentFundEventItem
tblActivityUnemploymentFundEventItem
ActivityCoreItem
tblBookingHistory
tblBooking
tblPersonStatusAbsenceHistory
EntryHistory
tblPersonStatusAbsence
tblEOReconciliationStatementHeader
Entry
MyPlanVersion
MyPlanVersionHistory
CitizenMessageHistory
UdbEvent
tblCompulsoryNotificationEvent
EducationHistory
tblEORunHistory
tblPersonStatusEnrollment
CitizenMessage
tblAvailabilityAssessment
tblEOPartialAgreementHistory
tblUnemploymentFundMembershipArchive
tblCVStatusUnemploymentFundEvent
tblLabourMarketBalance
tblUnemploymentFundMembershipChangeLog
CoreEntryHistory
ActivityCourseItemHistory
Education
PlanVersionHistory
tblPersonStatusInterviewHistory
tblPersonStatusInterviewParticipantHistory
ActivityCompanyItemHistory
PlanVersion
tblEOInvoicingStatementHeader
tblRecalledAvailabilityAssesment
tblRecalledCompulsoryNotificationEvent
tblRecalledJobReferralNotification
JobSearchEntryHistory
tblEORun
tblPersonStatusContact
tblPersonStatusContactGroup
tblPersonStatusHealthLimitation
tblPersonStatusHealthLimitationHistory
tblPersonStatusInterview
tblPersonStatusMeetingParticipationHistory
CoreEntry
EducationPlan
tblCprCore
tblEOPartialAgreement
tblPersonStatusMeetingParticipation
JobSearchEntry
ActivityPersonalAssistanceItemHistory
EducationPlanHistory
tblLocationDetail
tblPersonStatusGroupProject
tblUnemploymentBenefitRightsHistory
DocumentHistory
ActivityCourseItem
tblAuthorityUnemploymentFundBranches
tblAuthorityUnemploymentFundBranchesHistory
tblPersonStatusAbsenceAdditionalInformationHistory
tblPersonStatusUnemploymentFundParticipationHistory
tblUnemploymentBenefitRights
TaskHistory
ActivityCompanyItem
GoalHistory
tblParticipantHistory
tblJobCenterDetail
tblPersonJobcenterHistory
tblPersonStatusAbsenceAdditionalInformation
tblPersonStatusEnrollmentAckDates
tblPersonStatusEnrollmentWarningDates
tblPersonStatusInterviewParticipant
tblPersonStatusUnemploymentFundParticipation
tblResponsibleAuthority
tblUnemploymentFundMembership
tblUnemploymentFundMembershipFutureChanges
CitizenMessageReplyHistory
CitizenMessageUser
ActivityHelpingDeviceItemHistory
CaseWorker
UdbSubscriptionHistory
tblAppendix
tblPersonStatusCategory
tblPersonStatusProfessionCollection
tblPersonStatusProfessionCollectionHistory
Document
PlanObjectiveHistory
UdbSubscription
SA_kode_Company
tblJobCenterAddressInformation
tblOccupationName
tblUnemploymentFundDetails
GuidanceTextRule
ActivityPersonalAssistanceItem
Goal
tblParticipant
tblOccupation
tblUnemploymentRegistrationHistory
GeographicalAreaForJobSearch
JobSearchDefinition
CitizenMessageReply
DocumentMetadata
SearchIndexCore
Task
TradeForJobSearch
MyPlanUser
EducationPlanPdf
PlanObjective
tblAuthorityJobcenters
tblAuthorityUnemploymentFunds
tblEOEffectType
tblOccupationGroup
tblOccupationSynonym
tblPersonStatusSocialAid
tblPersonStatusSustenanceHistory
EntryChangeLog
OtherEntryHistory
SearchIndexDay
ActivityHelpingDeviceItem
UdbSubscriptionQueue
tblJobcenterAuthor
tblOccupationArea
tblPersonAbsenceIllnessLetter
tblPersonAbsenceIllnessLetterHistory
tblSocialAidReferral
SearchIndexDayJoblog
CitizenMessageTag
GuidanceText
PlanVersionEvent
tblContactDetail
tblAuthorityDirectMunicipalityJobcenterRelation
tblAuthorityMunicipalities
tblAuthorityRegions
tblAuthorityUnemploymentFundRelation
tblCodeListNUPH
tblDiscoCodes
tblDUNAMUCodes
tblJobCenterOpeningHours
tblJobCenterPhoneHours
tblPersonStatusSustenanceHistoryClassification
JobSearchStatus
OtherEntry
SearchIndexBuildLog
Municipality
PdfRecipient
tblExternalBookingSystemEndpointName
EmploymentAreaMunicipality
SA_kode_Education
SA_kode_Myndighed
tblAuthorityJobcenterMunicipalityRelation
tblCountry
tblDiscoConvert
tblUnemploymentFundTransitionEventMapping
EntryWsrm
CitizenMessageMark
CitizenMessageReplyMark
MyPlanVersionEvent
ActivityUpdatedByRevision
tblJobcenterExternalBookingSystem
SA_kode_AbsenceTypeIdentifier
SA_kode_ActivationTypeIdentifier
SA_kode_ActivityStatusCauseTypeIdentifier
SA_kode_ActivityStatusTypeIdentifier
SA_kode_AdditionalInformationOnAbsenceTypeIdentifier
SA_kode_AvailabilityAssessmentRegistrationTypeIdentifier
SA_kode_CancellationCauseTypeIdentifier
SA_kode_CauseTypeIdentifier
SA_kode_CitizenMessageChannelTypeIdentifier
SA_kode_CitizenMessageContextTypeIdentifier
SA_kode_CitizenMessageResponseTypeIdentifier
SA_kode_ClientCategoryTypeIdentifier
SA_kode_CompulsoryNotificationEventTypeIdentifier
SA_kode_ContactGroupTypeIdentifier
SA_kode_CountryTypeIdentifier
SA_kode_CourseAllocationTypeIdentifier
SA_kode_CourseTypeIdentifier
SA_kode_CurrentUnemploymentStatusTypeIdentifier
SA_kode_CvStatusTypeIdentifier
SA_kode_DiscoAms08
SA_kode_DocumentExtensionTypeIdentifier
SA_kode_DocumentSchemaTypeIdentifier
SA_kode_EducationEventStatusCodeTypeIdentifier
SA_kode_EducationLevel
SA_kode_EducationPlanStepIdentifier
SA_kode_EducationSourceCodeTypeIdentifier
SA_kode_EducationStatusTypeIdentifier
SA_kode_EffectTypeIdentifier
SA_kode_EmploymentAreaTypeIdentifier
SA_kode_FlexJobEmploymentTypeIdentifier
SA_kode_GeographicalAreaTypeIdentifier
SA_kode_GoalCodeTypeIdentifier
SA_kode_HelpingDevice1TypeIdentifier
SA_kode_HelpingDeviceOwnershipDisposalTypeIdentifier
SA_kode_HelpingDeviceTypeIdentifier
SA_kode_InterviewContactTypeIdentifier
SA_kode_InterviewTypeIdentifier
SA_Kode_JaNej
SA_kode_JobAllocationTypeIdentifier
SA_kode_JobApplicationSourceTypeIdentifier
SA_kode_JoblogDocumentTypeIdentifier
SA_kode_JoblogEntryCategoryTypeIdentifier
SA_kode_JoblogEntryStatusTypeIdentifier
SA_kode_JoblogEntryTypeOfSubmissionTypeIdentifier
SA_kode_JoblogOtherEntryTypeIdentifier
SA_kode_JobOrderPriceHourTypeIdentifier
SA_kode_JobOrderTypeIdentifier
SA_kode_JobReferralNotificationEventTypeIdentifier
SA_kode_JobSeekingStatusTypeIdentifier
SA_kode_JobTypeIdentifier
SA_kode_LetterVariant
SA_kode_MartialStatusCode
SA_kode_MeetingParticipationChoiceTypeIdentifier
SA_kode_MinisterialDepartmentTypeIdentifier
SA_kode_Municipalities
SA_kode_MyPlanAutoGenerationCauseTypeIdentifier
SA_kode_MyPlanInvalidCauseTypeIdentifier
SA_kode_OrganisationTypeIdentifier
SA_kode_ParticipantTypeIdentifier
SA_kode_PersonalAssistanceIdentifier
SA_kode_PersonalAssistancePriceHourTypeIdentifier
SA_kode_PersonalAssistancePriceOtherTypeIdentifier
SA_kode_PersonalAssistanceTypeIdentifier
SA_kode_PersonCaseStatus
SA_kode_PersonCategoryTypeIdentifier
SA_kode_PersonCivilRegistrationStatusTypeIdentifier
SA_kode_PersonContactTypeIdentifier
SA_kode_PersonGenderCode
SA_kode_PersonGroupProjectTypeIdentifier
SA_kode_PersonOriginCode
SA_kode_PlanTypeIdentifier
SA_kode_PlanVersionEventTypeIdentifier
SA_kode_PlanVersionTypeIdentifier
SA_kode_RequestUserTypeIdentifier
SA_kode_StatusTypeIdentifier
SA_kode_SustenanceHistoryCategoryTypeIdentifier
SA_kode_SustenanceHistoryClassificationTypeIdentifier
SA_kode_SustenanceTypeIdentifier
SA_kode_TradeForJobSearchTypeIdentifier
SA_kode_UnemploymentBenefitRightsPeriodTypeIdentifier
SA_kode_UnemploymentFundMembershipCancellationCodeTypeIdentifier
SA_kode_UnemploymentInsuranceCategoryTypeIdentifier
SA_kode_WeeklyWorkTimeTypeIdentifier
SA_kode_WorkingHoursTypeIdentifier
tblUnemploymentRegistrationType
BusinessArea
DocumentType
CitizenMessageAttachment
CitizenMessageAttachmentMetadata
ActivityPlanVersionLink
ChangeType
PlanVersionGuidanceText
SA_kode_MessageImportantTypeIdentifier
SA_kode_PlanVersionAcknowledgedByTypeIdentifier
SA_kode_EducationEventCancellationCauseCodeTypeIdentifier
SA_kode_EducationSubscriptionCancellationCauseCodeTypeIdentifier
Tabel

tblEOReconciliationStatementHeader


Beskrivelse ?

Ekstern operatør afstemningsopgørelse

Størrelse (Antal rækker) ?

17015

Indhold (Kolonner/variable) ?

Navn Indhold
HashKey Intern Hash nøgle
ReconciliationStatementHeaderIdentifier Unikt ID for afstemningsopgørelse
PartialAgreementIdentifier Identifier for delaftale
aar År for afstemningsopgørelse
maaned Måned for afstemningsopgørelse
OperationSettledSumBeforeJanuary1st2010 Driftsum afregnet før 1. januar 2010 i DKK
OperationSettledSumAfterJanuary1st2010 Driftsum afregnet efter 1. januar 2010 i DKK
OperationSettledSumGrandTotal Driftsum afregnet totalt i DKK
OperationEarnedSumBeforeJanuary1st2010 Driftsum indtjent før 1. januar 2010 i DKK
OperationEarnedSumAfterJanuary1st2010 Driftsum indtjent efter 1. januar 2010 i DKK
OperationEarnedSumGrandTotal Driftsum indtjent totalt i DKK
OperationDueSumBeforeJanuary1st2010 Driftsum skyldig før 1. januar 2010 i DKK
OperationDueSumAfterJanuary1st2010 Driftsum skyldig efter 1. januar 2010 i DKK
OperationDueSumGrandTotal Driftsum skyldig total i DKK
BonusSettledSumBeforeJanuary1st2010 Bonussum afregnet før 1. januar 2010 i DKK
BonusSettledSumAfterJanuary1st2010 Bonussum afregnet efter 1. januar 2010 i DKK
BonusSettledSumGrandTotal Bonussum afregnet totalt i DKK
BonusEarnedSumBeforeJanuary1st2010 Bonussum optjent før 1. januar 2010 i DKK
BonusEarnedSumAfterJanuary1st2010 Bonussum optjent efter 1. januar 2010 i DKK
BonusEarnedSumGrandTotal Bonussum optjent totalt i DKK
BonusDueSumBeforeJanuary1st2010 Bonussum forfalden før 1. januar 2010 i DKK
BonusDueSumAfterJanuary1st2010 Bonussum forfalden efter 1. januar 2010 i DKK
BonusDueSumGrandTotal Bonussum total forfalden i DKK
TotalDueSumBeforeJanuary1st2010 Totalsum skyldig før 1. januar 2010 i DKK
TotalDueSumAfterJanuary1st2010 Totalsum skyldig efter 1. januar 2010 i DKK
TotalDueSumGrandTotal Totalsum skyldig ialt i DKK
ReconciliationStatementCreateDate Oprettelsesdato for afstemningsopgørelse
IsWSRMProcessed Angiver om WSRM er udført