Søgning » KMD Institution I2 » CalculationChild
Tabel

CalculationChild


Beskrivelse ?

A CalculationChild holds calculation information for a specific month for a booking.

Størrelse (Antal rækker) ?

1697982

Indhold (Kolonner/variable) ?

Navn Indhold
BookingId The (Booking) that has been calculated.
CalculationBookingTypeString CalculationBookingType defines the types of bookings in regards to calculation.
CalculationType Defines the types of calculations
CalculationViewableId The (CalculationViewable) which holds this CalculationChild.
Cvr Bookings with the CalculationBookingType "ExternalCitizen" has a municipality as payer. This is the CVR-number for the paying municipality.
EAN Bookings with the CalculationBookingType "ExternalCitizen" has a municipality as payer. This is the EAN number for the paying municipality.
EndDate EndDate is the last day of the month that this CalculationChild covers.
ExternalMunicipalityNumber Bookings with the CalculationBookingType "ExternalCitizen" and "ExternalInstitution" are related to another municipality than the one in which the booking is created. For the "ExternalCitizen" booking type this is the municipality where the child resides. For the "ExternalInstitution" booking type this is the municipality where the child is cared for. The ExternalMunicipalityNumber holds the municipality number of that other municipality.
Id Unique identifier (in scope of specific entity).
IsPrivateInstitutionNewInstance Whether this CalculationChild concerns a booking in a private institution, where the booking has never been calculated for this period before.
IsYearlyRecalculation Whether this CalculationChild is created for the yearly recalculation. True if it is.
MunicipalityNumber The municipality number of the municipality that owns the calculation data
PayerSSN The social security number of the person who pays for the booking.
PersonReference A booking with CalculationBookingType "ExternalCitizen" can be marked with a person reference id via its SeatType. The id data is pure meta data supplied by the municipality, and is used in the debtor integration (pass-through).
PersonReferenceName A booking with CalculationBookingType "ExternalCitizen" can be marked with a person reference name via its SeatType. The reference name data is pure meta data supplied by the municipality, and is used in the debtor integration (pass-through).
SecondaryPayer The social security number of an optional secondary payer.
SlotId The (Slot) related to the booking.
SSN The social security number of the child which the booking relates to.
StartDate StartDate is the first day of the month that this CalculationChild covers.
Timestamp_column Date of the last update.
Value_column The calculated price for the booking. Values are specified in Danish kroner
CalculationBookingTypeString_Decoded Decoding values for CalculationBookingTypeString
CalculationType_Decoded Decoding values for CalculationType
IsPrivateInstitutionNewInstance_Decoded Afkodning af kolonnen IsPrivateInstitutionNewInstance
IsYearlyRecalculation_Decoded Afkodning af kolonnen IsYearlyRecalculation
ExternalMunicipalityNumber_Decoded ExternalMunicipalityNumber Decoded
MunicipalityNumber_Decoded MunicipalityNumber Decoded
SSN_Person_CPR_Id ID of Persons record that matches the corresponding social security number
PayerSSN_Person_CPR_Id ID of Persons record that matches the corresponding social security number