Name: HCPH_COVID_TESTENVIRONMENT

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"HCPH_COVID_TESTENVIRONMENT","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• symptoms_911 (type: esriFieldTypeString, alias: Does patient have severe symptoms, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• call_911 (type: esriFieldTypeString, alias: STOP AND DO NOT PROCEED TO TEST FACILITY: Please direct patient to call 911, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• info_yesverify (type: esriFieldTypeString, alias: Is person a member of vulnerable population (elderly 60+, underlying chronic conditions, etc?), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• info_underlying (type: esriFieldTypeString, alias: Vulnerability Factors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• first_responder (type: esriFieldTypeString, alias: Are you a healthcare worker or first responder?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• responder_type (type: esriFieldTypeString, alias: Which of the below best describe your response field?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• responder_other (type: esriFieldTypeString, alias: Field of Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• symptoms_worsen (type: esriFieldTypeString, alias: Has your temperature or symptoms worsened since completing initial online assessment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• temperature (type: esriFieldTypeString, alias: Temperature, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [temp_1: Temperature above 100.4 °F (38 °C)], [temp_2: Older than 65 and temperature above 99.6 °F (37.5 °C)], [temp_3: I feel feverish], ... 2 more ...)
• vun_popno (type: esriFieldTypeString, alias: Symptoms, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_symptom_onset (type: esriFieldTypeDate, alias: Date of Symptom Onset, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• height (type: esriFieldTypeInteger, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• weight (type: esriFieldTypeInteger, alias: Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bmi (type: esriFieldTypeString, alias: bmi, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bmi_40 (type: esriFieldTypeString, alias: BMI over 40 counts as an underlying condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• onset_exposured (type: esriFieldTypeString, alias: (Travel to restricted areas (CDC Guidance*, local sepcific**), close contact with confirmed COVID19 case (if yes note and refer to epidemiology team), been on a cruise (cruise ships, river ships, etc), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• international_travel (type: esriFieldTypeString, alias: Have you traveled internationally?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• where_int (type: esriFieldTypeString, alias: Where did you travel internationally?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• regional_travel (type: esriFieldTypeString, alias: Have you traveled regionally? i.e adjacent counties, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• where_reg (type: esriFieldTypeString, alias: Where did you travel to regionally?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• domestic_travel (type: esriFieldTypeString, alias: Have you traveled domestically?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• where_dom (type: esriFieldTypeString, alias: Where did you travel domestically?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• close_contact (type: esriFieldTypeString, alias: Have you come into close contact with a confirmed COVID-19 case?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• call_center (type: esriFieldTypeString, alias: Please call the HCPH Epidemiology call center: (832) 927-7575, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• congregate_history (type: esriFieldTypeString, alias: Have you spent any time in a healthcare facility, nursing home, jail, childcare facility, or place of worhsip in the last 14 days?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• test_request (type: esriFieldTypeString, alias: Are you requesting a COVID-19 test?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• request_decline (type: esriFieldTypeString, alias: STOP AND DO NOT PROCEED TO TEST FACILITY: If the caller has declined ensure that they know they will need to resubmit another online assesment to be able to qualify for testing., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• no_symptomsworse (type: esriFieldTypeString, alias: STOP AND DO NOT PROCEED TO TEST FACILITY: Reasurance proceed as usual - reinforce that patient should call before seeking additional care (if symptoms worsen) and provide additional guidance from appropriate health deparment/resources, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• drive_ability (type: esriFieldTypeString, alias: Are you able to drive or be driven to the testing site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• no_ability (type: esriFieldTypeString, alias: Which of the below best describe your difficulty traveling to test site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• travel_ability_note (type: esriFieldTypeString, alias: Please notify caller that a nurse will call them to schedule a home-based test
• no_vehicle_note (type: esriFieldTypeString, alias: Apologies, home-based testing is limited and the current prioritization is on those who are physically unable to leave their homes. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• family_members (type: esriFieldTypeString, alias: Are there additional people associated with you that will require additional tests?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• family_note (type: esriFieldTypeString, alias: EVERY ADDITIONAL PATIENT MUST HAVE A UNIQUE ID # AND RECOMPLETE THE SCREENING/QUALIFICATION PROCEDURE FOR EACH ACCOMPANYING PERSON, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• all_symptoms (type: esriFieldTypeString, alias: Patient has met test criteria - Please proceed , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• language (type: esriFieldTypeString, alias: Language (if not English), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• first_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_birth (type: esriFieldTypeDate, alias: Date of Birth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gender (type: esriFieldTypeString, alias: Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [female: Female], [male: Male], [not_specified: Not Specified])
• race (type: esriFieldTypeString, alias: Race/Ethnicity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [aian: American Indian/Alaskan Native], [asian: Asian], [black_american: Black/African American], ... 4 more ...)
• income (type: esriFieldTypeString, alias: Annual Household Income, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [income8: $24,980 or less], [income7: $24,981 - $33,820], [income6: $33,821 - $42,660], ... 6 more ...)
• insurance (type: esriFieldTypeString, alias: Health Insurance Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [unk: I prefer not to answer], [medicaid_chip: Medicaid/CHIP], [medicare: Medicare], ... 2 more ...)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mobile_phone (type: esriFieldTypeString, alias: What is your Primary Phone number?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_provider (type: esriFieldTypeString, alias: What is your mobile phone provider?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [att: AT&T], [boost_mobile: Boost Mobile], [consumer_cellular: Consumer Cellular], ... 12 more ...)
• insurance_carrier (type: esriFieldTypeString, alias: Insurance Carrier Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• group_number (type: esriFieldTypeString, alias: Group Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• member_number (type: esriFieldTypeString, alias: Member/Individual Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• contact_type (type: esriFieldTypeString, alias: What is your exposure to others who are known to have COVID‑19?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address2 (type: esriFieldTypeString, alias: Address 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• occupation (type: esriFieldTypeString, alias: Occupation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [occupation_1: Food & Beverage], [occupation_2: Hospital & Health Care], [occupation_3: Package / Freight Delivery], ... 5 more ...)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/20/2020 4:13:15 AM

Schema Last Edit Date: 4/20/2020 4:13:15 AM

Data Last Edit Date: 4/20/2020 4:13:15 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat