Søgning » KMD I2 » IncomePair

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

IncomePair


Beskrivelse ?

Incomes of the applicant(s) updated in the aided place subsidy recalculation process.

Størrelse (Antal rækker) ?

106722

Indhold (Kolonner/variable) ?

Navn Indhold
CalculationViewableId Payment calculation for bookings covered by the recalculated application using the updated income.
Current_column If the income should be used for calculating aided place subsidy value instead of the income entered in the original (ApplicationAidedPlace). True if the income has been "transferred" (should be used).
Id Unique identifier (in scope of specific entity).
Locked If the income should be split between months in the yearly recalculation process. True if the income is marked as split.
MonthId Related recalculation.
OriginText Origin of a monthly income in aided place subsidy recalculation process.
StepDeviation Difference between original aided place subsidy level based on subsidy percentage calculated on creating the (ApplicationAidedPlace) and subsidy level based on the updated income represented by (IncomePair.TotalIncomeBasis). Can be zero for the same percentage, negative when updated percentage is lower than the original or positive when updated percentage is higher than original.NB. It's not difference in percentage points, but rather difference between indexes of corresponding subsidy levels on the administrative scale (Fripladsskala).
Timestamp_column Date of the last update.
TotalIncomeBasis Total income basis value (in DKK, per annum) calculated using the updated monthly incomes for the recalculation month and other incomes, like company earnings or dividends, assessed on creating the (ApplicationAidedPlace).
YearlyRecalculation If the income has been created and transferred in the yearly recalculation process. True if originated from a yearly recalculation.
OriginText_Decoded Decoding values for OriginText
Current_Decoded Afkodning af kolonnen Current
Locked_Decoded Afkodning af kolonnen Locked
YearlyRecalculation_Decoded Afkodning af kolonnen YearlyRecalculation