...
Kontroltabellen hedder dbo.tblStagingControlTable og findes i databasen Staging_DWH.
ProcessStatus kan antage følgende værdier:
Loadtabel
Tabellen indeholde. En række pr borger pr besked og følgende felte
...
Loadtabellen kaldes CITIMES_CitizenMessage. Denne oprettes Staging_DWH med følgende indhold
Id | PK, Int not null |
UpdateIdentifier | uniqueIdentifier, not null |
UserTypeIdentifier | Int, not null |
UserIdentifier | Nvarchar(50), not null |
FullName | Nvarchar(300) |
Company | Bit, not null |
ProductionUnitIdentifier | Char(10), null |
CVRnumberIdentifier | Char(8), null |
CompanyContactIdentifier | Uniqueidentifier, null |
OrganisationTypeIdentifier | Int , not null |
OrganisationCode | Nvarchar(128), null |
PersonCivilRegistrationIdentifier | Char(10), not null |
ContextTypeIdentifier | Int, null |
Title | Nvarchar(200) , null |
Text | Nvarchar(max) not null |
CitizenMessageResponseTypeIdentifier | Int, not null |
CitizenMessageChannelTypeIdentifier | Int, not null |
CitizenMessageRecipient | Bit, not null |
OrganisationTypeIdentifier | Int, null |
OrganisationCode | Nvarchar(128), null |
ShowInMessagebox | Bit, not null |
MessageVisibleFromDate | Datetime, null |
MessageVisibleToDate | Datetime, null |
MessageLatestReply | Datetime, null |
MessageImportantIdentifier | Int, not null |
MessageDocumentCollection | Bit, not null |
DocumentID | Uniqueidentifier, null |
DocumentTitle | Nvarchar(260) |
DocumentExtensionIdentifier | Int, null |
DocumentSchemaTypeIdentifier | Int null |
DocumentData | Varbinary(max) , null |
Statuscode | Int, null |
DFDGError | Nvarchar(4000), null |
Batchjob - ProcessCitizenMessagesFromBackend
...
Batchjobbet logger på normal vis.
Kilde:
Uddrag fra epic 884.1 / 2017.