CodesUsedByImporter
When the data from the input CSVs and XMLs are inserted into the db, it will use the values below for what is actually inserted into the gipse_store table.
Age:
SELECT * FROM gipse_ages where classifier_id=7
701 7 <2 DiSTRIBuTE <2
702 7 2-4 DiSTRIBuTE 2-4
703 7 5-17 DiSTRIBuTE 5-17
704 7 18-44 DiSTRIBuTE 18-44
705 7 45-64 DiSTRIBuTE 45-64
706 7 65+ DiSTRIBuTE 65+
707 7 Unknown DiSTRIBuTE Unknown
Indicator:
SELECT * FROM gipse_indicators where classifier_id=1 (for BioSense originated data)
6 1 Asthma BioSense-Asthma Sub-Syndrome (6)
7 1 Bites, animal BioSense-Bites, animal Sub-Syndrome (7)
9 1 Burns BioSense-Burns Sub-Syndrome (9)
10 1 Carbon monoxide poisoning BioSense-Carbon monoxide poisoning Sub-Syndrome (10)
11 1 Cardiac dysrhythmias BioSense-Cardiac dysrhythmias Sub-Syndrome (11)
13 1 Chest pain BioSense-Chest pain Sub-Syndrome (13)
14 1 CNS, inflammatory disease BioSense-CNS, inflammatory disease Sub-Syndrome (14)
17 1 Convulsions BioSense-Convulsions Sub-Syndrome (17)
18 1 COPD BioSense-COPD Sub-Syndrome (18)
19 1 Cough BioSense-Cough Sub-Syndrome (19)
23 1 Diabetes mellitus BioSense-Diabetes mellitus Sub-Syndrome (23)
24 1 Diarrhea BioSense-Diarrhea Sub-Syndrome (24)
27 1 Dyspnea BioSense-Dyspnea Sub-Syndrome (27)
29 1 Falls BioSense-Chronic Disease Sub-Syndrome (29)
30 1 Fever(Subyndrome) BioSense-Fever(Subyndrome) Sub-Syndrome (30)
32 1 Fractures and dislocation BioSense-Fractures and dislocation Sub-Syndrome (32)
36 1 Heart disease, ischemic BioSense-Heart disease, ischemic Sub-Syndrome (36)
37 1 Heat, excessive BioSense-Heat, excessive Sub-Syndrome (37)
43 1 Injury, NOS BioSense-Injury, NOS Sub-Syndrome (43)
44 1 Insect bites BioSense-Insect bites Sub-Syndrome (44)
46 1 Jaundice BioSense-Jaundice Sub-Syndrome (46)
49 1 Meningismus BioSense-Meningismus Sub-Syndrome (49)
50 1 Mental disorders BioSense-Mental disorders Sub-Syndrome (50)
52 1 Motor vehicle traffic accidents BioSense-Motor vehicle traffic accidents Sub-Syndrome (52)
54 1 Nausea and vomiting BioSense-Nausea and vomiting Sub-Syndrome (54)
62 1 Pneumonia and lung abscess BioSense-Pneumonia and lung abscess Sub-Syndrome (62)
64 1 Pregnancy, childbirth, puerperium co BioSense-Pregnancy, childbirth, puerperium complications Sub-Syndrome (64)
66 1 Rash(Subsyndrome) BioSense-Rash(Subsyndrome) Sub-Syndrome (66)
71 1 Skin infection BioSense-Skin infection Sub-Syndrome (71)
76 1 Upper respiratory infections BioSense-Upper respiratory infections Sub-Syndrome (76)
80 1 Fever BioSense-Fever Syndrome (80)
81 1 Rash BioSense-Rash Syndrome (81)
82 1 Botulism-like BioSense-Botulism-like Syndrome (82)
83 1 Gastrointestinal BioSense-Gastrointestinal (83)
84 1 Hemorrhagic BioSense-Hemorrhagic Syndrome (84)
85 1 Localized Cutaneous Lesion BioSense-Localized Cutaneous Lesion Syndrome (85)
86 1 Lymphadenitis BioSense-Lymphadenitis Syndrome (86)
87 1 Neurological BioSense-Neurological Syndrome (87)
88 1 Respiratory BioSense-Respiratory Syndrome (88)
89 1 Specific Infection BioSense-Specific Infection Syndrome (89)
90 1 Severe Illness or Death BioSense-Severe Illness or Death (90)
91 1 Injury BioSense-Injury Syndrome (91)
92 1 Chronic Disease BioSense-Chronic Disease Syndrome (92)
100 1 ILI2 BioSense-ILI2 Sub-Syndrome (100)
10001 1 EDVisits BioSense-EDVisits
10002 1 EDVisits-LowTemp BioSense-EDVisits With Temperature <100.5
10003 1 EDVisits-HighTemp BioSense-EDVisits With Temperature >100.5
10004 1 EDVisits-Unknown BioSense-EDVisits With Unknown Temperature
10005 1 ILI-b BioSense-ILI-b
10006 1 ILI-b-LowTemp BioSense-ILI-b With Temperature <100.5
10007 1 ILI-b-HighTemp BioSense-ILI-b With Temperature >100.5
10008 1 ILI-b-Unknown BioSense-ILI-b With Unknown Temperature
10009 1 ILI-n BioSense-ILI-n
10010 1 ILI-n-LowTemp BioSense-ILI-n With Temperature <100.5
10011 1 ILI-n-HighTemp BioSense-ILI-n With Temperature >100.5
10012 1 ILI-n-Unknown BioSense-ILI-n With Unknown Temperature
Specifically:
Indicator #10001 is used for EDVisits without a temperature value in the CSV,
Indicator #10002 is used for EDVisits with temperature value=1 (low) in the CSV,
Indicator #10003 is used for EDVisits with temperature value=2 (high) in the CSV,
Indicator #10004 is used for EDVisits with temperature value=3 (unknown) in the CSV,
Indicator #10005 is used for ILI-b without a temperature value in the CSV,
Indicator #10006 is used for ILI-b with temperature value=1 (low) in the CSV,
Indicator #10007 is used for ILI-b with temperature value=2 (high) in the CSV,
Indicator #10008 is used for ILI-b with temperature value=3 (unknown) in the CSV,
Indicator #10009 is used for ILI-n without a temperature value in the CSV,
Indicator #10010 is used for ILI-n with temperature value=1 (low) in the CSV,
Indicator #10011 is used for ILI-n with temperature value=2 (high) in the CSV,
Indicator #10012 is used for ILI-n with temperature value=3 (unknown) in the CSV.
Temperature data is only stored in the repository for EDVisits and ILI-b/ILI-n indicators.
SELECT * FROM gipse_indicators where classifier_id=7 (for DiSTRIBuTE/State originated data)
70001 7 EDVisits DiSTRIBuTE-Denominator for total ED Visits
70002 7 EDVisits-LowTemp DiSTRIBuTE-Denominator for total ED Visits with temperature under 100.5
70003 7 EDVisits-HighTemp DiSTRIBuTE-Denominator for total ED Visits with temperature 100.5 or greater
70004 7 EDVisits-UnknownTemp DiSTRIBuTE-Denominator for total ED Visits with unknown temperature
70005 7 ILI-b DiSTRIBuTE-ILI broad definition
70006 7 ILI-b-LowTemp DiSTRIBuTE-ILI broad definition with temperature under 100.5
70007 7 ILI-b-HighTemp DiSTRIBuTE-ILI broad definition with temperature 100.5 or greater
70008 7 ILI-b-UnknownTemp DiSTRIBuTE-ILI broad definition with unknown temperature
70009 7 ILI-n DiSTRIBuTE-ILI narrow definition
70010 7 ILI-n-LowTemp DiSTRIBuTE-ILI narrow definition with temperature under 100.5
70011 7 ILI-n-HighTemp DiSTRIBuTE-ILI narrow definition with temperature 100.5 or greater
70012 7 ILI-n-UnknownTemp DiSTRIBuTE-ILI narrow definition with unknown temperature
70013 7 GI-b DiSTRIBuTE-GI broad definition
70014 7 GI-b-LowTemp DiSTRIBuTE-GI broad definition with temperature under 100.5
70015 7 GI-b-HighTemp DiSTRIBuTE-GI broad definition with temperature 100.5 or greater
70016 7 GI-b-UnknownTemp DiSTRIBuTE-GI broad definition with unknown temperature
70017 7 GI-n DiSTRIBuTE-GI narrow definition
70018 7 GI-n-LowTemp DiSTRIBuTE-GI narrow definition with temperature under 100.5
70019 7 GI-n-HighTemp DiSTRIBuTE-GI narrow definition with temperature 100.5 or greater
70020 7 GI-n-UnknownTemp DiSTRIBuTE-GI narrow definition with unknown temperature
Service Area:
SELECT * from gipse_service_areas where classifier_id=1
1 1 Admit BioSense Admit Disposition
2 1 Discharge BioSense Discharge Disposition
3 1 Transfer BioSense Transfer Disposition
4 1 Left BioSense Left Disposition
5 1 Expiration BioSense Expiration Disposition
6 1 Unknown BioSense Unknown Disposition