evalIDEvalCoordID


Description

Evaluation coordinator assignments linking patient evaluations to their assigned evaluation coordinators for early intervention assessment management. This junction table manages the assignment of evaluation coordinators to specific patient evaluations, supporting evaluation workflow coordination, responsibility tracking, and communication management for developmental assessments and early intervention eligibility determinations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
evalID int 4 null

Evaluation reference - Links to PatientEvaluation table for the specific evaluation being coordinated (foreign key to PatientEvaluation.EvalID)

evalCoordID int 4 null

Evaluation coordinator reference - Links to AccessUser table for the healthcare provider assigned as evaluation coordinator (foreign key to AccessUser.UserID)

Relationships