PAT_SVC_PROV_SEARCH_LIST
Description:
This table stores metadata for a list of post-discharge service providers that was given to a patient so that they can indicate their preference. The service providers that are part of the list are in PAT_SVC_PROV_SEARCH_RSLT.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 PAT_ENC_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 CONTINUED_CARE_SERVICE_C_NAME VARCHAR No
The category ID for the service used to generate a list of post-discharge service providers for this patient.
May contain organization-specific values: Yes
Category Entries:
Addiction Outpatient Treatment
Adoption and Foster Care
Adoption and Foster Parenting Support
Adoption and Foster Placement
Adoption Counseling
Adult Daycares
After School Programs
Alternative Education
Alternative Medicine and Therapy
Ambulances
Assisted Living
Assistive Technology
Baby and Toddler Clothes
Baby Supplies
Basic Literacy
Bath Safety Equipment
Bed Positioners
Bed Safety
Beds, Mattresses, and Accessories
Before School Programs
Behavioral Health Services
Behavioral Skills Training
Bereavement
Birth Control
Blankets and Bedding
Blood Sugar Monitors
Books
Burial and Funeral Assistance
Canes
Child Life Services
Child Nutrition Programs
Child Welfare
Childcare
Children's Hospital
Citizenship and Immigration
Cleaning Supplies for the Home
Clothes for School
Clothes for Work
Clothing
Clothing Vouchers
Cognitive Disorder Services
Commode Chairs and Raised Toilet Seats
Community Gardens
Community Transportation Programs
Community Transportation Programs for Medical Appointments
Computer Education
Continuous Passive Motion Machine
Continuous Positive Airway Pressure Devices
Credit Counseling
Crisis Services
Crutches
Cultural Assistance
Daily Life Skills Training
Day Camps
Daytime Care
Dental Care
Dialysis
Diapers
Disability Benefits
Disability Screenings
Disaster Response
Discounted Healthcare
Discrimination and Civil Rights Services
Disease Management
Disease Screenings
Domestic Abuse Support Services
Doulas
Drug Testing
Drug Testing Mobile Unit
Durable Medical Equipment
Early School Preparedness
Eating Disorder Treatment
Education Assistance
Education Financial Aid and Loans
Efficiency and Upgrades for the Home
Elder Community Support/Recreation
Emergency Food
End-of-Life Care
Exercise and Fitness
Exercise Equipment
Exercise Therapy
Exterior Painting
Eye Surgery
Eye Wear
Fall Prevention
Family Counseling
Family Planning
Fans and Air Conditioners
Fertility Services
Financial Aid and Loans
Financial Assistance
Financial Education
Fitness Classes
Food Delivery
Food Insecurity Services
Food Pantry
Foreclosure Counseling
Foreign Language Education
Formula
Free Meals
Furniture
Geriatric Chairs and Accessories
Goods
Government Benefits
Grocery Delivery
Group Home
Guardianship
Gym
Health and Safety for the Home
Health Education
Health Services
Hearing Aids
Hearing Tests
Help Escape Violence
Help Fill Out Forms
Help Find Childcare
Help Find Housing
Help Find Schools
Help Hotlines
Help Understanding Government Programs
Hip Chairs
HIV and AIDS Counseling
HIV and AIDS Services
HIV and AIDS Support Groups
HIV and AIDS Treatment
Home Accessibility Updates
Home Dialysis
Home Exteriors
Home Goods
Home Health Services
Home Hemodialysis
Home Hospice
Home Infusion and Injection
Home Living Aide Services
Home Maintenance and Repairs
Home Medical Social Services
Home Nursing
Home Peritoneal Dialysis
Homebuyer Education
Hospital Beds
Household Assistance
Household Cleaning
Housing Advice
Housing Insecurity Services
Identification Recovery
In-Center Dialysis
In-Center Hemodialysis
In-Center Peritoneal Dialysis
In-Home Meal Preparation
Independent Living
Infusion and IV Therapy
Infusion Clinic
Infusion Pumps and Supplies
In-Home Lab Specimen Collection
Home Rehabilitation
In-Home Oxygen Therapy
In-Home Wound Care
Inpatient Hospice
Inpatient Rehabilitation
Intellectual Disability Education
Intellectual Disability Group Home
Intellectual Disability Self-Care Resources
Intellectual Disability Services
Intellectual Disability Specialists
Intellectual Disability Therapies
Intermediate Care
Job Insecurity Services
Job Placement
Lawn Care
Legal Assistance
Long Term Acute Care
Long Term Detoxification
Long Term Housing
Low-Income Group Home
Manual Wheelchairs
Maternity Care
Mediation
Medical Travel Escort
Medications for Mental Health
Medi-Vans
Memory Care
Mental Health Education
Mental Health Evaluation
Mental Health Hospital Treatment
Mental Health Outpatient Treatment
Mental Health Residential Treatment
Mental Health Services
Midwives
Money Saving Programs
Navigating the System
Nebulizers and Nebulizer Medications
Non-Medical Transportation
Notary
Nursing Home
Nutrition Education
Outpatient Occupational Therapy
Outdoor Home Maintenance
Outpatient Rehabilitation
Overnight Shelter
Oxygen Equipment and Accessories
Pain Management
Palliative Care
Parenting Education
Patient Lifts
Patient Scales
Pediatric Social Services
Pediatric Strollers
Personal Care Items
Personal Care Services
Personal Hygiene
Pest Control
Physical Disability Education
Physical Medicine and Rehabilitation
Outpatient Physical Therapy
Physical Trainer
Post-Trauma Therapy and Support
Post-Acute Care
Post-Adoption Support
Power and Manual Mobility Devices
Pregnancy Tests
Prepared Food Delivery
Preschool
Prescription Assistance
Primary Care
Prosthesis
Public Housing
Public Transportation
Refugee and Immigrant Services
Relationship Counseling
Legal Representation
Reproductive Health Services
Residential Housing
Respite and Relief for Caregivers
Retirement Benefits
Ride Shares
Rural Hospital
Safe Housing
Safe Housing: Children
Safe Housing: Homelessness
Safe Housing: LGBTQ+
Safe Housing: Substance Use
Safe Housing: Women
School Book Assistance
School Equivalency
School Lunch Assistance
Scooters and Accessories
Second Language Learning
Senior Group Home
Severe Mental Illness Group Home
Sexual Health Services
Short Term Detoxification
Short Term Housing
Skilled Nursing
Skills and Training
Snow Plowing
Snow Shoveling
Sober Living Community
Social Care
Social Services
Space Heaters
Special Education
Specialized Training
Outpatient Speech Therapy
Spiritual Support
Steps and Stairs Safety Equipment
STI Prevention and Treatment
Subsidized Automobile Purchasing
Subsidized Public Transportation
Substance Use Recovery Home
Substance Use Counseling
Substance Use Services
Suction Pumps
Supplemental Nutrition Programs
Supplies for School
Supplies for Work
Supported Employment
Tax Preparation
Taxi
Temporary Shelter
Tenant Rights
Toys and Gifts
Traction Equipment
Transfer Equipment
Transportation
Transitional Care Unit
Translation and Interpretation
Transportation for School
Tree Care
Tube Feeding
Tutoring
Unemployment Benefits
Vaccinations
Ventilator Equipment
Ventilator Services
Virtual Support
Vision Tests
Visiting and Companionship
Vision Care
Walkers
Wheelchair Cushions and Accessories
Winter Clothing
Workplace Rights Advocacy
Wound Care
Youth Community Support/Recreation
Youth Group Home
General Psychiatry
General Psychology
Acute Care Hospital
6 SEARCH_LOCATION_TYPE_C_NAME VARCHAR No
The category ID for the type of location used to generate the list of service providers
May contain organization-specific values: No
Category Entries:
Patient Home Address
Patient Work Address
Patient Temp Address
Department Address
Zip Code
City, State
State
Free Text
7 SEARCH_LOCATION VARCHAR No
The location used to generate the list of service providers. The format will vary based on the type of location used to search.
8 SEARCH_RADIUS NUMERIC No
The radius from the location in miles searched to generate the list.
9 USER_ID VARCHAR No
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
10 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 GENERATION_UTC_DTTM DATETIME (UTC) No
The UTC date/time the list of service providers was generated at.
12 SEARCH_LIST_IDENT INTEGER No
An ID for the list of service providers that is unique within the patient encounter it is on. This column is frequently used to link to the PAT_SVC_PROV_SEARCH_RSLT table.
13 SEARCH_LOCATION_CITY VARCHAR No
The city that is part of the location used to generate a list of service providers
14 SEARCH_LOCATION_STATE_C_NAME VARCHAR No
The state that is part of the location used to generate a list of service providers
May contain organization-specific values: Yes
15 SEARCH_LOCATION_ZIP VARCHAR No
The zip code that is part of the location used to generate a list of service providers
16 SEARCH_LOCATION_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
17 SEARCH_LOCATION_FACILITY_ID_LOC_NAME VARCHAR No
The name of the revenue location.
18 PRIMARY_SVC_GROUPER_ID_GROUPER_NAME VARCHAR No
Record name
19 FILTER_BY_AGE_YN VARCHAR No
This item represents whether the service provider list was filtered to exclude facilities ineligible based on patient age.
May contain organization-specific values: No
Category Entries:
No
Yes
20 SENSITIVE_YN VARCHAR No
This represents whether the service provider list is considered sensitive.
The category values for this column were already listed for column: FILTER_BY_AGE_YN