Name: BSD_Health_Survey_3

Display Field: Survey_ID

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Survey_ID (type: esriFieldTypeInteger, alias: Survey ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Are_you_enrolled_in_the_City_s_ (type: esriFieldTypeString, alias: Are you enrolled in the City's medical plan?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Which_plan_are_you_enrolled_in_ (type: esriFieldTypeString, alias: Which plan are you enrolled in?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Who_is_covered_by_your_plan_ (type: esriFieldTypeString, alias: Who is covered by your plan?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Do_you_or_your_spouse_have_acce (type: esriFieldTypeString, alias: Do you or your spouse have access to other health insurance?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Help_us_understand_what_factors (type: esriFieldTypeString, alias: Help us understand what factors played into your choice of coverage. Please place the following factors in order of importance, with one being the most important., SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• F__from_the_plan_ (type: esriFieldTypeString, alias: ) from the plan?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• How_often_do_you_or_your_covere (type: esriFieldTypeString, alias: How often do you or your covered family members, combined, receive prescription medications from the plan?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Please_indicate_your_level_of_a (type: esriFieldTypeString, alias: Please indicate your level of agreement with the following statements., SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Generally__when_it_comes_to_com (type: esriFieldTypeString, alias: Generally, when it comes to compensation and benefits, I place the following in order of importance:, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Place_the_following_in_order_of (type: esriFieldTypeString, alias: Place the following in order of importance to you when you consider choosing a health plan, with 1 being the most important., SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Rate_your_level_of_satisfaction (type: esriFieldTypeString, alias: Rate your level of satisfaction with the following factors of your current health plan:, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___The_medical_serv (type: esriFieldTypeString, alias: Satisfaction - The medical services and prescription drugs covered by the health plan meet my needs, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction____network_of_phys (type: esriFieldTypeString, alias: Satisfaction - network of physicians and pharmacies that I can choose from is adequate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___Whether_there_is (type: esriFieldTypeString, alias: Satisfaction - Whether there is out-of-state coverage, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___How_much_I_under (type: esriFieldTypeString, alias: Satisfaction - How much I understand or feel familiar with a particular health plan, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___The_premium_amou (type: esriFieldTypeString, alias: Satisfaction - The premium amount that is deducted from each of my paychecks, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___The_out_of_pocke (type: esriFieldTypeString, alias: Satisfaction - The out-of-pocket costs that I must pay when I go to the doctor or pharmacy, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___The_contribution (type: esriFieldTypeString, alias: Satisfaction - The contribution that my employer makes to my health savings or reimbursement account, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___The_amount_of_an (type: esriFieldTypeString, alias: Satisfaction - The amount of annual deductible that must be met, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___The_amount_of_th (type: esriFieldTypeString, alias: Satisfaction - The amount of the copays for visits and prescription drugs, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Satisfaction___I_am_satisfied_t (type: esriFieldTypeString, alias: Satisfaction - I am satisfied that my employer's health benefits are the best in our industry, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Do_you_have_access_to_other_hea (type: esriFieldTypeString, alias: Do you have access to other health insurance?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• In_order_to_help_offset_the_inc (type: esriFieldTypeString, alias: In order to help offset the increase in medical costs each year, what would be most likely to consider:, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Moving_to_a_plan_that_ (type: esriFieldTypeString, alias: Offset - Moving to a plan that had fewer physician/provider options (a smaller network), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Paying_more_out_of_poc (type: esriFieldTypeString, alias: Offset - Paying more out of pocket each month for the plan I'm on, including paying more in copays at the doctor or pharmacy, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Going_to_a_low_cost_cl (type: esriFieldTypeString, alias: Offset - Going to a low-cost clinic rather than a doctor's office, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Joining_a_wellness_pro (type: esriFieldTypeString, alias: Offset - Joining a wellness program that had specific requirements in order to keep my monthly premiums low, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Improving_my_physical_ (type: esriFieldTypeString, alias: Offset - Improving my physical and mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Having_my_spouse_obtai (type: esriFieldTypeString, alias: Offset - Having my spouse obtain coverage from their employer for themselves and our family members, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Moving_to_a_lower_cost (type: esriFieldTypeString, alias: Offset - Moving to a lower-cost plan if I could save dollars in my paycheck, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Offset___Driving_further_to_see (type: esriFieldTypeString, alias: Offset - Driving further to see a recommended provider, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Is_there_anything_else_you_d_li (type: esriFieldTypeString, alias: Is there anything else you'd like us to know or consider for our health benefit offerings?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Indicate_your_level_of_agreemen (type: esriFieldTypeString, alias: Indicate your level of agreement with the following statements:, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• I_am_physically_healthy_and_wel (type: esriFieldTypeString, alias: I am physically healthy and well, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_exercise_has_a_major_ef (type: esriFieldTypeString, alias: Lack of exercise has a major effect on my physical health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Stress_at_home_has_a_major_effe (type: esriFieldTypeString, alias: Stress at home has a major effect on my physical health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Stress_at_work_has_a_major_effe (type: esriFieldTypeString, alias: Stress at work has a major effect on my physical health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unhealthy_eating_has_a_major_ef (type: esriFieldTypeString, alias: Unhealthy eating has a major effect on my physical health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_sleep_has_a_major_effec (type: esriFieldTypeString, alias: Lack of sleep has a major effect on my physical health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_access_to_the_physical_ (type: esriFieldTypeString, alias: Lack of access to the physical care I need has a major effect on my physical health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• I_feel_mentally_healthy_and_wel (type: esriFieldTypeString, alias: I feel mentally healthy and well, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_work_life_balance_has_a (type: esriFieldTypeString, alias: Lack of work-life balance has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Feeling_lonely_has_a_major_effe (type: esriFieldTypeString, alias: Feeling lonely has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_purpose_or_direction_in (type: esriFieldTypeString, alias: Lack of purpose or direction in my work has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_purpose_or_direction_at (type: esriFieldTypeString, alias: Lack of purpose or direction at home has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Feeling_burned_out_has_a_major_ (type: esriFieldTypeString, alias: Feeling burned out has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Feeling_emotionally_drained_has (type: esriFieldTypeString, alias: Feeling emotionally drained has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lack_of_access_to_the_mental_he (type: esriFieldTypeString, alias: Lack of access to the mental health care I need has a major effect on my mental health, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Our_organization_contributes_po (type: esriFieldTypeString, alias: Our organization contributes positively to the health and wellness of our employees, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Is_there_anything_else_you_d__1 (type: esriFieldTypeString, alias: Is there anything else you'd like us to know about health and wellness?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• What_is_your_age_ (type: esriFieldTypeString, alias: What is your age?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• With_which_racial_and_ethnic_gr (type: esriFieldTypeString, alias: With which racial and ethnic group do you identify? (select all that apply), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• How_do_you_describe_your_gender (type: esriFieldTypeString, alias: How do you describe your gender identity?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• What_is_your_zip_or_postal_code (type: esriFieldTypeInteger, alias: What is your zip or postal code?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• What_is_your_total_household_in (type: esriFieldTypeString, alias: What is your total household income?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• What_is_your_marital_status_ (type: esriFieldTypeString, alias: What is your marital status?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• How_many_people_live_in_your_ho (type: esriFieldTypeString, alias: How many people live in your household?, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Native_American_Alaskan (type: esriFieldTypeSmallInteger, alias: Native_American_Alaskan, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asian (type: esriFieldTypeSmallInteger, alias: Asian or Asian American, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Black (type: esriFieldTypeSmallInteger, alias: Black or African American, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hispanic (type: esriFieldTypeSmallInteger, alias: Hispanic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hawaiian_Pac_Island (type: esriFieldTypeSmallInteger, alias: Native Hawaiian or Pacific Islander, SQL Type: sqlTypeOther, nullable: true, editable: true)
• White_Caucasian (type: esriFieldTypeSmallInteger, alias: White or Caucasian, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Race_Prefer_Not_to_Say (type: esriFieldTypeSmallInteger, alias: Race - Prefer Not to Say, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Race_Other (type: esriFieldTypeSmallInteger, alias: Race - Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: BSD_Health_Survey_3
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/23/2022 6:16:21 PM

Schema Last Edit Date: 11/23/2022 6:16:21 PM

Data Last Edit Date: 11/23/2022 4:38:11 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat