Søgning » Det Fælles Datagrundlag » tblPersonStatusAbsence

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

tblPersonStatusAbsence


Beskrivelse ?

Denne tabel indeholder fraværs registreringer

Størrelse (Antal rækker) ?

13030480

Indhold (Kolonner/variable) ?

Navn Indhold
AbsenceID Primærnøgle
AbsenceUniqueIdentifier Unik nøgle
CivilRegistrationIdentifier Cpr nummer
AbsenceType Typeangivelse for fravær
StartDate Startdato for fraværet
EndDate Slutdato for fraværet
AbsenceComment Kommentar til fraværsoprettelsen
CorrectionComment Kommentar ved opdatering af fravær
CreateDate Det kaldende systems oprettelsesdato
UpdateDate Dato for seneste opdatering af fraværet
EventDate Dfdg dato for seneste opdatering af fraværet
StartDateAuthorityTypeId Myndighedstype for registrering af startdato
StartDateAuthorityCode Myndighedskode for registrering af startdato
StartDateCaseWorkerRID Brugerid for registrering af startdato
EndDateAuthorityTypeId Myndighedstype for registrering af slutdato
EndDateAuthorityCode Myndighedskode for registrering af slutdato
EndDateCaseWorkerRID Brugerid for registrering af slutdato
AuthorityTypeId Myndighedstype der har foretaget registreringen
AuthorityCode Myndighedskoden der har foretaget registreringen
CaseWorkerRID Brugerid for registrering
EndDateRegistrationDate Dato for seneste opdatering af fraværet hvor slutdato er ændret
Active Angivelse af om fraværet er aktivt
NotificationDate Notifikationsdato
NemRefusionIdentifier Edagpenges bevillingsid
CauseTypeIdentifier Afslutningsårsag for fravær
IsIllnessUpdatedWsrmSent Angivelse af om GetIllnessUpdated wsrm besked er sendt
CurrentUnemploymentStatusTypeIdentifier Angivelse af ledighedsgrad for borger ved registrering på fraværet
ProductionUnitIdentifier Virksomheds identifikation ved angivelse af erhvervsrelateret fravær
CVRnumberIdentifier Virksomheds identifikation ved angivelse af erhvervsrelateret fravær