CancelledVisitCodes


Description

Cancelled visit attendance codes defining which attendance codes represent cancelled or missed visits for reporting and billing purposes. This lookup table identifies attendance codes that indicate visit cancellations, enabling proper categorization of cancelled visits for attendance tracking, billing adjustments, and service delivery reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null

Primary key - Unique identifier for each cancelled visit code mapping
AttCode int 4 null

Attendance code reference - Links to AttendanceCode table for codes that represent cancelled visits

Indexes

Constraint Name Type Sort Column(s)
PK__Cancelle__3214EC2759259C4B Primary key Asc ID

Relationships

Close relationships within degrees of separation