Table Name | AEEVF |
Long Name | Activities |
Description | One child can be referred many times for an intervention. Each referral can result in evaluation in multiple areas. This file records the specific information about each evaluation area. |
Prefix | EV |
Field Name | Length | Type | Description | Comments |
---|---|---|---|---|
ev_chid | 15 | char | Child ID | Key Field - links to child file |
ev_type | 3 | char | Evaluation type code | |
ev_rcddate | 8 | datetime | Evaluation Received Date | |
ev_date | 8 | datetime | Evaluation Date | |
ev_method | 3 | char | Evaluation Method | |
ev_rsltcod | 4 | char | Results | |
ev_results | 250 | char | Results | |
ev_rptdate | 8 | datetime | Report Date | |
ev_udate | 8 | datetime | Record Updated (Date) | |
ev_utime | 8 | char | Record Updated (Time) | |
ev_uid | 9 | char | Record Updated (User ID) | |
ev_area | 5 | char | Evaluation Area | |
ev_staff | 10 | char | Staff ID | |
ev_keyref | 10 | char | Unique Referral ID | |
ev_keyevf | 10 | char | Unique Evaluation ID | |
ev_domain | 4 | char | Domain Area | |
ev_mailed | 8 | datetime | Date Mailed | |
ev_person1 | 10 | char | ||
ev_person2 | 10 | char | ||
ev_date1 | 8 | datetime |