Tabel

Booking


Beskrivelse ?

Represents Child's enrollment in given institution.

Størrelse (Antal rækker) ?

21946

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