As a result, you may find variance in message length in your own systems. Special characters are treated differently in different systems. (currently un-populated) Foreign key to the account dimension for the account associated with the associated courseįoreign key to the user dimension for the user that created the discussion topic.įoreign key to the user to last edit the entry, if different than user_idīest guess at the count of characters in the message. Discussion entries are replies in a discussion topic.įoreign key to the reply that it is nested underneath.įoreign key to the user that created this entry.įoreign key to associated discussion topic.įoreign key to account for associated course.įoreign key to user that posted the associated discussion topic.įoreign key to assignment associated with the entry's discussion topic.įoreign key to editor associated with the entry's discussion topic.įoreign key to the discussion topic dimension for the associated discussion topic. The message size in words using space and common punctuation as word breaks. When not empty, this field is the ID of the group the user is part of.įact table for each message in a conversation and each participantįoreign key to the message dimension for the associated message.įoreign key to the conversation dimension for the associated conversationįoreign key to the user dimension for the associated userįoreign key to the course dimension for the associated course.įoreign key to the group dimension for a particular groupįoreign key to the enrollment roll-up dimension table When not empty, this field is the ID of the group category the user is part of. When not empty, this field is the ID of the enrollment for a course section. When not empty, this field is the ID of the course_section the user is part of. When not empty, this field is the ID of the user in the adhoc group table. The ID of the assignment_override for this override user. There are 3 ways a user can be included, via an adhoc form, via a group membership, or a course section. This table contains the user ids of users for whom an override was created. Table contains measures related to students for whom an assignment override exists. The course ID for the original course if this course has been cross listed.įoreign key to the quiz the override is associated with. If the group is directly associated with an account, this is the id. (Not implemented) Foreign key to group category dimension table. May be empty.įoreign key to the assignment group dimension table.įoreign key to the course associated with this assignment. Unique surrogate ID for the assignment_override.įoreign key to the account associated with the course associated with this assignment.įoreign key to the assignment the override is associated with. Overrides are primarily the dates about the assigmnents for a given group of assignees. Overrides can be found in the assignment_override_dim. Table contains measures related to assignment overrides.
0 Comments
Leave a Reply. |