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