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 » BatchjobActivityCancellation

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

BatchjobActivityCancellation


Beskrivelse ?

Denne tabel indeholder referencer til aktiviteter og klienttilmeldinger, der ønskes afbrudt på et fremtidigt tidspunkt. Når batchjobbet ’Job_CloseExceededActivities’ afvikles, gennemløbes tabellen, og alle aktiviteter, hvor CancellationDate er overskredet, afsluttes med årsag som angivet i tabelkolonnen fk_CancellationReasonId

Størrelse (Antal rækker) ?

160470

Indhold (Kolonner/variable) ?

Navn Indhold
Id tabellens primær nøgle
fk_ActivityId reference til aktiviteten i Activity tabel
fk_ClientId reference til klienten i Client tabel
CancelClientOnly indikator for om kun klientens tilmelding skal afsluttes (1) eller om hele aktiviteten skal afsluttes (0)
fk_CancellationReasonId reference til afslutningsårsag i tabel CancellationReason
fk_CaseWorkerId reference til bruger CaseWorker tabel: Den der sidst har oprettet/redigeret denne række i denne tabel
CancellationDate Dato hvor afslutningen af klientens aktivitet skal effektueres
BatchjobExecutionDateTime Dato+Tid hvor afslutningen er effektueret
Createddate dato+tid for hvornår denne række er oprettet
SessionIdentifer unik GUID for rækken
fk_ClientActivityId reference til klient aktiviteten i ClientActivity tabel