SAM V2:Case Notes

From CIDI Wiki
Revision as of 10:59, 20 June 2008 by Srunkle3X (talk | contribs) (New page: The case notes table records the cases or interactions between students and disability service providers. A case notes record exists for each meeting or contact, so if the student has met...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

The case notes table records the cases or interactions between students and disability service providers. A case notes record exists for each meeting or contact, so if the student has met with disability services 3 times, then the one student parent record will have 3 child case notes records.

Back to SAM V2 Tables

Fields

The fields of the case notes table are:

Field Description
duration Elapsed time of the meeting entered in minutes.
last_updated Date record was last updated.
notes Notes regarding the case.
purpose Purpose of the meeting or contact: Intake, Counseling, Training, Support, etc. Purpose is required.
service_provider The service provider who conducted the meeting or contact. Service provider is required.
case_date The date of the meeting. Case date is required.
start_time The time the meeting or contact started.
sid The student the case note is related to. Student ID is required.
type Type of meeting or contact: Office Visit, Phone, Email, Instant Message, etc. Type is required.
uid Unique ID# of the record.
updated_by User who last modified the record.