PatientEvaluation_VW


Description

Patient evaluation comprehensive view providing complete information about patient evaluations including assessment tracking, coordinator assignments, evaluator details, and service recommendations. This view consolidates data from PatientEvaluation, Patient, AccessUser, ProcCode, ServiceType, and OutsideSource tables to support evaluation management, progress tracking, compliance monitoring, and reporting for early intervention assessment processes and developmental evaluations.

Columns

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

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

Evaluator reference - Links to AccessUser table for the assigned evaluator

EvalTypeID int 4 null

Evaluation type reference - Links to ProcCode table for type of evaluation

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

dateClosed smalldatetime 16 null

Closure date - Date when the evaluation was closed

evalServiceType int 4 null

Evaluation service type - Links to ServiceType table for type of service

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 indicating if services are recommended

ScheduledIFSPDate smalldatetime 16 null

Scheduled IFSP date - Scheduled date for Individualized Family Service Plan

OutSideSourceID int 4 null

Outside source reference - Links to OutsideSource table for external evaluator

caseID int 4 null

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

priorAuth varchar 30 null

Prior authorization - Prior authorization number for evaluation

Location int 4 null

Location reference - Links to Locations table for evaluation location

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

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 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

patientFName varchar 50 null

Patient first name - First name of the patient being evaluated

patientLName varchar 50 null

Patient last name - Last name of the patient being evaluated

DateOfBirth datetime 16,3 null

Patient birth date - Date of birth of the patient

Borough char 20 null

Borough - Borough where the patient resides

siteID int 4 null

Site reference - Links to AgencySite table for the site

evalCoordID int 4 null

Evaluation coordinator ID - ID of the evaluation coordinator

evalCoordName varchar 102 null

Evaluation coordinator name - Full name of the evaluation coordinator

evaluatorName varchar 102 null

Evaluator name - Full name of the assigned evaluator

evalTypeAbbrev varchar 30 null

Evaluation type abbreviation - Abbreviated code for evaluation type

evalType varchar 133 null

Evaluation type description - Full description of evaluation type

evalServiceTypeAbbrev varchar 10 null

Service type abbreviation - Abbreviated code for evaluation service type

evalServiceTypeDesc varchar 113 null

Service type description - Full description of evaluation service type

EvalOutsideSrcAbbrev varchar 50 null

Outside source abbreviation - Abbreviated name of outside evaluation source

EvalOutsideSrc varchar 103 null

Outside source description - Full description of outside evaluation source

DateEIReferral smalldatetime 16 null

EI referral date - Date of Early Intervention referral for the case

Relationships

View Definition