--DROP TABLE alter_in_kategorien CASCADE;
CREATE TABLE alter_in_kategorien (
alter_in_kategorien_id int NOT NULL PRIMARY KEY,
code varchar(255) NOT NULL,
codeSystem varchar(255) NOT NULL,
displayName varchar(255) NOT NULL,
statusCode varchar(255),
effectiveDate varchar(255),
expirationDate varchar(255),
officialReleaseDate varchar(255),
);
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (1, '0', '1.2.276.0.76.3.1.195.5.100', '0 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (2, '1', '1.2.276.0.76.3.1.195.5.100', '1 Jahr', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (3, '2', '1.2.276.0.76.3.1.195.5.100', '2 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (4, '3', '1.2.276.0.76.3.1.195.5.100', '3 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (5, '4', '1.2.276.0.76.3.1.195.5.100', '4 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (6, '5-9', '1.2.276.0.76.3.1.195.5.100', '5-9 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (7, '10-14', '1.2.276.0.76.3.1.195.5.100', '10-14 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (8, '15-19', '1.2.276.0.76.3.1.195.5.100', '15-19 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (9, '20-24', '1.2.276.0.76.3.1.195.5.100', '20-24 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (10, '25-29', '1.2.276.0.76.3.1.195.5.100', '25-29 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (11, '30-34', '1.2.276.0.76.3.1.195.5.100', '30-34 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (12, '35-39', '1.2.276.0.76.3.1.195.5.100', '35-39 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (13, '40-44', '1.2.276.0.76.3.1.195.5.100', '40-44 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (14, '45-49', '1.2.276.0.76.3.1.195.5.100', '45-49 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (15, '50-54', '1.2.276.0.76.3.1.195.5.100', '50-54 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (16, '55-59', '1.2.276.0.76.3.1.195.5.100', '55-59 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (17, '60-64', '1.2.276.0.76.3.1.195.5.100', '60-64 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (18, '65-69', '1.2.276.0.76.3.1.195.5.100', '65-69 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (19, '70-74', '1.2.276.0.76.3.1.195.5.100', '70-74 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (20, '75-79', '1.2.276.0.76.3.1.195.5.100', '75-79 Jahre', 'active', '2019-12-30T00:00:00', '', '');
INSERT INTO alter_in_kategorien (alter_in_kategorien_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (21, '80+', '1.2.276.0.76.3.1.195.5.100', '80+ Jahre', 'active', '2019-12-30T00:00:00', '', '');