| ApplicationDate |
Date for when the application was made. |
| BadFaithDiscoveryDate |
The day it was discovered that the (ApplicationAidedPlace) was applied in bad faith (untruthful information given). The value is set when the application is closed due to bad faith. |
| ChangedBy |
Reference to the person or system that last made a change. |
| ChangedDate |
Date of the last change made. |
| CivilStatusValue |
Defines the different types of civil status. |
| ClosingReasonRegistrationDate |
The date the (ApplicationAidedPlace) was closed with a specific reason. |
| ClosingReasonValue |
This value is used to mark why an (ApplicationAidedPlace) has been closed, as the reason can have an effect on related regulations. |
| 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). |
| EndDate |
The end date of the application. |
| ExcludeYearlyRecalculation |
Indicates if this specific application should not be automatically regulated as part of yearly recalculation. True if excluded. |
| HasChildOnOtherAddress |
Indicates if a child from another address is connected to this application. True if any. |
| Id |
Unique identifier (in scope of specific entity). |
| LifePartnerSsn |
Social security number of a co-applicant if any. |
| Manual |
Indicates if the Caseworker should manually handle processes around this application. Ex. monthly recalculation. True if should be manually handled. |
| ManualEndDate |
If a period for manually handling this application is defined. This is the end date. |
| ManualStartDate |
If a period for manually handling this application is defined. This is the start date. |
| MunicipalityId |
Municipality this entity is related to. |
| OriginalId |
Original id of the object, used for in-table history |
| Ssn |
Social security number of the applicant. |
| StartDate |
The start date of the application |
| StatusReasonValue |
Reason(s) for manual processing or automatic rejection of an application for aided place subsidy. Can be a bitwise disjunction of multiple reasons. |
| StatusValue |
When a citizen applies for aided place, there is a set of rules for when an application can be automatically approved or should be approved by caseworker manually. Automatic approval can have two states: New or Approved. Manual approval can have four states: New, Active, Rejected or Approved. An approved application can be cancelled, if the caseworker or citizen deletes an application, or if an existing application is replaced with a new application which covers the same period. |
| Timestamp_column |
Date of the last update. |
| ValidEndDate |
End date - the object is valid until this date (including the date AND time) |
| ValidStartDate |
Start date - the object is valid from this date (including the date AND time) |
| CivilStatusValue_Decoded |
Decoding values for CivilStatusValue |
| StatusReasonValue_Decoded |
Decoding values for StatusReasonValue |
| ClosingReasonValue_Decoded |
Decoding values for ClosingReasonValue |
| ExcludeYearlyRecalculation_Decoded |
Afkodning af kolonnen ExcludeYearlyRecalculation |
| HasChildOnOtherAddress_Decoded |
Afkodning af kolonnen HasChildOnOtherAddress |
| Manual_Decoded |
Afkodning af kolonnen Manual |
| LifePartnerSsn_Person_CPR_Id |
ID of Persons record that matches the corresponding social security number |
| Ssn_Person_CPR_Id |
ID of Persons record that matches the corresponding social security number |