AltiPlan - Kundeliste

2026-02-11T11:22:29Z

Admin:

'''Kunde liste'''
{| class="wikitable"
|+https://login.altiplan.dk/hosfiles/2.8.0.385/Hosinfo_install.msi
!Kunde
!New Version
!Metode
!Link
!1st contact
!2nd contact
!Note
|-
|Frederiksberg Kommune
|2.8.0.378
Requested
2.8.0.400
|Intern software deploment
|<nowiki>https://login.altiplan.dk/hosfiles/frederiksberg/hosinfo_install.msi</nowiki>
|altiplan@frederiksberg.dk
Line Bang Vinholdt
M: linvin@frederiksberg.dk
M: +45 28982323
|Nevzat Tokmak
IT Endpoint Manager

M: neto2@frederiksberg.dk

M: 3821 2169
|SSO web- & mobileapp done
|-
|OK-Fonden
|2.8.0.366
requested new
|EG SQL server
|<nowiki>https://login.altiplan.dk/hosfiles/okfonden/hosinfo_install.msi</nowiki>
|Thomas Buchwaldt
IT- og digitaliseringsansvarlig

M: tbu@ok-fonden.dk

M: 20 21 03 85

D: 33 85 45 15
|Marianne L. Andersen
Teamleder

Mail: maa@ok-fonden.dk

M: 2262 3106

D: 33 85 45 35
|SSO web- & mobileapp done
|-
|Hørsholm Kommune
|2.8.0.366
|Intern software deploment
|<nowiki>https://login.altiplan.dk/Hosfiles/Horsholm/hosinfo_install.msi</nowiki>
|Dorota Agnieszka Børjesen
Lønkonsulent

M: dob430@horsholm.dk

M: +4529314352
|Nikolaj Skipper Olsen
IT Specialist

M: nso@horsholm.dk

M: +4520348480

Kasper Klint Hansen

IT Systemadministrator

M: kah135@horsholm.dk

M: +4524979296
|
|-
|Region Nordjylland
|requested new
|
|
|Andreas Bjørn Jørgensen
Specialkonsulent
M: anbjj@rn.dk
|
|SSO web- & mobileapp request
|-
|Region Midtjylland
|requested new
|
|
|Stefan Åke Jørgensen
IT-Teknisk Specialist
M: stfjor@rm.dk
M: +4529656664
|
|SSO web- & mobileapp request
|-
|Region Syd
|Requested 2.8.0.400
|
|
|Gitte R. Sørensen
Specialkonsulent

M: grs@rsyd.dk

M: +45 21572802

D: +45 76631775

Tina Feldfoss

M: tfe@rsyd.dk

Julie Thorning Rasmussen

Julietr@rsyd.dk
|
|SSO web- & mobileapp request
|-
|Plejehjemmet Sct. Olaf
|2.8.0.372
|EG SQL upgrade
|
|Vibeke Boe
Sekretær
M: vibo@aarhus.dk

Plejehjemmet Sct. Olaf

Hjulbjergvej 58A-B

8270 Højbjerg

Tlf: 87 36 80 40
|
|-
|Sillerup (Haderslev Kommune)
|requested new
|
|
|Annja
Tlf.: 23991776
M: annj@haderslev.dk
|
|EDU 26/01/26
|-
|Brøndby Kommune
|requested new
|
|
|Michael Byrgesen
P: 4328 2183

P: 24800369

M: MIBYR@brondby.dk

Netværk

Christian Larsson

Mail: chila@brondby.dk

Tlf.: 30897351
|
|-
|Kløvervangen (Aarhus K)
|requested new
2.8.0.400
|EG Upgrade
|
|Sebastian Rosenberg Lenda
P: +45 40834878
M: serl@aarhus.dk
Mia Vestergaard
M: mive@aarhus.dk
|
|-
|Lions
|Requested
2.8.0.400
|Selfdeploy
|https://login.altiplan.dk/Hosfiles/lions/hosinfo_install.msi
|June Nikoline Hartmann
M: june.h@lionsneurocenter.dk

Alfha Secka

M: ase@unit-it.dk
|
|-
|Hospice Sjælland
|requested 08/01/25
|Selfdeploy
|https://login.altiplan.dk/hosfiles/2.8.0.386/Hosinfo_install.msi
|Nadia El-Tannoukhi
M: nbel@hosj.dk
Vibeke Steen Lund

M: 46762929

M: vslu@hosj.dk
|
|-
|Nordjyllands Trafikselskab
|requested new (new year)
|?
|https://login.altiplan.dk/Hosfiles/nt/hosinfo_install.msi
|Birthe Bak
M: bl@ntmail.dk
|
|-
|Fortegården (Aarhus Kommune)
|
|
|
|Anni Breinholt
Mobil 2938 2928

abg@aarhus.dk
|
|EDU start 09/03/26
|}

