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