--DROP TABLE candidate_loincs CASCADE;
CREATE TABLE candidate_loincs (
candidate_loincs_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 candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (1, 'FLN-11', '1.2.276.0.76.3.1.195.5.98', 'Ungeplante Vorstellung zum gleichen Vorstellungsgrund innerhalb von 28 Tagen', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (2, 'FLN-12', '1.2.276.0.76.3.1.195.5.98', 'Zeit seit letzter Vorstellung zum gleichen Vorstellungsgrund', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (3, 'FLN-13', '1.2.276.0.76.3.1.195.5.98', 'Direkter Arztkontakt', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (4, 'FLN-14', '1.2.276.0.76.3.1.195.5.98', 'Niedrigste GCS-Summe', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (5, 'FLN-15', '1.2.276.0.76.3.1.195.5.98', 'Erste Schmerzmessung', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (6, 'FLN-122', '1.2.276.0.76.3.1.195.5.98', 'CT-/MR-/DS-Angiographie', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (7, 'FLN-123', '1.2.276.0.76.3.1.195.5.98', 'Kombination Typen Verlegung und Entlassung', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (8, 'FLN-124', '1.2.276.0.76.3.1.195.5.98', 'Zeitpunkt Entscheidung zur Verlegung / Entlassung', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (9, 'FLN-125', '1.2.276.0.76.3.1.195.5.98', 'Zeitpunkt Patient verlegungs- / entlassungsfähig', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (10, 'FLN-126', '1.2.276.0.76.3.1.195.5.98', 'Zeitpunkt Patient verlegt / entlassen nach', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (11, 'FLN-127', '1.2.276.0.76.3.1.195.5.98', 'Stunde Beginn patientenbezogene Dokumentation', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (12, 'FLN-128', '1.2.276.0.76.3.1.195.5.98', 'Datum Beginn patientenbezogene Dokumentation', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (13, 'FLN-129', '1.2.276.0.76.3.1.195.5.98', 'Zeit zwischen Ankunft und Aufnahme', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (14, 'FLN-130', '1.2.276.0.76.3.1.195.5.98', 'Zeit zwischen Aufnahme und erster Ersteinschätzung', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (15, 'FLN-131', '1.2.276.0.76.3.1.195.5.98', 'Zeit zwischen Aufnahme und erstem Arztkontakt', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (16, 'FLN-132', '1.2.276.0.76.3.1.195.5.98', 'Zeit zwischen Aufnahme und Verlegungs-/Entlassungsfähigkeit des Patienten', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (17, 'FLN-133', '1.2.276.0.76.3.1.195.5.98', 'Zeit zwischen Aufnahme und Verlassen des Patienten', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (18, 'FLN-134', '1.2.276.0.76.3.1.195.5.98', 'Zeit bis zum Export', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (19, 'FLN-135', '1.2.276.0.76.3.1.195.5.98', 'Name des EDIS', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (20, 'FLN-136', '1.2.276.0.76.3.1.195.5.98', 'Version des EDIS', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (21, 'FLN-137', '1.2.276.0.76.3.1.195.5.98', 'Zeitpunkt Export aus EDIS', 'draft', '2024-04-30T00:00:00', '', '');
INSERT INTO candidate_loincs (candidate_loincs_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
VALUES (22, 'FLN-138', '1.2.276.0.76.3.1.195.5.98', 'Auslandsreise innerhalb der letzten 12 Monate', 'draft', '2024-04-30T00:00:00', '', '');