AllClientAvg


Description

Client average metrics that store calculated average values and statistical data across all clients for reporting and analytics purposes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AvgValue Unknown 0 null

Average value - Calculated average metric value

ClientID Unknown 0 null

Client reference - Reference to the client record

CompanyName varchar 50 null

Name field - Descriptive name or identifier for AllClientAvg records

totalPatients int 4 null

Numeric value - Quantity, count, or numeric measurement for AllClientAvg records

totalClaims int 4 null

Numeric value - Quantity, count, or numeric measurement for AllClientAvg records

minDOS datetime 16,3 null

Date/time field - minDOS temporal information for AllClientAvg records

maxDOS datetime 16,3 null

Date/time field - maxDOS temporal information for AllClientAvg records

MetricType Unknown 0 null

Metric type - Type of metric being averaged (sessions, duration, etc.)

totalServiceProviders int 4 null

Numeric value - Quantity, count, or numeric measurement for AllClientAvg records

Relationships