Math4Team/RIT/Projects: Difference between revisions

No edit summary
No edit summary
Line 37: Line 37:
|StartDate | Effective date of this question instance
|StartDate | Effective date of this question instance
|EndDate | Expiry date of this instance
|EndDate | Expiry date of this instance
}}
====Answer Field Dictionary====
{{Definition_table
|ID | primary key
|Question_ID| ID of parent question
|Sequence | number to order answer among answer choices for question
|Answer | text of solution or answer
|Notes | Description, images, rich format data
|StartDate | Effective date of this answer instance
|EndDate | Expiry date of this instance
}}
====AnswerType Field Dictionary====
{{Definition_table
|ID | primary key
|AnswerType | text for the class of answer. Example, text, numeric, multiple choice, tabular, yes/no, etc.
|Category | ID for class of answer type
}}
====Survey Field Dictionary====
{{Definition_table
|ID | primary key
|BaseID | ID of parent Survey. Used to identify families of Surveys, such as version
|School | ID of the School or organization sponsoring this Survey instance
|Teacher | ID of Person extending this instance of the survey or quiz
|Student | ID of the Person taking this instance of the survey or quiz
|Notes | Description, images, rich format data for this instance of the survey or quiz
|DateTime | DateTime that this Survey instance was taken
|ReviewDate | Date that this Survey instance was reviewed by the Teacher
|ChangeDate | Date that this instance of the Survey was changed (reasons are provided in the Response record).
}}
====Response Field Dictionary====
{{Definition_table
|ID | primary key
|Answer_ID | ID of selected answer (when one of a choice)
|Question_ID| ID of the Question instance for this Response instance
|Survey_ID | ID of the parent Survey or Quiz instance for this Response
|Response| text of Response
|ResponseValue| numerical Response
|Notes | Description, images, rich format data for this Response
|DateTime | DateTime for this Response
|ChangeDate | Date that this instance of the Survey was changed
|ChangePerson | ID of Person who changed this Response instance
|ChangeReason | Reason this Response instance was changed.
}}
====School Field Dictionary====
{{Definition_table
|ID | primary key
|School | School or organizational name
}}
====Person Field Dictionary====
{{Definition_table
|ID | primary key
|Last Name | Family name for Person
|First Name | Primary name for Person
}}
}}