Difference between revisions of "SAM V2:Case Notes"

From AMACWiki
Jump to: navigation, search
(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...)
 
(Fields)
Line 10: Line 10:
 
!Field
 
!Field
 
!Description
 
!Description
 +
|-
 +
|case_date
 +
|The date of the meeting.  Case date is required.
 +
|-
 +
|case_time
 +
|The time the meeting or contact started.
 
|-
 
|-
 
|duration
 
|duration
Line 25: Line 31:
 
|service_provider
 
|service_provider
 
|The service provider who conducted the meeting or contact.  Service provider is required.
 
|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
 
|sid

Revision as of 09:59, 20 June 2008

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
case_date The date of the meeting. Case date is required.
case_time The time the meeting or contact started.
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.
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.