Skip to content

1.0 MVP Help Categories, Additional Fields & their Metadata

Pallavi Chitrada edited this page Mar 11, 2026 · 10 revisions

This page shows all the help categories and their sub-help categories that are part of the 1.0 MVP release. We also list the additional fields that would appear when a help/sub help category is selected.

Last Updated at: 12/04/2025 Updated By: Pallavi Chitrada - Database Lead

Reference Design

Categories of Help Requests

Database Tables

1. help_categories

Defines the hierarchy of help categories using a materialized path.

cat_id cat_name cat_desc
0.0.0.0.0 GENERAL_CATEGORY GENERAL_CATEGORY_DESC
1 FOOD_AND_ESSENTIALS FOOD_AND_ESSENTIALS_DESC
1.1 FOOD_ASSISTANCE FOOD_ASSISTANCE_DESC
1.2 GROCERY_SHOPPING_AND_DELIVERY GROCERY_SHOPPING_AND_DELIVERY_DESC
1.3 COOKING_HELP COOKING_HELP_DESC
1.3.1 MEAL_PREP_BASIC MEAL_PREP_BASIC_DESC
1.3.2 FESTIVE_OR_BULK_COOKING FESTIVE_OR_BULK_COOKING_DESC
1.3.3 NUTRITIONAL_MEAL_PLANNING NUTRITIONAL_MEAL_PLANNING_DESC
1.3.4 CULTURAL_CUISINE_GUIDANCE CULTURAL_CUISINE_GUIDANCE_DESC
1.3.5 OTHER_COOKING_HELP OTHER_COOKING_HELP_DESC
2 CLOTHING_ASSISTANCE CLOTHING_ASSISTANCE_DESC
2.1 DONATE_CLOTHES DONATE_CLOTHES_DESC
2.2 BORROW_CLOTHES BORROW_CLOTHES_DESC
2.3 EMERGENCY_CLOTHING_ASSISTANCE EMERGENCY_CLOTHING_ASSISTANCE_DESC
2.4 TAILORING TAILORING_DESC
3 HOUSING_ASSISTANCE HOUSING_ASSISTANCE_DESC
3.1 LEASE_SUPPORT LEASE_SUPPORT_DESC
3.10 SELL_THINGS SELL_THINGS_DESC
3.2 TENANT_RENT_SUPPORT TENANT_RENT_SUPPORT_DESC
3.3 REPAIR_MAINTENANCE_SUPPORT REPAIR_MAINTENANCE_SUPPORT_DESC
3.3.1 PLUMBING PLUMBING_DESC
3.3.10 MASONRY_OR_CONCRETE MASONRY_OR_CONCRETE_DESC
3.3.11 METALWORK_OR_WELDING METALWORK_OR_WELDING_DESC
3.3.12 POOL_AND_SPA_MAINTENANCE POOL_AND_SPA_MAINTENANCE_DESC
3.3.13 OTHER_REPAIR_MAINTENANCE_SUPPORT OTHER_REPAIR_MAINTENANCE_SUPPORT_DESC
3.3.2 HANDYMAN HANDYMAN_DESC
3.3.3 ELECTRICIAN ELECTRICIAN_DESC
3.3.4 CARPENTRY CARPENTRY_DESC
3.3.5 GARDEN GARDEN_DESC
3.3.6 HVAC_AIR_CONDITIONING HVAC_AIR_CONDITIONING_DESC
3.3.7 ROOFING ROOFING_DESC
3.3.8 LOCKSMITH LOCKSMITH_DESC
3.3.9 PAINTING PAINTING_DESC
3.4 UTILITIES_SETUP_SUPPORT UTILITIES_SETUP_SUPPORT_DESC
3.5 LOOKING_FOR_RENTAL LOOKING_FOR_RENTAL_DESC
3.6 FIND_ROOMATE FIND_ROOMATE_DESC
3.7 MOVE_IN_HELP MOVE_IN_HELP_DESC
3.8 BOOKING_PACKERS_MOVERS_SUPPORT BOOKING_PACKERS_MOVERS_SUPPORT_DESC
3.9 BUY_THINGS BUY_THINGS_DESC
4 EDUCATION_CAREER_SUPPORT EDUCATION_CAREER_SUPPORT_DESC
4.1 COLLEGE_APPLICATION_HELP COLLEGE_APPLICATION_HELP_DESC
4.2 SOP_ESSAY_REVIEW SOP_ESSAY_REVIEW_DESC
4.3 TUTORING TUTORING_DESC
4.3.1 MATH MATH_DESC
4.3.2 ENGLISH ENGLISH_DESC
4.3.3 SCIENCE SCIENCE_DESC
4.3.4 COMPUTER_SCIENCE COMPUTER_SCIENCE_DESC
4.3.5 TEST_PREP TEST_PREP_DESC
4.3.6 OTHER_SUBJECTS OTHER_SUBJECTS_DESC
4.4 SCHOLARSHIP_KNOWLEDGE SCHOLARSHIP_KNOWLEDGE_DESC
4.5 STUDY_GROUP_FORMATION STUDY_GROUP_FORMATION_DESC
4.6 CAREER_GUIDANCE CAREER_GUIDANCE_DESC
4.7 EDUCATION_RESOURCE_SHARING EDUCATION_RESOURCE_SHARING_DESC
5 HEALTHCARE_AND_WELLNESS HEALTHCARE_AND_WELLNESS_DESC
5.1 MEDICAL_CONSULTATION MEDICAL_CONSULTATION_DESC
5.1.1 GENERAL_CONSULTATION GENERAL_CONSULTATION_DESC
5.1.10 PEDIATRICS_OR_CHILD_HEALTH PEDIATRICS_OR_CHILD_HEALTH_DESC
5.1.11 OTHER_MEDICAL_CONCERN OTHER_MEDICAL_CONCERN_DESC
5.1.2 ENT(EAR_NOSE_AND_THROAT) ENT(EAR_NOSE_AND_THROAT)_DESC
5.1.3 DENTAL_OR_ORAL_HEALTH DENTAL_OR_ORAL_HEALTH_DESC
5.1.4 EYE_OR_VISION_CARE EYE_OR_VISION_CARE_DESC
5.1.5 CARDIAC_OR_BLOOD_PRESSURE CARDIAC_OR_BLOOD_PRESSURE_DESC
5.1.6 ORTHOPEDIC_OR_PHYSIOTHERAPY ORTHOPEDIC_OR_PHYSIOTHERAPY_DESC
5.1.7 SKIN_OR_DERMATOLOGY SKIN_OR_DERMATOLOGY_DESC
5.1.8 WOMENS_OR_REPRODUCTIVE_HEALTH WOMENS_OR_REPRODUCTIVE_HEALTH_DESC
5.1.9 VACCINATIONS_AND_PREVENTIVE_SCREENINGS VACCINATIONS_AND_PREVENTIVE_SCREENINGS_DESC
5.2 MEDICINE_DELIVERY MEDICINE_DELIVERY_DESC
5.3 MENTAL_WELLBEING_SUPPORT MENTAL_WELLBEING_SUPPORT_DESC
5.4 MEDICATION_REMINDERS MEDICATION_REMINDERS_DESC
5.5 HEALTH_EDUCATION_GUIDANCE HEALTH_EDUCATION_GUIDANCE_DESC
6 ELDERLY_COMMUNITY_ASSISTANCE ELDERLY_COMMUNITY_ASSISTANCE_DESC
6.1 SENIOR_RELOCATION_SUPPORT SENIOR_RELOCATION_SUPPORT_DESC
6.2 DIGITAL_SUPPORT_FOR_SENIORS DIGITAL_SUPPORT_FOR_SENIORS_DESC
6.3 MEDICATION_MANAGEMENT MEDICATION_MANAGEMENT_DESC
6.4 MEDICAL_DEVICES_SETUP MEDICAL_DEVICES_SETUP_DESC
6.5 ERRANDS_EVENTS_TRANSPORTATION ERRANDS_EVENTS_TRANSPORTATION_DESC
6.6 TRANSPORTATION_APPOINTMENTS_EVENTS TRANSPORTATION_APPOINTMENTS_EVENTS_DESC
6.7 SCHEDULING_APPOINTMENTS_OR_TASKS SCHEDULINGG_APPOINTMENTS_OR_TASKS_DESC
6.8 SOCIAL_CONNECTION SOCIAL_CONNECTION_DESC
6.9 MEAL_SUPPORT MEAL_SUPPORT_DESC

2. help_categories_map

Acts as the base table to determine the parent-child relationship between the help categories.

parent_id child_id
0.0.0.0.0
0.0.0.0.0 1
1 1.1
1 1.2
1 1.3
1.3 1.3.1
1.3 1.3.2
1.3 1.3.3
1.3 1.3.4
1.3 1.3.5
0.0.0.0.0 2
2 2.1
2 2.2
2 2.3
2 2.4
0.0.0.0.0 3
3 3.1
3 3.2
3 3.3
3.3 3.3.1
3.3 3.3.2
3.3 3.3.3
3.3 3.3.4
3.3 3.3.5
3.3 3.3.6
3.3 3.3.7
3.3 3.3.8
3.3 3.3.9
3.3 3.3.10
3.3 3.3.11
3.3 3.3.12
3.3 3.3.13
3 3.4
3 3.5
3 3.6
3 3.7
3 3.8
3 3.9
3 3.10
0.0.0.0.0 4
4 4.1
4 4.2
4 4.3
4.3 4.3.1
4.3 4.3.2
4.3 4.3.3
4.3 4.3.4
4.3 4.3.5
4.3 4.3.6
4 4.4
4 4.5
4 4.6
4 4.7
0.0.0.0.0 5
5 5.1
5.1 5.1.1
5.1 5.1.2
5.1 5.1.3
5.1 5.1.4
5.1 5.1.5
5.1 5.1.6
5.1 5.1.7
5.1 5.1.8
5.1 5.1.9
5.1 5.1.10
5.1 5.1.11
5 5.2
5 5.3
5 5.4
5 5.5
0.0.0.0.0 6
6 6.1
6 6.2
6 6.3
6 6.4
6 6.5
6 6.6
6 6.7
6 6.8
6 6.9

3. req_add_info_metadata

Stores metadata definitions for the dynamic fields required per help category. We call as FIELDS.

field_id field_name_key field_type status cat_id
1.1.A PREFERRED_MEAL_TYPE list active 1.1
1.1.B DIETARY_RESTRICTIONS list active 1.1
1.1.C HOUSEHOLD_SIZE integer active 1.1
1.2.A GROCERY_LIST textbox active 1.2
1.2.B DELIVERY_TIME list active 1.2
1.2.C PAYMENT_METHOD list active 1.2
1.2.D URGENCY_TIMELINE list active 1.2
1.3.1.A RECIPE_PREFERENCE list active 1.3.1
1.3.1.B KITCHEN_EQUIPMENT list active 1.3.1
1.3.1.C URGENCY_TIMELINE list active 1.3.1
1.3.1.D PREFERRED_LANGUGAE textbox active 1.3.1
1.3.2.A RECIPE_PREFERENCE list active 1.3.2
1.3.2.B KITCHEN_EQUIPMENT list active 1.3.2
1.3.2.C URGENCY_TIMELINE list active 1.3.2
1.3.2.D PREFERRED_LANGUGAE textbox active 1.3.2
1.3.3.A RECIPE_PREFERENCE list active 1.3.3
1.3.3.B KITCHEN_EQUIPMENT list active 1.3.3
1.3.3.C URGENCY_TIMELINE list active 1.3.3
1.3.3.D PREFERRED_LANGUGAE textbox active 1.3.3
1.3.4.A RECIPE_PREFERENCE list active 1.3.4
1.3.4.B KITCHEN_EQUIPMENT list active 1.3.4
1.3.4.C URGENCY_TIMELINE list active 1.3.4
1.3.4.D PREFERRED_LANGUGAE textbox active 1.3.4
1.3.5.A RECIPE_PREFERENCE list active 1.3.5
1.3.5.B KITCHEN_EQUIPMENT list active 1.3.5
1.3.5.C URGENCY_TIMELINE list active 1.3.5
1.3.5.D PREFERRED_LANGUGAE textbox active 1.3.5
2.1.A GENDER_CATEGORY list active 2.1
2.1.B TYPE_OF_CLOTHING list active 2.1
2.1.C SIZE list active 2.1
2.1.D CONDITION list active 2.1
2.1.E TOTAL_QUANTITY integer active 2.1
2.2.A ITEM_NAME textbox active 2.2
2.2.B GENDER_CATEGORY list active 2.2
2.2.C TYPE_OF_CLOTHING list active 2.2
2.2.D SIZE list active 2.2
2.2.E CONDITION list active 2.2
2.2.F TOTAL_QUANTITY integer active 2.2
2.2.H BORROW_TYPE list active 2.2
2.2.I PICKUP_DATE_AND_TIME date&time active 2.2
2.3.A GENDER_CATEGORY list active 2.3
2.3.B TYPE_OF_CLOTHING list active 2.3
2.3.C SIZE list active 2.3
2.3.D NUMBER_OF_INDIVIDUALS textbox active 2.3
2.3.E EMERGENCY_TYPE list active 2.3
2.3.F URGENCY_LEVEL list active 2.3
2.4.A GENDER_CATEGORY list active 2.4
2.4.B TYPE_OF_CLOTHING list active 2.4
2.4.C GARMENT_TYPE list active 2.4
2.4.D PREFERRED_METHOD list active 2.4
3.10.A ITEM_CATEGORY list active 3.10
3.10.B AREA_OF_SUPPORT list active 3.10
3.10.C ITEM_CONDITION list active 3.10
3.10.D SALE_TIMELINE list active 3.10
3.1.A AREA_OF_HELP list active 3.1
3.1.B LANGUAGE_DOC_TO_REVIEW list active 3.1
3.1.C URGENCY_TIMELINE list active 3.1
3.2.A AREA_OF_DISPUTE list active 3.2
3.2.B STATUS_OF_DISPUTE list active 3.2
3.2.C DOCUMENTS_AVAILABLE list active 3.2
3.2.D LANGUAGE_OF_SUPPORT textbox active 3.2
3.2.E URGENCY_TIMELINE list active 3.2
3.3.1.A URGENCY_TIMELINE list active 3.3.1
3.3.1.B PREFERRED_TIMELINE list active 3.3.1
3.3.2.A URGENCY_TIMELINE list active 3.3.2
3.3.2.B PREFERRED_TIMELINE list active 3.3.2
3.3.3.A URGENCY_TIMELINE list active 3.3.3
3.3.3.B PREFERRED_TIMELINE list active 3.3.3
3.3.4.A URGENCY_TIMELINE list active 3.3.4
3.3.4.B PREFERRED_TIMELINE list active 3.3.4
3.3.5.A URGENCY_TIMELINE list active 3.3.5
3.3.5.B PREFERRED_TIMELINE list active 3.3.5
3.3.6.A URGENCY_TIMELINE list active 3.3.6
3.3.6.B PREFERRED_TIMELINE list active 3.3.6
3.3.7.A URGENCY_TIMELINE list active 3.3.7
3.3.7.B PREFERRED_TIMELINE list active 3.3.7
3.3.8.A URGENCY_TIMELINE list active 3.3.8
3.3.8.B PREFERRED_TIMELINE list active 3.3.8
3.3.9.A URGENCY_TIMELINE list active 3.3.9
3.3.9.B PREFERRED_TIMELINE list active 3.3.9
3.3.10.A URGENCY_TIMELINE list active 3.3.10
3.3.10.B PREFERRED_TIMELINE list active 3.3.10
3.3.11.A URGENCY_TIMELINE list active 3.3.11
3.3.11.B PREFERRED_TIMELINE list active 3.3.11
3.3.12.A URGENCY_TIMELINE list active 3.3.12
3.3.12.B PREFERRED_TIMELINE list active 3.3.12
3.3.13.A URGENCY_TIMELINE list active 3.3.13
3.3.13.B PREFERRED_TIMELINE list active 3.3.13
3.4.A AREA_OF_SUPPORT list active 3.4
3.4.B TIMELINE_FOR_SUPPORT list active 3.4
3.5.A PROPERTY_TYPE list active 3.5
3.5.B AGREEMENT_TYPE list active 3.5
3.5.C MONTHLY_RENT_BUDGET_RANGE list active 3.5
3.5.D MOVE_IN_TIMELINE list active 3.5
3.5.E ROOMMATE_PREFERENCE list active 3.5
3.5.F NUMBER_OF_PEOPLE_SHARING integer active 3.5
3.5.G NUMBER_OF_BATHROOMS integer active 3.5
3.5.H ADDITIONAL_ROOM_CRITERIA list active 3.5
3.6.A RENTAL_LISTING_TYPE list active 3.6
3.6.B PROPERTY_TYPE list active 3.6
3.6.C LEASE_TYPE list active 3.6
3.6.D MONTHLY_RENT currency active 3.6
3.6.E UTILITIES_INCLUDED list active 3.6
3.6.F AVAILABLE_MOVE_IN list active 3.6
3.6.G NUMBER_OF_PEOPLE_SHARING integer active 3.6
3.6.H ADDITIONAL_ROOM_CRITERIA list active 3.6
3.6.I PREFERRED_GENDER list active 3.6
3.6.J PREFERRED_AGE list active 3.6
3.6.K PROPERTY_RULES list active 3.6
3.7.A TYPE_OF_ASSISTANCE_NEEDED list active 3.7
3.7.B ESTIMATED_MOVING_DATE date&time active 3.7
3.7.C ESTIMATED_DURATION_OF_HELP_NEEDED list active 3.7
3.7.D NEED_FOR_VEHICLE checkbox active 3.7
3.7.E VOLUME_OF_ITEMS_TO_MOVE list active 3.7
3.8.A SERVICE_TYPE list active 3.8
3.8.B ESTIMATED_MOVING_DATE date&time active 3.8
3.8.C VOLUME_OF_ITEMS_TO_MOVE list active 3.8
3.8.D BUDGET_FOR_MOVERS list active 3.8
3.8.E NEED_FOR_INSURANCE_LIABILITY checkbox active 3.8
3.9.A ITEM_CATEGORY list active 3.9
3.9.B AREA_OF_SUPPORT list active 3.9
3.9.C BUDGET_RANGE list active 3.9
3.9.D NEED_FOR_LOGISTICS_TRANSPORT checkbox active 3.9
3.9.E SUPPORT_TIMELINE list active 3.9
3.9.F ITEM_CONDITION list active 3.9
4.1.A AREA_OF_HELP list active 4.1
4.2.A DOCUMENT_TYPE list active 4.2
4.2.B FEEDBACK_TYPE list active 4.2
4.3.1.A TUTORING_FOCUS list active 4.3.1
4.3.1.B GRADE_LEVEL list active 4.3.1
4.3.1.C PREFERRED_TUTORING_FEE list active 4.3.1
4.3.2.A TUTORING_FOCUS list active 4.3.2
4.3.2.B GRADE_LEVEL list active 4.3.2
4.3.2.C PREFERRED_TUTORING_FEE list active 4.3.2
4.3.3.A TUTORING_FOCUS list active 4.3.3
4.3.3.B GRADE_LEVEL list active 4.3.3
4.3.3.C PREFERRED_TUTORING_FEE list active 4.3.3
4.3.4.A TUTORING_FOCUS list active 4.3.4
4.3.4.B GRADE_LEVEL list active 4.3.4
4.3.4.C PREFERRED_TUTORING_FEE list active 4.3.4
4.3.5.A TUTORING_FOCUS list active 4.3.5
4.3.5.B GRADE_LEVEL list active 4.3.5
4.3.5.C PREFERRED_TUTORING_FEE list active 4.3.5
4.3.6.A TUTORING_FOCUS list active 4.3.6
4.3.6.B GRADE_LEVEL list active 4.3.6
4.3.6.C PREFERRED_TUTORING_FEE list active 4.3.6
4.4.A EDUCATION_LEVEL list active 4.4
4.4.B FIELD_OF_STUDY textbox active 4.4
4.4.C FINANCIAL_NEED checkbox active 4.4
4.4.D DOCUMENT_TYPE list active 4.4
4.4.E IS_SPECIAL_CATEGORY checkbox active 4.4
4.5.A GROUP_TYPE list active 4.5
4.5.B SUBJECT_OR_TOPIC textbox active 4.5
4.5.C GROUP_SIZE list active 4.5
4.5.D FREQUENCY list active 4.5
4.6.A TYPE_OF_GUIDANCE list active 4.6
4.6.B SUPPORTING_FILES_TYPE list active 4.6
4.7.A RESOURCE_TYPE list active 4.7
5.1.1.A URGENCY_LEVEL list active 5.1.1
5.1.1.B ACCESSIBILITY_NEEDS list active 5.1.1
5.1.2.A URGENCY_LEVEL list active 5.1.2
5.1.2.B ACCESSIBILITY_NEEDS list active 5.1.2
5.1.3.A URGENCY_LEVEL list active 5.1.3
5.1.3.B ACCESSIBILITY_NEEDS list active 5.1.3
5.1.4.A URGENCY_LEVEL list active 5.1.4
5.1.4.B ACCESSIBILITY_NEEDS list active 5.1.4
5.1.5.A URGENCY_LEVEL list active 5.1.5
5.1.5.B ACCESSIBILITY_NEEDS list active 5.1.5
5.1.6.A URGENCY_LEVEL list active 5.1.6
5.1.6.B ACCESSIBILITY_NEEDS list active 5.1.6
5.1.7.A URGENCY_LEVEL list active 5.1.7
5.1.7.B ACCESSIBILITY_NEEDS list active 5.1.7
5.1.8.A URGENCY_LEVEL list active 5.1.8
5.1.8.B ACCESSIBILITY_NEEDS list active 5.1.8
5.1.9.A URGENCY_LEVEL list active 5.1.9
5.1.9.B ACCESSIBILITY_NEEDS list active 5.1.9
5.1.10.A URGENCY_LEVEL list active 5.1.10
5.1.10.B ACCESSIBILITY_NEEDS list active 5.1.10
5.1.11.A URGENCY_LEVEL list active 5.1.11
5.1.11.B ACCESSIBILITY_NEEDS list active 5.1.11
5.2.A DELIVERY_TYPE list active 5.2
5.2.B PRESCRIPTION_TYPE list active 5.2
5.2.C OTC_CATEGORY list active 5.2
5.2.D DELIVERY_TIME list active 5.2
5.2.E IS_OTC_AND_NON_PRESCRIPTION checkbox active 5.2
5.3.A HELP_TYPE list active 5.3
5.3.B PROVIDER_TYPE list active 5.3
5.3.C TIMEFRAME_TIMEZONE list active 5.3
5.4.A REMINDER_TYPE list active 5.4
5.4.B REMINDER_TIMES time active 5.4
5.4.C REPETITION_SCHEDULE list active 5.4
5.4.D DURATION list active 5.4
5.4.E REMINDER_METHOD list active 5.4
5.5.A EDUCATION_TOPIC list active 5.5
5.5.B PREFERRED_FORMAT list active 5.5
6.1.A DESTINATION_ADDRESS textbox active 6.1
6.1.B PREFERRED_MOVE_OUT_DATE list active 6.1
6.1.C ITEMS_TO_BE_MOVED list active 6.1
6.1.D TYPE_OF_ASSISTANCE_NEEDED list active 6.1
6.2.A ADDITIONAL_INFORMATION list active 6.2
6.3.A SCHEDULE_INFORMATION list active 6.3
6.3.B DOCTOR_PRESCRIPTION checkbox active 6.3
6.3.C REMINDER_TYPE list active 6.3
6.3.D PREFERRED_TIME_SLOTS date&time active 6.3
6.4.A DEVICE_TYPE list active 6.4
6.4.B SETUP_MODE list active 6.4
6.4.C PREFERRED_TIME_SLOTS date&time active 6.4
6.4.D DEVICE_BRAND textbox active 6.4
6.5.A ERRAND_TYPE list active 6.5
6.5.B FREQUENCY list active 6.5
6.5.C PREFERRED_TIME_SLOTS time active 6.5
6.6.A DROP_OFF_LOCATION textbox active 6.6
6.6.B APPOINTMENT_EVENT_TYPE textbox active 6.6
6.6.C APPOINTMENT_EVENT_TIME date&time active 6.6
6.6.D TRIP_TYPE list active 6.6
6.6.E ACCESSIBILITY_NEEDS list active 6.6
6.6.F TRANSPORT_MODE list active 6.6
6.7.A APPOINTMENT_TYPE list active 6.7
6.7.B APPOINTMENT_MODE list active 6.7
6.7.C PREFERRED_TIME_SLOTS date&time active 6.7
6.8.A ACTIVITY list active 6.8
6.8.B FREQUENCY list active 6.8
6.8.C PREFERRED_TIME_SLOTS date&time active 6.8
6.9.A TYPE_OF_HELP_NEEDED list active 6.9
6.9.B PREFERRED_LOCATION textbox active 6.9
6.9.C DIETARY_PREFERENCES list active 6.9
6.9.D FREQUENCY list active 6.9
6.9.E PREFERRED_TIME time active 6.9

