CREATE TABLE [D060-12-5].[DSAHIST_L402_Handicapleverancer](
  [ModtagerCPRNummer] [varchar](16) COLLATE Norwegian_100_CI_AS NULL,
  [SamletFunktionsVurdering] [varchar](1) COLLATE Norwegian_100_CI_AS NULL,
  [ModtagerYdelsesID] [varchar](100) COLLATE Norwegian_100_CI_AS NULL,
  [ModtagerYdelsekode] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [ModtagerYdelseBetalingskommune] [int] NULL,
  [ModtagerYdelseStartDato] [datetime2](3) NULL,
  [ModtagerYdelseSlutDato] [datetime2](3) NULL,
  [TilbudProduktionsEnhedsNummer] [bigint] NULL,
  [TilbudProduktionsEnhedsNavn] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [TilbudProduktionsEnhedsAdresse] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [TilbudProduktionsEnhedsPostnr] [int] NULL,
  [ModtagerMaalgruppe] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [Source] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [SurveyID] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [FormID] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [Period] [varchar](15) COLLATE Norwegian_100_CI_AS NULL,
  [EntityIDType] [varchar](50) COLLATE Norwegian_100_CI_AS NULL,
  [EntityID] [int] NULL,
  [CommunicationDescription] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [CommunicationDateTime] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [SystemName] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [SystemVersion] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [ContactTypeName] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [ContactIdentifier] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [ContactEmailAddress] [varchar](200) COLLATE Norwegian_100_CI_AS NULL,
  [FFB_ydelses_UUID] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [FFB_tilbuds_UUID] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [AFDELINGS_UUID] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [UNDERTEMA_FUNK] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [DATO_FUNK] [datetime2](3) NULL,
  [AKTIV_VURD] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [UNDERTEMA_AKTIV] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [DATO_AKTIV] [datetime2](3) NULL,
  [UNDERTEMA_AKTIV_MAAL_Indsats] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [MAAL_TYPE] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [FORV_FUNK] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [DATO_MAAL] [datetime2](3) NULL,
  [DATO_OPFOELG] [datetime2](3) NULL,
  [UNDERTEMA_OMGIV] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [DATO_OMGIV] [datetime2](3) NULL,
  [STOETTE_BEHOV] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [DATO_STOETTE] [datetime2](3) NULL,
  [UNDERTEMA_AKTIV_MAAL] [varchar](36) COLLATE Norwegian_100_CI_AS NULL,
  [SYS_KommuneId] [int] NULL,
  [SYS_BatchDate] [datetime2](3) NULL,
  [SYS_RowID] [bigint] identity(1,1) NOT NULL,
  [SYS_ExtractDate] [datetime2](3) NULL,
  [SYS_SourceFileID] [varchar](80) COLLATE Norwegian_100_CI_AS NULL,
  [SYS_RettelserTidAngivelse] [datetime2](3) NULL,
  [SYS_VersionID] [bigint] NULL,
  [SYS_Checksum] AS (CONVERT([bigint],hashbytes('SHA2_256',concat([ModtagerCPRNummer],[SamletFunktionsVurdering],[ModtagerYdelsesID],[ModtagerYdelsekode],[ModtagerYdelseBetalingskommune],[ModtagerYdelseStartDato],[ModtagerYdelseSlutDato],[TilbudProduktionsEnhedsNummer],[TilbudProduktionsEnhedsNavn],[TilbudProduktionsEnhedsAdresse],[TilbudProduktionsEnhedsPostnr],[ModtagerMaalgruppe],[Source],[SurveyID],[FormID],[Period],[EntityIDType],[EntityID],[CommunicationDescription],[CommunicationDateTime],[SystemName],[SystemVersion],[ContactTypeName],[ContactIdentifier],[ContactEmailAddress],[FFB_ydelses_UUID],[FFB_tilbuds_UUID],[AFDELINGS_UUID],[UNDERTEMA_FUNK],[DATO_FUNK],[AKTIV_VURD],[UNDERTEMA_AKTIV],[DATO_AKTIV],[UNDERTEMA_AKTIV_MAAL_Indsats],[MAAL_TYPE],[FORV_FUNK],[DATO_MAAL],[DATO_OPFOELG],[UNDERTEMA_OMGIV],[DATO_OMGIV],[STOETTE_BEHOV],[DATO_STOETTE],[UNDERTEMA_AKTIV_MAAL])),0)) PERSISTED,
  [SYS_ExecutionId] [bigint] NULL,
  [SYS_DataDeliveryBatchId_Create] [bigint] NULL
) 
on sys_batch_date_sc(SYS_BatchDate)
GO

