Statuses_CHType_vw


Description

CHType status view providing filtered status options for CHType application level. This view consolidates status information from Statuses, StatusInLevel, and AppLevels tables specifically for CHType functionality, supporting context-appropriate status selection, workflow management, and application-specific status filtering for healthcare type categorization and management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
StatusValue varchar 10 √ null

Status value - Short code or value representing the status for CHType processing
StatusName varchar 50 null

Status name - Descriptive name of the status for CHType context
StatusDesc varchar 500 √ null

Status description - Detailed description of the status meaning for CHType applications

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views