ContactCode


Description

Contact code definitions defining standardized codes for different types of contacts and communication methods. This lookup table manages contact type codes and descriptions to support contact categorization, communication tracking, and standardized contact management for healthcare organizations and patient interactions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ContactCode char 10 null

Primary key - Unique code identifier for the contact type
ContactDesc varchar 200 √ null

Contact description - Descriptive name for the contact type

Indexes

Constraint Name Type Sort Column(s)
PK_ContactCode Primary key Asc ContactCode

Relationships

Close relationships within degrees of separation