PatientEvaluation


Description

Patient evaluation management table for tracking comprehensive developmental assessments and evaluations in early intervention services. This table manages the complete evaluation lifecycle from initial assignment through completion, including evaluator assignments, scheduling, documentation tracking, outcome determination, and compliance monitoring. Essential for coordinating multidisciplinary evaluations, ensuring timely completion, and supporting eligibility determinations for early intervention services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
EvalID int identity 4 √ null
PatientEvalAttempt.EvalID FK__PatientEv__EvalI__725BF7F6 C
PatientEvaluationCPT.fkEvalID FK_PatientEvaluationCPT_PatientEvaluation R
PatientEvaluationICD9.fkEvalID FK_PatientEvaluationICD9_PatientEvaluation R

Evaluation primary key - Unique identifier for each patient evaluation
Status varchar 20 √ null

Evaluation status - Current status of the evaluation (Assigned, In Progress, Completed, etc.)
DateAssigned smalldatetime 16 √ null

Assignment date - Date when the evaluation was assigned to an evaluator
DateEvalRecieved smalldatetime 16 √ null

Evaluation received date - Date when the completed evaluation was received
DatePacketSent smalldatetime 16 √ null

Packet sent date - Date when evaluation packet was sent to evaluator
Evaluator int 4 √ null
AccessUser.UserID FK__PatientEv__Evalu__6FE99F9F R

Evaluator reference - Links to AccessUser table for the assigned evaluator
EvalTypeID int 4 √ null

Evaluation type reference - Links to evaluation type configuration
PatientID int 4 √ null

Patient reference - Links to Patient table for the patient being evaluated
Comments varchar 4000 √ null

Evaluation comments - Comments and notes about the evaluation process
dateClosed smalldatetime 16 √ null

Closure date - Date when the evaluation was closed
evalServiceType int 4 √ null

Evaluation service type - Type of service for the evaluation
PerformedDatesTo smalldatetime 16 √ null

Performance end date - End date of evaluation performance period
PerformedDatesFrom smalldatetime 16 √ null

Performance start date - Start date of evaluation performance period
EvaluationDueDate smalldatetime 16 √ null

Due date - Date when evaluation is due to be completed
ServiceRecommended int 4 √ null

Service recommended flag - Indicates if services are recommended based on evaluation
ScheduledIFSPDate smalldatetime 16 √ null

Scheduled IFSP date - Scheduled date for Individualized Family Service Plan meeting
OutSideSourceID int 4 √ null

Outside source reference - Links to external evaluator or organization
caseID int 4 √ null
PatientAdministration.AdmitID FK__PatientEv__PatientAdmin C

Case reference - Links to PatientAdministration table for the case
DateCreated smalldatetime 16 √ null

Creation date - Date when evaluation record was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created the evaluation
DateUpdated smalldatetime 16 √ null

Last update date - Date when evaluation was last updated
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated the evaluation
bilingual int 4 √ null

Bilingual flag - Indicates if bilingual evaluation is required
stac5 int 4 √ null

STAC5 flag - Special evaluation indicator for STAC5 requirements
DateEvalReferral datetime 16,3 √ null

Evaluation referral date - Date when evaluation was referred
DateDraftDue smalldatetime 16 √ null

Draft due date - Date when evaluation draft is due
DateCopySent smalldatetime 16 √ null

Copy sent date - Date when evaluation copy was sent
OutcomeDate smalldatetime 16 √ null

Outcome date - Date when evaluation outcome was determined
eligible int 4 √ null

Eligibility flag - Indicates if patient is eligible for services based on evaluation
priorAuth varchar 30 √ null

Prior authorization - Prior authorization number for the evaluation
Location int 4 √ null

Location reference - Links to location where evaluation is conducted
SocialWorker int 4 √ null

Social worker reference - Links to AccessUser table for assigned social worker
Consent bit 1 √ null

Consent flag - Indicates if consent has been obtained for evaluation
CustomField1 int 4 √ null

Custom field 1 - First custom field for additional evaluation data
reasondelay bit 1 √ null

Reason delay flag - Indicates if there is a documented reason for delay
CustomField2 int 4 √ null

Custom field 2 - Second custom field for additional evaluation data
FollowupCall bit 1 √ null

Follow-up call flag - Indicates if follow-up call is needed
obtainMedicals1stAttempt smalldatetime 16 √ null

First medical attempt date - Date of first attempt to obtain medical records
obtainMedicals2ndAttempt smalldatetime 16 √ null

Second medical attempt date - Date of second attempt to obtain medical records
obtainMedicals3rdAttempt smalldatetime 16 √ null

Third medical attempt date - Date of third attempt to obtain medical records
PayrollRate money 21,4 √ null

Payroll rate - Rate for payroll calculation for the evaluation
Duration varchar 10 √ null

Duration - Duration of the evaluation session
Language int 4 √ null

Language reference - Links to Language table for evaluation language

Indexes

Constraint Name Type Sort Column(s)
PK_PatientEvaluation Primary key Asc EvalID
IX_PatientEvaluation_caseID Performance Asc caseID
IX_PatientEvaluation_DatePacketSent_EvalTypeID Performance Asc/Asc DatePacketSent + EvalTypeID
IX_PatientEvaluation_PatientId Performance Asc PatientID
IX_PatientEvaluationID Must be unique Asc EvalID

Relationships

Close relationships within degrees of separation