4. list_item_metadata

Stores further metadata definitions for the dynamic field required per help category. We call as ITEMS.

item_id field_id item_value item_type
1.1.A.1 1.1.A VEGETARIAN radiobutton
1.1.A.2 1.1.A VEGAN radiobutton
1.1.A.3 1.1.A NON_VEGETARIAN radiobutton
1.1.A.4 1.1.A GLUTEN_FREE radiobutton
1.1.A.5 1.1.A OTHER radiobutton
1.1.B.1 1.1.B DIABETIC_FRIENDLY checkbox
1.1.B.2 1.1.B KOSHER_HALAL checkbox
1.1.B.3 1.1.B NUT_FREE checkbox
1.1.B.4 1.1.B LACTOSE_FREE checkbox
1.1.B.5 1.1.B NONE checkbox
1.1.B.6 1.1.B OTHER checkbox
1.2.B.1 1.2.B MORNING_8AM_TO_12PM radiobutton
1.2.B.2 1.2.B AFTERNOON_12PM _TO_5PM radiobutton
1.2.B.3 1.2.B EVENING_5PM_TO_9PM radiobutton
1.2.C.1 1.2.C VOLUNTEER_PURCHASE_REIMBURSE radiobutton
1.2.C.2 1.2.C GIFT_CARD_VOUCHER radiobutton
1.2.C.3 1.2.C ORGANIZATION_SPONSORED radiobutton
1.2.C.4 1.2.C FREE_ASSISTANCE radiobutton
1.2.D.1 1.2.D IMMEDIATE_NEXT_24HRS radiobutton
1.2.D.2 1.2.D WITHIN_3_DAYS radiobutton
1.2.D.3 1.2.D WITHIN_1_WEEK radiobutton
1.2.D.4 1.2.D FLEXIBLE radiobutton
1.3.1.A.1 1.3.1.A VEGETARIAN radiobutton
1.3.1.A.2 1.3.1.A VEGAN radiobutton
1.3.1.A.3 1.3.1.A HIGH_PROTEIN radiobutton
1.3.1.A.4 1.3.1.A LOW_CARB radiobutton
1.3.1.A.5 1.3.1.A CULTURALLY_SPECIFIC radiobutton
1.3.1.B.1 1.3.1.B STOVE_OR_COOKTOP checkbox
1.3.1.B.2 1.3.1.B OVEN_OR_MICROWAVE checkbox
1.3.1.B.3 1.3.1.B UTENSILS_OR_COOKWARE_SET checkbox
1.3.1.B.4 1.3.1.B MIXER_OR_BLENDER checkbox
1.3.1.B.5 1.3.1.B NONE checkbox
1.3.1.C.1 1.3.1.C IMMEDIATE_NEXT_24_HOURS radiobutton
1.3.1.C.2 1.3.1.C WITHIN_3_DAYS radiobutton
1.3.1.C.3 1.3.1.C WITHIN_1_WEEK radiobutton
1.3.1.C.4 1.3.1.C FLEXIBLE radiobutton
1.3.2.A.1 1.3.2.A VEGETARIAN radiobutton
1.3.2.A.2 1.3.2.A VEGAN radiobutton
1.3.2.A.3 1.3.2.A HIGH_PROTEIN radiobutton
1.3.2.A.4 1.3.2.A LOW_CARB radiobutton
1.3.2.A.5 1.3.2.A CULTURALLY_SPECIFIC radiobutton
1.3.2.B.1 1.3.2.B STOVE_OR_COOKTOP checkbox
1.3.2.B.2 1.3.2.B OVEN_OR_MICROWAVE checkbox
1.3.2.B.3 1.3.2.B UTENSILS_OR_COOKWARE_SET checkbox
1.3.2.B.4 1.3.2.B MIXER_OR_BLENDER checkbox
1.3.2.B.5 1.3.2.B NONE checkbox
1.3.2.C.1 1.3.2.C IMMEDIATE_NEXT_24_HOURS radiobutton
1.3.2.C.2 1.3.2.C WITHIN_3_DAYS radiobutton
1.3.2.C.3 1.3.2.C WITHIN_1_WEEK radiobutton
1.3.2.C.4 1.3.2.C FLEXIBLE radiobutton
1.3.3.A.1 1.3.3.A VEGETARIAN radiobutton
1.3.3.A.2 1.3.3.A VEGAN radiobutton
1.3.3.A.3 1.3.3.A HIGH_PROTEIN radiobutton
1.3.3.A.4 1.3.3.A LOW_CARB radiobutton
1.3.3.A.5 1.3.3.A CULTURALLY_SPECIFIC radiobutton
1.3.3.B.1 1.3.3.B STOVE_OR_COOKTOP checkbox
1.3.3.B.2 1.3.3.B OVEN_OR_MICROWAVE checkbox
1.3.3.B.3 1.3.3.B UTENSILS_OR_COOKWARE_SET checkbox
1.3.3.B.4 1.3.3.B MIXER_OR_BLENDER checkbox
1.3.3.B.5 1.3.3.B NONE checkbox
1.3.3.C.1 1.3.3.C IMMEDIATE_NEXT_24_HOURS radiobutton
1.3.3.C.2 1.3.3.C WITHIN_3_DAYS radiobutton
1.3.3.C.3 1.3.3.C WITHIN_1_WEEK radiobutton
1.3.3.C.4 1.3.3.C FLEXIBLE radiobutton
1.3.4.A.1 1.3.4.A VEGETARIAN radiobutton
1.3.4.A.2 1.3.4.A VEGAN radiobutton
1.3.4.A.3 1.3.4.A HIGH_PROTEIN radiobutton
1.3.4.A.4 1.3.4.A LOW_CARB radiobutton
1.3.4.A.5 1.3.4.A CULTURALLY_SPECIFIC radiobutton
1.3.4.B.1 1.3.4.B STOVE_OR_COOKTOP checkbox
1.3.4.B.2 1.3.4.B OVEN_OR_MICROWAVE checkbox
1.3.4.B.3 1.3.4.B UTENSILS_OR_COOKWARE_SET checkbox
1.3.4.B.4 1.3.4.B MIXER_OR_BLENDER checkbox
1.3.4.B.5 1.3.4.B NONE checkbox
1.3.4.C.1 1.3.4.C IMMEDIATE_NEXT_24_HOURS radiobutton
1.3.4.C.2 1.3.4.C WITHIN_3_DAYS radiobutton
1.3.4.C.3 1.3.4.C WITHIN_1_WEEK radiobutton
1.3.4.C.4 1.3.4.C FLEXIBLE radiobutton
1.3.5.A.1 1.3.5.A VEGETARIAN radiobutton
1.3.5.A.2 1.3.5.A VEGAN radiobutton
1.3.5.A.3 1.3.5.A HIGH_PROTEIN radiobutton
1.3.5.A.4 1.3.5.A LOW_CARB radiobutton
1.3.5.A.5 1.3.5.A CULTURALLY_SPECIFIC radiobutton
1.3.5.B.1 1.3.5.B STOVE_OR_COOKTOP checkbox
1.3.5.B.2 1.3.5.B OVEN_OR_MICROWAVE checkbox
1.3.5.B.3 1.3.5.B UTENSILS_OR_COOKWARE_SET checkbox
1.3.5.B.4 1.3.5.B MIXER_OR_BLENDER checkbox
1.3.5.B.5 1.3.5.B NONE checkbox
1.3.5.C.1 1.3.5.C IMMEDIATE_NEXT_24_HOURS radiobutton
1.3.5.C.2 1.3.5.C WITHIN_3_DAYS radiobutton
1.3.5.C.3 1.3.5.C WITHIN_1_WEEK radiobutton
1.3.5.C.4 1.3.5.C FLEXIBLE radiobutton
2.1.A.1 2.1.A MEN checkbox
2.1.A.2 2.1.A WOMEN checkbox
2.1.A.3 2.1.A UNISEX checkbox
2.1.B.1 2.1.B BABY_0_2_YEARS checkbox
2.1.B.2 2.1.B CHILD_3_12_YEARS checkbox
2.1.B.3 2.1.B TEEN_13_18_YEARS checkbox
2.1.B.4 2.1.B ADULT_19_64_YEARS checkbox
2.1.B.5 2.1.B ELDERLY_65_ABOVE_YEARS checkbox
2.1.C.1 2.1.C XS checkbox
2.1.C.2 2.1.C S checkbox
2.1.C.3 2.1.C M checkbox
2.1.C.4 2.1.C L checkbox
2.1.C.5 2.1.C XL checkbox
2.1.C.6 2.1.C XXL checkbox
2.1.C.7 2.1.C XXXL checkbox
2.1.D.1 2.1.D NEW_WITH_TAGS checkbox
2.1.D.2 2.1.D LIKE_NEW checkbox
2.1.D.3 2.1.D GENTLY_USED checkbox
2.1.D.4 2.1.D WORN_BUT_USABLE checkbox
2.1.D.5 2.1.D NEEDS_REPAIR checkbox
2.2.B.1 2.2.B MEN checkbox
2.2.B.2 2.2.B WOMEN checkbox
2.2.B.3 2.2.B UNISEX checkbox
2.2.C.1 2.2.C BABY_0_2_YEARS checkbox
2.2.C.2 2.2.C CHILD_3_12_YEARS checkbox
2.2.C.3 2.2.C TEEN_13_18_YEARS checkbox
2.2.C.4 2.2.C ADULT_19_64_YEARS checkbox
2.2.C.5 2.2.C ELDERLY_65_ABOVE_YEARS checkbox
2.2.D.1 2.2.D XS checkbox
2.2.D.2 2.2.D S checkbox
2.2.D.3 2.2.D M checkbox
2.2.D.4 2.2.D L checkbox
2.2.D.5 2.2.D XL checkbox
2.2.D.6 2.2.D XXL checkbox
2.2.D.7 2.2.D XXXL checkbox
2.2.E.1 2.2.E NEW_WITH_TAGS checkbox
2.2.E.2 2.2.E LIKE_NEW checkbox
2.2.E.3 2.2.E GENTLY_USED checkbox
2.2.E.4 2.2.E WORN_BUT_CLEAN checkbox
2.2.E.5 2.2.E NEEDS_REPAIR checkbox
2.2.H.1 2.2.H BORROW_TEMPORARILY radiobutton
2.2.H.2 2.2.H REQUEST_AS_DONATION radiobutton
2.3.A.1 2.3.A MEN checkbox
2.3.A.2 2.3.A WOMEN radiobutton
2.3.A.3 2.3.A UNISEX radiobutton
2.3.B.1 2.3.B BABY_0_2_YEARS radiobutton
2.3.B.2 2.3.B CHILD_3_12_YEARS radiobutton
2.3.B.3 2.3.B TEEN_13_18_YEARS radiobutton
2.3.B.4 2.3.B ADULT_19_64_YEARS radiobutton
2.3.B.5 2.3.B ELDERLY_65_ABOVE_YEARS radiobutton
2.3.C.1 2.3.C XS radiobutton
2.3.C.2 2.3.C S radiobutton
2.3.C.3 2.3.C M radiobutton
2.3.C.4 2.3.C L radiobutton
2.3.C.5 2.3.C XL radiobutton
2.3.C.6 2.3.C XXL radiobutton
2.3.C.7 2.3.C XXXL radiobutton
2.3.E.1 2.3.E FLOOD radiobutton
2.3.E.2 2.3.E FIRE radiobutton
2.3.E.3 2.3.E EVICTION radiobutton
2.3.E.4 2.3.E OTHER radiobutton
2.3.F.1 2.3.F IMMEDIATE_LESS_THAN_6HRS radiobutton
2.3.F.2 2.3.F URGENT_LESS_THAN_24HRS radiobutton
2.3.F.3 2.3.F SOON_LESS_THAN_48HRS radiobutton
2.4.A.1 2.4.A MEN checkbox
2.4.A.2 2.4.A WOMEN checkbox
2.4.A.3 2.4.A UNISEX checkbox
2.4.B.1 2.4.B BABY_0_2_YEARS checkbox
2.4.B.2 2.4.B CHILD_3_12_YEARS checkbox
2.4.B.3 2.4.B TEEN_13_18_YEARS checkbox
2.4.B.4 2.4.B ADULT_19_64_YEARS checkbox
2.4.B.5 2.4.B ELDERLY_65_ABOVE_YEARS checkbox
2.4.C.1 2.4.C SHIRT checkbox
2.4.C.2 2.4.C PANTS checkbox
2.4.C.3 2.4.C DRESS checkbox
2.4.C.4 2.4.C SKIRT checkbox
2.4.C.5 2.4.C JACKET_COAT checkbox
2.4.C.6 2.4.C SUIT checkbox
2.4.C.7 2.4.C SAREE_TRADITIONAL_WEAR checkbox
2.4.C.8 2.4.C ACCESSORIES checkbox
2.4.C.9 2.4.C OTHER checkbox
2.4.D.1 2.4.D DROP_OFF radiobutton
2.4.D.2 2.4.D PICK_UP radiobutton
2.4.D.3 2.4.D MAIL_IN radiobutton
3.10.A.1 3.10.A FURNITURE checkbox
3.10.A.2 3.10.A MAJOR_APPLIANCES checkbox
3.10.A.3 3.10.A SMALL_ELECTRONICS checkbox
3.10.A.4 3.10.A KITCHENWARE_COOKWARE checkbox
3.10.A.5 3.10.A GARDENING_OUTDOOR_EQUIPMENT checkbox
3.10.A.6 3.10.A OTHER checkbox
3.10.B.1 3.10.B PRICING_VALUATION_GUIDANCE checkbox
3.10.B.2 3.10.B BEST_SELLING_PLATFORM checkbox
3.10.B.3 3.10.B LISTING_CREATION_PHOTO_TAKING checkbox
3.10.B.4 3.10.B BUYER_COMMUNICATION_SAFETY checkbox
3.10.C.1 3.10.C NEW_WITH_TAGS checkbox
3.10.C.2 3.10.C GENTLY_USED_GOOD_CONDITION checkbox
3.10.C.3 3.10.C USED_WEAR_AND_TEAR checkbox
3.10.C.4 3.10.C NEEDS_REPAIR checkbox
3.10.D.1 3.10.D MUST_GO_IMMEDIATELY textbox
3.10.D.2 3.10.D WITHIN_1_MONTH textbox
3.10.D.3 3.10.D FLEXIBLE textbox
3.1.A.1 3.1.A LEASE_REVIEW_PRE_SIGNING radiobutton
3.1.A.2 3.1.A LEASE_INTERPRETATION_POST_SIGNING radiobutton
3.1.A.3 3.1.A LEASE_TERMINATION_BREAK_CLAUSE_REVIEW radiobutton
3.1.A.4 3.1.A EVICTION_NOTICE_NON_RENEWAL_REVIEW radiobutton
3.1.A.5 3.1.A OTHER radiobutton
3.1.B.1 3.1.B ENGLISH checkbox
3.1.B.2 3.1.B SPANISH checkbox
3.1.B.3 3.1.B MANDARIN checkbox
3.1.B.4 3.1.B FRENCH checkbox
3.1.B.5 3.1.B OTHER checkbox
3.1.C.1 3.1.C IMMEDIATE_NEXT_24_TO_48_HOURS radiobutton
3.1.C.2 3.1.C WITHIN_1_WEEK radiobutton
3.1.C.3 3.1.C WITHIN_1_MONTH radiobutton
3.1.C.4 3.1.C FLEXIBLE radiobutton
3.2.A.1 3.2.A UNLAWFUL_RENT_INCREASE checkbox
3.2.A.2 3.2.A EVICTION_LOCKOUT_ILLEGAL_ACTION checkbox
3.2.A.3 3.2.A HEALTH_SAFETY_MAINTENANCE_ISSUES checkbox
3.2.A.4 3.2.A SECURITY_DEPOSIT_RETURN_DISPUTE checkbox
3.2.A.5 3.2.A DISCRIMINATION_HARASSMENT checkbox
3.2.A.6 3.2.A OTHER_TENANT_RIGHTS_ISSUE checkbox
3.2.B.1 3.2.B INITIAL_CONCERN_REQUESTING_ADVICE radiobutton
3.2.B.2 3.2.B FORMAL_LETTER_NOTICE EXCHANGED radiobutton
3.2.B.3 3.2.B FILED_WITH_HOUSING_TENANCY_BOARD radiobutton
3.2.B.4 3.2.B COURT_LEGAL_ACTION_INITIATED radiobutton
3.2.C.1 3.2.C LEASE_AGREEMENT checkbox
3.2.C.2 3.2.C NOTICE_OF_RENT_INCREASE_EVICTION checkbox
3.2.C.3 3.2.C COMMUNICATION_LOGS checkbox
3.2.C.4 3.2.C PHOTOS_VIDEOS_OF_ISSUE checkbox
3.2.C.5 3.2.C NO_DOCUMENTS_AVAILABLE checkbox
3.2.E.1 3.2.E IMMEDIATE_NEXT_24_TO_48_HOURS radiobutton
3.2.E.2 3.2.E WITHIN_1_WEEK radiobutton
3.2.E.3 3.2.E WITHIN_1_MONTH radiobutton
3.2.E.4 3.2.E FLEXIBLE radiobutton
3.3.1.A.1 3.3.1.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.1.A.2 3.3.1.A URGENT_IN_24_HOURS radiobutton
3.3.1.A.3 3.3.1.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.1.A.4 3.3.1.A FLEXIBLE radiobutton
3.3.1.B.1 3.3.1.B WEEKDAY_MORNINGS checkbox
3.3.1.B.2 3.3.1.B WEEKDAY_AFTERNOONS checkbox
3.3.1.B.3 3.3.1.B EVENINGS checkbox
3.3.1.B.4 3.3.1.B WEEKENDS checkbox
3.3.2.A.1 3.3.2.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.2.A.2 3.3.2.A URGENT_IN_24_HOURS radiobutton
3.3.2.A.3 3.3.2.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.2.A.4 3.3.2.A FLEXIBLE radiobutton
3.3.2.B.1 3.3.2.B WEEKDAY_MORNINGS checkbox
3.3.2.B.2 3.3.2.B WEEKDAY_AFTERNOONS checkbox
3.3.2.B.3 3.3.2.B EVENINGS checkbox
3.3.2.B.4 3.3.2.B WEEKENDS checkbox
3.3.3.A.1 3.3.3.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.3.A.2 3.3.3.A URGENT_IN_24_HOURS radiobutton
3.3.3.A.3 3.3.3.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.3.A.4 3.3.3.A FLEXIBLE radiobutton
3.3.3.B.1 3.3.3.B WEEKDAY_MORNINGS checkbox
3.3.3.B.2 3.3.3.B WEEKDAY_AFTERNOONS checkbox
3.3.3.B.3 3.3.3.B EVENINGS checkbox
3.3.3.B.4 3.3.3.B WEEKENDS checkbox
3.3.4.A.1 3.3.4.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.4.A.2 3.3.4.A URGENT_IN_24_HOURS radiobutton
3.3.4.A.3 3.3.4.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.4.A.4 3.3.4.A FLEXIBLE radiobutton
3.3.4.B.1 3.3.4.B WEEKDAY_MORNINGS checkbox
3.3.4.B.2 3.3.4.B WEEKDAY_AFTERNOONS checkbox
3.3.4.B.3 3.3.4.B EVENINGS checkbox
3.3.4.B.4 3.3.4.B WEEKENDS checkbox
3.3.5.A.1 3.3.5.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.5.A.2 3.3.5.A URGENT_IN_24_HOURS radiobutton
3.3.5.A.3 3.3.5.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.5.A.4 3.3.5.A FLEXIBLE radiobutton
3.3.5.B.1 3.3.5.B WEEKDAY_MORNINGS checkbox
3.3.5.B.2 3.3.5.B WEEKDAY_AFTERNOONS checkbox
3.3.5.B.3 3.3.5.B EVENINGS checkbox
3.3.5.B.4 3.3.5.B WEEKENDS checkbox
3.3.6.A.1 3.3.6.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.6.A.2 3.3.6.A URGENT_IN_24_HOURS radiobutton
3.3.6.A.3 3.3.6.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.6.A.4 3.3.6.A FLEXIBLE radiobutton
3.3.6.B.1 3.3.6.B WEEKDAY_MORNINGS checkbox
3.3.6.B.2 3.3.6.B WEEKDAY_AFTERNOONS checkbox
3.3.6.B.3 3.3.6.B EVENINGS checkbox
3.3.6.B.4 3.3.6.B WEEKENDS checkbox
3.3.7.A.1 3.3.7.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.7.A.2 3.3.7.A URGENT_IN_24_HOURS radiobutton
3.3.7.A.3 3.3.7.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.7.A.4 3.3.7.A FLEXIBLE radiobutton
3.3.7.B.1 3.3.7.B WEEKDAY_MORNINGS checkbox
3.3.7.B.2 3.3.7.B WEEKDAY_AFTERNOONS checkbox
3.3.7.B.3 3.3.7.B EVENINGS checkbox
3.3.7.B.4 3.3.7.B WEEKENDS checkbox
3.3.8.A.1 3.3.8.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.8.A.2 3.3.8.A URGENT_IN_24_HOURS radiobutton
3.3.8.A.3 3.3.8.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.8.A.4 3.3.8.A FLEXIBLE radiobutton
3.3.8.B.1 3.3.8.B WEEKDAY_MORNINGS checkbox
3.3.8.B.2 3.3.8.B WEEKDAY_AFTERNOONS checkbox
3.3.8.B.3 3.3.8.B EVENINGS checkbox
3.3.8.B.4 3.3.8.B WEEKENDS checkbox
3.3.9.A.1 3.3.9.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.9.A.2 3.3.9.A URGENT_IN_24_HOURS radiobutton
3.3.9.A.3 3.3.9.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.9.A.4 3.3.9.A FLEXIBLE radiobutton
3.3.9.B.1 3.3.9.B WEEKDAY_MORNINGS checkbox
3.3.9.B.2 3.3.9.B WEEKDAY_AFTERNOONS checkbox
3.3.9.B.3 3.3.9.B EVENINGS checkbox
3.3.9.B.4 3.3.9.B WEEKENDS checkbox
3.3.10.A.1 3.3.10.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.10.A.2 3.3.10.A URGENT_IN_24_HOURS radiobutton
3.3.10.A.3 3.3.10.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.10.A.4 3.3.10.A FLEXIBLE radiobutton
3.3.10.B.1 3.3.10.B WEEKDAY_MORNINGS checkbox
3.3.10.B.2 3.3.10.B WEEKDAY_AFTERNOONS checkbox
3.3.10.B.3 3.3.10.B EVENINGS checkbox
3.3.10.B.4 3.3.10.B WEEKENDS checkbox
3.3.11.A.1 3.3.11.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.11.A.2 3.3.11.A URGENT_IN_24_HOURS radiobutton
3.3.11.A.3 3.3.11.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.11.A.4 3.3.11.A FLEXIBLE radiobutton
3.3.11.B.1 3.3.11.B WEEKDAY_MORNINGS checkbox
3.3.11.B.2 3.3.11.B WEEKDAY_AFTERNOONS checkbox
3.3.11.B.3 3.3.11.B EVENINGS checkbox
3.3.11.B.4 3.3.11.B WEEKENDS checkbox
3.3.12.A.1 3.3.12.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.12.A.2 3.3.12.A URGENT_IN_24_HOURS radiobutton
3.3.12.A.3 3.3.12.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.12.A.4 3.3.12.A FLEXIBLE radiobutton
3.3.12.B.1 3.3.12.B WEEKDAY_MORNINGS checkbox
3.3.12.B.2 3.3.12.B WEEKDAY_AFTERNOONS checkbox
3.3.12.B.3 3.3.12.B EVENINGS checkbox
3.3.12.B.4 3.3.12.B WEEKENDS checkbox
3.3.13.A.1 3.3.13.A EMERGENCY_LESS_THAN_4_HOURS radiobutton
3.3.13.A.2 3.3.13.A URGENT_IN_24_HOURS radiobutton
3.3.13.A.3 3.3.13.A STANDARD_WITHIN_1_WEEK radiobutton
3.3.13.A.4 3.3.13.A FLEXIBLE radiobutton
3.3.13.B.1 3.3.13.B WEEKDAY_MORNINGS checkbox
3.3.13.B.2 3.3.13.B WEEKDAY_AFTERNOONS checkbox
3.3.13.B.3 3.3.13.B EVENINGS checkbox
3.3.13.B.4 3.3.13.B WEEKENDS checkbox
3.4.A.1 3.4.A UTILITY_CONNECTION checkbox
3.4.A.10 3.4.A GARDEN_CARE checkbox
3.4.A.11 3.4.A OTHER checkbox
3.4.A.2 3.4.A INTERNET_SETUP checkbox
3.4.A.3 3.4.A CABLE_SETUP checkbox
3.4.A.4 3.4.A PHONE_SETUP checkbox
3.4.A.5 3.4.A TV_INSTALLATION checkbox
3.4.A.6 3.4.A WIFI_SETUP checkbox
3.4.A.7 3.4.A FURNITURE_ASSEMBLY_SETUP checkbox
3.4.A.8 3.4.A HOUSEHOLD_GOODS checkbox
3.4.A.9 3.4.A GENERAL_OUTDOOR_MAINTENANCE checkbox
3.4.B.1 3.4.B AVAILABLE_AT_LOCATION radiobutton
3.4.B.2 3.4.B BEFORE_MOVE_IN radiobutton
3.4.B.3 3.4.B POST_MOVE_IN radiobutton
3.4.B.4 3.4.B FLEXIBLE radiobutton
3.5.A.1 3.5.A APARTMENT_CONDO radiobutton
3.5.A.2 3.5.A HOUSE_TOWNHOME radiobutton
3.5.A.3 3.5.A ROOM_SHARED_HOUSING radiobutton
3.5.A.4 3.5.A STUDIO radiobutton
3.5.B.1 3.5.B NEW_LEASE radiobutton
3.5.B.2 3.5.B SUBLET radiobutton
3.5.B.3 3.5.B LEASE_TRANSFER radiobutton
3.5.B.4 3.5.B MONTH_TO_MONTH radiobutton
3.5.B.5 3.5.B DOESNT_MATTER radiobutton
3.5.C.1 3.5.C MINIMUM_BUDGET currency
3.5.C.2 3.5.C MAXIMUM_BUDGET currency
3.5.D.1 3.5.D IMMEDIATELY radiobutton
3.5.D.2 3.5.D WITHIN_1_MONTH radiobutton
3.5.D.3 3.5.D 1_TO_3_MONTHS radiobutton
3.5.D.4 3.5.D FLEXIBLE radiobutton
3.5.E.1 3.5.E SAME_GENDER checkbox
3.5.E.2 3.5.E PET_FRIENDLY checkbox
3.5.E.3 3.5.E NON_SMOKING checkbox
3.5.E.4 3.5.E WORK_SCHEDULE checkbox
3.5.E.5 3.5.E GUEST_POLICY checkbox
3.5.H.1 3.5.H PARKING_SPACE_AVAILABLE checkbox
3.5.H.2 3.5.H FURNITURE_PROVIDED checkbox
3.6.A.1 3.6.A LISTING_A_FULL_UNIT radiobutton
3.6.A.2 3.6.A LISTING_A_ROOM radiobutton
3.6.B.1 3.6.B APARTMENT_CONDO radiobutton
3.6.B.2 3.6.B HOUSE_TOWNHOME radiobutton
3.6.B.3 3.6.B ROOM_SHARED_HOUSING radiobutton
3.6.C.1 3.6.C NEW_LEASE radiobutton
3.6.C.2 3.6.C SUBLET radiobutton
3.6.C.3 3.6.C LEASE_TRANSFER radiobutton
3.6.C.4 3.6.C MONTH_TO_MONTH radiobutton
3.6.C.5 3.6.C DOESNT_MATTER radiobutton
3.6.E.1 3.6.E UTILITED_INCLUDED radiobutton
3.6.E.2 3.6.E UTILITIES_NOT_INCLUDED radiobutton
3.6.E.3 3.6.E UTILITIES_PARTIALLY_INCLUDED radiobutton
3.6.F.1 3.6.F IMMEDIATELY radiobutton
3.6.F.2 3.6.F WITHIN_1_MONTH radiobutton
3.6.F.3 3.6.F 1_TO_3_MONTHS radiobutton
3.6.F.4 3.6.F FLEXIBLE radiobutton
3.6.H.1 3.6.H PRIVATE_BATHROOM checkbox
3.6.H.2 3.6.H PARKING_AVAILABLE checkbox
3.6.H.3 3.6.H FURNITURE_PROVIDED checkbox
3.6.I.1 3.6.I MEN radiobutton
3.6.I.2 3.6.I WOMEN radiobutton
3.6.I.3 3.6.I UNISEX radiobutton
3.6.J.1 3.6.J MIN_AGE integer
3.6.J.2 3.6.J MAX_AGE integer
3.6.K.1 3.6.K PET_FRIENDLY checkbox
3.6.K.2 3.6.K NON_SMOKING checkbox
3.7.A.1 3.7.A PACKING_UNPACKING checkbox
3.7.A.2 3.7.A LOADING_UNLOADING checkbox
3.7.A.3 3.7.A DRIVING_TRANSPORTATION checkbox
3.7.A.4 3.7.A MINOR_ASSEMBLY_SETUP checkbox
3.7.A.5 3.7.A OTHER checkbox
3.7.C.1 3.7.C 1_TO_2_HOURS radiobutton
3.7.C.2 3.7.C 2_TO_4_HOURS radiobutton
3.7.C.3 3.7.C 4_TO_8_HOURS radiobutton
3.7.C.4 3.7.C FULL_DAY radiobutton
3.7.E.1 3.7.E MINIMAL_FEW_BOXES radiobutton
3.7.E.2 3.7.E SMALL_STUDIO_ROOM radiobutton
3.7.E.3 3.7.E MEDIUM_1_BEDROOM radiobutton
3.7.E.4 3.7.E LARGE_2MORE_BEDROOM radiobutton
3.8.A.1 3.8.A FULL_PACKING_AND_MOVING checkbox
3.8.A.2 3.8.A MOVING_ONLY checkbox
3.8.A.3 3.8.A PACKING_ONLY checkbox
3.8.A.4 3.8.A SPECIALTY_ITEM_MOVING checkbox
3.8.C.1 3.8.C MINIMAL_FEW_BOXES textbox
3.8.C.2 3.8.C SMALL_STUDIO_ROOM textbox
3.8.C.3 3.8.C MEDIUM_1_BEDROOM textbox
3.8.C.4 3.8.C LARGE_2_MORE_BEDROOM textbox
3.8.D.1 3.8.D MINIMUM_BUDGET currency
3.8.D.2 3.8.D MAXIMUM_BUDGET currency
3.9.A.1 3.9.A FURNITURE checkbox
3.9.A.2 3.9.A MAJOR_APPLIANCES checkbox
3.9.A.3 3.9.A SMALL_ELECTRONICS checkbox
3.9.A.4 3.9.A KITCHENWARE_COOKWARE checkbox
3.9.A.5 3.9.A GARDENING_OUTDOOR_EQUIPMENT checkbox
3.9.A.6 3.9.A OTHER checkbox
3.9.B.1 3.9.B VALUATION_GUIDANCE checkbox
3.9.B.2 3.9.B CHOOSE_BEST_SELL_PLATFORM checkbox
3.9.B.3 3.9.B CREATE_LISTING checkbox
3.9.B.4 3.9.B BUYER_COMMUNICATION checkbox
3.9.C.1 3.9.C MINIMUM_BUDGET currency
3.9.C.2 3.9.C MAXIMUM_BUDGET currency
3.9.E.1 3.9.E IMMEDIATE_NEXT_48_HOURS radiobutton
3.9.E.2 3.9.E WITHIN_1_WEEK radiobutton
3.9.E.3 3.9.E WITHIN_1_MONTH radiobutton
3.9.E.4 3.9.E FLEXIBLE radiobutton
3.9.F.1 3.9.F NEW_ITEMS_ONLY radiobutton
3.9.F.2 3.9.F USED radiobutton
3.9.F.3 3.9.F REPAIR_OR_REFURBISING radiobutton
3.9.F.4 3.9.F BUDGET_FRIENDLY_OPTIONS radiobutton
4.1.A.1 4.1.A APPLICATION_FORM_GUIDANCE checkbox
4.1.A.2 4.1.A COMMON_APP_OR_COALITION APP_HELP checkbox
4.1.A.3 4.1.A RESUME_BUILDING checkbox
4.1.A.4 4.1.A CHOOSING_MAJORS_OR_COLLEGES checkbox
4.1.A.5 4.1.A INTERVIEW_PREPARATION checkbox
4.2.A.1 4.2.A STATEMENT_OF_PURPOSE_SOP radiobutton
4.2.A.2 4.2.A ADMISSION_ESSAY radiobutton
4.2.A.3 4.2.A SCHOLARSHIP_ESSAY radiobutton
4.2.A.4 4.2.A PERSONAL_STATEMENT radiobutton
4.2.B.1 4.2.B GRAMMAR_AND_SPELLING checkbox
4.2.B.2 4.2.B STRUCTURE_AND_FLOW checkbox
4.2.B.3 4.2.B CONTENT_SUGGESTIONS checkbox
4.2.B.4 4.2.B FULL_REVIEW checkbox
4.3.1.A.1 4.3.1.A CONCEPT_EXPLANATION checkbox
4.3.1.A.2 4.3.1.A PROBLEM_SOLVING_PRACTICE checkbox
4.3.1.A.3 4.3.1.A HOMEWORK_GUIDANCE checkbox
4.3.1.A.4 4.3.1.A EXAM_PREPARATION checkbox
4.3.1.A.5 4.3.1.A PRACTICE_TEST_REVIEW checkbox
4.3.1.B.1 4.3.1.B ELEMENTARY_SCHOOL radiobutton
4.3.1.B.2 4.3.1.B MIDDLE_SCHOOL radiobutton
4.3.1.B.3 4.3.1.B HIGH_SCHOOL radiobutton
4.3.1.B.4 4.3.1.B COLLEGE radiobutton
4.3.1.B.5 4.3.1.B UNIVERSITY radiobutton
4.3.1.B.6 4.3.1.B PHD radiobutton
4.3.1.C.1 4.3.1.C MINIMUM_FEE currency
4.3.1.C.2 4.3.1.C MAXIMUM_FEE currency
4.3.2.A.1 4.3.2.A CONCEPT_EXPLANATION checkbox
4.3.2.A.2 4.3.2.A PROBLEM_SOLVING_PRACTICE checkbox
4.3.2.A.3 4.3.2.A HOMEWORK_GUIDANCE checkbox
4.3.2.A.4 4.3.2.A EXAM_PREPARATION checkbox
4.3.2.A.5 4.3.2.A PRACTICE_TEST_REVIEW checkbox
4.3.2.B.1 4.3.2.B ELEMENTARY_SCHOOL radiobutton
4.3.2.B.2 4.3.2.B MIDDLE_SCHOOL radiobutton
4.3.2.B.3 4.3.2.B HIGH_SCHOOL radiobutton
4.3.2.B.4 4.3.2.B COLLEGE radiobutton
4.3.2.B.5 4.3.2.B UNIVERSITY radiobutton
4.3.2.B.6 4.3.2.B PHD radiobutton
4.3.2.C.1 4.3.2.C MINIMUM_FEE currency
4.3.2.C.2 4.3.2.C MAXIMUM_FEE currency
4.3.3.A.1 4.3.3.A CONCEPT_EXPLANATION checkbox
4.3.3.A.2 4.3.3.A PROBLEM_SOLVING_PRACTICE checkbox
4.3.3.A.3 4.3.3.A HOMEWORK_GUIDANCE checkbox
4.3.3.A.4 4.3.3.A EXAM_PREPARATION checkbox
4.3.3.A.5 4.3.3.A PRACTICE_TEST_REVIEW checkbox
4.3.3.B.1 4.3.3.B ELEMENTARY_SCHOOL radiobutton
4.3.3.B.2 4.3.3.B MIDDLE_SCHOOL radiobutton
4.3.3.B.3 4.3.3.B HIGH_SCHOOL radiobutton
4.3.3.B.4 4.3.3.B COLLEGE radiobutton
4.3.3.B.5 4.3.3.B UNIVERSITY radiobutton
4.3.3.B.6 4.3.3.B PHD radiobutton
4.3.3.C.1 4.3.3.C MINIMUM_FEE currency
4.3.3.C.2 4.3.3.C MAXIMUM_FEE currency
4.3.4.A.1 4.3.4.A CONCEPT_EXPLANATION checkbox
4.3.4.A.2 4.3.4.A PROBLEM_SOLVING_PRACTICE checkbox
4.3.4.A.3 4.3.4.A HOMEWORK_GUIDANCE checkbox
4.3.4.A.4 4.3.4.A EXAM_PREPARATION checkbox
4.3.4.A.5 4.3.4.A PRACTICE_TEST_REVIEW checkbox
4.3.4.B.1 4.3.4.B ELEMENTARY_SCHOOL radiobutton
4.3.4.B.2 4.3.4.B MIDDLE_SCHOOL radiobutton
4.3.4.B.3 4.3.4.B HIGH_SCHOOL radiobutton
4.3.4.B.4 4.3.4.B COLLEGE radiobutton
4.3.4.B.5 4.3.4.B UNIVERSITY radiobutton
4.3.4.B.6 4.3.4.B PHD radiobutton
4.3.4.C.1 4.3.4.C MINIMUM_FEE currency
4.3.4.C.2 4.3.4.C MAXIMUM_FEE currency
4.3.5.A.1 4.3.5.A CONCEPT_EXPLANATION checkbox
4.3.5.A.2 4.3.5.A PROBLEM_SOLVING_PRACTICE checkbox
4.3.5.A.3 4.3.5.A HOMEWORK_GUIDANCE checkbox
4.3.5.A.4 4.3.5.A EXAM_PREPARATION checkbox
4.3.5.A.5 4.3.5.A PRACTICE_TEST_REVIEW checkbox
4.3.5.B.1 4.3.5.B ELEMENTARY_SCHOOL radiobutton
4.3.5.B.2 4.3.5.B MIDDLE_SCHOOL radiobutton
4.3.5.B.3 4.3.5.B HIGH_SCHOOL radiobutton
4.3.5.B.4 4.3.5.B COLLEGE radiobutton
4.3.5.B.5 4.3.5.B UNIVERSITY radiobutton
4.3.5.B.6 4.3.5.B PHD radiobutton
4.3.5.C.1 4.3.5.C MINIMUM_FEE currency
4.3.5.C.2 4.3.5.C MAXIMUM_FEE currency
4.3.6.A.1 4.3.6.A CONCEPT_EXPLANATION checkbox
4.3.6.A.2 4.3.6.A PROBLEM_SOLVING_PRACTICE checkbox
4.3.6.A.3 4.3.6.A HOMEWORK_GUIDANCE checkbox
4.3.6.A.4 4.3.6.A EXAM_PREPARATION checkbox
4.3.6.A.5 4.3.6.A PRACTICE_TEST_REVIEW checkbox
4.3.6.B.1 4.3.6.B ELEMENTARY_SCHOOL radiobutton
4.3.6.B.2 4.3.6.B MIDDLE_SCHOOL radiobutton
4.3.6.B.3 4.3.6.B HIGH_SCHOOL radiobutton
4.3.6.B.4 4.3.6.B COLLEGE radiobutton
4.3.6.B.5 4.3.6.B UNIVERSITY radiobutton
4.3.6.B.6 4.3.6.B PHD radiobutton
4.3.6.C.1 4.3.6.C MINIMUM_FEE currency
4.3.6.C.2 4.3.6.C MAXIMUM_FEE currency
4.4.A.1 4.4.A ELEMENTARY_SCHOOL radiobutton
4.4.A.2 4.4.A MIDDLE_SCHOOL radiobutton
4.4.A.3 4.4.A HIGH_SCHOOL radiobutton
4.4.A.4 4.4.A COLLEGE radiobutton
4.4.A.5 4.4.A UNIVERSITY radiobutton
4.4.A.6 4.4.A PHD radiobutton
4.4.D.1 4.4.D RESUME_CV checkbox
4.4.D.2 4.4.D ACADEMIC_TRANSCRIPTS checkbox
4.4.D.3 4.4.D CERTIFICATES checkbox
4.4.D.4 4.4.D OTHER checkbox
4.5.A.1 4.5.A ACADEMIC radiobutton
4.5.A.2 4.5.A EXAM_PREPARATION radiobutton
4.5.A.3 4.5.A SKILL_DEVELOPMENT radiobutton
4.5.A.4 4.5.A CAREER_DEVELOPMENT radiobutton
4.5.C.1 4.5.C GROUP_SIZE_MIN integer
4.5.C.2 4.5.C GROUP_SIZE_MAX integer
4.5.D.1 4.5.D DAILY radiobutton
4.5.D.2 4.5.D WEEKLY radiobutton
4.6.A.1 4.6.A RESUME_REVIEW checkbox
4.6.A.2 4.6.A MOCK_INTERVIEW checkbox
4.6.A.3 4.6.A JOB_SEARCH_HELP checkbox
4.6.A.4 4.6.A REFERRAL_GUIDANCE checkbox
4.6.A.5 4.6.A LINKEDIN_OPTIMIZATION checkbox
4.6.A.6 4.6.A CAREER_MENTORSHIP checkbox
4.6.B.1 4.6.B RESUME checkbox
4.6.B.2 4.6.B COVER_LETTER checkbox
4.6.B.3 4.6.B OTHER checkbox
4.7.A.1 4.7.A TEXTBOOKS checkbox
4.7.A.2 4.7.A NOTES_PDFS checkbox
4.7.A.3 4.7.A STATIONERY_EQUIPMENT checkbox
4.7.A.4 4.7.A OTHER checkbox
5.1.1.A.1 5.1.1.A WALK_IN_TODAY radiobutton
5.1.1.A.2 5.1.1.A SAME_NEXT_DAY radiobutton
5.1.1.A.3 5.1.1.A WITHIN_A_WEEK radiobutton
5.1.1.A.4 5.1.1.A NO_PREFERENCE radiobutton
5.1.1.B.1 5.1.1.B WHEELCHAIR_ACCESS checkbox
5.1.1.B.2 5.1.1.B STEP_FREE_ENTRY checkbox
5.1.1.B.3 5.1.1.B INTERPRETER_SUPPORT checkbox
5.1.1.B.4 5.1.1.B CAREGIVER_ALLOWED checkbox
5.1.1.B.5 5.1.1.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.1.B.6 5.1.1.B NONE checkbox
5.1.1.B.7 5.1.1.B OTHER checkbox
5.1.2.A.1 5.1.2.A WALK_IN_TODAY radiobutton
5.1.2.A.2 5.1.2.A SAME_NEXT_DAY radiobutton
5.1.2.A.3 5.1.2.A WITHIN_A_WEEK radiobutton
5.1.2.A.4 5.1.2.A NO_PREFERENCE radiobutton
5.1.2.B.1 5.1.2.B WHEELCHAIR_ACCESS checkbox
5.1.2.B.2 5.1.2.B STEP_FREE_ENTRY checkbox
5.1.2.B.3 5.1.2.B INTERPRETER_SUPPORT checkbox
5.1.2.B.4 5.1.2.B CAREGIVER_ALLOWED checkbox
5.1.2.B.5 5.1.2.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.2.B.6 5.1.2.B NONE checkbox
5.1.2.B.7 5.1.2.B OTHER checkbox
5.1.3.A.1 5.1.3.A WALK_IN_TODAY radiobutton
5.1.3.A.2 5.1.3.A SAME_NEXT_DAY radiobutton
5.1.3.A.3 5.1.3.A WITHIN_A_WEEK radiobutton
5.1.3.A.4 5.1.3.A NO_PREFERENCE radiobutton
5.1.3.B.1 5.1.3.B WHEELCHAIR_ACCESS checkbox
5.1.3.B.2 5.1.3.B STEP_FREE_ENTRY checkbox
5.1.3.B.3 5.1.3.B INTERPRETER_SUPPORT checkbox
5.1.3.B.4 5.1.3.B CAREGIVER_ALLOWED checkbox
5.1.3.B.5 5.1.3.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.3.B.6 5.1.3.B NONE checkbox
5.1.3.B.7 5.1.3.B OTHER checkbox
5.1.4.A.1 5.1.4.A WALK_IN_TODAY radiobutton
5.1.4.A.2 5.1.4.A SAME_NEXT_DAY radiobutton
5.1.4.A.3 5.1.4.A WITHIN_A_WEEK radiobutton
5.1.4.A.4 5.1.4.A NO_PREFERENCE radiobutton
5.1.4.B.1 5.1.4.B WHEELCHAIR_ACCESS checkbox
5.1.4.B.2 5.1.4.B STEP_FREE_ENTRY checkbox
5.1.4.B.3 5.1.4.B INTERPRETER_SUPPORT checkbox
5.1.4.B.4 5.1.4.B CAREGIVER_ALLOWED checkbox
5.1.4.B.5 5.1.4.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.4.B.6 5.1.4.B NONE checkbox
5.1.4.B.7 5.1.4.B OTHER checkbox
5.1.5.A.1 5.1.5.A WALK_IN_TODAY radiobutton
5.1.5.A.2 5.1.5.A SAME_NEXT_DAY radiobutton
5.1.5.A.3 5.1.5.A WITHIN_A_WEEK radiobutton
5.1.5.A.4 5.1.5.A NO_PREFERENCE radiobutton
5.1.5.B.1 5.1.5.B WHEELCHAIR_ACCESS checkbox
5.1.5.B.2 5.1.5.B STEP_FREE_ENTRY checkbox
5.1.5.B.3 5.1.5.B INTERPRETER_SUPPORT checkbox
5.1.5.B.4 5.1.5.B CAREGIVER_ALLOWED checkbox
5.1.5.B.5 5.1.5.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.5.B.6 5.1.5.B NONE checkbox
5.1.5.B.7 5.1.5.B OTHER checkbox
5.1.6.A.1 5.1.6.A WALK_IN_TODAY radiobutton
5.1.6.A.2 5.1.6.A SAME_NEXT_DAY radiobutton
5.1.6.A.3 5.1.6.A WITHIN_A_WEEK radiobutton
5.1.6.A.4 5.1.6.A NO_PREFERENCE radiobutton
5.1.6.B.1 5.1.6.B WHEELCHAIR_ACCESS checkbox
5.1.6.B.2 5.1.6.B STEP_FREE_ENTRY checkbox
5.1.6.B.3 5.1.6.B INTERPRETER_SUPPORT checkbox
5.1.6.B.4 5.1.6.B CAREGIVER_ALLOWED checkbox
5.1.6.B.5 5.1.6.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.6.B.6 5.1.6.B NONE checkbox
5.1.6.B.7 5.1.6.B OTHER checkbox
5.1.7.A.1 5.1.7.A WALK_IN_TODAY radiobutton
5.1.7.A.2 5.1.7.A SAME_NEXT_DAY radiobutton
5.1.7.A.3 5.1.7.A WITHIN_A_WEEK radiobutton
5.1.7.A.4 5.1.7.A NO_PREFERENCE radiobutton
5.1.7.B.1 5.1.7.B WHEELCHAIR_ACCESS checkbox
5.1.7.B.2 5.1.7.B STEP_FREE_ENTRY checkbox
5.1.7.B.3 5.1.7.B INTERPRETER_SUPPORT checkbox
5.1.7.B.4 5.1.7.B CAREGIVER_ALLOWED checkbox
5.1.7.B.5 5.1.7.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.7.B.6 5.1.7.B NONE checkbox
5.1.7.B.7 5.1.7.B OTHER checkbox
5.1.8.A.1 5.1.8.A WALK_IN_TODAY radiobutton
5.1.8.A.2 5.1.8.A SAME_NEXT_DAY radiobutton
5.1.8.A.3 5.1.8.A WITHIN_A_WEEK radiobutton
5.1.8.A.4 5.1.8.A NO_PREFERENCE radiobutton
5.1.8.B.1 5.1.8.B WHEELCHAIR_ACCESS checkbox
5.1.8.B.2 5.1.8.B STEP_FREE_ENTRY checkbox
5.1.8.B.3 5.1.8.B INTERPRETER_SUPPORT checkbox
5.1.8.B.4 5.1.8.B CAREGIVER_ALLOWED checkbox
5.1.8.B.5 5.1.8.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.8.B.6 5.1.8.B NONE checkbox
5.1.8.B.7 5.1.8.B OTHER checkbox
5.1.9.A.1 5.1.9.A WALK_IN_TODAY radiobutton
5.1.9.A.2 5.1.9.A SAME_NEXT_DAY radiobutton
5.1.9.A.3 5.1.9.A WITHIN_A_WEEK radiobutton
5.1.9.A.4 5.1.9.A NO_PREFERENCE radiobutton
5.1.9.B.1 5.1.9.B WHEELCHAIR_ACCESS checkbox
5.1.9.B.2 5.1.9.B STEP_FREE_ENTRY checkbox
5.1.9.B.3 5.1.9.B INTERPRETER_SUPPORT checkbox
5.1.9.B.4 5.1.9.B CAREGIVER_ALLOWED checkbox
5.1.9.B.5 5.1.9.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.9.B.6 5.1.9.B NONE checkbox
5.1.9.B.7 5.1.9.B OTHER checkbox
5.1.10.A.1 5.1.10.A WALK_IN_TODAY radiobutton
5.1.10.A.2 5.1.10.A SAME_NEXT_DAY radiobutton
5.1.10.A.3 5.1.10.A WITHIN_A_WEEK radiobutton
5.1.10.A.4 5.1.10.A NO_PREFERENCE radiobutton
5.1.10.B.1 5.1.10.B WHEELCHAIR_ACCESS checkbox
5.1.10.B.2 5.1.10.B STEP_FREE_ENTRY checkbox
5.1.10.B.3 5.1.10.B INTERPRETER_SUPPORT checkbox
5.1.10.B.4 5.1.10.B CAREGIVER_ALLOWED checkbox
5.1.10.B.5 5.1.10.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.10.B.6 5.1.10.B NONE checkbox
5.1.10.B.7 5.1.10.B OTHER checkbox
5.1.11.A.1 5.1.11.A WALK_IN_TODAY radiobutton
5.1.11.A.2 5.1.11.A SAME_NEXT_DAY radiobutton
5.1.11.A.3 5.1.11.A WITHIN_A_WEEK radiobutton
5.1.11.A.4 5.1.11.A NO_PREFERENCE radiobutton
5.1.11.B.1 5.1.11.B WHEELCHAIR_ACCESS checkbox
5.1.11.B.2 5.1.11.B STEP_FREE_ENTRY checkbox
5.1.11.B.3 5.1.11.B INTERPRETER_SUPPORT checkbox
5.1.11.B.4 5.1.11.B CAREGIVER_ALLOWED checkbox
5.1.11.B.5 5.1.11.B SERVICE_ANIMAL_FRIENDLY checkbox
5.1.11.B.6 5.1.11.B NONE checkbox
5.1.11.B.7 5.1.11.B OTHER checkbox
5.2.A.1 5.2.A DELIVERY_OTC_ITEMS radiobutton
5.2.A.2 5.2.A PICKUP_ASSISTANCE radiobutton
5.2.A.3 5.2.A PHARMACY_GUIDANCE radiobutton
5.2.B.1 5.2.B PRESCRIBED radiobutton
5.2.B.2 5.2.B NON_PRESCRIBED radiobutton
5.2.C.1 5.2.C PAIN_RELIEF checkbox
5.2.C.10 5.2.C OTHER checkbox
5.2.C.2 5.2.C COLD_FLU_CARE checkbox
5.2.C.3 5.2.C ALLERGY_RELIEF checkbox
5.2.C.4 5.2.C DIGESTIVE_HEALTH checkbox
5.2.C.5 5.2.C FIRST_AID_WOUND_CARE checkbox
5.2.C.6 5.2.C VITAMINS_SUPPLEMENTS checkbox
5.2.C.7 5.2.C SKIN_CARE_TOPICALS checkbox
5.2.C.8 5.2.C WOMEN_MEN_HEALTH checkbox
5.2.C.9 5.2.C CHILDREN_HEALTH checkbox
5.2.D.1 5.2.D SAME_NEXT_DAY radiobutton
5.2.D.2 5.2.D 3 _4_DAYS radiobutton
5.2.D.3 5.2.D WITHIN_A_WEEK radiobutton
5.2.D.4 5.2.D NO_PREFERENCE radiobutton
5.3.A.1 5.3.A COUNSELING_REFERRAL radiobutton
5.3.A.2 5.3.A PEER_SUPPORT_GROUP radiobutton
5.3.A.3 5.3.A WELLNESS_CLASS_WORKSHOP radiobutton
5.3.A.4 5.3.A SELF_GUIDED_RESOURCES radiobutton
5.3.B.1 5.3.B LICENSED_PROFESSIONAL radiobutton
5.3.B.2 5.3.B PEER_SUPPORT_VOLUNTEER radiobutton
5.3.B.3 5.3.B COMMUNITY_ORGANIZATION radiobutton
5.3.C.1 5.3.C MORNING_9AM_12PM radiobutton
5.3.C.2 5.3.C AFTERNOON_12PM_5PM radiobutton
5.3.C.3 5.3.C EVENING_5PM_9PM radiobutton
5.3.C.4 5.3.C WEEKENDS radiobutton
5.3.C.5 5.3.C FLEXIBLE radiobutton
5.4.A.1 5.4.A MEDICATION_SUPPLEMENT_REMINDER radiobutton
5.4.A.2 5.4.A DOCTOR_APPOINTMENT radiobutton
5.4.A.3 5.4.A TEST_LAB_SCHEDULE radiobutton
5.4.A.4 5.4.A EXERCISE_OR_PHYSICAL_TRAINING_SESSION radiobutton
5.4.A.5 5.4.A CUSTOM_WELLNESS_TASK radiobutton
5.4.C.1 5.4.C ONCE_DAILY radiobutton
5.4.C.2 5.4.C TWICE_DAILY radiobutton
5.4.C.3 5.4.C CUSTOM_TIMES_PER_DAY radiobutton
5.4.C.4 5.4.C SPECIFIC_DAYS_MON_FRI radiobutton
5.4.C.5 5.4.C DAILY radiobutton
5.4.D.1 5.4.D 7 _DAYS radiobutton
5.4.D.2 5.4.D 30_DAYS radiobutton
5.4.D.3 5.4.D CUSTOM_DURATION radiobutton
5.4.E.1 5.4.E SMS radiobutton
5.4.E.2 5.4.E EMAIL radiobutton
5.4.E.3 5.4.E MOBILE_APP radiobutton
5.4.E.4 5.4.E CAREGIVER_NOTIFICATION radiobutton
5.5.A.1 5.5.A NUTRITION_AND_HEALTHY_EATING checkbox
5.5.A.2 5.5.A PHYSICAL_ACTIVITY_AND_MOVEMENT checkbox
5.5.A.3 5.5.A HYGIENE_AND_PERSONAL_CARE checkbox
5.5.A.4 5.5.A PREVENTIVE_HEALTH_TIPS checkbox
5.5.A.5 5.5.A SLEEP_AND_WELlBEING checkbox
5.5.A.6 5.5.A HEALTHY_AGING checkbox
5.5.A.7 5.5.A STRESS_MANAGEMENT_AND_MINDFULNESS checkbox
5.5.A.8 5.5.A GENERAL_WELLNESS_EDUCATION checkbox
5.5.A.9 5.5.A OTHER_NON_CLINICAL checkbox
5.5.B.1 5.5.B ARTICLES checkbox
5.5.B.2 5.5.B VIDEOS checkbox
5.5.B.3 5.5.B INFOGRAPHICS checkbox
5.5.B.4 5.5.B PRINTABLE_GUIDES_PDFS checkbox
5.5.B.5 5.5.B SHORT_TIPS_SUMMARIES checkbox
5.5.B.6 5.5.B SMS_FRIENDLY_LINKS checkbox
5.5.B.7 5.5.B AUDIO_CLIPS_PODCASTS checkbox
5.5.B.8 5.5.B MIXED_FORMAT checkbox
6.1.B.1 6.1.B PRIMARY_SLOT date&time
6.1.B.2 6.1.B ALTERNATE_SLOT date&time
6.1.C.1 6.1.C NUMBER_OF_BOXES checkbox
6.1.C.2 6.1.C FURNITURE_CHECKLIST checkbox
6.1.C.3 6.1.C FRAGILE_ITEMS checkbox
6.1.C.4 6.1.C SPECIAL_HANDLING_NEEDS checkbox
6.1.D.1 6.1.D PACKING checkbox
6.1.D.2 6.1.D TRANSPORT checkbox
6.1.D.3 6.1.D UNPACKING checkbox
6.1.D.4 6.1.D LOADING_UNLOADING checkbox
6.2.A.1 6.2.A APP_NAME textbox
6.2.A.2 6.2.A TYPE_OF_DEVICE textbox
6.2.A.3 6.2.A OPERATING_SYSTEM textbox
6.3.A.1 6.3.A NUMBER_OF_MEDICATIONS integer
6.3.A.2 6.3.A TIMING_PER_DAY integer
6.3.C.1 6.3.C PHONE_CALL radiobutton
6.3.C.2 6.3.C APP_SETUP_HELP radiobutton
6.3.C.3 6.3.C PHYSICAL_VISIT radiobutton
6.4.A.1 6.4.A BLOOD_PRESSURE_MONITOR checkbox
6.4.A.2 6.4.A GLUCOSE_METER checkbox
6.4.A.3 6.4.A PULSE_OXIMETER checkbox
6.4.A.4 6.4.A SMARTWATCH_WEARABLE checkbox
6.4.B.1 6.4.B VIDEO_CALL radiobutton
6.4.B.2 6.4.B HOME_VISIT radiobutton
6.4.B.3 6.4.B REMOTE_STEP_BY_STEP_GUIDE radiobutton
6.5.A.1 6.5.A GROCERY_SHOPPING checkbox
6.5.A.2 6.5.A PHARMACY_PICKUP checkbox
6.5.A.3 6.5.A BILL_PAYMENT checkbox
6.5.A.4 6.5.A GENERAL_STORE checkbox
6.5.B.1 6.5.B ONE_TIME radiobutton
6.5.B.2 6.5.B WEEKLY_MONTHLY radiobutton
6.5.B.3 6.5.B EMERGENCY radiobutton
6.6.D.1 6.6.D ROUND_TRIP radiobutton
6.6.D.2 6.6.D ONE_WAY radiobutton
6.6.D.3 6.6.D WAIT_AND_RETURN radiobutton
6.6.E.1 6.6.E WHEELCHAIR_ACCESSIBLE_VEHICLE checkbox
6.6.E.2 6.6.E NEEDS_HELP_ENTERING_EXITING_VEHICLE checkbox
6.6.E.3 6.6.E USES_WALKER_OR_CANE checkbox
6.6.E.4 6.6.E NO_SPECIAL_NEEDS checkbox
6.6.F.1 6.6.F VOLUNTEER_CAR radiobutton
6.6.F.2 6.6.F ESCORT_IN_PUBLIC_TRANSIT radiobutton
6.6.F.3 6.6.F RIDE_BOOKING_ASSISTANCE radiobutton
6.7.A.1 6.7.A DOCTOR_OR_DENTIST radiobutton
6.7.A.2 6.7.A SOCIAL_SERVICE radiobutton
6.7.A.3 6.7.A BANK_OR_GOVERNMENT radiobutton
6.7.A.4 6.7.A UTILITY_SERVICES radiobutton
6.7.B.1 6.7.B BOOKING_ONLINE radiobutton
6.7.B.2 6.7.B CALLING radiobutton
6.7.B.3 6.7.B GOING_IN_PERSON_WITH_HELP radiobutton
6.8.A.1 6.8.A PHONE_CALL_OR_CHAT checkbox
6.8.A.2 6.8.A WALK_IN_THE_PARK checkbox
6.8.A.3 6.8.A BOARD_GAMES_OR_CARD_GAMES checkbox
6.8.A.4 6.8.A READING_TOGETHER checkbox
6.8.B.1 6.8.B ONE_TIME radiobutton
6.8.B.2 6.8.B WEEKLY_MONTHLY radiobutton
6.8.B.3 6.8.B SPECIFIC_DATES radiobutton
6.9.A.1 6.9.A MEAL_PREP_ASSISTANCE checkbox
6.9.A.2 6.9.A COOKING_TOGETHER checkbox
6.9.A.3 6.9.A SUPERVISION_WHILE_COOKING checkbox
6.9.B.1 6.9.B VOLUNTEERS_HOME radiobutton
6.9.B.2 6.9.B ELDERS_HOME radiobutton
6.9.B.3 6.9.B COMMUNITY_KITCHEN radiobutton
6.9.C.1 6.9.C VEGETARIAN checkbox
6.9.C.2 6.9.C DIABETIC_FRIENDLY checkbox
6.9.C.3 6.9.C LOW_SODIUM checkbox
6.9.C.4 6.9.C NO_PREFERENCE checkbox
6.9.D.1 6.9.D ONE_TIME radiobutton
6.9.D.2 6.9.D WEEKLY_MONTHLY radiobutton
6.9.D.3 6.9.D SPECIFIC_DATES radiobutton

