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 |
