Søgning » PUMA » ClientActivity

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

ClientActivity


Beskrivelse ?

Denne tabel indeholder klienters tilmeldinger til en aktivitet. En klient kan have mange forskellige tilmeldinger - også til samme aktivitet

Størrelse (Antal rækker) ?

457942

Indhold (Kolonner/variable) ?

Navn Indhold
Id tabellens primær nøgle
fk_ClientID reference til klienten i Client tabel
fk_ActivityId reference til aktiviteten i Activity tabel
fk_ClientActivityStatusTypeId reference til tilmeldingsstatus for klientens tilmelding til aktiviteten i tabel ClientActivityStatusType
StartDate første dato hvor denne række er gyldig
EndDate sidste dato hvor denne række er gyldig
RecordingCaseWorker reference til bruger CaseWorker tabel: Den der sidst har oprettet/redigeret denne række i denne tabel
LastModifiedDateTime dato+tid for hvornår denne række sidet er opdateret
CreateDateTime dato+tid for hvornår denne række er oprettet
CancellationDateTime dato+tid for hvornår rækkens gyldighed blev ændret
fk_CancellationReasonId reference til afslutnings/frameldingsårsag i tabel CancellationReason (null hvis klienten stadig er tilmeldt, eller i stedet efterfølgende evalueret)
fk_ClientActivityNeedsId reference til behov fra Behov microservice, hvis tilmelding er sket på baggrund af microservice behov
PrioritySignup 0: almindelig tilmelding, 1: prioriteret tilmelding, 2: automatisk (top)prioriteret tilmelding af misbrugsbehandling
clientActivityNeedFk referenece til behov fra AfsoningsPlan i tabel ClientActivityNeeds, his tilmeldingen er sket på baggrund af behov fra AP
fk_educationlevelTypeId reference til klientens individuelle niveau på blandet hold, i tabel EducationLevelType
KeepWaiting indikation for om klienten skal beholdes på venteliste når denne aktivitetstilmelding træder i kraft