5. req_add_info

Stores the actual field values submitted by users for each request. These values will be generated dynamically, One row per answer.

CREATE TABLE IF NOT EXISTS virginia_dev_saayam_rdbms.req_add_info (
    id               SERIAL        NOT NULL,
    req_id           VARCHAR(255)  NOT NULL,
    field_id         VARCHAR(70)   NOT NULL,
    item_id          VARCHAR(100)  NULL,          -- FK: used for list-type answers
    field_value VARCHAR(255)  NULL,           -- used for string/int/float answers

    PRIMARY KEY (id),
    UNIQUE (req_id, field_id, item_id),            -- prevents duplicate answers

    FOREIGN KEY (req_id)   REFERENCES virginia_dev_saayam_rdbms.request(req_id),
    FOREIGN KEY (field_id) REFERENCES virginia_dev_saayam_rdbms.req_add_info_metadata(field_id),
    FOREIGN KEY (item_id)  REFERENCES virginia_dev_saayam_rdbms.list_item_metadata(item_id)
);

How Data is Inserted

When a request is submitted, for each question/field answered:

field_type in metadata item_id field_value
list e.g. 1.1.A.1 NULL
string / int / float NULL e.g. 4

Rules

  • List-type fields → one row inserted per selected option, referencing item_id from list_item_metadata
  • Field-value fields → one row inserted with the typed value stored in field_value, item_id is NULL
  • Surrogate key (SERIAL id) is used as the primary key to avoid NULL-in-PK issues since item_id can be NULL
  • UNIQUE (req_id, field_id, item_id) constraint prevents duplicate answers from being submitted