AltiPlan - Teknisk implementering

2026-02-03T13:01:11Z

Admin:

AltiPlan - Kundeliste

2026-02-02T10:29:31Z

Admin:

'''Kunde liste'''
{| class="wikitable"
|+https://login.altiplan.dk/hosfiles/2.8.0.385/Hosinfo_install.msi
!Kunde
!New Version
!Metode
!Link
!1st contact
!2nd contact
!Note
|-
|Frederiksberg Kommune
|2.8.0.378
Requested
2.8.0.400
|Intern software deploment
|<nowiki>https://login.altiplan.dk/hosfiles/frederiksberg/hosinfo_install.msi</nowiki>
|altiplan@frederiksberg.dk
Line Bang Vinholdt
M: linvin@frederiksberg.dk
M: +45 28982323
|Nevzat Tokmak
IT Endpoint Manager

M: neto2@frederiksberg.dk

M: 3821 2169
|SSO web- & mobileapp done
|-
|OK-Fonden
|2.8.0.366
requested new
|EG SQL server
|<nowiki>https://login.altiplan.dk/hosfiles/okfonden/hosinfo_install.msi</nowiki>
|Thomas Buchwaldt
IT- og digitaliseringsansvarlig

M: tbu@ok-fonden.dk

M: 20 21 03 85

D: 33 85 45 15
|Marianne L. Andersen
Teamleder

Mail: maa@ok-fonden.dk

M: 2262 3106

D: 33 85 45 35
|SSO web- & mobileapp done
|-
|Hørsholm Kommune
|2.8.0.366
|Intern software deploment
|<nowiki>https://login.altiplan.dk/Hosfiles/Horsholm/hosinfo_install.msi</nowiki>
|Dorota Agnieszka Børjesen
Lønkonsulent

M: dob430@horsholm.dk

M: +4529314352
|Nikolaj Skipper Olsen
IT Specialist

M: nso@horsholm.dk

M: +4520348480

Kasper Klint Hansen

IT Systemadministrator

M: kah135@horsholm.dk

M: +4524979296
|
|-
|Region Nordjylland
|requested new
|
|
|Andreas Bjørn Jørgensen
Specialkonsulent
M: anbjj@rn.dk
|
|SSO web- & mobileapp request
|-
|Region Midtjylland
|requested new
|
|
|Stefan Åke Jørgensen
IT-Teknisk Specialist
M: stfjor@rm.dk
M: +4529656664
|
|SSO web- & mobileapp request
|-
|Region Syd
|Requested 2.8.0.400
|
|
|Gitte R. Sørensen
Specialkonsulent

M: grs@rsyd.dk

M: +45 21572802

D: +45 76631775

Tina Feldfoss

M: tfe@rsyd.dk

Julie Thorning Rasmussen

Julietr@rsyd.dk
|
|SSO web- & mobileapp request
|-
|Plejehjemmet Sct. Olaf
|2.8.0.372
|EG SQL upgrade
|
|Vibeke Boe
Sekretær
M: vibo@aarhus.dk

Plejehjemmet Sct. Olaf

Hjulbjergvej 58A-B

8270 Højbjerg

Tlf: 87 36 80 40
|
|-
|Sillerup (Haderslev Kommune)
|requested new
|
|
|Annja
Tlf.: 23991776
M: annj@haderslev.dk
|
|EDU 26/01/26
|-
|Brøndby Kommune
|requested new
|
|
|Michael Byrgesen
P: 4328 2183

P: 24800369

M: MIBYR@brondby.dk
|
|-
|Kløvervangen (Aarhus K)
|requested new
2.8.0.400
|EG Upgrade
|
|Sebastian Rosenberg Lenda
P: +45 40834878
M: serl@aarhus.dk
Mia Vestergaard
M: mive@aarhus.dk
|
|-
|Lions
|Requested
2.8.0.400
|Selfdeploy
|https://login.altiplan.dk/Hosfiles/lions/hosinfo_install.msi
|June Nikoline Hartmann
M: june.h@lionsneurocenter.dk

Alfha Secka

M: ase@unit-it.dk
|
|-
|Hospice Sjælland
|requested 08/01/25
|Selfdeploy
|https://login.altiplan.dk/hosfiles/2.8.0.386/Hosinfo_install.msi
|Nadia El-Tannoukhi
M: nbel@hosj.dk
Vibeke Steen Lund

M: 46762929

M: vslu@hosj.dk
|
|-
|Nordjyllands Trafikselskab
|requested new (new year)
|?
|https://login.altiplan.dk/Hosfiles/nt/hosinfo_install.msi
|Birthe Bak
M: bl@ntmail.dk
|
|-
|Fortegården (Aarhus Kommune)
|
|
|
|Anni Breinholt
Mobil 2938 2928

abg@aarhus.dk
|
|EDU start 09/03/26
|}

