Søgning » KMD I2 » Booking

KMD I2

Tabeloversigt ?
Institution
AgeGroup
ApplicationAidedPlace
InstitutionClosingPeriod
Attachment
CalculationChild
Incident
PayableService
Booking
MindingOwnChildrenApplication
Rate
PrivateDaycareApplication
Roles
CalculationAmount
IncomeMonthState
InstitutionOpeningHours
Employee
Offer
CalculatedIncome
ExternalSeatType
WishSlot
Addresses
ChildNote
ContactInformation
DayCareReallocation
ExternalSeatTypeRate
Module_table
SeatType
SeatTypeRate
Slot
ContactPerson
GroupCareType
Income
IncomePair
NeededHours
Consent
ParentNote
PayableServiceSlot
SpaceRequirement
YearlyRecalculationAidedPlaceNote
Persons
InstitutionGuestChildExemption
RateInterval
AidedPlaceNote
ApplicationAidedPlaceNote
CalculationViewable
DayCareCourseParticipation
InstitutionCapacity
InstitutionProfile
MindingOwnChildrenApplicationNote
PersonAddresses
TemporarySeat
AbsenceContactChildEntry
DaycareGroup
InstitutionSubGroup
AliasName
ApplicationAidedPlaceIncome
COIGroupDistrict
Condition_table
DayCareEquipmentLoan
GroupInstitution
IncomeDetail
ApplicationAidedPlaceChild
DayCareCourse
DayCareEquipment
HealthVisitor
InstitutionNote
Municipality
NewComerParticipant
DeadStatus
AbsenceContactChildminderEntry
AbsenceContactSupervisorEntry
Child
ContactPersonType
PriorityChildminder
Supervisor
CoveragePeriod
EmployeeRole
ExcludedChildminder
IncomeMonth
InstitutionCOIGroupDistrict
Language_table
NewComer
Parent
ChildNativeLanguage
InstitutionDescription
Intend
Objection
SupervisorGroupInstitution
ChildCondition
ConditionInstitutionChildminder
DayCareReallocationTemporarySeat
InstitutionEmployeeSubGroup
InstitutionSubGroupBooking
GroupInstitutionInstitution
Arkivering_dummy_dangling_tuples
Tabel

Booking


Beskrivelse ?

Represents Child's enrollment in given institution.

Størrelse (Antal rækker) ?

63965

Indhold (Kolonner/variable) ?

Navn Indhold
ChangedBy Reference to the person or system that last made a change.
ChangedDate Date of the last change made.
ChildId The child that is enrolled
CreatedBy Name of the caseworker that created a booking Bookings created automatically are marked as "System"
DeletedBy Identity of person who deleted the entity. Empty if the entry is active (not deleted). Can be name of a caseworker, CPR of a citizen or "System" for automatic removal.
DeletedCause Reason why booking was deleted Sometimes bookings are deleted automatically by system due to other events, like accepting other offers etc.
DeletedOn Date when the entry was deleted. Empty if the entry is active (not deleted).
Discriminator The discriminator is indicating the context in witch the Booking was created. The descriptions of the different values is described in the value list.
EndDate When the enrollment ended (or will end). The date 31-12-9999 is used to signify booking without end.
ExpectedWithdrawalDate When the booking is expected to end This may differ from actual EndDate as this is only estimations and usually calculated based on child's age
ExternalSeatTypeId Seat type from the other municipality
Id Unique identifier (in scope of specific entity).
InFocusStateText Current state of handling the start of the new booking by caseworker.
InFocusWithdrawStateText Current state of handling the child withdraw from institution.
ParentId Parent that created the booking
SeatTypeId Seat type associated with external booking
SlotId Slot used for this booking
StartDate When the booking starts
Timestamp_column Date of the last update.
Discriminator_Decoded Decoding values for Discriminator
InFocusStateText_Decoded InFocusStateText Decoded
InFocusWithdrawStateText_Decoded InFocusWithdrawStateText Decoded
Arkivering_dangling_tuple_column Kolonne tilføjet arkiveringsversionen på grund af dangling tuples