Example: REQ-1 Submission

Request: REQ-1 belongs to category 1.1 (Food Assistance)

Answers submitted:

  • 1.1.A (PREFERRED_MEAL_TYPE) → selected VEG and NON-VEG
  • 1.1.C (HOUSEHOLD_SIZE) → typed 4

Insert Statements

-- List-type answers: one row per selected item
INSERT INTO virginia_dev_saayam_rdbms.req_add_info (req_id, field_id, item_id)
VALUES
    ('REQ-1', '1.1.A', '1.1.A.1'),   -- VEG
    ('REQ-1', '1.1.A', '1.1.A.2');   -- NON-VEG

-- Value
INSERT INTO virginia_dev_saayam_rdbms.req_add_info (req_id, field_id, field_value)
VALUES
    ('REQ-1', '1.1.C', '4');          -- Household size

Resulting Rows

id req_id field_id item_id field_value
1 REQ-1 1.1.A 1.1.A.1 NULL
2 REQ-1 1.1.A 1.1.A.2 NULL
3 REQ-1 1.1.C NULL 4

Query to Retrieve Full Answer Details

SELECT
    rai.req_id,
    rai.field_id,
    m.field_name_key          AS question,
    m.field_type,
    l.item_value              AS list_answer,
    rai.field_value
FROM virginia_dev_saayam_rdbms.req_add_info          rai
JOIN virginia_dev_saayam_rdbms.req_add_info_metadata  m  ON rai.field_id = m.field_id
LEFT JOIN virginia_dev_saayam_rdbms.list_item_metadata l  ON rai.item_id  = l.item_id
WHERE rai.req_id = 'REQ-1'
ORDER BY rai.field_id;

Result:

req_id field_id question field_type list_answer field_value
REQ-1 1.1.A PREFERRED_MEAL_TYPE list VEG NULL
REQ-1 1.1.A PREFERRED_MEAL_TYPE list NON-VEG NULL
REQ-1 1.1.C HOUSEHOLD_SIZE int NULL 4

Table Relationship Diagram

request  ──────────────────────────────────────────┐
      │                                             │
      │ (req_id generated here)                     │
      ▼                                             ▼
help_categories                              req_add_info
      │                                             ▲
      ▼                                             │
req_add_info_metadata ──► list_item_metadata ───────┘

The request table will have all the details of a request.

  • request is the parent — owns req_id
  • req_add_info is the child — borrows req_id via FK
  • You can never insert into req_add_info without a valid req_id already existing in the request

Clone this wiki locally