Difference between revisions of "SAM V2:Accommodations"

From CIDI Wiki
Jump to navigation Jump to search
Line 12: Line 12:
|-
|-
|accommodation
|accommodation
|The accommodation provided.  Accommid is required.
|The name of the accommodation provided.  Accommid is required.
|-
|-
|expiration
|expiration

Revision as of 10:36, 20 June 2008

The accommodations table contains the accommodations received by each student. An accommodation record exists for each accommodation received the student, so if the student has 3 accommodations, then the one student parent record will have 3 child accommodation records.

Back to SAM V2 Tables

Fields

The fields of the accommodations table are:

Field Description
accommodation The name of the accommodation provided. Accommid is required.
expiration If the accommodation is a temporary accommodation, the date the accommodation expires.
last_updated Date record was last updated.
notes Notes regarding the accommodation. The notes field is a cumulative field and date stamped with the date, time and user adding the notes.
sid The student the accommodation is related to. Student ID is required.
type Type of accommodation: Permanent or Temporary. Default value is Permanent. Type is required.
uid Unique ID# of the record.
updated_by User who last modified the record.