Brug for hjælp?
Skriv til data@sa.dk og få hjælp til at:

  • finde det, du søger
  • forstå det, du har fundet

Søgning » PUMA » ClientStatusType

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

ClientStatusType


Beskrivelse ?

Denne tabel fungerer som en krydstabel mellem eventkoder, der repræsenterer hhv. begyndelse og afslutning p? en status samt en default varighed, hvis der ikke forventes en returh?ndelse.

Størrelse (Antal rækker) ?

27

Indhold (Kolonner/variable) ?

Navn Indhold
Id tabellens primær nøgle
fk_InitiatingKSEventTypeId reference til event der udløser denne status, i tabel KSEventType
fk_ReturningKSEventTypeId reference til den eventtype der kan afslutte denne status, i tabel KSEventType
fk_AbsenceReasonId reference til fraværsårsag som puma foreslår under denne status, i tabel AbsenceReason
DefaultDurationInDays default varighed af status, i dage