CREATE UNIQUE CLUSTERED INDEX [IDX_CL_D060-12-5_DSAHIST_L402_Handicapleverancer] On [D060-12-5].[DSAHIST_L402_Handicapleverancer] (SYS_BatchDate, SYS_KommuneId, SYS_RowID) with (data_compression = page, STATISTICS_INCREMENTAL = ON) on sys_batch_date_sc(SYS_BatchDate);
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Borgers CPR nummer', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerCPRNummer';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Angiver den samledew funktionsvurdering for borger', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SamletFunktionsVurdering';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'ID nummer, der identificerer ydelsen', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerYdelsesID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'kode for den yydelse som borger modtager', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerYdelsekode';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'kommunekode for betalingskommune', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerYdelseBetalingskommune';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver den dato den pågældende ydelse starter', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerYdelseStartDato';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver den dato den pågældende ydelse er afsluttet. Slutdato skal angives når ydelsen er afsluttet', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerYdelseSlutDato';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver produktionsenheds nummer for det sted, der er anvist til borger. Kan hentes fra tilbudsportalen', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'TilbudProduktionsEnhedsNummer';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver navn for det sted, der er anvist borgeren. Skal kun bruges hvis p-nummer ikke forefindes', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'TilbudProduktionsEnhedsNavn';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver vej og husnummer mv. for de tsted der er anvist til borger. Skal kun bruges hvis p-nummer ikke forefindes', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'TilbudProduktionsEnhedsAdresse';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver postnummer for det sted, der er anvist for borgeren. Skal kun bruges hvis p-nummer ikke forefindes', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'TilbudProduktionsEnhedsPostnr';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'angiver borgerens målgruppe®. Se nærmere under værdiset for dataelementer', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ModtagerMaalgruppe';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'system, der flytter data fra ekstern server til server hos DST. Skal være ""CEMOS""', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'Source';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Entydig ident for dataleverancen i DST. Sskal være ""D100000""', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SurveyID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Navn på leverance: produktionsdata angives ""L402, testdata angives ""T402""', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'FormID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Den senest afsluttede mpåned, inden leverancen sendes', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'Period';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'indberetningsenhedstype. Skal være ""kommune""', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'EntityIDType';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'kommunekode', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'EntityID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'anvendelse af ""communicationdatetime"" (""oprettelse på lokal server"")', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'CommunicationDescription';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'tidspunkt for oprettelse p ålokal server i komunen', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'CommunicationDateTime';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'navn på DHUV-system, som har genereret XML-filerne', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SystemName';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Version af DHUV-system, som har genereret XML-filerne', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SystemVersion';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Følgende 3 tgyper skal altid indberettes: ""faglig ansvarlig"", ""teknisk ansvarlig"", ""kvitteringsmodtager""', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ContactTypeName';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Der skal altid indberettes 3 af denne tyoe. Navn på kontakt', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ContactIdentifier';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Der skal altid indberettes 3 af denne type. Mailadresse på kontakt', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'ContactEmailAddress';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Angiver ID for ydelsen i FFB', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'FFB_ydelses_UUID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Angiver hvilken tilbudstype i FFB, som knytter sig til ydelsen', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'FFB_tilbuds_UUID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Angiver afdelings-UUID. Dette er et autogeneret nummer, som anvendes af Tilbudsportalen', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'AFDELINGS_UUID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'UNDERTEMA_FUNK';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'DATO_FUNK';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'AKTIV_VURD';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'UNDERTEMA_AKTIV';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'DATO_AKTIV';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'UNDERTEMA_AKTIV_MAAL_Indsats';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'MAAL_TYPE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'FORV_FUNK';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'DATO_MAAL';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'DATO_OPFOELG';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'UNDERTEMA_OMGIV';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'DATO_OMGIV';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'STOETTE_BEHOV';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'DATO_STOETTE';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'UNDERTEMA_AKTIV_MAAL';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder nummeret på den kommune, som rækken tilhører', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_KommuneId';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder information om, hvilken batch rækken er indlæst i', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_BatchDate';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder et fortløbende nummer, så alle rækker i tabellen har et unikt nummer', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_RowID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder det dato stempel, som kildefilen er markeret med', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_ExtractDate';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder ID for den primære snitflade, hvor data i rækken stammer fra', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_SourceFileID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder den forretningsmæssige tidsangivelse for rækken. Denne bruges hvis data skal slettes med tidsangivelse', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_RettelserTidAngivelse';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder et versionsnummer for den pågældende række', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_VersionID';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'Dette er en teknisk Kolonne i FLIS. Indeholder cheksum info', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_Checksum';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SysExecutionId', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_ExecutionId';
GO

EXEC sys.sp_addextendedproperty 
@name = N'MS_Description', 
@value = N'SysDataDeliveryBatchIdCreate', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer', 
@level2type = N'COLUMN', @level2name = N'SYS_DataDeliveryBatchId_Create';
GO

EXEC sys.sp_addextendedproperty 
@name = N'DataArea', 
@value = N'voksnehandicappede', 
@level0type = N'SCHEMA', @level0name = N'D060-12-5', 
@level1type = N'TABLE',  @level1name = N'DSAHIST_L402_Handicapleverancer';
GO

