Søgning » PUMA » ClientEventDetail

PUMA

Tabeloversigt ?
ClientEducationArea_Afsoning
ClientEducationArea
Activity
ClientActivityTimeRegistration
ClientActivitySplitFromStatus
ClientAbuseNote
ClientAbuseNote_Afsoning
ClientActivityTimeRegistrationPeriod
ClientEventDetail
ClientActivity
ClientProgramArea_afsoning
Behov
ClientProgramArea
ClientWorkExperienceArea_Afsoning
Client
ClientAbuseArea_afsoning
ClientWorkExperienceArea
WaitingListSubscription
ClientAbuseArea
BehovBeskrivelser
BehovStatus
Indsatser
IndsatsStatus
ClientDrugAbuseProfile_afsoning
IndsatsBeskrivelser
BatchjobActivityCancellation
ClientDrugAbuseProfile
ClientFreeTimeArea_afsoning
Instructor
BehovKategorier
BehovStatusKategorier
Bidragsydere
IndsatsStatusKategorier
ClientFreeTimeArea
ClientLongAbsenceRegistration
ActivitySuspension
ClientAfsoningsplanNeedEffortStatus
ClientFreeTimeActivityProfile_afsoning
ClientAbuseTreatmentOfferGuaranteePeriod
ClientAbuseTreatmentVersion
ClientActivityNeeds
ClientActivityRequiredForWaitingList
ClientEducationOtherLanguages_Afsoning
ClientEmploymentTypeDocument
ClientEvent
ClientEventLog
ClientFreeTimeActivityProfile
ClientNeedEffortStatuschange
TimeRegistrationDeliveryLog
Klienter_ReadOnly
ActivityBase
ActivitySchedule
Afsoning
ClientActivityAbruptCancellationEvaluation
ClientActivityRejection
ClientActivitySchedule
clientAPNeeds
ClientEducationOtherLanguages
ClientNeedEffortStatus
ClientSupplementData
ClientWorkExperience
Institution
WaitingListSubscriptionNeeds
AbsenceReason
ActivityBaseRegistrationCode
ClientActivityEvaluation
ClientEducationAVUResult_Afsoning
ClientOtherActivityArea
InstitutionSection
InstructorCompetence
ClientAbuseTreatmentActivity
ClientActivitySplitEvent
ClientEducationAVUResult
ClientEducationCourse_Afsoning
ClientEducationCourse2_Afsoning
ClientEducationCourseAfterRelease_Afsoning
ClientStatus
ClientStatusType
EducationCancellationReason
EducationScreeningTestOptionType
InstitutionArea
KSEventType
AssessmentType
CancellationGroup
CancellationReason
ClientChild
ClientEducationAreaTestCategoryNeed
ClientEmploymentTypeDocumentData
EducationCourseTypeCategory
EducationType
ExceededTreatmentOffer
NotInitiatedTreatmentOffer
RegimeType
ActivityInstructor
CaseWorker
ClientAbuseTreatment
ClientEducationCourse
ClientEducationCourse2
ClientEducationCourseAfterRelease
ClientEducationTestResult
ClientProgramAreaChosenTargetPrograms_afsoning
EducationAVUCourse
EducationAVULevelType
EducationCourse
EducationLevelType
FreeTimeActivityProfileActivityTypeType
IndsatsBeskrivelser_p
ProgramAreaChosenTargetProgramType
ProgramAreaInTargetForProgramType
ProgramAreaReasonForNotSuitedType
ProgramAreaWishesProgramType
RejectionReason
TreatmentTerminatedReasonType
WaitingListSubscriberStatus
WorkExperienceDurationType
ActivityRegistrationType
AssessmentCategoryType
ClientAbuseTreatmentVersionType
ClientActivityStatusType
ClientActivityTimeRegistrationType
ClientAttendanceType
ClientEventProcessedStatusType
ClientProgramAreaChosenTargetPrograms
ClientWorkDriversLicense
ClientWorkKnownBarriers
ConsumedDrugsOneMonthBeforeDetentionOptionType
DriversLicenseType
DrugAbuseConsumptionMethodType
DrugAbuseConsumptionUnitType
DrugAbuseDebutAgeType
DrugAbuseDrugType
DrugAbuseDurationType
DrugAbuseFrequencyType
EducationCanOtherLanguageType
EducationCategoryType
EducationDanishEvaluationType
EducationDyslexiaTestType
EducationHasFinishedPrimarySchoolType
EducationInTargetForAVUType
EducationInTargetForDanishType
EducationInTargetForDigitalType
EducationInTargetForDyslexiaType
EducationInTargetForEnglishType
EducationInTargetForMathType
EducationInTargetForStartType
EducationLanguageEvaluationType
EducationLevelGroupType
EducationLevelPlacementDanishType
EducationLevelPlacementDigitalType
EducationLevelPlacementEnglishType
EducationLevelPlacementMathType
EducationMathEvaluationType
EducationOtherNativeLanguageThanDanishType
EducationScreeningCategoryType
EducationScreeningPartType
EducationScreeningPerformedWithinTwoYearsType
EducationWishesEducationAtImprisonmentType
EducationWishesGuidanceAtImprisonmentType
EmploymentType
ExceedingTreatmentGuaranteeReasonType
FreeTimeActivityProfileDurationType
FreeTimeActivityProfileFrequencyType
FreeTimeActivityProfileLevelType
FreeTimeAreaActivityType
FreeTimeAreaHasFreeTimeActivitiesBeforeSentenceType
FreeTimeAreaWishesFreeTimeActivitiesDuringSentenceType
KSEventGroup
LanguagesType
RejectionGroup
RequestedTreatmentType
RequestStatusType
TreatmentIntensityLevelType
TreatmentNotInitiatedReasonType
TreatmentTerminatedReasonGroupType
TreatmentType
WeekDayType
WorkAfterReleaseType
WorkKnownBarriersType
WorkProfessionType
WorkWishesWorkType
WorkWorkingAtImprisonmentType
WorkWorkingAtImprisonmentTypeType
Tabel

ClientEventDetail


Beskrivelse ?

Denne tabel indeholder yderligere oplysninger omkring et event indlæst i ClientEvent tabellen. Disse data indeholder desuden en eventkode, der angiver hvordan eventet skal fortolkes i PUMA.

Størrelse (Antal rækker) ?

2419971

Indhold (Kolonner/variable) ?

Navn Indhold
Id tabellens primær nøgle
CPR klientens cprnr, ved cprskift: det gamle cprnr
NewCPR ved cprskift: klientens nye cprnr
FirstName klientens fornavn(e)
LastName klientens efternavn(e)
KS_PersonId klientens personid i KlientSystemet
KS_FællesStamdataFællesId id for klientinstansen fra KlientSystemet
KS_DataSourceType klientens status i Klientsystemet (AFSONER/...)
CellNo klientens cellenummer
KS_InstitutionId Klientsystemets id for klientens matrikel
KS_AreaId Klientsystemets id for matriklens region (Hovedstaden/Sjælland/...) se tabel InstitutionArea
KS_InstitutionSectionName afdelingsnavn
KS_InstitutionSectionId Klientsystemets id for afdelingen. Se tabel InstitutionSection
fk_KSEventTypeId reference til event/hændelse i tabel KSEventType
AdditionalText evt. ekstra tekstinformation
StartTime starttidspunkt for hændelsen (f.eks første dag i strafcelle)
EndTime sluttidspunkt for hændelsen, hvis denne er afgrænset fra start (f.eks sidste dag i strafcelle)