All Layers and Tables (Hosted/service_f87888272109452bb1cea947a02dfa9f)

Layers:

Layer: Dengue_Case_Investigation (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount:

Supported Query Formats:

Min Scale:

Max Scale:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Supports ValidateSQL:

Supports Calculate:

Extent:

Drawing Info:

Renderer:

Simple Renderer:

Symbol:

Style:

Color:

Size:

Angle:

XOffset:

YOffset:

Outline:

Width:

Label:

Description:

Transparency:

Labeling Info:

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
local_id_number ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Local ID Number:, type: esriFieldTypeString )
dengue_severe ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Check One:, type: esriFieldTypeString , Coded Values: [dengue: Dengue] , [severe_dengue: Severe Dengue] )
patient_note ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Please Note: This is an online version of the Dengue/Severe Dengue Case Report. If you use this form, you will have to input this information into CalREDIE in addition to this form., type: esriFieldTypeString )
last_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Last Name, type: esriFieldTypeString )
first_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: First Name, type: esriFieldTypeString )
middle_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Middle Name, type: esriFieldTypeString )
suffix ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Suffix, type: esriFieldTypeString )
date_of_birth ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DOB, type: esriFieldTypeDate )
age ( nullable: true, editable: true, defaultValue: null, alias: Age, type: esriFieldTypeInteger )
age_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Age in:, type: esriFieldTypeString , Coded Values: [years: Years] , [months: Months] , [days: Days] )
country_of_birth ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Country of Birth, type: esriFieldTypeString )
arrival_in_us ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: If not U.S. Born, Date of Arrival in U.S., type: esriFieldTypeDate )
home_telephone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Home Telephone, type: esriFieldTypeString )
cell_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cell Phone, type: esriFieldTypeString )
work_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work/School Phone, type: esriFieldTypeString )
email_address ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Email Address, type: esriFieldTypeString )
other_electronic_contact ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Other Electronic Contact Information, type: esriFieldTypeString )
occupation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Occupation, type: esriFieldTypeString )
work_school ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Work/School, type: esriFieldTypeString )
gender ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Gender, type: esriFieldTypeString )
pregnant ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Pregnant?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
if_pregnant ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: If yes, Est. Delivery Date, type: esriFieldTypeDate )
mrn ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Medical Record Number, type: esriFieldTypeString )
guardian ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Patient's Parent/Guardian, type: esriFieldTypeString )
primary_language ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Primary Language, type: esriFieldTypeString , Coded Values: [english: English] , [spanish: Spanish] , [other: Other] )
language_other ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Other Primary Language, type: esriFieldTypeString )
race ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Race(s), type: esriFieldTypeString )
sex_assigned ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sex Assigned at Birth, type: esriFieldTypeString )
sexual_orientation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sexual Orientation, type: esriFieldTypeString )
physician_last ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Physician - Last Name, type: esriFieldTypeString )
physician_first ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Physician - First Name, type: esriFieldTypeString )
physician_phone ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Physician - Phone Number, type: esriFieldTypeString )
symptomatic ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Symptomatic?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
onset_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Onset Date, type: esriFieldTypeDate )
date_first ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date First Sought Medical Care, type: esriFieldTypeDate )
symptoms ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Symptom List, type: esriFieldTypeString )
if_fever ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If Fever, what was your highest temp?, type: esriFieldTypeString )
if_jointpain ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If joint pain, what joints?, type: esriFieldTypeString )
if_hypotension_a ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If hypotension, Systolic/Diastolic:, type: esriFieldTypeString )
if_hypotension_b ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date measured:, type: esriFieldTypeDate )
other_symptoms ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Other symptoms:, type: esriFieldTypeString )
previous_diagnosis ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Has the patient been previously diagnosed with dengue?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
if_previous ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: If yes, date of diagnosis:, type: esriFieldTypeDate )
serotype ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Serotype (if known), type: esriFieldTypeString , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
er_visit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did the patient visit the emergency room for illness?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
patient_hospitalized ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was the patient hospitalized?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
if_hospitalized_a ( nullable: true, editable: true, defaultValue: null, alias: If yes, how many total nights?, type: esriFieldTypeInteger )
if_hospitalized_b ( nullable: true, editable: true, defaultValue: null, length: 255, alias: During any part of the hospitalization, did the patient stay in an intensive care unit (ICU) or critical care unit (CCU), type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
outcome ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Outcome?, type: esriFieldTypeString , Coded Values: [survived: Survived] , [died: Died] , [Unknown: Unknown] )
if_survived ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: If survived, as of:, type: esriFieldTypeDate )
if_death ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Death:, type: esriFieldTypeDate )
specimen_type1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specimen Type 1, type: esriFieldTypeString , Coded Values: [serum: Serum] , [csf: CSF] , [other: Other] )
specimen_other_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If other:, type: esriFieldTypeString )
laboratory_type1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Laboratory Type, type: esriFieldTypeString , Coded Values: [state_ph: State PH Lab] , [local_ph: Local PH Lab] , [commercial: Commercial Lab] , ...3 more... )
laboratory_other_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If other:, type: esriFieldTypeString )
test_type1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Type of Test, type: esriFieldTypeString , Coded Values: [pcr: PCR] , [elisa_igm: ELISA-IgM] , [elisa_igg: ELISA-IgG] , ...3 more... )
testtype_other_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If other:, type: esriFieldTypeString )
interpretation1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Interpretation, type: esriFieldTypeString , Coded Values: [positive: Positive] , [negative: Negative] , [equivocal: equivocal] )
results1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Results, type: esriFieldTypeString )
collection_date1 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Collection Date, type: esriFieldTypeDate )
laboratory_name1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Laboratory Name, type: esriFieldTypeString )
lab_phone1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Telephone Number, type: esriFieldTypeString )
specimen_type2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Specimen Type 1, type: esriFieldTypeString , Coded Values: [serum: Serum] , [csf: CSF] , [other: Other] )
specimen_other_2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If other:, type: esriFieldTypeString )
laboratory_type2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Laboratory Type, type: esriFieldTypeString , Coded Values: [state_ph: State PH Lab] , [local_ph: Local PH Lab] , [commercial: Commercial Lab] , ...3 more... )
laboratory_other_2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If other:, type: esriFieldTypeString )
test_type2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Type of Test, type: esriFieldTypeString , Coded Values: [pcr: PCR] , [elisa_igm: ELISA-IgM] , [elisa_igg: ELISA-IgG] , ...3 more... )
testtype_other_2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If other:, type: esriFieldTypeString )
interpretation2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Interpretation, type: esriFieldTypeString , Coded Values: [positive: Positive] , [negative: Negative] , [equivocal: equivocal] )
results2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Results, type: esriFieldTypeString )
collection_date2 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Collection Date, type: esriFieldTypeDate )
laboratory_name2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Laboratory Name, type: esriFieldTypeString )
lab_phone2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Telephone Number, type: esriFieldTypeString )
hematology ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hematology, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
hematology_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Collected:, type: esriFieldTypeDate )
wbc ( nullable: true, editable: true, defaultValue: null, length: 255, alias: WBC, type: esriFieldTypeString )
hct ( nullable: true, editable: true, defaultValue: null, length: 255, alias: HCT, type: esriFieldTypeString )
hb ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hb, type: esriFieldTypeString )
platelets ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Platelets, type: esriFieldTypeString )
other_diagnostics ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Other diagnostics performed (e.g., IHC, virus isolation?), type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
if_other_diagnositcs ( nullable: true, editable: true, defaultValue: null, length: 255, alias: If yes, describe, type: esriFieldTypeString )
question_18 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did the patient travel outside Ventura County during the incubation period?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
domestic_trip_1_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Trip #1 Location:, type: esriFieldTypeString )
domestic_trip_1_start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Started:, type: esriFieldTypeDate )
domestic_trip_1_end_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Ended:, type: esriFieldTypeDate )
additional_domestic_trips ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is there a need to enter additional trips?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
domestic_trip_2_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Trip #1 Location:, type: esriFieldTypeString )
domestic_trip_2_start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Started:, type: esriFieldTypeDate )
domestic_trip_2_end_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Ended:, type: esriFieldTypeDate )
question_19 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did the patient travel outside the United States during the incubation period?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
international_trip_1_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Trip #1 Location:, type: esriFieldTypeString )
international_trip_1_start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Started:, type: esriFieldTypeDate )
international_trip_1_end_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Ended:, type: esriFieldTypeDate )
additional_international_trips ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Is there a need to enter additional trips?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
international_trip_2_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Trip #1 Location:, type: esriFieldTypeString )
international_trip_2_start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Started:, type: esriFieldTypeDate )
international_trip_2_end_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Trip #1 Ended:, type: esriFieldTypeDate )
question_20 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Did the patient recall any mosquito bites during the incubation period?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
bite_1_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Location of bite:, type: esriFieldTypeString )
bite_1_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Mosquito Bite:, type: esriFieldTypeDate )
additional_bites_1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Are there additional bites to include?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
bite_2_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Location of bite:, type: esriFieldTypeString )
bite_2_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Mosquito Bite:, type: esriFieldTypeDate )
additional_bites_2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Are there additional bites to include?, type: esriFieldTypeString , Coded Values: [yes: Yes] , [no: No] , [unknown: Unknown] )
bite_3_location ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Location of bite:, type: esriFieldTypeString )
bite_3_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Mosquito Bite:, type: esriFieldTypeDate )
investigator_remarks ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Investigator Notes/Remarks, type: esriFieldTypeString )
created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Name: New Feature
Description:
Prototype:
Drawing Tool: N/A

Relationships:

Dengue_Case_Investigation_hospital_stays (0) -- Related To: hospital_stays (1)

Tables:

Table: hospital_stays (1)