IMS Data Dictionary

Back to Table List

Table NameAEREF
Long NameInterventions
DescriptionOne child can receive a specific intervention (e.g. evaluation or referral) for services many times for different reasons. This file records unique information about each intervention. One intervention can result in many different evaluations or services (recorded in the EVF).
PrefixRE

Field Name Length Type Description Comments
rf_chid 15 char Child ID Key Field - links to child file
rf_begdate 8 datetime Begin Date
rf_ini 1 bit Referral Type - INI (T/F)
rf_3yr 1 bit Referral Type - 3 Year (T/F)
rf_cee 1 bit Referral Type - CEE (T/F)
rf_mlt 1 bit Referral Type - MLT (T/F)
rf_other 1 bit Referral Type - Other - (T/F)
rf_othcode 20 char Referral Type Other Code
rf_condate 8 datetime Consent Date
rf_inidate 8 datetime Referral Initiation Date
rf_attempt 5 decimal Attempts to Gain Parental Consent
rf_consent 1 bit Consent Date
rf_sigdate 8 datetime Principals Signature Date
rf_enddate 8 datetime End Date
rf_outcome 5 char Referral Outcome
rf_status 2 char Referral Status
rf_agency 4 char Agency
rf_udate 8 datetime Record Updated (Date)
rf_utime 8 char Record Updated (Time)
rf_uid 9 char Record Updated (User ID)
rf_coordid 10 char Coordinator
rf_staff 10 char Staff ID
rf_refid 10 char Unique Referral ID
rf_keyref 10 char Unique Referral ID
rf_comment 254 char Comments
rf_udatec 8 datetime Date Referral Entered
rf_date2 8 datetime
rf_date3 8 datetime
rf_date4 8 datetime
rf_cntrctr 4 char Contractor
rf_staff2 10 char
rf_attdist 4 char Completed At District
rf_attbldg 4 char Completed At Building