Søgning » PUMA » ClientActivityTimeRegistrationPeriod

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

ClientActivityTimeRegistrationPeriod


Beskrivelse ?

Denne tabel indeholder alle elementer for en tidsregistrering for en aktivitet

Størrelse (Antal rækker) ?

9290675

Indhold (Kolonner/variable) ?

Navn Indhold
Id tabellens primær nøgle
fk_ClientActivityTimeRegistrationId reference til tidsregistreringen i tabel ClientActivityTimeRegistration
Title aktivitetstittel på den tidsregistrerede aktivitet/anden aktivitet/fravær periode
TimeFrom starttid for tidsregistreringsperioden
TimeTo sluttid for tidsregistreringsperioden
TimeType tidsart for tidsregistreringen (til KØLS)
TimeSubType tidsunderart for tidsregistreringen (til KØLS)
RegistrationCode registreringskode for tidsregistreringen (se ActivityBaseRegistrationCode
PresentHours antal timer tidsregistreringsperioden dækker
fk_ClientActivityTimeRegistrationTypeId reference til tidsregistreringstypen i tabel ClientActivityTimeRegistrationType
fk_AbsenceReasonId reference til evt. fraværsårsag i tabel AbsenceReason
fk_OtherActivityActivityBaseId reference til evt. anden udført aktivitet i tabel ActivityBase
Comment evt. kommentar ved fravær
PieceworkNumber antal akkordenheder ved akkordarbejde
UnitPieceworkRate akkord enhendspris ved akkordarbejde i danske kroner
HasSkillsSupplement indikator for kompetancetillæg
HasStabilitySupplement indikator for stabilitetstillæg