Søgning » KMD I2 » ExternalSeatType

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

ExternalSeatType


Beskrivelse ?

An ExternalSeatType defines a seat type in a foreign municipality. It stores basic information for that seat type such as the name, the EAN number (of the foreign municipality), a collection of related rates and others.

Størrelse (Antal rækker) ?

333

Indhold (Kolonner/variable) ?

Navn Indhold
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.
DeletedOn Date when the entry was deleted. Empty if the entry is active (not deleted).
EAN EAN number for the seat type.
ExternalMunicipalityId Id of the foreign municipality where the seat type is managed.
Id Unique identifier (in scope of specific entity).
InactiveFrom Date the seat type) is marked inactive from.
Is11Months Whether the rates on this seat type are 11 months rates (as opposed to 12 months)
Minutes Sum of minutes on bookings using this seat type set by municipality. Maximum number in a week for this seat type (50 hours would be 3000 minutes)
MunicipalityId Id of the municipality that owns the seat type
Name_column Name of the seat type.
OriginalSeatTypeId Id of the original seat type that is shared from other municipality
PersonReference Reference to specific person (used for debtor collection).
PersonReferenceName Name of the specific person referenced in (used for debtor collection).
Shared Whether the seat type is shared with other municipalities.
Timestamp_column Date of the last update.
Is11Months_Decoded Afkodning af kolonnen Is11Months
Shared_Decoded Afkodning af kolonnen Shared