PatientProvider_VW


Description

Patient provider relationship view displaying provider assignments and associations for patients with provider group filtering. This view joins patient-provider relationships with user information to show provider names, IDs, and group associations, supporting provider assignment tracking, patient care coordination, and provider-specific patient management for healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProviderName varchar 101 null

Provider full name - Combined first and last name of the healthcare provider

AccessUserID int 4 null

Provider user ID - Links to AccessUser table for the healthcare provider

PatientID int 4 null

Patient identifier - Links to Patient table for the patient assigned to this provider

GroupID int 4 null

Provider group ID - Links to user group classification for the provider

Relationships

View Definition


Possibly Referenced Tables/Views