2026-01-16T12:31:46Z

Admin:

2026-01-15T14:46:12Z

Admin:

2026-01-09T09:41:29Z

Admin:

Optima - Upgrade

2026-01-07T12:05:50Z

Admin:

'''1. Before upgrades create ZD ticket as #929616 (Enable recycle app pool after upgrade to 11.4.3):'''

"Hi,

When the rest of our LIVE environments is upgraded to version 11.4.3 MR, we like to request that recycle app pool is enabled for both every 30 or 60 min, on the following dates listed below:

26 March

- ESBJERGLIVE

- HADERSLLIVE

- HJORLIVE

- VIBORGLIVE

1 April

- ODSHERLIVE

- HOLSTEBLIVE

- KOLIDNGLIVE

- NYBORGLIVE

2 April

- AALBORGLIVE

- GLOSTRPLIVE

- SYDDJURLIVE

- FBORGLIVE

- SILKEBOLIVE

- RANDERSLIVE

Many thanks"

'''2. Check Nexus Integration as ZD ticket: #928629 (VIBORGLIVE - Nexus "The login failed"):'''

"Hi,

After VIBORGLIVE was upgraded last night, we are getting this error on the Nexus Integration:
Response:

dk.eg.sd.loen.optima.integration.business.restintegration.common.exceptions.InternalServerErrorException: RequestUrl: https://ais.allocate-cloud.de/api/workforce/1.4/HoursAssignmentShort
Message: Internal Server Error
Details: {
"odata.error":{
"code":"","message":{
"lang":"en-US","value":"An error has occurred."
},"innererror":{
"message":"Cannot open database \"HealthRoster_11_4_2036_VIBORGLIVE\" requested by the login. The login failed.\r\nLogin failed for user 'AIS-SilkeBorg'.","type":"System.Data.SqlClient.SqlException","stacktrace":" at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)\r\n at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)\r\n at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)\r\n at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at AllocateSoftware.InformationService.Logic.Connections.Information.MsSqlConnection.<GetData>d__4.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at AllocateSoftware.InformationService.Logic.Connections.AisResponse.EnsureSuccess()\r\n at AllocateSoftware.InformationService.Portal.Controllers.RelayController.<Get>d__2.MoveNext() in D:\\Jenkins\\workspace\\ais_AIS-Build_release_v24.9.1\\AIS.Portal\\Controllers\\RelayController.cs:line 104\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at AllocateSoftware.InformationService.Portal.Controllers.RelayController.<ExecuteAsync>d__5.MoveNext() in D:\\Jenkins\\workspace\\ais_AIS-Build_release_v24.9.1\\AIS.Portal\\Controllers\\RelayController.cs:line 216\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at Datadog.Trace.ClrProfiler.Integrations.AspNetWebApi2Integration.<ExecuteAsyncInternal>d__9`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Tracing.Tracers.HttpControllerTracer.<ExecuteAsyncCore>d__10.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at Datadog.Trace.ClrProfiler.Integrations.AspNetWebApi2Integration.<ExecuteAsyncInternal>d__9`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()"

Hope you can help correct the user.

Many thanks
Stefan"

'''3. REGHIBT check Cloudconnect (SMS function) is working (don't know how yet) after request from Ditte (see mail)'''

4. Check Norm period notification is working

Optima - Datahub

2026-01-06T13:36:49Z

Admin:

Connection string:
"HOST=ds04334.eu-west-1.snowflakecomputing.com;ACCOUNT=ds04334.eu-west-1;USER=RegH;PASSWORD=Wednesday20!;DB=OPTIMA;WAREHOUSE=DWH;",

DSN:

DSN’en skulle DWH stå i Warehouse og ikke i Database

'''SQL examples:'''

'''TARGET'''

SELECT * FROM "DATA_SHARE_DB"."OPTIMA_MANAGED"."NOTEGROUP"

'''Filter by date'''

select * from IDENTIFIER('"DATA_SHARE_DB"."OPTIMA_MANAGED"."HOURSASSIGNMENT"')
WHERE VALIDDATE BETWEEN '2021-01-01' AND '2022-01-01'

'''Filter by ASSIGNMENTNUMBER'''

SELECT * FROM DATA_SHARE_DB.OPTIMA_MANAGED.UNAVAILABILITY where ASSIGNMENTNUMBER = 01674

'''Filter by PAYFLAGNAME'''

SELECT DISTINCT
ha."VALIDDATE",
ha."ASSIGNMENTNUMBER",
hapf."DUTYID" AS "hapf_DUTYID",
hapf."PAYFLAGNAME",
ha."FORENAMES",
ha."SURNAME",
ha."OWNING_UNITCODE",
ha."OWNING_UNITSHORTNAME",
FROM
"OPTIMA"."OPTIMA_MANAGED"."HOURSASSIGNMENT" ha
JOIN
"OPTIMA"."OPTIMA_MANAGED"."HOURSASSIGNMENTPAYFLAG" hapf
ON ha."DUTYID" = hapf."DUTYID"
WHERE
ha."VALIDDATE" BETWEEN '2023-09-01' AND '2025-03-27'
AND (hapf."PAYFLAGNAME" = 'Vend aftentillæg til udbetaling 170' OR hapf."PAYFLAGNAME" = 'Vend nattillæg til udbetaling 178')
ORDER BY
ha."ASSIGNMENTNUMBER";

'''Release mail:'''

"Mark Reckendorff" <mark.reckendorff@regionh.dk>; "Anders Jørgen Rasmussen" <anders.r@rn.dk>; "Jesper Lyngholm Lysgaard" <jesper.lysgaard@herning.dk>; "Ole Jørgensen" <joeo@kolding.dk>; "Thomas Peder Nørgaard Iversen" <ithp@aarhus.dk>; "Ulrik Rievers Buhl" <ulrik.rievers.buhl@regionh.dk>; "Emil Nørgaard Rasmussen" <emil.noergaard.rasmussen@regionh.dk>; "Jakob Mandrup" <jaman@eg.dk>; "Morten Færk Rygaard" <datmr@herning.dk>

"Hej,

Der kommer ny release til Optima Datahub version X.X.X d. XX/XX/XXXX i tidsrummet kl. 14:00-15:00.

Det anbefales ikke at benytte Optima Datahub i det nævnte tidsrum, selvom opdateringen ikke forventer at være forbundet med nedetid.

Vedhæftet er release note.

Ved spørgsmål eller tvivl, må I endelig rette henvendelse til os."

Optima - Datahub

2026-01-06T13:22:44Z

Admin:

Connection string:
"HOST=ds04334.eu-west-1.snowflakecomputing.com;ACCOUNT=ds04334.eu-west-1;USER=RegH;PASSWORD=Wednesday20!;DB=OPTIMA;WAREHOUSE=DWH;",

DSN:

DSN’en skulle DWH stå i Warehouse og ikke i Database

'''SQL examples:'''

'''TARGET'''

SELECT * FROM "DATA_SHARE_DB"."OPTIMA_MANAGED"."NOTEGROUP"

'''Filter by date'''

select * from IDENTIFIER('"DATA_SHARE_DB"."OPTIMA_MANAGED"."HOURSASSIGNMENT"')
WHERE VALIDDATE BETWEEN '2021-01-01' AND '2022-01-01'

'''Filter by ASSIGNMENTNUMBER'''

SELECT * FROM DATA_SHARE_DB.OPTIMA_MANAGED.UNAVAILABILITY where ASSIGNMENTNUMBER = 01674

'''Filter by PAYFLAGNAME'''

SELECT DISTINCT
ha."VALIDDATE",
ha."ASSIGNMENTNUMBER",
hapf."DUTYID" AS "hapf_DUTYID",
hapf."PAYFLAGNAME",
ha."FORENAMES",
ha."SURNAME",
ha."OWNING_UNITCODE",
ha."OWNING_UNITSHORTNAME",
FROM
"OPTIMA"."OPTIMA_MANAGED"."HOURSASSIGNMENT" ha
JOIN
"OPTIMA"."OPTIMA_MANAGED"."HOURSASSIGNMENTPAYFLAG" hapf
ON ha."DUTYID" = hapf."DUTYID"
WHERE
ha."VALIDDATE" BETWEEN '2023-09-01' AND '2025-03-27'
AND (hapf."PAYFLAGNAME" = 'Vend aftentillæg til udbetaling 170' OR hapf."PAYFLAGNAME" = 'Vend nattillæg til udbetaling 178')
ORDER BY
ha."ASSIGNMENTNUMBER";

'''Release mail:'''

"Mark Reckendorff" <mark.reckendorff@regionh.dk>; "Anders Jørgen Rasmussen" <anders.r@rn.dk>; "Jesper Lyngholm Lysgaard" <jesper.lysgaard@herning.dk>; "Ole Jørgensen" <joeo@kolding.dk>; "Thomas Peder Nørgaard Iversen" <ithp@aarhus.dk>; "Ulrik Rievers Buhl" <ulrik.rievers.buhl@regionh.dk>; "Emil Nørgaard Rasmussen" <emil.noergaard.rasmussen@regionh.dk>; "Jakob Mandrup" <jaman@eg.dk>; datmr@herning.dk

"Hej,

Der kommer ny release til Optima Datahub version X.X.X d. XX/XX/XXXX i tidsrummet kl. 14:00-15:00.

Det anbefales ikke at benytte Optima Datahub i det nævnte tidsrum, selvom opdateringen ikke forventer at være forbundet med nedetid.

Vedhæftet er release note.

Ved spørgsmål eller tvivl, må I endelig rette henvendelse til os."