PatientEvalAttempt


Description

Patient evaluation attempt tracking managing evaluation attempt records including dates, comments, and completion status for patient assessments. This table tracks individual evaluation attempts including attempt dates, evaluation references, and detailed comments, supporting evaluation scheduling, attempt tracking, and comprehensive documentation for patient assessment processes.

Columns

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

Primary key - Unique identifier for each evaluation attempt
DateAttempt smalldatetime 16 √ null

Attempt date - Date when the evaluation attempt was made
EvalID int 4 √ null
PatientEvaluation.EvalID FK__PatientEv__EvalI__725BF7F6 C

Evaluation reference - Links to PatientEvaluation table for the associated evaluation (foreign key to PatientEvaluation.EvalID)
Comments varchar 1000 √ null

Attempt comments - Detailed comments about the evaluation attempt, outcomes, or observations

Indexes

Constraint Name Type Sort Column(s)
PK__PatientEvalAttem__7167D3BD Primary key Asc AttemptID

Relationships

Close relationships within degrees of separation