IMS Data Dictionary

Back to Table List

Table NameAEEVF
Long NameActivities
DescriptionOne 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.
PrefixEV

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