DP_SELECTED_SERVICE
Description:
This table represents services selected for continued care and services coordination.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
GROUP_LINE 2
VALUE_LINE 3

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 GROUP_LINE INTEGER No
The line number of the associated service providers in this patient's record. Together with PAT_ENC_CSN_ID, this forms the foreign key to the DP_FACILITY table.
3 VALUE_LINE INTEGER No
The line number of one of the multiple selected services that are associated with the patient and the service providers from the DP_FACILITY table
4 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.
5 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
6 CONTINUED_CARE_SERVICE_C_NAME VARCHAR No
The selected continued care service.
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