| AddressComments |
Option to add some comments in context to the selected addresses. |
| AddressMunicipalityNumber |
Municipality number related to the institution's address |
| AllocationDistrictId |
Allocation district which contains group of institutions in municipality. |
| AlternativeAddress |
Alternative address, such as a pick-up location or other physical site |
| AreaGroupInstitutionId |
Foreign key for AreaGroupInstitution. |
| CareTypeValue |
Raw text value of the care type stored in the database |
| ChangedBy |
Reference to the person or system that last made a change. |
| ChangedDate |
Date of the last change made. |
| CoordinatorId |
Foreign key to a municipality childminder institution |
| CustomParametersValue |
Metadata for institution, stored in JSON. Has no system significance. Data can be added and read through API by the Municipality. |
| CvrOrSeContainsSe |
Does (CvrOrSeNumber) contain a SE-number? Else it contain an ordinary CVR-number? |
| CvrOrSeNumber |
CVR or SE-number for the Private Daycare. |
| DaycareGroupId |
Foreign key for DaycareGroup. |
| DayCareTypeValue |
Raw text value of the day care type stored in the database |
| 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). |
| Discriminator |
The discriminator is indicating the context in witch the Institution was created. The descriptions of the different values is described in the value list. |
| Education |
Childminder's education. |
| Email |
Email address for the institution |
| ExcludedFromWs10 |
Indicates if this institution should be excluded from WS10/AULA, even if having a DTR ID and the owning municipality has purchased the integration. |
| Extension |
Phone extension for the institution |
| Floor_column |
Floor of institution address |
| HeadOfInstitution |
Name of the head/leader of the institution |
| Hired |
Point in Time when the Childminder was hired. |
| HoursPerDay |
Opening/working hours per day. |
| HouseLetter |
House letter of institution address |
| HouseNumber |
House number of institution address |
| Id |
Unique identifier (in scope of specific entity). |
| Independent |
Indicates if the institution is independent |
| IsAreaInstitution |
Indicates if the institution is an area institution (Områdeinstitution). |
| IsExternallyControlled |
Indicates if the institution is synchronised by external API(s) as part of scheduled jobs |
| IsOkInstitution |
Indicates whether this institution is an intermunicipal "placeholder" |
| IsPrimaryInstitution |
Indicates if the institution is a primary institution of a group of institutions. |
| IsResidenceMunicipalityInstitution |
Is this an institution in another municipality, that has been created for record keeping in the municipality that created the DB object Only a flag to show in UI. Is not used in any business logic |
| IsSpecialInstitution |
Does the institution provide special needs care? |
| MobileNumber |
Mobile phone number for the institution |
| MunicipalityId |
Municipality this entity is related to. |
| Name_column |
Name of the institution |
| PhoneHours |
The interval(s) the institution can be contacted by phone |
| PhoneNumber |
Official landline phone number of insititution |
| PoolOfSeats |
Extra days/hours where the employee can be called to work in connection with absence in the staff group. |
| PreventSendingWelcomeLetter |
If set, welcome letters should not be sent for this institution |
| PsrmTypeValue |
PsrmType is used to mark which PSRM claim type should be used when charging for this payable service addition, if any. |
| RegisteredForMobileApp |
Registered for mobile application integration. |
| ShortName |
Unique short name identifying institution. |
| Side |
Side part of institution's address |
| Ssn |
Childminder's social security number. |
| StreetCode |
Street code, if any, of institution's address |
| StreetName |
Street name of institution's address |
| SupervisorId |
Foreign key to Supervisor |
| Timestamp_column |
Date of the last update. |
| Url |
URL for institution's webpage |
| Vacated |
Point in Time when the Childminder's position ended. |
| ValidDateFrom |
First date (inclusive) insititution is active |
| ValidDateTo |
Last date (inclusive) insititution is active |
| Discriminator_Decoded |
Decoding values for Discriminator |
| CvrOrSeContainsSe_Decoded |
Afkodning af kolonnen CvrOrSeContainsSe |
| ExcludedFromWs10_Decoded |
Afkodning af kolonnen ExcludedFromWs10 |
| Independent_Decoded |
Afkodning af kolonnen Independent |
| IsAreaInstitution_Decoded |
Afkodning af kolonnen IsAreaInstitution |
| IsExternallyControlled_Decoded |
Afkodning af kolonnen IsExternallyControlled |
| IsOkInstitution_Decoded |
Afkodning af kolonnen IsOkInstitution |
| IsPrimaryInstitution_Decoded |
Afkodning af kolonnen IsPrimaryInstitution |
| IsResidenceMunicipalityInstitution_Decoded |
Afkodning af kolonnen IsResidenceMunicipalityInstitution |
| IsSpecialInstitution_Decoded |
Afkodning af kolonnen IsSpecialInstitution |
| PreventSendingWelcomeLetter_Decoded |
Afkodning af kolonnen PreventSendingWelcomeLetter |
| RegisteredForMobileApp_Decoded |
Afkodning af kolonnen RegisteredForMobileApp |
| Location_Latitude |
Location Coordinate, Latitude |
| Location_Longitude |
Location Coordinate, Longitude |
| PsrmTypeValue_Decoded |
Decoding of PSRM types |
| AddressMunicipalityNumber_Decoded |
AddressMunicipalityNumber Decoded |
| Ssn_Person_CPR_Id |
ID of Persons record that matches the corresponding social security number |
| AddressMunicipalityId |
Reference to Address Municipality. added for archiving |