tables_create.sql

set serveroutput on;
SET FEEDBACK OFF;
/*
 Created by CanvasToOracle/main.py --create-tables-file
*/
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_DIM');
END;
/

CREATE TABLE ACU.LMS_COURSE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, CODE NVARCHAR2(512)
	, TYPE NVARCHAR2(512)
	, CREATED_AT DATE
	, START_AT DATE
	, CONCLUDE_AT DATE
	, PUBLICLY_VISIBLE NCHAR(6)
	, SIS_SOURCE_ID NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, WIKI_ID NUMBER
	, SYLLABUS_BODY CLOB
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_DIM is 'A course in the canvas system';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.ID is 'Unique surrogate id for a course';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.CANVAS_ID is 'Primary key for this course in the canvas courses table.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.ROOT_ACCOUNT_ID is 'The root account associated with this course.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.ACCOUNT_ID is 'The parent account for this course.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.ENROLLMENT_TERM_ID is 'Foreign key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.NAME_ is 'The friendly name of the course.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.CODE is 'The code for the course (e.g. FA12 MATH 2000)';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.TYPE is 'deprecated. No longer used, will always be NULL.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.CREATED_AT is 'Timestamp when the course object was created in Canvas';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.START_AT is 'Timestamp for when the course starts.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.CONCLUDE_AT is 'Timestamp for when the course finishes';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.PUBLICLY_VISIBLE is 'True if the course is publicly visible';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.SIS_SOURCE_ID is 'Correlated id for the record for this course in the SIS system (assuming SIS integration is configured)';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.WORKFLOW_STATE is 'Workflow status indicating the current state of the course, valid values are: completed (course has been hard concluded), created (course has been created, but not published), deleted (course has been deleted), available (course is published, and not hard concluded), claimed (course has been undeleted, and is not published).';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.WIKI_ID is 'Foreign key to the wiki_dim table.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.SYLLABUS_BODY is 'Content of the syllabus for this course.';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ACCOUNT_DIM');
END;
/

CREATE TABLE ACU.LMS_ACCOUNT_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, DEPTH NUMBER
	, WORKFLOW_STATE NVARCHAR2(512)
	, PARENT_ACCOUNT NVARCHAR2(512)
	, PARENT_ACCOUNT_ID NUMBER
	, GRANDPARENT_ACCOUNT NVARCHAR2(512)
	, GRANDPARENT_ACCOUNT_ID NUMBER
	, ROOT_ACCOUNT NVARCHAR2(512)
	, ROOT_ACCOUNT_ID NUMBER
	, SUBACCOUNT1 NVARCHAR2(512)
	, SUBACCOUNT1_ID NUMBER
	, SUBACCOUNT2 NVARCHAR2(512)
	, SUBACCOUNT2_ID NUMBER
	, SUBACCOUNT3 NVARCHAR2(512)
	, SUBACCOUNT3_ID NUMBER
	, SUBACCOUNT4 NVARCHAR2(512)
	, SUBACCOUNT4_ID NUMBER
	, SUBACCOUNT5 NVARCHAR2(512)
	, SUBACCOUNT5_ID NUMBER
	, SUBACCOUNT6 NVARCHAR2(512)
	, SUBACCOUNT6_ID NUMBER
	, SUBACCOUNT7 NVARCHAR2(512)
	, SUBACCOUNT7_ID NUMBER
	, SUBACCOUNT8 NVARCHAR2(512)
	, SUBACCOUNT8_ID NUMBER
	, SUBACCOUNT9 NVARCHAR2(512)
	, SUBACCOUNT9_ID NUMBER
	, SUBACCOUNT10 NVARCHAR2(512)
	, SUBACCOUNT10_ID NUMBER
	, SUBACCOUNT11 NVARCHAR2(512)
	, SUBACCOUNT11_ID NUMBER
	, SUBACCOUNT12 NVARCHAR2(512)
	, SUBACCOUNT12_ID NUMBER
	, SUBACCOUNT13 NVARCHAR2(512)
	, SUBACCOUNT13_ID NUMBER
	, SUBACCOUNT14 NVARCHAR2(512)
	, SUBACCOUNT14_ID NUMBER
	, SUBACCOUNT15 NVARCHAR2(512)
	, SUBACCOUNT15_ID NUMBER
	, SIS_SOURCE_ID NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ACCOUNT_DIM is 'An account object in the Canvas system.  Accounts are most often used to represent a hierarchy of colleges, schools, departments, campuses, etc.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.ID is 'Unique surrogate id for an account';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.CANVAS_ID is 'Primary key for this entry in the Canvas accounts table';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.NAME_ is 'Name of the account';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.DEPTH is 'Depth of the account in the hierarchy.  The root node is at 0.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.WORKFLOW_STATE is 'Workflow status indicating that account is [deleted] or [active]';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.PARENT_ACCOUNT is 'Name of this account''s parent account.  This field will be NULL for the root account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.PARENT_ACCOUNT_ID is 'Id of this account''s parent account.  This field will be NULL for the root account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.GRANDPARENT_ACCOUNT is 'Name of this account''s grand parent account.  This field will be NULL for the root account and all accounts at level 1.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.GRANDPARENT_ACCOUNT_ID is 'Id of this account''s grand parent account.  This field will be NULL for the root account and all subaccounts at level 1.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.ROOT_ACCOUNT is 'Name of the root account associated with this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.ROOT_ACCOUNT_ID is 'Id of the root account associated with this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT1 is 'Name of this account''s parent at subaccount level 1.  If this account is a level 1 account, this will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT1_ID is 'Id of this account''s parent at subaccount level 1.  If this account is a level 1 account, this will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT2 is 'Name of this account''s parent at subaccount level 2.  If this account is a level 2 account, subaccount2 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT2_ID is 'Id of this account''s parent at subaccount level 2.  If this account is a level 2 account, subaccount2_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT3 is 'Name of this account''s parent at subaccount level 3.  If this account is a level 3 account, subaccount3 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT3_ID is 'Id of this account''s parent at subaccount level 3.  If this account is a level 3 account, subaccount3_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT4 is 'Name of this account''s parent at subaccount level 4.  If this account is a level 4 account, subaccount4 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT4_ID is 'Id of this account''s parent at subaccount level 4.  If this account is a level 4 account, subaccount4_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT5 is 'Name of this account''s parent at subaccount level 5.  If this account is a level 5 account, subaccount5 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT5_ID is 'Id of this account''s parent at subaccount level 5.  If this account is a level 5 account, subaccount5_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT6 is 'Name of this account''s parent at subaccount level 6.  If this account is a level 6 account, subaccount6 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT6_ID is 'Id of this account''s parent at subaccount level 6.  If this account is a level 6 account, subaccount6_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT7 is 'Name of this account''s parent at subaccount level 7.  If this account is a level 7 account, subaccount7 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT7_ID is 'Id of this account''s parent at subaccount level 7.  If this account is a level 7 account, subaccount7_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT8 is 'Name of this account''s parent at subaccount level 8.  If this account is a level 8 account, subaccount8 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT8_ID is 'Id of this account''s parent at subaccount level 8.  If this account is a level 8 account, subaccount8_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT9 is 'Name of this account''s parent at subaccount level 9.  If this account is a level 9 account, subaccount9 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT9_ID is 'Id of this account''s parent at subaccount level 9.  If this account is a level 9 account, subaccount9_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT10 is 'Name of this account''s parent at subaccount level 10.  If this account is a level 10 account, subaccount10 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT10_ID is 'Id of this account''s parent at subaccount level 10.  If this account is a level 10 account, subaccount10_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT11 is 'Name of this account''s parent at subaccount level 11.  If this account is a level 11 account, subaccount11 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT11_ID is 'Id of this account''s parent at subaccount level 11.  If this account is a level 11 account, subaccount11_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT12 is 'Name of this account''s parent at subaccount level 12.  If this account is a level 12 account, subaccount12 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT12_ID is 'Id of this account''s parent at subaccount level 12.  If this account is a level 12 account, subaccount12_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT13 is 'Name of this account''s parent at subaccount level 13.  If this account is a level 13 account, subaccount13 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT13_ID is 'Id of this account''s parent at subaccount level 13.  If this account is a level 13 account, subaccount13_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT14 is 'Name of this account''s parent at subaccount level 14.  If this account is a level 14 account, subaccount14 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT14_ID is 'Id of this account''s parent at subaccount level 14.  If this account is a level 14 account, subaccount14_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT15 is 'Name of this account''s parent at subaccount level 15.  If this account is a level 15 account, subaccount15 will be the name of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SUBACCOUNT15_ID is 'Id of this account''s parent at subaccount level 15.  If this account is a level 15 account, subaccount15_id will be the id of this account.';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.SIS_SOURCE_ID is 'Correlated id for the record for this course in the SIS system (assuming SIS integration is configured)';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ACCOUNT_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_USR_DIM');
END;
/

CREATE TABLE ACU.LMS_USR_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, TIME_ZONE NVARCHAR2(512)
	, CREATED_AT DATE
	, VISIBILITY NVARCHAR2(512)
	, SCHOOL_NAME NVARCHAR2(512)
	, SCHOOL_POSITION NVARCHAR2(512)
	, GENDER NVARCHAR2(512)
	, LOCALE NVARCHAR2(512)
	, PUBLIC_ NVARCHAR2(512)
	, BIRTHDATE DATE
	, COUNTRY_CODE NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, SORTABLE_NAME NVARCHAR2(512)
	, GLOBAL_CANVAS_ID NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_USR_DIM is 'Attributes for users';
COMMENT ON COLUMN ACU.LMS_USR_DIM.ID is 'Unique surrogate id for the user. This ID is obfuscated to protect the identity of the user.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.CANVAS_ID is 'Primary key for this user in the Canvas users table.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.ROOT_ACCOUNT_ID is 'Root account associated with this user.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.NAME_ is 'Name of the user';
COMMENT ON COLUMN ACU.LMS_USR_DIM.TIME_ZONE is 'User''s primary timezone';
COMMENT ON COLUMN ACU.LMS_USR_DIM.CREATED_AT is 'Timestamp when the user was created in the Canvas system';
COMMENT ON COLUMN ACU.LMS_USR_DIM.VISIBILITY is '(Deprecated) No longer used in Canvas. Will always be Null.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.SCHOOL_NAME is 'Used in Trial Versions of Canvas, the school the user is associated with';
COMMENT ON COLUMN ACU.LMS_USR_DIM.SCHOOL_POSITION is 'Used in Trial Versions of Canvas, the position the user has at the school. E.g. Admin';
COMMENT ON COLUMN ACU.LMS_USR_DIM.GENDER is 'The user''s gender. This is an optional field and may not be entered by the user.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.LOCALE is 'The user''s locale. This is an optional field and may not be entered by the user.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.PUBLIC_ is 'Used in Trial Versions of Canvas, the type of school the user is associated with';
COMMENT ON COLUMN ACU.LMS_USR_DIM.BIRTHDATE is 'The user''s birth date. This is an optional field and may not be entered by the user.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.COUNTRY_CODE is 'The user''s country code. This is an optional field and may not be entered by the user.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.WORKFLOW_STATE is 'Workflow status indicating the status of the user, valid values are: creation_pending, deleted, pre_registered, registered';
COMMENT ON COLUMN ACU.LMS_USR_DIM.SORTABLE_NAME is 'Name of the user that is should be used for sorting groups of users, such as in the gradebook.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.GLOBAL_CANVAS_ID is 'Similar to canvas_id but globalized. This field uses the same globalization as the ''id'' field of all other canvas-data tables. Use this field to join to caliper or live event streams.';
COMMENT ON COLUMN ACU.LMS_USR_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_USR_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_PSEUDONYM_DIM');
END;
/

CREATE TABLE ACU.LMS_PSEUDONYM_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, USR_ID NUMBER
	, ACCOUNT_ID NUMBER
	, WORKFLOW_STATE NVARCHAR2(512)
	, LAST_REQUEST_AT DATE
	, LAST_LOGIN_AT DATE
	, CURRENT_LOGIN_AT DATE
	, LAST_LOGIN_IP NVARCHAR2(512)
	, CURRENT_LOGIN_IP NVARCHAR2(512)
	, POSITION NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, PASSWORD_AUTO_GENERATED NCHAR(6)
	, DELETED_AT DATE
	, SIS_USR_ID NVARCHAR2(512)
	, UNIQUE_NAME NVARCHAR2(512)
	, INTEGRATION_ID NVARCHAR2(512)
	, AUTHENT_PROVIDER_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_PSEUDONYM_DIM is 'Pseudonyms are logins associated with users.';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.ID is 'Unique surrogate id for the pseudonym.';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.CANVAS_ID is 'Primary key for this pseudonym in the the Canvas database';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.USR_ID is 'Id for the user associated with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.ACCOUNT_ID is 'Id for the account associated with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.WORKFLOW_STATE is 'Workflow status indicating that pseudonym is [deleted] or [active]';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.LAST_REQUEST_AT is 'Timestamp of when the user last logged in with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.LAST_LOGIN_AT is 'Timestamp of last time a user logged in with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.CURRENT_LOGIN_AT is 'Timestamp of when the user logged in';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.LAST_LOGIN_IP is 'IP address recorded the last time a user logged in with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.CURRENT_LOGIN_IP is 'IP address  of user''s current/last login';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.POSITION is 'Position of user''s login credentials';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.CREATED_AT is 'Timestamp when this pseudonym was created in Canvas';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.UPDATED_AT is 'Timestamp when this pseudonym was last updated in Canvas';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.PASSWORD_AUTO_GENERATED is 'True if the password has been auto-generated';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.DELETED_AT is 'Timestamp when the pseudonym was deleted (NULL if the pseudonym is still active)';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.SIS_USR_ID is 'Correlated id for the record for this course in the SIS system (assuming SIS integration is configured)';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.UNIQUE_NAME is 'Actual login id for a given pseudonym/account';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.INTEGRATION_ID is 'A secondary unique identifier useful for more complex SIS integrations. This identifier must not change for the user, and must be globally unique.';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.AUTHENT_PROVIDER_ID is 'The authentication provider this login is associated with. This can be the integer ID of the provider, or the type of the provider (in which case, it will find the first matching provider.)';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_PSEUDONYM_FACT');
END;
/

CREATE TABLE ACU.LMS_PSEUDONYM_FACT
(
	PSEUDONYM_ID NUMBER
	, USR_ID NUMBER
	, ACCOUNT_ID NUMBER
	, LOGIN_COUNT NUMBER
	, FAILED_LOGIN_COUNT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_PSEUDONYM_FACT is '';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.PSEUDONYM_ID is 'Foreign key to pseudonym dimension table';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.USR_ID is 'Foreign key to user associated with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.ACCOUNT_ID is 'Foreign key to account associated with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.LOGIN_COUNT is 'Number of times a user has logged in with this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.FAILED_LOGIN_COUNT is 'Number of times failed login attempt to this pseudonym';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_PSEUDONYM_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, COURSE_ID NUMBER
	, TITLE NVARCHAR2(512)
	, DESCRIPTION CLOB
	, DUE_AT DATE
	, UNLOCK_AT DATE
	, LOCK_AT DATE
	, POINTS_POSSIBLE NUMBER
	, GRADING_TYPE NVARCHAR2(512)
	, SUBMIS_TYPES NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, PEER_REVIEW_COUNT NUMBER
	, PEER_REVIEWS_DUE_AT DATE
	, PEER_REVIEWS_ASSIGNED NCHAR(6)
	, PEER_REVIEWS NCHAR(6)
	, AUTOMATIC_PEER_REVIEWS NCHAR(6)
	, ALL_DAY NCHAR(6)
	, ALL_DAY_DATE DATE
	, COULD_BE_LOCKED NCHAR(6)
	, GRADE_GROUP_STUDENTS_INDIVIDUA NCHAR(6)
	, ANONYMOUS_PEER_REVIEWS NCHAR(6)
	, MUTED NCHAR(6)
	, ASSIGN_GROUP_ID NUMBER
	, POSITION NUMBER
	, VISIBILITY NVARCHAR2(2000)
	, EXT_TOOL_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_DIM is 'Attributes for for assignments.  There is one record in this table for each assignment.  Individual submissions of the assignment are in the submission_dim and submission_fact tables.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ID is 'Unique surrogate ID for the assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.CANVAS_ID is 'Primary key for this record in the Canvas assignments table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.COURSE_ID is 'Foreign key to the course associated with this assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.TITLE is 'Title of the assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.DESCRIPTION is 'Long description of the assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.DUE_AT is 'Timestamp for when the assignment is due';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.UNLOCK_AT is 'Timestamp for when the assignment is unlocked or visible to the user';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.LOCK_AT is 'Timestamp for when the assignment is locked';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.POINTS_POSSIBLE is 'Total points possible for the assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.GRADING_TYPE is 'Describes how the assignment will be graded (gpa_scale, pass_fail, percent, points, not_graded, letter_grade)';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.SUBMIS_TYPES is 'Comma separated list of valid methods for submitting the assignment (online_url, media_recording, online_upload, online_quiz, external_tool, online_text_entry, online_file_upload)';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.WORKFLOW_STATE is 'Current workflow state of the assignment.  Possible values are unpublished, published and deleted';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.CREATED_AT is 'Timestamp of the first time the assignment was entered into the system';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.UPDATED_AT is 'Timestamp of the last time the assignment was updated';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.PEER_REVIEW_COUNT is 'The number of pears to assign for review if using algorithmic assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.PEER_REVIEWS_DUE_AT is 'Timestamp for when peer reviews should be completed';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.PEER_REVIEWS_ASSIGNED is 'True if all peer reviews have been assigned';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.PEER_REVIEWS is 'True if peer reviews are enabled for this assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.AUTOMATIC_PEER_REVIEWS is 'True if peer reviews are assigned algorithmically (vs. letting the instructor make manual assignments)';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ALL_DAY is 'True if A specific time for when the assignment is due was not given.  The effective due time will be 11:59pm.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ALL_DAY_DATE is 'The date version of the due date if the all_day flag is true.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.COULD_BE_LOCKED is 'True if the assignment is under a module that can be locked';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.GRADE_GROUP_STUDENTS_INDIVIDUA is 'True if students who submit work as a group will each receive individual grades (vs one grade that is copied to all group members)';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ANONYMOUS_PEER_REVIEWS is '(currently unimplemented, do not use)';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.MUTED is 'Student cannot see grades left on the assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.POSITION is 'The sorting order of the assignment in the group';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.VISIBILITY is 'User sets that can view the assignment. Possible values (''everyone'', ''only_visible_to_overrides'')';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.EXT_TOOL_ID is 'Foreign key to the external tool activation if this assignment uses an external tool for submissions.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_FACT');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_FACT
(
	ASSIGN_ID NUMBER
	, COURSE_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, POINTS_POSSIBLE NUMBER
	, PEER_REVIEW_COUNT NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, EXT_TOOL_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_FACT is 'Table contains measures related to assignments.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.ASSIGN_ID is 'Foreign key to assignment dimension';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.COURSE_ID is 'Foreign key to the course associated with this assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account associated with the course associated with this assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.POINTS_POSSIBLE is 'Total points possible for the assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.PEER_REVIEW_COUNT is 'The number of pears to assign for review if using algorithmic assignment';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.EXT_TOOL_ID is 'Foreign key to the external tool activation if this assignment uses an external tool for submissions.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_RULE_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_RULE_DIM
(
	ASSIGN_ID NUMBER
	, DROP_RULE NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_RULE_DIM is 'Rules associated with an assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_RULE_DIM.ASSIGN_ID is 'ID of the assignment which can never be dropped from the group.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_RULE_DIM.DROP_RULE is 'Denotes if the assignment can be dropped from the assignment group if the group allows dropping assignments based on certain rules. Is set to ''never_drop'' if the assignment is exempted from dropping, else set to ''can_be_dropped''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_RULE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_RULE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SUBMIS_DIM');
END;
/

CREATE TABLE ACU.LMS_SUBMIS_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, BODY CLOB
	, URL NVARCHAR2(512)
	, GRADE NVARCHAR2(512)
	, SUBMITTED_AT DATE
	, SUBMIS_TYPE NVARCHAR2(2000)
	, WORKFLOW_STATE NVARCHAR2(2000)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, PROCESSED NCHAR(6)
	, PROCESS_ATTEMPTS NUMBER
	, GRADE_MATCHES_CURRENT_SUBMIS NCHAR(6)
	, PUBLISHED_GRADE NVARCHAR2(512)
	, GRADED_AT DATE
	, HAS_RUBRIC_ASSESSMENT NCHAR(6)
	, ATTEMPT NUMBER
	, HAS_ADMIN_COMMENT NCHAR(6)
	, ASSIGN_ID NUMBER
	, EXCUSED NVARCHAR2(2000)
	, GRADED_ANONYMOUSLY NVARCHAR2(2000)
	, GRADER_ID NUMBER
	, GROUP_ID NUMBER
	, QUIZ_SUBMIS_ID NUMBER
	, USR_ID NUMBER
	, GRADE_STATE NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SUBMIS_DIM is 'This table records the latest submission for an assignment.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.ID is 'Unique surrogate ID for the submission.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.CANVAS_ID is 'Primary key of this record in the Canvas submissions table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.BODY is 'Text content for the submission.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.URL is 'URL content for the submission.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GRADE is 'Letter grade mapped from the score by the grading scheme.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.SUBMITTED_AT is 'Timestamp of when the submission was submitted.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.SUBMIS_TYPE is 'Type of submission. Possible values are ''discussion_topic'', ''external_tool'', ''media_recording'', ''online_file_upload'', ''online_quiz'', ''online_text_entry'', ''online_upload'' and ''online_url''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.WORKFLOW_STATE is 'Workflow state for submission lifetime values. Possible values are ''graded'', ''pending_review'', ''submitted'' and ''unsubmitted''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.CREATED_AT is 'Timestamp of when the submission was created.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.UPDATED_AT is 'Timestamp of when the submission was last updated.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.PROCESSED is 'Valid only when there is a file/attachment associated with the submission. By default, this attribute is set to ''false'' when making the assignment submission. When a submission has a file/attachment associated with it, upon submitting the assignment a snapshot is saved and its'' value is set to ''true''. Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.PROCESS_ATTEMPTS is '(Deprecated) Will always be Null.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GRADE_MATCHES_CURRENT_SUBMIS is 'Valid only when a score has been assigned to a submission. This is set to ''false'' if a student makes a new submission to an already graded assignment. This is done to indicate that the current grade given by the teacher is not for the most recent submission by the student. It is set to ''true'' if a score has been given and there is no new submission. Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.PUBLISHED_GRADE is 'Valid only for a graded submission. The values are strings that reflect the grading type used. For example, a scoring method of ''points'' will show ''4'' if given a ''4'' out of ''5'', and a scoring method of ''letter grade'' will show ''B'' for the same score (assuming a grading scale where 80-90% is a ''B''). Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GRADED_AT is 'Timestamp of when the submission was graded.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.HAS_RUBRIC_ASSESSMENT is 'Valid only for a graded submission. Its'' value is set to ''true'' if the submission is associated with a rubric that has been assessed for at least one student, otherwise is set to ''false''. Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.ATTEMPT is 'The number of attempts made including this one.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.HAS_ADMIN_COMMENT is '(Deprecated) No longer used in Canvas. Will always be Null.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.ASSIGN_ID is 'Foreign key to assignment dimension.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.EXCUSED is 'Denotes if this submission is excused or not. Possible values are ''excused_submission'' and ''regular_submission''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GRADED_ANONYMOUSLY is 'Denotes how the grading has been performed. Possible values are ''graded_anonymously'' and ''not_graded_anonymously''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GRADER_ID is 'Foreign key to the user dimension of user who graded the assignment.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GROUP_ID is 'Foreign key to the group_dim table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.QUIZ_SUBMIS_ID is 'Foreign key to the quiz_submission_dim table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.USR_ID is 'Foreign key to the user_dim table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.GRADE_STATE is 'Denotes the current state of the grade. Possible values are ''auto_graded'', ''human_graded'' and ''not_graded''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SUBMIS_FACT');
END;
/

CREATE TABLE ACU.LMS_SUBMIS_FACT
(
	SUBMIS_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, USR_ID NUMBER
	, GRADER_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, SCORE NUMBER
	, PUBLISHED_SCORE NUMBER
	, WHAT_IF_SCORE NUMBER
	, SUBMIS_COMMENTS_COUNT NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, GROUP_ID NUMBER
	, QUIZ_ID NUMBER
	, QUIZ_SUBMIS_ID NUMBER
	, WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SUBMIS_FACT is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.SUBMIS_ID is 'Foreign key to submission dimension';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ASSIGN_ID is 'Foreign key to assignment dimension';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.COURSE_ID is 'Foreign key to course dimension of course associated with the assignment.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.USR_ID is 'Foreign key to user dimension of user who submitted the assignment.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.GRADER_ID is 'Foreign key to the user dimension of user who graded the assignment.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.COURSE_ACCOUNT_ID is '(Deprecated) Will always be Null.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up dimension table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.SCORE is 'Numeric grade given to the submission.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.PUBLISHED_SCORE is 'Valid only for a graded submission. It reflects the numerical value of the actual score. Referring to our previous example for ''submission_dim.published_grade'', let''s take two submissions, one for an assignment with a scoring method of ''points'' and the other for an assignment with a scoring method of ''letter grade''. If the published grade is ''4'' out of ''5'' and ''B'' for them, respectively, then they should both have a score of ''4'' out of ''5''. And their ''published_score'' values will be identical, ''4.0''. Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.WHAT_IF_SCORE is 'Valid only if the student ever entered a ''What If'' score for an assignment in the Canvas UI. Only the most recent score entered by the student is stored here. Any time a new score is entered, the existing one is overwritten. Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.SUBMIS_COMMENTS_COUNT is 'Reflects the total number of comments on the submission by anyone/everyone, excluding comments that are flagged as ''hidden''.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ACCOUNT_ID is 'Foreign key to the account the submission belongs to.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.GROUP_ID is 'Foreign key to the group_dim table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.QUIZ_ID is 'Foreign key to the quiz the quiz submission associated with this submission represents.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.QUIZ_SUBMIS_ID is 'Foreign key to the quiz_submission_dim table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.WIKI_ID is 'Foreign key to the wiki_dim table.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SUBMIS_COMMENT_FACT');
END;
/

CREATE TABLE ACU.LMS_SUBMIS_COMMENT_FACT
(
	SUBMIS_COMMENT_ID NUMBER
	, SUBMIS_ID NUMBER
	, RECIPIENT_ID NUMBER
	, AUTHOR_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, MESS_SIZE_BYTES NUMBER
	, MESS_CHARACTER_COUNT NUMBER
	, MESS_WORD_COUNT NUMBER
	, MESS_LINE_COUNT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SUBMIS_COMMENT_FACT is 'Table contains measures related to the submission comments feature in Canvas.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.SUBMIS_COMMENT_ID is 'Foreign key to the submission comment dimension related to the comment';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.SUBMIS_ID is 'Foreign key to the submission dimension related to the comment';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.RECIPIENT_ID is '(Deprecated) No longer used in Canvas. Will always be Null.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.AUTHOR_ID is 'Foreign key to the user dimension for the author of the comment';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.ASSIGN_ID is 'Foreign key to assignment dimension';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.COURSE_ID is 'Foreign key to course dimension of course associated with the assignment.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account dimension of the account associated with the course associated with the assignment';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.MESS_SIZE_BYTES is 'The message size in bytes.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.MESS_CHARACTER_COUNT is 'The message size in characters.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.MESS_WORD_COUNT is 'The message size in words using space and common punctuation as word breaks.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.MESS_LINE_COUNT is 'The number of lines in a message.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SUBMIS_COMMENT_DIM');
END;
/

CREATE TABLE ACU.LMS_SUBMIS_COMMENT_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, SUBMIS_ID NUMBER
	, RECIPIENT_ID NUMBER
	, AUTHOR_ID NUMBER
	, ASSESSMENT_REQUEST_ID NUMBER
	, GROUP_COMMENT_ID NVARCHAR2(512)
	, COMMENT_ CLOB
	, AUTHOR_NAME NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ANONYMOUS NCHAR(6)
	, TEACHER_ONLY_COMMENT NCHAR(6)
	, HIDDEN NCHAR(6)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SUBMIS_COMMENT_DIM is 'Table contains attributes related to the submission comments feature in Canvas.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.ID is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.CANVAS_ID is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.SUBMIS_ID is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.RECIPIENT_ID is '(Deprecated) No longer used in Canvas. Will always be Null';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.AUTHOR_ID is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.ASSESSMENT_REQUEST_ID is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.GROUP_COMMENT_ID is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.COMMENT_ is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.AUTHOR_NAME is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.CREATED_AT is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.UPDATED_AT is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.ANONYMOUS is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.TEACHER_ONLY_COMMENT is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.HIDDEN is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_COMMENT_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_GROUP_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_GROUP_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, COURSE_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, DEFAULT_ASSIGN_NAME NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, POSITION NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_GROUP_DIM is 'Attributes for assignment_groups.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.ID is 'Unique surrogate ID for the assignment group.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.CANVAS_ID is 'Primary key for this record in the Canvas assignment_groups table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.COURSE_ID is 'Foreign key to the course to which the assignment group belongs to.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.NAME_ is 'Name of the assignment group. Defaults to ''Assignments'' if no name is provided during group creation.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.DEFAULT_ASSIGN_NAME is 'Default name assigned to the assignments in the assignment group if no name is assigned to them during their creation. Also, it is the singularized version of the assignment group name by default (if it''s in English).';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.WORKFLOW_STATE is 'Current workflow state of the assignment groups. Possible values are ''available'' and ''deleted''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.POSITION is 'Position of the assignment group in the assignment index page. It determines where it should be displayed on the page and where it should be displayed in a new course if the course is cloned.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.CREATED_AT is 'Date/Time when the assignment group was created.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.UPDATED_AT is 'Date/Time when the assignment group was last updated.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_GROUP_FACT');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_GROUP_FACT
(
	ASSIGN_GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, GROUP_WEIGHT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_GROUP_FACT is 'Measures for assignment_groups.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_FACT.COURSE_ID is 'Foreign key to the course to which the assignment group belongs to.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_FACT.GROUP_WEIGHT is 'Weight of the assignment group. Reflects the value populated in the ''% of total grade'' field in Canvas while creating the assignment group.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_GROUP_RULE_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_GROUP_RULE_DIM
(
	ASSIGN_GROUP_ID NUMBER
	, DROP_LOWEST NUMBER
	, DROP_HIGHEST NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_GROUP_RULE_DIM is 'Rules associated with an assignment group.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_RULE_DIM.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_RULE_DIM.DROP_LOWEST is 'Number of lowest scored assignments which can be dropped from the group. Set to ''0'' when none should be dropped. Defauts to ''0''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_RULE_DIM.DROP_HIGHEST is 'Number of highest scored assignments which can be dropped form the group. Set to ''0'' when none should be dropped. Defaults to ''0''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_RULE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_RULE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_OVERR_USR_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_OVERR_USR_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_OVERR_ID NUMBER
	, QUIZ_ID NUMBER
	, USR_ID NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_OVERR_USR_DIM is 'Table contains measures related to adhoc users for whom an assignment override exists.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.ID is 'Unique surrogate ID for the assignment_override_student.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.CANVAS_ID is 'The ID of the user in the adhoc group table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.ASSIGN_ID is 'Foreign key to the assignment the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.ASSIGN_OVERR_ID is 'Foreign key to the assignment override dimension';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.QUIZ_ID is 'Foreign key to the quiz the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.USR_ID is 'Foreign key to the user.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.CREATED_AT is 'Timestamp of when the assignment_override_student was created.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.UPDATED_AT is 'Timestamp of when the assignment_override_student was last updated.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_OVERR_USR_FACT');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_OVERR_USR_FACT
(
	ASSIGN_OVERR_USR_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_OVERR_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, QUIZ_ID NUMBER
	, USR_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_OVERR_USR_FACT is 'Table contains measures related to students for whom an assignment override exists.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ASSIGN_OVERR_USR_ID is 'Unique surrogate ID for the assignment_override_student. Is made up by adding a large number to the ID of the source table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ACCOUNT_ID is 'Foreign key to the account associated with the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension this fact is related to';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ASSIGN_ID is 'Foreign key to the assignment the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ASSIGN_OVERR_ID is 'Foreign key to the assignment override dimension this fact is related to';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.COURSE_ID is 'Foreign key to the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.QUIZ_ID is 'Foreign key to the quiz the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.USR_ID is 'Foreign key to the user.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_OVERR_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_OVERR_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_SECTION_ID NUMBER
	, GROUP_ID NUMBER
	, QUIZ_ID NUMBER
	, ALL_DAY NVARCHAR2(2000)
	, ALL_DAY_DATE DATE
	, ASSIGN_VERSION NUMBER
	, CREATED_AT DATE
	, DUE_AT DATE
	, DUE_AT_OVERRIDDEN NVARCHAR2(2000)
	, LOCK_AT DATE
	, LOCK_AT_OVERRIDDEN NVARCHAR2(2000)
	, SET_TYPE NVARCHAR2(2000)
	, TITLE CLOB
	, UNLOCK_AT DATE
	, UNLOCK_AT_OVERRIDDEN NVARCHAR2(2000)
	, UPDATED_AT DATE
	, QUIZ_VERSION NUMBER
	, WORKFLOW_STATE NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_OVERR_DIM is 'Attributes for assignment_override.  There may be many records in this table for each assignment.  Use the data in this table to calculate actual due, all_day, lock and unlock dates/times.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ID is 'Unique surrogate ID for the assignment override.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.CANVAS_ID is 'Primary key for this record in the Canvas assignments table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ASSIGN_ID is 'Foreign key to the assignment the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.COURSE_SECTION_ID is 'Foreign key to the course_section.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.GROUP_ID is 'Foreign key to the group.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.QUIZ_ID is 'Foreign key to the quiz the override is associated with.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ALL_DAY is 'Indicates if the all_day field overrides the original assignment.all_day field for this group of users. Possible values are ''new_all_day'' and ''same_all_day''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ALL_DAY_DATE is 'The new date version of the due date if the all_day flag is true.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ASSIGN_VERSION is 'The version of the assignment this override is applied too.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.CREATED_AT is 'Timestamp of when the assignment_override was created.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.DUE_AT is 'The new due_at date-time for this group of users.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.DUE_AT_OVERRIDDEN is 'Indicates if the due_at field overrides the original assignment.due_at field for this group of users. Possible values are ''new_due_at'' and ''same_due_at''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.LOCK_AT is 'The new lock_at date-time for this group of users.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.LOCK_AT_OVERRIDDEN is 'Indicates if the lock_at field overrides the original assignment.lock_at field for this group of users. Possible values are ''new_lock_at'' and ''same_lock_at''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.SET_TYPE is 'Used in conjunction with set_id, this field tells us what type of foreign relation is used. Possible values are ''course_section'', ''group'' and ''adhoc''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.TITLE is 'The title for this assignment_override.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.UNLOCK_AT is 'The new unlock_at date-time for this group of users.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.UNLOCK_AT_OVERRIDDEN is 'Indicates if the unlock_at field overrides the original assignment.unlock_at field for this group of users. Possible values are ''new_unlock_at'' and ''same_unlock_at''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.UPDATED_AT is 'Timestamp of when the assignment_override was last updated.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.QUIZ_VERSION is 'The version of the quiz this override is applied too.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.WORKFLOW_STATE is 'Gives the workflow state of this record. Possible values are ''active'' and ''deleted''.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_OVERR_FACT');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_OVERR_FACT
(
	ASSIGN_OVERR_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, COURSE_SECTION_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, GROUP_ID NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, GROUP_PARENT_ACCOUNT_ID NUMBER
	, NONXLIST_COURSE_ID NUMBER
	, QUIZ_ID NUMBER
	, GROUP_WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_OVERR_FACT is 'Table contains measures related to assignment overrides.  Overrides can be found in the assignment_override_dim.  Overrides are primarily the dates about the assigmnents for a given group of assignees.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ASSIGN_OVERR_ID is 'Unique surrogate ID for the assignment_override.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ACCOUNT_ID is 'Foreign key to the account associated with the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ASSIGN_ID is 'Foreign key to the assignment the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.COURSE_ID is 'Foreign key to the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.COURSE_SECTION_ID is 'Foreign key to the course_section.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.GROUP_ID is 'Foreign key to the group.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.GROUP_CATEGORY_ID is '(Not implemented) Foreign key to group category dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.GROUP_PARENT_ACCOUNT_ID is 'If the group is directly associated with an account, this is the id.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.NONXLIST_COURSE_ID is 'The course ID for the original course if this course has been cross listed.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.QUIZ_ID is 'Foreign key to the quiz the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.GROUP_WIKI_ID is 'Foreign key to the wiki_dim table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT
(
	ASSIGN_ID NUMBER
	, ASSIGN_OVERR_ID NUMBER
	, ASSIGN_OVERR_USR_ADHOC_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, COURSE_SECTION_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, GROUP_ID NUMBER
	, GROUP_PARENT_ACCOUNT_ID NUMBER
	, GROUP_WIKI_ID NUMBER
	, NONXLIST_COURSE_ID NUMBER
	, QUIZ_ID NUMBER
	, USR_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT is 'Table contains measures related to students for whom an assignment override exists.  This table contains the user ids of users for whom an override was created.  There are 3 ways a user can be included, via an adhoc form, via a group membership, or a course section.  All three are included here.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ASSIGN_ID is 'Foreign key to the assignment the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ASSIGN_OVERR_ID is 'The ID of the assignment_override for this override user.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ASSIGN_OVERR_USR_ADHOC_ID is 'When not empty, this field is the ID of the user in the adhoc group table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group dimension table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.COURSE_ID is 'Foreign key to the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account associated with the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.COURSE_SECTION_ID is 'When not empty, this field is the ID of the course_section the user is part of.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ENROLLMENT_ID is 'When not empty, this field is the ID of the enrollment for a course section.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.GROUP_CATEGORY_ID is 'When not empty, this field is the ID of the group category the user is part of.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.GROUP_ID is 'When not empty, this field is the ID of the group the user is part of.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.GROUP_PARENT_ACCOUNT_ID is 'If the group is directly associated with an account, this is the id.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.GROUP_WIKI_ID is 'Foreign key to the wiki_dim table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.NONXLIST_COURSE_ID is 'The course ID for the original course if this course has been cross listed.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.QUIZ_ID is 'Foreign key to the quiz the override is associated with.  May be empty.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.USR_ID is 'Foreign key to the user.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_OVERR_USR_ROLL_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SUBMIS_FILE_FACT');
END;
/

CREATE TABLE ACU.LMS_SUBMIS_FILE_FACT
(
	SUBMIS_FILE_ID NUMBER
	, FILE_ID NUMBER
	, SUBMIS_ID NUMBER
	, ASSIGN_ID NUMBER
	, USR_ID NUMBER
	, GRADER_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SUBMIS_FILE_FACT is 'A junction table that associates files and submissions';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.SUBMIS_FILE_ID is 'Unique surrogate key for the file-submission association';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.FILE_ID is 'Foreign key to the file in this association';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.SUBMIS_ID is 'Foreign key to the submission in this association';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.ASSIGN_ID is 'Foreign key to the assignment the submission is associated with';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.USR_ID is 'Foreign key to the user who uploaded this file';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.GRADER_ID is 'Foreign key to the user who graded the submission in this assocation';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.COURSE_ID is 'Foreign key to course associated with the submission.';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term associated with the submission''s course';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SUBMIS_FILE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COMMUNICATION_CHANNEL_DIM');
END;
/

CREATE TABLE ACU.LMS_COMMUNICATION_CHANNEL_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, USR_ID NUMBER
	, ADDRESS NVARCHAR2(512)
	, TYPE NVARCHAR2(512)
	, POSITION NUMBER
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COMMUNICATION_CHANNEL_DIM is 'Attributes for communication channel.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.ID is 'Unique surrogate ID for the communication channel.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.CANVAS_ID is 'Primary key for this communication channel in the communication_channel table.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.USR_ID is 'Foreign key to the user that owns this communication channel.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.ADDRESS is 'Address, or path, of the communication channel. Set to ''NULL'' for push notifications.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.TYPE is 'Denotes the type of the path. Possible values are ''email'', ''facebook'', ''push'' (device push notifications), ''sms'' and ''twitter''. Defaults to ''email''.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.POSITION is 'Position of this communication channel relative to the user''s other channels when they are ordered.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.WORKFLOW_STATE is 'Current state of the communication channel. Possible values are ''unconfirmed'' and ''active''.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.CREATED_AT is 'Date/Time when the communication channel was created.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.UPDATED_AT is 'Date/Time when the communication channel was last updated.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COMMUNICATION_CHANNEL_FACT');
END;
/

CREATE TABLE ACU.LMS_COMMUNICATION_CHANNEL_FACT
(
	COMMUNICATION_CHANNEL_ID NUMBER
	, USR_ID NUMBER
	, BOUNCE_COUNT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COMMUNICATION_CHANNEL_FACT is 'Measures for communication channel.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_FACT.COMMUNICATION_CHANNEL_ID is 'Foreign key to the communication channel dimension table.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_FACT.USR_ID is 'Foreign key to the user that owns this communication channel.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_FACT.BOUNCE_COUNT is 'Number of permanent bounces since the channel was last reset. If it''s greater than 0, then no email is sent to the channel, until it is either reset by a siteadmin or it is removed and re-added by a user.';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COMMUNICATION_CHANNEL_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONFERENCE_DIM');
END;
/

CREATE TABLE ACU.LMS_CONFERENCE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, TITLE NVARCHAR2(512)
	, CONFERENCE_TYPE NVARCHAR2(512)
	, GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, START_AT DATE
	, STARTED_AT DATE
	, END_AT DATE
	, ENDED_AT DATE
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONFERENCE_DIM is 'Attributes for conferences';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.ID is 'Unique surrogate id for the conference';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.CANVAS_ID is 'Primary key for this conference in the web_conferences table';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.TITLE is 'The title of the conference';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.CONFERENCE_TYPE is 'The type of the conference (e.g. ''AdobeConnect'', ''BigBlueButton'')';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.GROUP_ID is 'Foreign key to the group if this conference was associated with a group';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.COURSE_ID is 'Foreign key to the course if this conference was associated with a course';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.ACCOUNT_ID is 'Foreign key to the account if this conference was associated with an account';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.START_AT is 'The time at which this conference was scheduled to begin';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.STARTED_AT is 'The time at which this conference actually started at, null if it hasn''t started';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.END_AT is 'The time at which this conference was scheduled to end';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.ENDED_AT is 'The time at which this conference actually ended, null if it hasn''t ended';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.CREATED_AT is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.UPDATED_AT is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONFERENCE_FACT');
END;
/

CREATE TABLE ACU.LMS_CONFERENCE_FACT
(
	CONFERENCE_ID NUMBER
	, GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, DURATION NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONFERENCE_FACT is 'Measures for conferences';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.CONFERENCE_ID is 'Foreign key to the conference dimension table';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.GROUP_ID is 'Foreign key to the group if this conference was associated with a group';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.COURSE_ID is 'Foreign key to the course if this conference was associated with a course';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.ACCOUNT_ID is 'Foreign key to the account if this conference was associated with an account';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.DURATION is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONFERENCE_PARTIC_DIM');
END;
/

CREATE TABLE ACU.LMS_CONFERENCE_PARTIC_DIM
(
	ID NUMBER
	, USR_ID NUMBER
	, CONFERENCE_ID NUMBER
	, PARTICIPATION_TYPE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONFERENCE_PARTIC_DIM is 'Attributes for conference participants';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.ID is 'Unique surrogate key for a conference participant';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.USR_ID is 'Foreign key to the user who is the conference participant';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.CONFERENCE_ID is 'Foreign key to the conference';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.PARTICIPATION_TYPE is 'Type of participation, (''invitee'' or ''attendee'')';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.CREATED_AT is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.UPDATED_AT is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONFERENCE_PARTIC_FACT');
END;
/

CREATE TABLE ACU.LMS_CONFERENCE_PARTIC_FACT
(
	CONFERENCE_PARTIC_ID NUMBER
	, GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, USR_ID NUMBER
	, CONFERENCE_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONFERENCE_PARTIC_FACT is 'Measures for conference participants';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.CONFERENCE_PARTIC_ID is 'Foreign key to the conference participant';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.GROUP_ID is 'Foreign key to the group if this conference was associated with a group';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.COURSE_ID is 'Foreign key to the course if this conference was associated with a course';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.ACCOUNT_ID is 'Foreign key to the account if this conference was associated with an account';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.USR_ID is 'Foreign key to the user who is the conference participant';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.CONFERENCE_ID is 'Foreign key to the conference';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONFERENCE_PARTIC_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONVERS_DIM');
END;
/

CREATE TABLE ACU.LMS_CONVERS_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, HAS_ATTACHMENTS NCHAR(6)
	, HAS_MEDIA_OBJECTS NCHAR(6)
	, SUBJECT NVARCHAR2(512)
	, COURSE_ID NUMBER
	, GROUP_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONVERS_DIM is 'Attributes for a conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.ID is 'Unique surrogate id for the conversation.';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.CANVAS_ID is 'Original primary key for conversation in the Canvas table';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.HAS_ATTACHMENTS is 'True if the conversation has attachments';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.HAS_MEDIA_OBJECTS is 'True if the conversation has media objects';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.SUBJECT is 'The subject of the conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.COURSE_ID is 'The course that owns this conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.GROUP_ID is 'The group that owns this conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.ACCOUNT_ID is 'The account this owns this conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONVERS_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONVERS_MESS_DIM');
END;
/

CREATE TABLE ACU.LMS_CONVERS_MESS_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, CONVERS_ID NUMBER
	, AUTHOR_ID NUMBER
	, CREATED_AT DATE
	, GENERATED NCHAR(6)
	, HAS_ATTACHMENTS NCHAR(6)
	, HAS_MEDIA_OBJECTS NCHAR(6)
	, BODY CLOB
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONVERS_MESS_DIM is 'Attributes for a message in a conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.ID is 'Unique surrogate id for the message.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.CANVAS_ID is 'Original ID for canvas table.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.CONVERS_ID is 'Parent conversation for this message.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.AUTHOR_ID is 'User id of the author of the message.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.CREATED_AT is 'Date and time this message was created.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.GENERATED is 'This attribute is true if the system generated this message (e.g. "John was added to this conversation")';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.HAS_ATTACHMENTS is 'True if the message has attachments.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.HAS_MEDIA_OBJECTS is 'True if the message has media objects.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.BODY is 'The content of the message.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_CONVERS_MESS_PARTIC_FACT');
END;
/

CREATE TABLE ACU.LMS_CONVERS_MESS_PARTIC_FACT
(
	CONVERS_MESS_ID NUMBER
	, CONVERS_ID NUMBER
	, USR_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, GROUP_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, MESS_SIZE_BYTES NUMBER
	, MESS_CHARACTER_COUNT NUMBER
	, MESS_WORD_COUNT NUMBER
	, MESS_LINE_COUNT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_CONVERS_MESS_PARTIC_FACT is 'Fact table for each message in a conversation and each participant';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.CONVERS_MESS_ID is 'Foreign key to the message dimension for the associated message.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.CONVERS_ID is 'Foreign key to the conversation dimension for the associated conversation';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.USR_ID is 'Foreign key to the user dimension for the associated user';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.COURSE_ID is 'Foreign key to the course dimension for the associated course.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.COURSE_ACCOUNT_ID is 'Foreign Key to the course''s account';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.GROUP_ID is 'Foreign key to the group dimension for a particular group';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.ACCOUNT_ID is 'Foreign key to account_dim';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up dimension table';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.MESS_SIZE_BYTES is 'The message size in bytes.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.MESS_CHARACTER_COUNT is 'The message size in characters.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.MESS_WORD_COUNT is 'The message size in words using space and common punctuation as word breaks.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.MESS_LINE_COUNT is 'The number of lines in a message.';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_CONVERS_MESS_PARTIC_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_DISCUSSION_TOPIC_DIM');
END;
/

CREATE TABLE ACU.LMS_DISCUSSION_TOPIC_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, TITLE NVARCHAR2(512)
	, MESS CLOB
	, TYPE NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, LAST_REPLY_AT DATE
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, DELAYED_POST_AT DATE
	, POSTED_AT DATE
	, DELETED_AT DATE
	, DISCUSSION_TYPE NVARCHAR2(512)
	, PINNED NCHAR(6)
	, LOCKED NCHAR(6)
	, COURSE_ID NUMBER
	, GROUP_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_DISCUSSION_TOPIC_DIM is 'Attributes for discussion topics in Canvas.  Discussion topics are logical discussion threads.  They can have many discussion entries.   They also have their own message text for the message that started the topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.ID is 'Unique surrogate id for the discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.CANVAS_ID is 'Primary key to the discussion_topics table in Canvas';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.TITLE is 'Title of the discussion topic';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.MESS is 'Message text for the discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.TYPE is 'Discussion topic type.  Two types are default (blank) and announcement.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.WORKFLOW_STATE is 'Workflow state for this discussion topic.  Valid states are unpublished, active, locked, deleted, and post_delayed';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.LAST_REPLY_AT is 'Timestamp of the last reply to this topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.CREATED_AT is 'Timestamp when the discussion topic was first saved in the system.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.UPDATED_AT is 'Timestamp when the discussion topic was last updated in the system.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.DELAYED_POST_AT is 'Timestamp when the discussion topic was/will be delay-posted';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.POSTED_AT is 'Timestamp when the discussion topic was posted';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.DELETED_AT is 'Timestamp when the discussion topic was deleted.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.DISCUSSION_TYPE is 'Type of discussion topic: default(blank), side_comment, threaded.  threaded indicates that replies are threaded where side_comment indicates that replies in the discussion are flat.  See related Canvas Guide https://guides.instructure.com/m/4152/l/60423-how-do-i-create-a-threaded-discussion';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.PINNED is 'True if the discussion topic has been pinned';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.LOCKED is 'True if the discussion topic has been locked';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.COURSE_ID is 'Foreign key to the course dimension';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.GROUP_ID is 'Foreign key to the group dimension';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_DISCUSSION_TOPIC_FACT');
END;
/

CREATE TABLE ACU.LMS_DISCUSSION_TOPIC_FACT
(
	DISCUSSION_TOPIC_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, USR_ID NUMBER
	, ASSIGN_ID NUMBER
	, EDITOR_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, MESS_LENGTH NUMBER
	, GROUP_ID NUMBER
	, GROUP_PARENT_COURSE_ID NUMBER
	, GROUP_PARENT_ACCOUNT_ID NUMBER
	, GROUP_PARENT_COURSE_ACCOUNT_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_DISCUSSION_TOPIC_FACT is 'Measures for discussion topics/threads.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.DISCUSSION_TOPIC_ID is 'Foreign key to the discussion topic dimension for the associated discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.COURSE_ID is 'Foreign key to the course dimension';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.COURSE_ACCOUNT_ID is '(currently un-populated) Foreign key to the account dimension for the account associated with the associated course';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.USR_ID is 'Foreign key to the user dimension for the user that created the discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.ASSIGN_ID is 'Foreign key to the assignment dimension';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.EDITOR_ID is 'Foreign key to the user to last edit the entry, if different than user_id';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up dimension table';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.MESS_LENGTH is 'Best guess at the count of characters in the message. Special characters are treated differently in different systems. As a result, you may find variance in message length in your own systems. NULL messages are mapped to 0 length.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.GROUP_ID is 'Foreign key to the group dimension';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.GROUP_PARENT_COURSE_ID is 'Foreign key to course dimension.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.GROUP_PARENT_ACCOUNT_ID is 'Foreign key to accounts table.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.GROUP_PARENT_COURSE_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the course to which the group belongs to.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_TOPIC_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_DISCUSSION_ENTRY_DIM');
END;
/

CREATE TABLE ACU.LMS_DISCUSSION_ENTRY_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, MESS CLOB
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, DELETED_AT DATE
	, DEPTH NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_DISCUSSION_ENTRY_DIM is 'Attributes for discussion entries. Discussion entries are replies in a discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.ID is 'Unique surrogate id for the discussion entry.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.CANVAS_ID is 'Primary key for this record in the Canvas discussion_entries table';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.MESS is 'Full text of the entry''s message';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.WORKFLOW_STATE is 'Workflow state for discussion message (values: deleted, active)';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.CREATED_AT is 'Timestamp when the discussion entry was created.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.UPDATED_AT is 'Timestamp when the discussion entry was updated.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.DELETED_AT is 'Timestamp when the discussion entry was deleted.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.DEPTH is 'Reply depth for this entry';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_DISCUSSION_ENTRY_FACT');
END;
/

CREATE TABLE ACU.LMS_DISCUSSION_ENTRY_FACT
(
	DISCUSSION_ENTRY_ID NUMBER
	, PARENT_DISCUSSION_ENTRY_ID NUMBER
	, USR_ID NUMBER
	, TOPIC_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, TOPIC_USR_ID NUMBER
	, TOPIC_ASSIGN_ID NUMBER
	, TOPIC_EDITOR_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, MESS_LENGTH NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_DISCUSSION_ENTRY_FACT is 'Measures for discussion entries.  Discussion entries are replies in a discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.DISCUSSION_ENTRY_ID is 'Foreign key to this entries attributes.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.PARENT_DISCUSSION_ENTRY_ID is 'Foreign key to the reply that it is nested underneath.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.USR_ID is 'Foreign key to the user that created this entry.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.TOPIC_ID is 'Foreign key to associated discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.COURSE_ID is 'Foreign key to associated course.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term table';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.COURSE_ACCOUNT_ID is 'Foreign key to account for associated course.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.TOPIC_USR_ID is 'Foreign key to user that posted the associated discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.TOPIC_ASSIGN_ID is 'Foreign key to assignment associated with the entry''s discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.TOPIC_EDITOR_ID is 'Foreign key to editor associated with the entry''s discussion topic.';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up dimension table';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.MESS_LENGTH is 'Length of the message in bytes';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_DISCUSSION_ENTRY_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ENROLLMENT_TERM_DIM');
END;
/

CREATE TABLE ACU.LMS_ENROLLMENT_TERM_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, DATE_START DATE
	, DATE_END DATE
	, SIS_SOURCE_ID NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ENROLLMENT_TERM_DIM is 'Enrollment term describes the term or semester associated with courses (e.g. Fall 2013)';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.ID is 'Unique surrogate id for the enrollment term.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.CANVAS_ID is 'Primary key for this record in the Canvas enrollments table.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.ROOT_ACCOUNT_ID is 'Foreign key to the root account for this enrollment term';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.NAME_ is 'Name of the enrollment term';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.DATE_START is 'Term start date';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.DATE_END is 'Term end date';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.SIS_SOURCE_ID is 'Correlated SIS id for this enrollment term (assuming SIS has been configured properly)';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_TERM_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_SECTION_DIM');
END;
/

CREATE TABLE ACU.LMS_COURSE_SECTION_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, DEFAULT_SECTION NCHAR(6)
	, ACCEPTING_ENROLLMENTS NCHAR(6)
	, CAN_MANUALLY_ENROLL NCHAR(6)
	, START_AT DATE
	, END_AT DATE
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(512)
	, RESTRICT_ENROLLMENTS_TO_SECTIO NCHAR(6)
	, NONXLIST_COURSE_ID NUMBER
	, SIS_SOURCE_ID NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_SECTION_DIM is 'Attributes for a section of a course';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.ID is 'Unique surrogate id for the course section.';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.CANVAS_ID is 'Primary key for this record in the Canvas course_sections table.';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.NAME_ is 'Name of the section';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.COURSE_ID is 'Foreign key to the associated course';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.ENROLLMENT_TERM_ID is 'Foreign key to the associated enrollment term';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.DEFAULT_SECTION is 'True if this is the default section';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.ACCEPTING_ENROLLMENTS is 'True if this section is open for enrollment';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.CAN_MANUALLY_ENROLL is 'Deprecated  Will always be NULL.';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.START_AT is 'Section start date';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.END_AT is 'Section end date';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.CREATED_AT is 'Timestamp for when this section was entered into the system.';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.UPDATED_AT is 'Timestamp for when the last time the section was updated';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.WORKFLOW_STATE is 'Life-cycle state for section. (active, deleted)';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.RESTRICT_ENROLLMENTS_TO_SECTIO is 'True when "Users can only participate in the course between these dates" is checked';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.NONXLIST_COURSE_ID is 'The course id for the original course if this course has been cross listed';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.SIS_SOURCE_ID is 'Id for the correlated record for the section in the SIS (assuming SIS integration has been properly configured)';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_SECTION_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ROLE_DIM');
END;
/

CREATE TABLE ACU.LMS_ROLE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, ACCOUNT_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, BASE_ROLE_TYPE NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, DELETED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ROLE_DIM is 'Give the possible roles for an enrolled user';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.ID is 'Unique surrogate id for the role.';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.CANVAS_ID is 'Primary key for this record in the Canvas roles table';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.ROOT_ACCOUNT_ID is 'Foreign key to the account dimension for this role''s root account.';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.ACCOUNT_ID is 'The foreign key to the account that is in the role';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.NAME_ is 'The name of role, previously was "role_name" on the enrollments_dim';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.BASE_ROLE_TYPE is 'The built in type this role is based on.';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.WORKFLOW_STATE is 'Workflow status indicating that the role is [deleted] or [inactive]';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.CREATED_AT is 'Timestamp of the first time the role was entered into the system';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.UPDATED_AT is 'Timestamp of the last time the role was updated';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.DELETED_AT is 'Timestamp of when the role was removed from the system';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ROLE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ENROLLMENT_DIM');
END;
/

CREATE TABLE ACU.LMS_ENROLLMENT_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, COURSE_SECTION_ID NUMBER
	, ROLE_ID NUMBER
	, TYPE NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, START_AT DATE
	, END_AT DATE
	, COMPLETED_AT DATE
	, SELF_ENROLLED NCHAR(6)
	, SIS_SOURCE_ID NVARCHAR2(512)
	, COURSE_ID NUMBER
	, USR_ID NUMBER
	, LAST_ACTIVITY_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ENROLLMENT_DIM is 'An enrollment represents a user''s association with a specific course and section';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.ID is 'Unique surrogate id for the enrollment.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.CANVAS_ID is 'Primary key for this record in the Canvas enrollments table';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.ROOT_ACCOUNT_ID is 'Root account id associated with this enrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.COURSE_SECTION_ID is 'Foreign key to the course section for this enrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.ROLE_ID is 'Foreign key to the role of the person enrolled in the course';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.TYPE is 'Enrollment type: TaEnrollment, DesignerEnrollment, StudentEnrollment, TeacherEnrollment, StudentViewEnrollment, ObserverEnrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.WORKFLOW_STATE is 'Workflow state for enrollment: active, completed, rejected, deleted, invited, creation_pending';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.CREATED_AT is 'Timestamp for when this section was entered into the system.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.UPDATED_AT is 'Timestamp for when the last time the section was updated';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.START_AT is 'Enrollment start date';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.END_AT is 'Enrollment end date';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.COMPLETED_AT is 'Enrollment completed date';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.SELF_ENROLLED is 'Enrollment was created via self-enrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.SIS_SOURCE_ID is '(Deprecated) No longer used in Canvas. Will always be NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.COURSE_ID is 'Foreign key to course for this enrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.USR_ID is 'Foreign key to user for the enrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.LAST_ACTIVITY_AT is 'Last time the enrolled user viewed content or took action in the enrolled course';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ENROLLMENT_FACT');
END;
/

CREATE TABLE ACU.LMS_ENROLLMENT_FACT
(
	ENROLLMENT_ID NUMBER
	, USR_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, COURSE_SECTION_ID NUMBER
	, COMPUTED_FINAL_SCORE NUMBER
	, COMPUTED_CURRENT_SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ENROLLMENT_FACT is 'Measures for enrollments';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.ENROLLMENT_ID is 'Foreign key for the attributes of the enrollment';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.USR_ID is 'Foreign key to the enrolled user';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.COURSE_ID is 'Foreign key to the enrolled course';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term table';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account of the enrolled course';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.COURSE_SECTION_ID is 'Foreign key to the enrolled section';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.COMPUTED_FINAL_SCORE is '(Deprecated Jan-28-2017) Scores have migrated to the score_fact table.  Will always be Null.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.COMPUTED_CURRENT_SCORE is '(Deprecated Jan-28-2017) Scores have migrated to the score_fact table.  Will always be Null.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ENROLLMENT_ROLL_DIM');
END;
/

CREATE TABLE ACU.LMS_ENROLLMENT_ROLL_DIM
(
	ID NUMBER
	, USR_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_COUNT NUMBER
	, ROLE_COUNT NUMBER
	, BASE_ROLE_COUNT NUMBER
	, ACCOUNT_ADMIN_ROLE_COUNT NUMBER
	, TEACHER_ENROLLMENT_ROLE_COUNT NUMBER
	, DESIGNER_ENROLLMENT_ROLE_COUNT NUMBER
	, TA_ENROLLMENT_ROLE_COUNT NUMBER
	, STUDENT_ENROLLMENT_ROLE_COUNT NUMBER
	, OBSERVER_ENROLLMENT_ROLE_COUNT NUMBER
	, ACCOUNT_MEMBERSHIP_ROLE_COUNT NUMBER
	, NO_PERMISSIONS_ROLE_COUNT NUMBER
	, ACCOUNT_ADMIN_ENROLLMENT_ID NUMBER
	, TEACHER_ENROLLMENT_ENROLLMENT_ NUMBER
	, DESIGNER_ENROLLMENT_ENROLLMENT NUMBER
	, TA_ENROLLMENT_ENROLLMENT_ID NUMBER
	, STUDENT_ENROLLMENT_ENROLLMENT_ NUMBER
	, OBSERVER_ENROLLMENT_ENROLLMENT NUMBER
	, ACCOUNT_MEMBERSHIP_ENROLLMENT_ NUMBER
	, NO_PERMISSIONS_ENROLLMENT_ID NUMBER
	, MOST_PRIVILEGED_ROLE NVARCHAR2(512)
	, LEAST_PRIVILEGED_ROLE NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ENROLLMENT_ROLL_DIM is 'Would be an empty table. Roll-up aggregating the roles held by the users in the courses they are associated with.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ID is 'Unique surrogate id for the user and the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.USR_ID is 'Foreign key to the enrolled user.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.COURSE_ID is 'Foreign key to the enrolled course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ENROLLMENT_COUNT is 'Total number of enrollments associated with the user in the course for his/her all roles under all base roles, duplicate or not.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ROLE_COUNT is 'Total number of unique roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.BASE_ROLE_COUNT is 'Total number of unique base roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ACCOUNT_ADMIN_ROLE_COUNT is 'Total number of ''AccountAdmin'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.TEACHER_ENROLLMENT_ROLE_COUNT is 'Total number of ''TeacherEnrollment'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.DESIGNER_ENROLLMENT_ROLE_COUNT is 'Total number of ''DesignerEnrollment'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.TA_ENROLLMENT_ROLE_COUNT is 'Total number of ''TaEnrollment'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.STUDENT_ENROLLMENT_ROLE_COUNT is 'Total number of ''StudentEnrollment'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.OBSERVER_ENROLLMENT_ROLE_COUNT is 'Total number of ''ObserverEnrollment'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ACCOUNT_MEMBERSHIP_ROLE_COUNT is 'Total number of ''AccountMembership'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.NO_PERMISSIONS_ROLE_COUNT is 'Total number of ''NoPermissions'' roles associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ACCOUNT_ADMIN_ENROLLMENT_ID is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.TEACHER_ENROLLMENT_ENROLLMENT_ is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.DESIGNER_ENROLLMENT_ENROLLMENT is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.TA_ENROLLMENT_ENROLLMENT_ID is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.STUDENT_ENROLLMENT_ENROLLMENT_ is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.OBSERVER_ENROLLMENT_ENROLLMENT is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ACCOUNT_MEMBERSHIP_ENROLLMENT_ is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.NO_PERMISSIONS_ENROLLMENT_ID is 'Enrollment ID if this a valid role for the user in the course, else NULL.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.MOST_PRIVILEGED_ROLE is 'The most privileged role associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.LEAST_PRIVILEGED_ROLE is 'The least privileged role associated with the user in the course.';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ENROLLMENT_ROLL_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SCORE_FACT');
END;
/

CREATE TABLE ACU.LMS_SCORE_FACT
(
	SCORE_ID NUMBER
	, CANVAS_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, GRADING_PERIOD_ID NUMBER
	, GRADING_PERIOD_GROUP_ID NUMBER
	, GRADING_PERIOD_GROUP_ACCOUNT_I NUMBER
	, CURRENT_SCORE NUMBER
	, FINAL_SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SCORE_FACT is '[Deprecated] No longer an accurate way to find scores in canvas data.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.SCORE_ID is '[Deprecated] Unique surrogate identifier for the score.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.CANVAS_ID is '[Deprecated] Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.ACCOUNT_ID is '[Deprecated] Foreign key to the Account group table.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.COURSE_ID is '[Deprecated] Foreign key to the Course group table.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.ENROLLMENT_ID is '[Deprecated] Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.GRADING_PERIOD_ID is '[Deprecated] Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.GRADING_PERIOD_GROUP_ID is '[Deprecated] Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.GRADING_PERIOD_GROUP_ACCOUNT_I is '[Deprecated] One hop ID to the Account table for the grading period group table.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.CURRENT_SCORE is '[Deprecated] Current score.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.FINAL_SCORE is '[Deprecated] Final score.';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SCORE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_SCORE_DIM');
END;
/

CREATE TABLE ACU.LMS_SCORE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, GRADING_PERIOD_ID NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_SCORE_DIM is '[Deprecated] No longer an accurate way to find scores in canvas data.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.ID is '[Deprecated] Unique surrogate identifier for the  score.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.CANVAS_ID is '[Deprecated] Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.ENROLLMENT_ID is '[Deprecated] Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.GRADING_PERIOD_ID is '[Deprecated] Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.CREATED_AT is '[Deprecated] Timestamp when record was created.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.UPDATED_AT is '[Deprecated] Timestamp when record was last updated.';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.WORKFLOW_STATE is '[Deprecated] workflow state for the score.  Possibe values are ''active'', ''deleted''';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_SCORE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_GROUP_SCORE_FACT');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_GROUP_SCORE_FACT
(
	SCORE_ID NUMBER
	, CANVAS_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, CURRENT_SCORE NUMBER
	, FINAL_SCORE NUMBER
	, MUTED_CURRENT_SCORE NUMBER
	, MUTED_FINAL_SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_GROUP_SCORE_FACT is 'Table containing measures for Assignment Group scores within Canvas gradebook.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.SCORE_ID is 'Unique surrogate identifier for the score.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.CANVAS_ID is 'Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.ACCOUNT_ID is 'Foreign key to the Account group table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.COURSE_ID is 'Foreign key to the Course group table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.ASSIGN_GROUP_ID is 'Foreign key to the Assignment group table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.ENROLLMENT_ID is 'Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.CURRENT_SCORE is 'Current score.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.FINAL_SCORE is 'Final score.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.MUTED_CURRENT_SCORE is 'Current score that might not yet be public, or is muted.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.MUTED_FINAL_SCORE is 'Final score that might not yet be public. Or is muted.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_SCORE_FACT');
END;
/

CREATE TABLE ACU.LMS_COURSE_SCORE_FACT
(
	SCORE_ID NUMBER
	, CANVAS_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, CURRENT_SCORE NUMBER
	, FINAL_SCORE NUMBER
	, MUTED_CURRENT_SCORE NUMBER
	, MUTED_FINAL_SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_SCORE_FACT is 'Table containing measures for overall course scores within Canvas gradebook.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.SCORE_ID is 'Unique surrogate identifier for the score.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.CANVAS_ID is 'Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.ACCOUNT_ID is 'Foreign key to the Account group table.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.COURSE_ID is 'Foreign key to the Course group table.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.ENROLLMENT_ID is 'Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.CURRENT_SCORE is 'Current score.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.FINAL_SCORE is 'Final score.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.MUTED_CURRENT_SCORE is 'Current score that might not yet be public, or is muted.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.MUTED_FINAL_SCORE is 'Final score that might not yet be public. Or is muted.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GRADING_PERIOD_SCORE_FACT');
END;
/

CREATE TABLE ACU.LMS_GRADING_PERIOD_SCORE_FACT
(
	SCORE_ID NUMBER
	, CANVAS_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, GRADING_PERIOD_ID NUMBER
	, GRADING_PERIOD_GROUP_ID NUMBER
	, GRADING_PERIOD_GROUP_ACCOUNT_I NUMBER
	, CURRENT_SCORE NUMBER
	, FINAL_SCORE NUMBER
	, MUTED_CURRENT_SCORE NUMBER
	, MUTED_FINAL_SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GRADING_PERIOD_SCORE_FACT is 'Table containing measures for Grading Period scores within Canvas gradebook.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.SCORE_ID is 'Unique surrogate identifier for the score.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.CANVAS_ID is 'Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.ACCOUNT_ID is 'Foreign key to the Account group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.COURSE_ID is 'Foreign key to the Course group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.ENROLLMENT_ID is 'Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.GRADING_PERIOD_ID is 'Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.GRADING_PERIOD_GROUP_ID is 'Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.GRADING_PERIOD_GROUP_ACCOUNT_I is 'One hop ID to the Account table for the grading period group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.CURRENT_SCORE is 'Current score.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.FINAL_SCORE is 'Final score.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.MUTED_CURRENT_SCORE is 'Current score that might not yet be public, or is muted.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.MUTED_FINAL_SCORE is 'Final score that might not yet be public. Or is muted.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_ASSIGN_GROUP_SCORE_DIM');
END;
/

CREATE TABLE ACU.LMS_ASSIGN_GROUP_SCORE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_ASSIGN_GROUP_SCORE_DIM is 'Attributes for Assignment Group scores. You can think of a score as synonymous with a cell inside the gradebook.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.ID is 'Unique surrogate identifier for the  score.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.CANVAS_ID is 'Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.ASSIGN_GROUP_ID is 'Foreign key to the assignment group table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.ENROLLMENT_ID is 'Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.CREATED_AT is 'Timestamp when record was created.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.UPDATED_AT is 'Timestamp when record was last updated.';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.WORKFLOW_STATE is 'Workflow state for the score. Possible values are ''active'', ''deleted''';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_ASSIGN_GROUP_SCORE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_SCORE_DIM');
END;
/

CREATE TABLE ACU.LMS_COURSE_SCORE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_SCORE_DIM is 'Attributes for course scores. You can think of a score as synonymous with a cell inside the gradebook.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.ID is 'Unique surrogate identifier for the  score.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.CANVAS_ID is 'Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.ENROLLMENT_ID is 'Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.CREATED_AT is 'Timestamp when record was created.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.UPDATED_AT is 'Timestamp when record was last updated.';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.WORKFLOW_STATE is 'Workflow state for the score. Possible values are ''active'', ''deleted''';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_SCORE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GRADING_PERIOD_SCORE_DIM');
END;
/

CREATE TABLE ACU.LMS_GRADING_PERIOD_SCORE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ENROLLMENT_ID NUMBER
	, GRADING_PERIOD_ID NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GRADING_PERIOD_SCORE_DIM is 'Attributes for Grading Period scores. You can think of a score as synonymous with a cell inside the grade book.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.ID is 'Unique surrogate identifier for the  score.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.CANVAS_ID is 'Primary key for the score.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.ENROLLMENT_ID is 'Foreign key to the Enrollment table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.GRADING_PERIOD_ID is 'Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.CREATED_AT is 'Timestamp when record was created.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.UPDATED_AT is 'Timestamp when record was last updated.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.WORKFLOW_STATE is 'Workflow state for the score. Possible values are ''active'', ''deleted''';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_SCORE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GRADING_PERIOD_FACT');
END;
/

CREATE TABLE ACU.LMS_GRADING_PERIOD_FACT
(
	GRADING_PERIOD_ID NUMBER
	, CANVAS_ID NUMBER
	, GRADING_PERIOD_GROUP_ID NUMBER
	, GRADING_PERIOD_GROUP_ACCOUNT_I NUMBER
	, GRADING_PERIOD_GROUP_COURSE_ID NUMBER
	, WEIGHT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GRADING_PERIOD_FACT is 'Measures for grading periods.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.GRADING_PERIOD_ID is 'Unique surrogate identifier for the  grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.CANVAS_ID is 'Primary key for the grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.GRADING_PERIOD_GROUP_ID is 'Foreign key to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.GRADING_PERIOD_GROUP_ACCOUNT_I is 'One hop ID to the Account table for the grading period group';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.GRADING_PERIOD_GROUP_COURSE_ID is 'One hop ID to the Course table for the grading period group';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.WEIGHT is 'A weight value that contributes to the overall weight of a grading period set which is used to calculate how much assignments in this period contribute to the total grade.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GRADING_PERIOD_DIM');
END;
/

CREATE TABLE ACU.LMS_GRADING_PERIOD_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, GRADING_PERIOD_GROUP_ID NUMBER
	, CLOSE_DATE DATE
	, CREATED_AT DATE
	, END_DATE DATE
	, START_DATE DATE
	, TITLE NVARCHAR2(512)
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GRADING_PERIOD_DIM is 'Attributes for grading period. A Grading period is like a "term", essentially used for splitting up the grade book into "periods"';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.ID is 'Unique surrogate identifier for the  grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.CANVAS_ID is 'Primary key for the grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.GRADING_PERIOD_GROUP_ID is 'Surrogate ID to the grading period group table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.CLOSE_DATE is 'Grades can only be changed before the close date of the grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.CREATED_AT is 'Timestamp when record was created';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.END_DATE is 'End date of the grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.START_DATE is 'Start date of the grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.TITLE is 'Title for the grading period.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.UPDATED_AT is 'Timestamp when record was last updated.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.WORKFLOW_STATE is 'current workflow state. Possible values are ''active'', ''deleted''';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GRADING_PERIOD_GROUP_DIM');
END;
/

CREATE TABLE ACU.LMS_GRADING_PERIOD_GROUP_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, COURSE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, CREATED_AT DATE
	, TITLE NVARCHAR2(512)
	, UPDATED_AT DATE
	, WORKFLOW_STATE NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GRADING_PERIOD_GROUP_DIM is 'Attributes for grading period groups. Which are a group of grading periods.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.ID is 'Unique surrogate identifier for the grading period groups';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.CANVAS_ID is 'Primary key for the grading period groups';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.COURSE_ID is 'Foreign key to the Course table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.ACCOUNT_ID is 'Foreign key to the Account table.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.CREATED_AT is 'Timestamp when record was created.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.TITLE is 'Title for the grading period group.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.UPDATED_AT is 'Timestamp when record was last updated.';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.WORKFLOW_STATE is 'Workflow state for the grading period group. Possible values are ''active'', ''deleted''';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GRADING_PERIOD_GROUP_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_FILE_DIM');
END;
/

CREATE TABLE ACU.LMS_FILE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, DISPLAY_NAME CLOB
	, ACCOUNT_ID NUMBER
	, ASSIGN_ID NUMBER
	, CONVERS_MESS_ID NUMBER
	, COURSE_ID NUMBER
	, FOLDER_ID NUMBER
	, GROUP_ID NUMBER
	, QUIZ_ID NUMBER
	, QUIZ_SUBMIS_ID NUMBER
	, REPLACEMENT_FILE_ID NUMBER
	, ROOT_FILE_ID NUMBER
	, SUBMIS_ID NUMBER
	, UPLOADER_ID NUMBER
	, USR_ID NUMBER
	, OWNER_ENTITY_TYPE NVARCHAR2(2000)
	, CONTENT_TYPE NVARCHAR2(512)
	, MD5 NVARCHAR2(512)
	, FILE_STATE NVARCHAR2(2000)
	, COULD_BE_LOCKED NVARCHAR2(2000)
	, LOCKED NVARCHAR2(2000)
	, LOCK_AT DATE
	, UNLOCK_AT DATE
	, VIEWED_AT DATE
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, DELETED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_FILE_DIM is 'Attributes for files.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.ID is 'Unique surrogate ID for this file.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.CANVAS_ID is 'Primary key for this file in the attachments table.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.DISPLAY_NAME is 'Name of this file.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.ACCOUNT_ID is 'Foreign key to the account this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.ASSIGN_ID is 'Foreign key to the assignment this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.CONVERS_MESS_ID is 'Foreign key to the conversation message this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.COURSE_ID is 'Foreign key to the course this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.FOLDER_ID is 'Foreign key to the folder this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.GROUP_ID is 'Foreign key to the group this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.QUIZ_ID is 'Foreign key to the quiz this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.QUIZ_SUBMIS_ID is 'Foreign key to the quiz submission this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.REPLACEMENT_FILE_ID is 'ID of the overwriting file if this file is overwritten.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.ROOT_FILE_ID is 'ID of the source file from which this file was copied and created. Set to ''NULL'' when this is the only copy.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.SUBMIS_ID is 'Foreign key to the submission this file belongs to if the file''s context was a submission or quiz submission. A file''s context is an independent attribute from its relationship with a submission. Files have a many-to-many relationship with submissions in Canvas which requires a junction table to represent. See submission_file_fact for details on the junction table that links files to submissions.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.UPLOADER_ID is 'Foreign key to the user who uploaded this file. Might contain users which are not in the user dimension table.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.USR_ID is 'Foreign key to the user this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.OWNER_ENTITY_TYPE is 'Table this file is associated with. Possible values are ''account'', ''assignment'', ''conversation_message'', ''course'', ''group'', ''quiz'', ''quiz_submission'', ''submission'' and ''user''.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.CONTENT_TYPE is 'Contains the MIME type of this file.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.MD5 is 'Contains the MD5 checksum of the contents of this file.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.FILE_STATE is 'Denotes the current state of this file. Possible values are ''available'', ''broken'', ''deleted'', ''errored'' and ''hidden''.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.COULD_BE_LOCKED is 'Dictates if the quiz can be locked or not. Possible values are ''allow_locking'' and ''disallow_locking''.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.LOCKED is 'Denotes the current lock status of this file. Possible values are ''is_locked'' and ''is_not_locked''.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.LOCK_AT is 'Date/Time when this file is to be locked.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.UNLOCK_AT is 'Date/Time when this file is to unlocked.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.VIEWED_AT is 'Date/Time when this file was last viewed.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.CREATED_AT is 'Date/Time when this file was created.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.UPDATED_AT is 'Date/Time when this file was last updated.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.DELETED_AT is 'Date/Time when this file was deleted.';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_FILE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_FILE_FACT');
END;
/

CREATE TABLE ACU.LMS_FILE_FACT
(
	FILE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, CONVERS_ID NUMBER
	, CONVERS_MESS_AUTHOR_ID NUMBER
	, CONVERS_MESS_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, FOLDER_ID NUMBER
	, GRADER_ID NUMBER
	, GROUP_ID NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, QUIZ_ID NUMBER
	, QUIZ_SUBMIS_ID NUMBER
	, REPLACEMENT_FILE_ID NUMBER
	, ROOT_FILE_ID NUMBER
	, SIS_SOURCE_ID NVARCHAR2(512)
	, SUBMIS_ID NUMBER
	, UPLOADER_ID NUMBER
	, USR_ID NUMBER
	, WIKI_ID NUMBER
	, SIZE_ NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_FILE_FACT is 'Measures for files.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.FILE_ID is 'Foreign key to this file dimesion table.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ACCOUNT_ID is 'Foreign key to the account this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ASSIGN_ID is 'Foreign key to the assignment, the quiz/quiz submission/submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ASSIGN_GROUP_ID is 'Foreign key to the assignment group, the assignment/submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.CONVERS_ID is 'Foreign key to the conversation, the conversation message associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.CONVERS_MESS_AUTHOR_ID is 'Foreign key to the user, who authored the conversation message this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.CONVERS_MESS_ID is 'Foreign key to the conversation message this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.COURSE_ID is 'Foreign key to the course, the assignment/quiz/quiz submission/submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up, the quiz submission/submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ENROLLMENT_TERM_ID is 'Foreign Key to enrollment term, the assignment/conversation message/group/quiz/quiz submission/submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.FOLDER_ID is 'Foreign key to the folder this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.GRADER_ID is 'Foreign key to the user who graded the submission associated with this file. Please see submission_id for clarification on the relationship between a file and a submission.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.GROUP_ID is 'Foreign key to the group this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.GROUP_CATEGORY_ID is '(Not implemented) Foreign key to group category the group associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.QUIZ_ID is 'Foreign key to the quiz, the quiz/quiz submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.QUIZ_SUBMIS_ID is 'Foreign key to the quiz submission this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.REPLACEMENT_FILE_ID is 'Foreign key to the file which overwrote/replaced this file. Defaults to ''NULL'' when the file was not overwritten/replaced.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ROOT_FILE_ID is 'Foreign key to the source file from which this file was copied and created. Defaults to ''NULL'' when this is the only copy.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.SIS_SOURCE_ID is 'Correlated ID for the record for the course, associated with this file, in the SIS system (assuming SIS integration is configured).';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.SUBMIS_ID is 'Foreign key to the submission this file belongs to if the file''s context was a submission or quiz submission. A file''s context is an independent attribute from its relationship with a submission. Files have a many-to-many relationship with submissions in Canvas which requires a junction table to represent. See submission_file_fact for details on the junction table that links files to submissions.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.UPLOADER_ID is 'Foreign key to the user who uploaded this file. Might contain users which are not in the user dimension table.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.USR_ID is 'Foreign key to the user this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.WIKI_ID is 'Foreign key to the wiki the conversation message/group/submission associated with this file belongs to.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.SIZE_ is 'Size of this file in bytes.';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_FILE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GROUP_DIM');
END;
/

CREATE TABLE ACU.LMS_GROUP_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, DESCRIPTION CLOB
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, DELETED_AT DATE
	, IS_PUBLIC NCHAR(6)
	, WORKFLOW_STATE NVARCHAR2(512)
	, CONTEXT_TYPE NVARCHAR2(512)
	, CATEGORY CLOB
	, JOIN_LEVEL NVARCHAR2(512)
	, DEFAULT_VIEW NVARCHAR2(512)
	, SIS_SOURCE_ID NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, ACCOUNT_ID NUMBER
	, WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GROUP_DIM is 'Attributes for groups in canvas. Groups contain two or more students enrolled in a particular course working on an assignment or project together.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.ID is 'Unique surrogate id for the group.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.CANVAS_ID is 'Primary key to the groups table in canvas.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.NAME_ is 'Name of the group.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.DESCRIPTION is 'Description of the group.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.CREATED_AT is 'Timestamp when the group was first saved in the system.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.UPDATED_AT is 'Timestamp when the group was last updated in the system.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.DELETED_AT is 'Timestamp when the group was deleted.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.IS_PUBLIC is 'True if the group contents are accessible to public.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.WORKFLOW_STATE is 'Workflow state for group.(values: deleted,active)';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.CONTEXT_TYPE is 'The context type to which the group belongs to. For example- Accounts, Courses etc.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.CATEGORY is 'Group description by the users.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.JOIN_LEVEL is 'Permissions required to join a group. For example, it can be invitation-only or auto.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.DEFAULT_VIEW is 'Default view for groups is the feed.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.SIS_SOURCE_ID is 'Correlated id for the record for this group in the SIS system (assuming SIS integration is configured)';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.GROUP_CATEGORY_ID is '(Not implemented) Foreign key to group category dimension table.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.ACCOUNT_ID is 'Parent account for this group.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.WIKI_ID is 'Foreign key to the wiki_dim table.';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GROUP_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GROUP_FACT');
END;
/

CREATE TABLE ACU.LMS_GROUP_FACT
(
	GROUP_ID NUMBER
	, PARENT_COURSE_ID NUMBER
	, PARENT_ACCOUNT_ID NUMBER
	, PARENT_COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, MAX_MEMBERSHIP NUMBER
	, STORAGE_QUOTA NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, ACCOUNT_ID NUMBER
	, WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GROUP_FACT is 'Measures for groups.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.GROUP_ID is 'Foreign key to the group dimension for a particular group.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.PARENT_COURSE_ID is 'Foreign key to course dimension.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.PARENT_ACCOUNT_ID is 'Foreign key to accounts table.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.PARENT_COURSE_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the course to which the group belongs to.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term table for the parent course.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.MAX_MEMBERSHIP is 'Maximum number of users that can be accommodated in a group.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.STORAGE_QUOTA is 'Storage Limit allowed per group.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.GROUP_CATEGORY_ID is '(Not implemented) Foreign key to group category dimension table.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.ACCOUNT_ID is 'Parent account for this group.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.WIKI_ID is 'Foreign key to the wiki_dim table.';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GROUP_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GROUP_MEMBERSHIP_FACT');
END;
/

CREATE TABLE ACU.LMS_GROUP_MEMBERSHIP_FACT
(
	GROUP_ID NUMBER
	, PARENT_COURSE_ID NUMBER
	, PARENT_ACCOUNT_ID NUMBER
	, PARENT_COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, USR_ID NUMBER
	, GROUP_MEMBERSHIP_ID NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GROUP_MEMBERSHIP_FACT is 'Measures for groups.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.GROUP_ID is 'Foreign key to the group dimension for a particular group.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.PARENT_COURSE_ID is 'Foreign key to course dimension.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.PARENT_ACCOUNT_ID is 'Foreign key to accounts table.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.PARENT_COURSE_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the course to which the group belongs to.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term table for the parent course.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.USR_ID is 'Foreign key to the user dimension for the users in the group.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.GROUP_MEMBERSHIP_ID is 'The ID of the membership object';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_GROUP_MEMBERSHIP_DIM');
END;
/

CREATE TABLE ACU.LMS_GROUP_MEMBERSHIP_DIM
(
	ID NVARCHAR2(512)
	, CANVAS_ID NVARCHAR2(512)
	, GROUP_ID NUMBER
	, MODERATOR NVARCHAR2(2000)
	, WORKFLOW_STATE NVARCHAR2(2000)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_GROUP_MEMBERSHIP_DIM is 'Attributes for groups_membership in canvas.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.ID is 'The ID of the membership object';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.CANVAS_ID is 'The ID of the membership object as it appears in the db.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.GROUP_ID is 'Foreign key to the group dimension for a particular group.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.MODERATOR is 'Whether or not the user is a moderator of the group.  Possible values are ''is_moderator'' and ''not_moderator''.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.WORKFLOW_STATE is 'The current state of the membership. Current possible values are ''accepted'', ''invited'', ''requested'', and ''deleted''';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.CREATED_AT is 'Timestamp when the group membership was first saved in the system.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.UPDATED_AT is 'Timestamp when the group membership was last updated in the system.';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_GROUP_MEMBERSHIP_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_DIM');
END;
/

CREATE TABLE ACU.LMS_MODULE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, COURSE_ID NUMBER
	, REQUIRE_SEQUENTIAL_PROGRESS NVARCHAR2(2000)
	, WORKFLOW_STATE NVARCHAR2(2000)
	, POSITION NUMBER
	, NAME_ CLOB
	, CREATED_AT DATE
	, DELETED_AT DATE
	, UNLOCK_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_DIM is 'Attributes for a module.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.ID is 'Unique surrogate ID for the module.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.CANVAS_ID is 'Original primary key for module in the Canvas table.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.COURSE_ID is 'The course that owns this module.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.REQUIRE_SEQUENTIAL_PROGRESS is 'Should module items be completed sequentially?  Valid values are ''required'', ''not_required'', ''unspecified''.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.WORKFLOW_STATE is 'Workflow state for submission lifetime values. Possible values are ''locked'', ''completed'', ''unlocked'' and ''started''.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.POSITION is 'Position of the module on the modules page.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.NAME_ is 'The name of the module in Canvas.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.CREATED_AT is 'Date/Time when the module was created.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.DELETED_AT is 'Timestamp when the module was deleted.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.UNLOCK_AT is 'Timestamp when the module will unlock.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.UPDATED_AT is 'Date/Time when the module was last updated.';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_FACT');
END;
/

CREATE TABLE ACU.LMS_MODULE_FACT
(
	MODULE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_FACT is 'Table containing measures related to modules.';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.MODULE_ID is 'Foreign key to assignment dimension.';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.ACCOUNT_ID is 'Foreign key to the account the module belongs to.';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.COURSE_ID is 'Foreign key to the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment_term associated with the module_fact course.';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.WIKI_ID is 'Foreign key to the wiki associated with the module_fact course.';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_ITEM_DIM');
END;
/

CREATE TABLE ACU.LMS_MODULE_ITEM_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ID NUMBER
	, DISCUSSION_TOPIC_ID NUMBER
	, FILE_ID NUMBER
	, MODULE_ID NUMBER
	, QUIZ_ID NUMBER
	, WIKI_PAGE_ID NUMBER
	, CONTENT_TYPE NVARCHAR2(2000)
	, WORKFLOW_STATE NVARCHAR2(2000)
	, POSITION NUMBER
	, TITLE CLOB
	, URL CLOB
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_ITEM_DIM is 'Attributes for a module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.ID is 'Unique surrogate ID for the module_item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.CANVAS_ID is 'Original primary key for module_item in the Canvas table.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.ASSIGN_ID is 'Key into assignments table for ''Assignment'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.COURSE_ID is 'The course that owns this module.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.DISCUSSION_TOPIC_ID is 'Key into discussion_topics table for ''Discussion'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.FILE_ID is 'Key into file table for ''File'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.MODULE_ID is 'Parent module for this module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.QUIZ_ID is 'Key into quizzes table for ''Quiz'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.WIKI_PAGE_ID is 'Key into wiki_pages table for ''Page'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.CONTENT_TYPE is 'The type of content linked to this item. One of: ''Assignment'', ''Attachment'', ''DiscussionTopic'', ''ContextExternalTool'', ''ContextModuleSubHeader'', ''ExternalUrl'', ''LearningOutcome'', ''Quiz'', ''Rubric'' or ''WikiPage''.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.WORKFLOW_STATE is 'State of the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.POSITION is 'Position of the module item within the module context.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.TITLE is 'Title of the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.URL is 'Url for external url type module items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.CREATED_AT is 'Date/Time when the module item was created.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.UPDATED_AT is 'Date/Time when the module item was last updated.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_ITEM_FACT');
END;
/

CREATE TABLE ACU.LMS_MODULE_ITEM_FACT
(
	MODULE_ITEM_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, DISCUSSION_TOPIC_ID NUMBER
	, DISCUSSION_TOPIC_EDITOR_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, FILE_ID NUMBER
	, MODULE_ID NUMBER
	, QUIZ_ID NUMBER
	, USR_ID NUMBER
	, WIKI_ID NUMBER
	, WIKI_PAGE_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_ITEM_FACT is 'Table containing measures related to modules_items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.MODULE_ITEM_ID is 'Unique surrogate ID for the module_item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ACCOUNT_ID is 'Foreign key to the account the module belongs to.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ASSIGN_ID is 'Key into assignments table for ''Assignment'', ''DiscussionTopic'', ''File'', ''Quiz'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ASSIGN_GROUP_ID is 'Key into assignment_groups for ''Assignment'', ''File'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.COURSE_ID is 'The course that owns this module.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.DISCUSSION_TOPIC_ID is 'Key into discussion_topics table for ''DiscussionTopic'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.DISCUSSION_TOPIC_EDITOR_ID is 'Key into users table for user who edited ''DiscussionTopic'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ENROLLMENT_ROLL_ID is 'Key into enrollment_rollup table for user associated with ''DiscussionTopic'', ''File'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment_term associated with the module course.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.FILE_ID is 'Key into file table for ''File'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.MODULE_ID is 'Parent module for this module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.QUIZ_ID is 'Key into quizzes table for ''File'', ''Quiz'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.USR_ID is 'Key into users table for ''DiscussionTopic'', ''File'', ''WikiPage'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.WIKI_ID is 'Key into wiki table for ''WikiPage'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.WIKI_PAGE_ID is 'Key into wiki_pages table for ''WikiPage'' type items.';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_ITEM_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_PROG_DIM');
END;
/

CREATE TABLE ACU.LMS_MODULE_PROG_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, MODULE_ID NUMBER
	, USR_ID NUMBER
	, COLLAPSED NVARCHAR2(2000)
	, IS_CURRENT NVARCHAR2(2000)
	, WORKFLOW_STATE NVARCHAR2(2000)
	, CURRENT_POSITION NUMBER
	, LOCK_VERSION NUMBER
	, CREATED_AT DATE
	, COMPLETED_AT DATE
	, EVALUATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_PROG_DIM is 'Attributes for a module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.ID is 'Unique surrogate ID for the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.CANVAS_ID is 'Original primary key for module progression in the Canvas table.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.MODULE_ID is 'Parent module for this module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.USR_ID is 'User being tracked in the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.COLLAPSED is 'Collapsed state of the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.IS_CURRENT is 'The current state of the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.WORKFLOW_STATE is 'The workflow state of the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.CURRENT_POSITION is 'Represents the users current position in the module.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.LOCK_VERSION is 'Lock version of the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.CREATED_AT is 'Date/Time when the module progression was created.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.COMPLETED_AT is 'Date/Time when the module progression was completed.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.EVALUATED_AT is 'Date/Time when the module progression was evaluated.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.UPDATED_AT is 'Date/Time when the module progression was last updated.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_PROG_FACT');
END;
/

CREATE TABLE ACU.LMS_MODULE_PROG_FACT
(
	MODULE_PROG_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, MODULE_ID NUMBER
	, USR_ID NUMBER
	, WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_PROG_FACT is 'Table containing measures related to modules_progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.MODULE_PROG_ID is 'Unique surrogate ID for the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.ACCOUNT_ID is 'Foreign key to the account the module belongs to.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.COURSE_ID is 'Foreign key to the course associated with this module.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment_term associated with the module course.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.MODULE_ID is 'Parent module for this module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.USR_ID is 'User being tracked in the module progression.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.WIKI_ID is 'Foreign key to the wiki associated with the module course.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_COMPL_REQ_DIM');
END;
/

CREATE TABLE ACU.LMS_MODULE_COMPL_REQ_DIM
(
	ID NUMBER
	, MODULE_ID NUMBER
	, MODULE_ITEM_ID NUMBER
	, REQ_TYPE NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_COMPL_REQ_DIM is 'Attributes for a module completion.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_DIM.ID is 'Unique surrogate ID for the module completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_DIM.MODULE_ID is 'Module that contains the completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_DIM.MODULE_ITEM_ID is 'Item that is the subject of the completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_DIM.REQ_TYPE is 'Type of completion event that must be achieved to consider item complete.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_COMPL_REQ_FACT');
END;
/

CREATE TABLE ACU.LMS_MODULE_COMPL_REQ_FACT
(
	MODULE_COMPL_REQ_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, DISCUSSION_TOPIC_ID NUMBER
	, DISCUSSION_TOPIC_EDITOR_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, FILE_ID NUMBER
	, MODULE_ID NUMBER
	, MODULE_ITEM_ID NUMBER
	, QUIZ_ID NUMBER
	, USR_ID NUMBER
	, WIKI_ID NUMBER
	, WIKI_PAGE_ID NUMBER
	, MIN_SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_COMPL_REQ_FACT is 'Table containing measures related to module completion requirements.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.MODULE_COMPL_REQ_ID is 'Unique surrogate ID for the module completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ACCOUNT_ID is 'Foreign key to the account the module and the module item belong to.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ASSIGN_ID is 'Assignment associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ASSIGN_GROUP_ID is 'Assignment group associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.COURSE_ID is 'Foreign key to the course associated with this module and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.DISCUSSION_TOPIC_ID is 'Discussion topic associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.DISCUSSION_TOPIC_EDITOR_ID is 'Editor of the discussion topic associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ENROLLMENT_ROLL_ID is 'Enrollment rollup associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term associated with this module and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.FILE_ID is 'File associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.MODULE_ID is 'Module that contains the completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.MODULE_ITEM_ID is 'Item that is the subject of the completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.QUIZ_ID is 'Quiz associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.USR_ID is 'User associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.WIKI_ID is 'Foreign key to the wiki associated with this module and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.WIKI_PAGE_ID is 'Wiki page associated with the module_item.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.MIN_SCORE is 'For min_score type requirements, the score that must be attained for completion.';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_COMPL_REQ_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_PREREQ_DIM');
END;
/

CREATE TABLE ACU.LMS_MODULE_PREREQ_DIM
(
	ID NUMBER
	, MODULE_ID NUMBER
	, PREREQ_MODULE_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_PREREQ_DIM is 'Attributes for a module prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_DIM.ID is 'Unique surrogate ID for the module prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_DIM.MODULE_ID is 'Module that contains the prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_DIM.PREREQ_MODULE_ID is 'Module that must be completed to fulfill the prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_PREREQ_FACT');
END;
/

CREATE TABLE ACU.LMS_MODULE_PREREQ_FACT
(
	MODULE_PREREQ_ID NUMBER
	, ACCOUNT_ID NUMBER
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, MODULE_ID NUMBER
	, PREREQ_MODULE_ID NUMBER
	, PREREQ_WIKI_ID NUMBER
	, WIKI_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_PREREQ_FACT is 'Table containing measures related to module prerequisites.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.MODULE_PREREQ_ID is 'Unique surrogate ID for the module prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.ACCOUNT_ID is 'Foreign key to the account the module belongs to.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.COURSE_ID is 'Foreign key to the course associated with this assignment.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment_term associated with the module_fact course.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.MODULE_ID is 'Module that contains the prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.PREREQ_MODULE_ID is 'Module that must be completed to fulfill the prerequisite.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.PREREQ_WIKI_ID is 'Foreign key to the wiki associated with the module_fact course.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.WIKI_ID is 'Foreign key to the wiki associated with the module_fact course.';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_PREREQ_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_PROG_COMPL_REQ_DIM');
END;
/

CREATE TABLE ACU.LMS_MODULE_PROG_COMPL_REQ_DIM
(
	ID NUMBER
	, MODULE_PROG_ID NUMBER
	, MODULE_ITEM_ID NUMBER
	, REQ_TYPE NVARCHAR2(2000)
	, COMPL_STATUS NVARCHAR2(2000)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_PROG_COMPL_REQ_DIM is 'Attributes tracking a requirement that remains to be completed by a user.  Not a comprehensive list, typically just holds requirements that have been attempted by the user.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.ID is 'Unique surrogate ID for the module progression completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.MODULE_PROG_ID is 'Module progression referenced by completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.MODULE_ITEM_ID is 'Item that the user has not completed.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.REQ_TYPE is 'Type of completion event that must be achieved to consider item complete.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.COMPL_STATUS is 'Denotes if the completion event is complete or not. Possible values are ''complete'' and ''incomplete''.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_MODULE_PROG_COMPL_REQ_FACT');
END;
/

CREATE TABLE ACU.LMS_MODULE_PROG_COMPL_REQ_FACT
(
	MODULE_PROG_COMPL_REQ_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ASSIGN_ID NUMBER
	, ASSIGN_GROUP_ID NUMBER
	, COURSE_ID NUMBER
	, DISCUSSION_TOPIC_ID NUMBER
	, DISCUSSION_TOPIC_EDITOR_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, FILE_ID NUMBER
	, MODULE_ID NUMBER
	, MODULE_ITEM_ID NUMBER
	, MODULE_PROG_ID NUMBER
	, QUIZ_ID NUMBER
	, USR_ID NUMBER
	, WIKI_ID NUMBER
	, WIKI_PAGE_ID NUMBER
	, MIN_SCORE NUMBER
	, SCORE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_MODULE_PROG_COMPL_REQ_FACT is 'Table containing measures related to module progression completion requirements.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.MODULE_PROG_COMPL_REQ_ID is 'Unique surrogate ID for the module progression completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ACCOUNT_ID is 'Key to the account associated with the module progression and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ASSIGN_ID is 'Key to the assignment associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ASSIGN_GROUP_ID is 'Key to the assignment group associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.COURSE_ID is 'Key to the course associated with the module progression and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.DISCUSSION_TOPIC_ID is 'Key to the discussion topic associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.DISCUSSION_TOPIC_EDITOR_ID is 'Key to the user editing the discussion topic associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ENROLLMENT_ROLL_ID is 'Key to the enrollment rollup associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ENROLLMENT_TERM_ID is 'Key to the enrollment term associated with the module progression and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.FILE_ID is 'Key to the file associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.MODULE_ID is 'Parent module for this module progression and module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.MODULE_ITEM_ID is 'Item that the user has not completed.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.MODULE_PROG_ID is 'Module progression referenced by the completion requirement.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.QUIZ_ID is 'Key to the quiz associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.USR_ID is 'Key to the user associated with the module progression and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.WIKI_ID is 'Key to the wiki associated with the module progression and the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.WIKI_PAGE_ID is 'Key to the wiki page associated with the module item.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.MIN_SCORE is 'For min_score type requirements, the score that must be attained for completion.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.SCORE is 'For min_score type requirements, the score that the user has currently achieved.';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_MODULE_PROG_COMPL_REQ_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_UI_CANVAS_NAV_DIM');
END;
/

CREATE TABLE ACU.LMS_COURSE_UI_CANVAS_NAV_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, DEFAULT_ NVARCHAR2(512)
	, ORIGINAL_POSITION NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_UI_CANVAS_NAV_DIM is 'Attributes for a Canvas navigation function';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.ID is 'Primary key for navigational item';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.CANVAS_ID is 'ID in Canvas system';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.NAME_ is 'Name of navigational item';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.DEFAULT_ is '(Default|NotDefault) - set to Default if this is one of the navigation items enabled in a course by default';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.ORIGINAL_POSITION is 'Original position of this navigation item';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_CANVAS_NAV_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_UI_NAV_ITEM_DIM');
END;
/

CREATE TABLE ACU.LMS_COURSE_UI_NAV_ITEM_DIM
(
	ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, VISIBLE NVARCHAR2(512)
	, POSITION NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_UI_NAV_ITEM_DIM is 'Attributes for a navigation item';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_DIM.ID is 'Primary key for navigational item';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_DIM.ROOT_ACCOUNT_ID is 'Foreign key to root account of the course';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_DIM.VISIBLE is '(visible|hidden) Visible if this element is visible, hidden if hidden/not available in the navigation';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_DIM.POSITION is 'Position in the navigation.  NULL if hidden.';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_COURSE_UI_NAV_ITEM_FACT');
END;
/

CREATE TABLE ACU.LMS_COURSE_UI_NAV_ITEM_FACT
(
	ROOT_ACCOUNT_ID NUMBER
	, COURSE_UI_NAV_ITEM_ID NUMBER
	, COURSE_UI_CANVAS_NAV_ID NUMBER
	, EXT_TOOL_ACTIV_ID NUMBER
	, COURSE_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_COURSE_UI_NAV_ITEM_FACT is 'Facts describing a single item in the navigation UI';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.ROOT_ACCOUNT_ID is 'Foreign key to root account of the course';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.COURSE_UI_NAV_ITEM_ID is 'Foreign key to course_ui_navigation_item_dim';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.COURSE_UI_CANVAS_NAV_ID is 'Foreign key to navigation function';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.EXT_TOOL_ACTIV_ID is 'Foreign key to external_tool_activation_dim';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.COURSE_ID is 'Foreign key to course';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.COURSE_ACCOUNT_ID is 'Foreign key to account for course';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.ENROLLMENT_TERM_ID is 'Foreign key to enrollment term';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_COURSE_UI_NAV_ITEM_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_DIM');
END;
/

CREATE TABLE ACU.LMS_QUIZ_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, POINTS_POSSIBLE NUMBER
	, DESCRIPTION CLOB
	, QUIZ_TYPE NVARCHAR2(512)
	, COURSE_ID NUMBER
	, ASSIGN_ID NUMBER
	, WORKFLOW_STATE NVARCHAR2(512)
	, SCORING_POLICY NVARCHAR2(512)
	, ANONYMOUS_SUBMISS NVARCHAR2(512)
	, DISPLAY_QUESTS NVARCHAR2(512)
	, ANSWER_DISPLAY_ORDER NVARCHAR2(512)
	, GO_BACK_TO_PREVIOUS_QUEST NVARCHAR2(512)
	, COULD_BE_LOCKED NVARCHAR2(512)
	, BROWSER_LOCKDOWN NVARCHAR2(512)
	, BROWSER_LOCKDOWN_FOR_DISPLAYIN NVARCHAR2(512)
	, BROWSER_LOCKDOWN_MONITOR NVARCHAR2(512)
	, IP_FILTER NVARCHAR2(512)
	, SHOW_RESULTS NVARCHAR2(512)
	, SHOW_CORRECT_ANSWERS NVARCHAR2(512)
	, SHOW_CORRECT_ANSWERS_AT DATE
	, HIDE_CORRECT_ANSWERS_AT DATE
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, PUBLISHED_AT DATE
	, UNLOCK_AT DATE
	, LOCK_AT DATE
	, DUE_AT DATE
	, DELETED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_DIM is 'Attributes for quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ID is 'Unique surrogate ID for the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.CANVAS_ID is 'Primary key for this quiz in the quizzes table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ROOT_ACCOUNT_ID is 'Root account ID associated with this quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.NAME_ is 'Name of the quiz. Equivalent Canvas API field -> ''title''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.POINTS_POSSIBLE is 'Total point value given to the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.DESCRIPTION is 'Description of the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.QUIZ_TYPE is 'Type of quiz. Possible values are ''practice_quiz'', ''assignment'', ''graded_survey'' and ''survey''. Defaults to ''NULL''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.COURSE_ID is 'Foreign key to the course the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.WORKFLOW_STATE is 'Denotes where the quiz is in the workflow. Possible values are ''unpublished'', ''published'' and ''deleted''. Defaults to ''unpublished''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.SCORING_POLICY is 'Scoring policy for a quiz that students can take multiple times. Is required and only valid if allowed_attempts > 1. Possible values are ''keep_highest'', ''keep_latest'' and ''keep_average''. Defaults to ''keep_highest''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ANONYMOUS_SUBMISS is 'Dictates whether students are allowed to submit the quiz anonymously. Possible values are ''allow_anonymous_submissions'' and ''disallow_anonymous_submissions''. Defaults to ''disallow_anonymous_submissions''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.DISPLAY_QUESTS is 'Policy for displaying the questions in the quiz. Possible values are ''multiple_at_a_time'' and ''one_at_a_time''. Defaults to ''multiple_at_a_time''. Equivalent Canvas API field -> ''one_question_at_a_time''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ANSWER_DISPLAY_ORDER is 'Policy for displaying the answers for each question in the quiz. Possible values are ''in_order'' and ''shuffled''. Defaults to ''in_order''. Equivalent Canvas API field -> ''shuffle_answers''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.GO_BACK_TO_PREVIOUS_QUEST is 'Policy on going back to the previous question. Is valid only if ''display_questions'' is set to ''one_at_a_time''. Possible values are ''allow_going_back'' and ''disallow_going_back''. Defaults to ''allow_going_back''. Equivalent Canvas API field -> ''cant_go_back''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.COULD_BE_LOCKED is 'Dictates if the quiz can be locked or not. Possible values are ''allow_locking'' and ''disallow_locking''. Defaults to ''disallow_locking''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.BROWSER_LOCKDOWN is 'Dictates whether the browser has locked-down when the quiz is being taken. Possible values are ''required'' and ''not_required''. Defaults to ''not_required''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.BROWSER_LOCKDOWN_FOR_DISPLAYIN is 'Dictates whether the browser has to be locked-down to display the results. Is valid only if ''hide_results'' is set to ''never'' or ''until_after_last_attempt'' (for the results to be displayed after the last attempt). Possible values are ''required'' and ''not_required''. Defaults to ''not_required''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.BROWSER_LOCKDOWN_MONITOR is 'Dictates whether a browser lockdown monitor is required. Possible values are ''required'' and ''not_required''. Defaults to ''not_required''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.IP_FILTER is 'Restricts access to the quiz to computers in a specified IP range. Filters can be a comma-separated list of addresses, or an address followed by a mask.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.SHOW_RESULTS is 'Dictates whether or not quiz results are shown to students. If set to ''always'', students can see their results after any attempt and if set to ''never'', students can never see their results. If ''dw_quiz_fact.allowed_attempts > 1'' then when set to ''always_after_last_attempt'', students can only see their results always, but only after their last attempt. Similarly, if set to ''only_once_after_last_attempt'', then students can see their results only after their last attempt, that too only once. Possible values are ''always'', ''never'', ''always_after_last_attempt'' and ''only_once_after_last_attempt''. Defaults to ''always''. Equivalent Canvas API field -> ''hide_results'' combined with ''one_time_results''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.SHOW_CORRECT_ANSWERS is 'Dictates whether correct answers are shown when are results are viewed. It''s valid only if ''show_results'' is set to ''always''. Possible values are ''always'', ''never'', ''only_once_after_last_attempt'' and ''always_after_last_attempt'' (Last two are only valid if ''dw_quiz_fact.allowed_attempts > 1'') which have a behavior similar to ''show_results''. Defaults to ''always''. Equivalent Canvas API field -> ''show_correct_answers'' combined with ''show_correct_answers_last_attempt''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.SHOW_CORRECT_ANSWERS_AT is 'Day/Time when the correct answers would be shown.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.HIDE_CORRECT_ANSWERS_AT is 'Day/Time when the correct answers are to be hidden.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.CREATED_AT is 'Time when the quiz was created.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.UPDATED_AT is 'Time when the quiz was last updated.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.PUBLISHED_AT is 'Time when the quiz was published.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.UNLOCK_AT is 'Day/Time when the quiz is to be unlocked for students.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.LOCK_AT is 'Day/Time when the quiz is to be locked for students.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.DUE_AT is 'Day/Time when the quiz is due.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.DELETED_AT is 'Time when the quiz was deleted.';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_FACT');
END;
/

CREATE TABLE ACU.LMS_QUIZ_FACT
(
	QUIZ_ID NUMBER
	, POINTS_POSSIBLE NUMBER
	, TIME_LIMIT NUMBER
	, ALLOWED_ATTEMPTS NUMBER
	, UNPUBLISHED_QUEST_COUNT NUMBER
	, QUEST_COUNT NUMBER
	, COURSE_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_FACT is 'Measures for quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.QUIZ_ID is 'Foreign key to quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.POINTS_POSSIBLE is 'Total point value given to the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.TIME_LIMIT is 'Time limit, in minutes, to complete the quiz. Set to -1 for no time limit. Defaults to -1.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.ALLOWED_ATTEMPTS is 'Number of attempts allowed to complete the quiz. Set to -1 for unlimited attempts. Defaults to -1.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.UNPUBLISHED_QUEST_COUNT is 'Number of questions in the current unpublished version of the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.QUEST_COUNT is 'Number of questions in the last published version of the quiz';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.COURSE_ID is 'Foreign key to the course the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account associated with the course associated with this quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.ENROLLMENT_TERM_ID is 'Foreign key to enrollment term the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_SUBMIS_HIST_DIM');
END;
/

CREATE TABLE ACU.LMS_QUIZ_SUBMIS_HIST_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, QUIZ_ID NUMBER
	, SUBMIS_ID NUMBER
	, USR_ID NUMBER
	, VERSION_NUMBER NUMBER
	, SUBMIS_STATE NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, QUIZ_STATE_DURING_SUBMIS NVARCHAR2(512)
	, SUBMIS_SCORING_POLICY NVARCHAR2(512)
	, SUBMIS_SOURCE NVARCHAR2(512)
	, HAS_SEEN_RESULTS NVARCHAR2(512)
	, TEMPORARY_USR_CODE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, STARTED_AT DATE
	, FINISHED_AT DATE
	, DUE_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_SUBMIS_HIST_DIM is 'Attributes for all submitted quizzes';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.ID is 'Unique surrogate ID for the quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.CANVAS_ID is 'Primary key for this quiz submission in the ''quiz_submissions'' Canvas table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.QUIZ_ID is 'ID of the quiz the quiz submission represents. Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.SUBMIS_ID is 'ID to the submission the quiz submission represents. Foreign key to the quiz submission dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.USR_ID is 'ID of the user (who is a student) who made the submission. Foreign key to the user dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.VERSION_NUMBER is 'Version number of this quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.SUBMIS_STATE is 'Denotes if the quiz submission is a current or previous submission. Possible values are ''current_submission'' and ''previous_submission''. Defaults to ''current_submission''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.WORKFLOW_STATE is 'Denotes the current state of the quiz submission. Possible values are ''untaken'', ''complete'', ''pending_review'', ''preview'' and ''settings_only''. Out of these, ''settings_only'' pertains only to quiz moderation events. It stores the settings to create and store moderation events before the student has begun an attempt. Defaults to ''untaken''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.QUIZ_STATE_DURING_SUBMIS is 'There can be two types of quiz states during submission, 1. Quiz submission took place after the quiz was manually unlocked after being locked (but only for a particular student such that (s)he can take the quiz even if it''s locked for everyone else). 2. Quiz submission was on-time (that is, when the quiz was never locked). So the two possible values are ''manually_unlocked'' and ''never_locked''. Defaults to ''never_locked''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.SUBMIS_SCORING_POLICY is 'Denotes if the score has been manually overridden by a teacher to reflect the score of a previous attempt (as opposed to a score calculated by the quiz''s scoring policy. Possible values are ''manually_overridden'' or the general quiz scoring policies, i.e. ''keep_highest'', ''keep_latest'' and ''keep_average''. Defaults to the scoring policy of the quiz the submission is associated with.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.SUBMIS_SOURCE is 'Denotes where the submission was received from. Possible values are ''student'' and ''test_preview''. Defaults to ''student''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.HAS_SEEN_RESULTS is 'Denotes whether the student has viewed their results to the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.TEMPORARY_USR_CODE is 'Construct for previewing a quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.CREATED_AT is 'Time when the quiz submission was created.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.UPDATED_AT is 'Time when the quiz submission was last updated.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.STARTED_AT is 'Time at which the student started the quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.FINISHED_AT is 'Time at which the student submitted the quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.DUE_AT is 'Time at which the quiz submission will be overdue, and will be flagged as a late submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_SUBMIS_HIST_FACT');
END;
/

CREATE TABLE ACU.LMS_QUIZ_SUBMIS_HIST_FACT
(
	SCORE NUMBER
	, KEPT_SCORE NUMBER
	, DATE_ DATE
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, QUIZ_ID NUMBER
	, ASSIGN_ID NUMBER
	, USR_ID NUMBER
	, SUBMIS_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, QUIZ_SUBMIS_HIST_ID NUMBER
	, QUIZ_POINTS_POSSIBLE NUMBER
	, SCORE_BEFORE_REGRADE NUMBER
	, FUDGE_POINTS NUMBER
	, TOTAL_ATTEMPTS NUMBER
	, EXTRA_ATTEMPTS NUMBER
	, EXTRA_TIME NUMBER
	, TIME_TAKEN NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_SUBMIS_HIST_FACT is 'Measures for the all submitted quizzes';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.SCORE is 'Denotes the score for this submission. Its value would be NULL when they are in the ''preview'', ''untaken'' OR ''settings_only'' workflow states (since it is associated with quiz moderation events). Or its value should not be NULL when workflow state is either ''complete'' or ''pending_review''. It defaults to NULL.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.KEPT_SCORE is 'For quizzes that allow multiple attempts, this is the actual score that will be associated with the user for this quiz. This score depends on the scoring policy we have for the submission in the quiz submission dimension table, the workflow state being ''completed'' or ''pending_review'' and the allowed attempts to be greater than 1. Its value can be NULL when not all these required conditions are met.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.DATE_ is 'Contains the same value as ''finished_at''. Provided to support backward compatibility with the existing table in production.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.COURSE_ID is 'Foreign key to the course this submission belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term of the course this submission belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account of the course this submission belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.QUIZ_ID is 'ID of the quiz the quiz submission represents. Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.USR_ID is 'ID of the user (who is a student) who made the submission. Foreign key to the user dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.SUBMIS_ID is 'ID to the submission the quiz submission represents. Foreign key to the quiz submission dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.QUIZ_SUBMIS_HIST_ID is 'Foreign key to the quiz submission dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.QUIZ_POINTS_POSSIBLE is 'Maximum points that can be scored in this quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.SCORE_BEFORE_REGRADE is 'Original score of the quiz submission prior to any re-grading. It''s NULL if the submission has never been regraded. Defaults to NULL.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.FUDGE_POINTS is 'Number of points the quiz submission''s score was fudged (changed) by. Values can be negative or positive. Defaults to 0.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.TOTAL_ATTEMPTS is 'Denotes the total number of attempts made by the student for the quiz. Is valid only if the quiz allows multiple attempts.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.EXTRA_ATTEMPTS is 'Number of times the student was allowed to re-take the quiz over the multiple-attempt limit.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.EXTRA_TIME is 'Amount of extra time allowed for the quiz submission, in minutes.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.TIME_TAKEN is 'Time taken, in seconds, to finish the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_HIST_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_SUBMIS_DIM');
END;
/

CREATE TABLE ACU.LMS_QUIZ_SUBMIS_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, QUIZ_ID NUMBER
	, SUBMIS_ID NUMBER
	, USR_ID NUMBER
	, WORKFLOW_STATE NVARCHAR2(512)
	, QUIZ_STATE_DURING_SUBMIS NVARCHAR2(512)
	, SUBMIS_SCORING_POLICY NVARCHAR2(512)
	, SUBMIS_SOURCE NVARCHAR2(512)
	, HAS_SEEN_RESULTS NVARCHAR2(512)
	, TEMPORARY_USR_CODE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, STARTED_AT DATE
	, FINISHED_AT DATE
	, DUE_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_SUBMIS_DIM is 'Attributes for the last submitted quiz';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.ID is 'Unique surrogate ID for the quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.CANVAS_ID is 'Primary key for this quiz submission in the ''quiz_submissions'' Canvas table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.QUIZ_ID is 'ID of the quiz the quiz submission represents. Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.SUBMIS_ID is 'ID to the submission the quiz submission represents. Foreign key to the quiz submission dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.USR_ID is 'ID of the user (who is a student) who made the submission. Foreign key to the user dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.WORKFLOW_STATE is 'Denotes the current state of the quiz submission. Possible values are ''untaken'', ''complete'', ''pending_review'', ''preview'' and ''settings_only''. Defaults to ''untaken''. An ''untaken'' quiz submission is recorded as soon as a student starts the quiz taking process, before even answering the first question. ''pending_review'' denotes that a manual submission has been made by the student which has not been completely graded yet. This usually happens when one or more questions in the quiz cannot be autograded (e.g.. ''essay_question'' type questions). A ''preview'' workflow state is recorded when a Teacher or Admin previews a quiz (even a partial one). ''settings_only'' pertains only to quiz moderation events. It stores the settings to create and store moderation events before the student has begun an attempt.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.QUIZ_STATE_DURING_SUBMIS is 'There can be two types of quiz states during submission, 1. Quiz submission took place after the quiz was manually unlocked after being locked (but only for a particular student such that (s)he can take the quiz even if it''s locked for everyone else). 2. Quiz submission was on-time (that is, when the quiz was never locked). So the two possible values are ''manually_unlocked'' and ''never_locked''. Defaults to ''never_locked''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.SUBMIS_SCORING_POLICY is 'Denotes if the score has been manually overridden by a teacher to reflect the score of a previous attempt (as opposed to a score calculated by the quiz''s scoring policy. Possible values are ''manually_overridden'' or the general quiz scoring policies, i.e. ''keep_highest'', ''keep_latest'' and ''keep_average''. Defaults to the scoring policy of the quiz the submission is associated with.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.SUBMIS_SOURCE is 'Denotes where the submission was received from. Possible values are ''student'' and ''test_preview''. Defaults to ''student''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.HAS_SEEN_RESULTS is 'Denotes whether the student has viewed their results to the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.TEMPORARY_USR_CODE is 'Construct for previewing a quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.CREATED_AT is 'Time when the quiz submission was created.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.UPDATED_AT is 'Time when the quiz submission was last updated.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.STARTED_AT is 'Time at which the student started the quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.FINISHED_AT is 'Time at which the student submitted the quiz submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.DUE_AT is 'Time at which the quiz submission will be overdue, and will be flagged as a late submission.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_SUBMIS_FACT');
END;
/

CREATE TABLE ACU.LMS_QUIZ_SUBMIS_FACT
(
	SCORE NUMBER
	, KEPT_SCORE NUMBER
	, DATE_ DATE
	, COURSE_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, QUIZ_ID NUMBER
	, ASSIGN_ID NUMBER
	, USR_ID NUMBER
	, SUBMIS_ID NUMBER
	, ENROLLMENT_ROLL_ID NUMBER
	, QUIZ_SUBMIS_ID NUMBER
	, QUIZ_POINTS_POSSIBLE NUMBER
	, SCORE_BEFORE_REGRADE NUMBER
	, FUDGE_POINTS NUMBER
	, TOTAL_ATTEMPTS NUMBER
	, EXTRA_ATTEMPTS NUMBER
	, EXTRA_TIME NUMBER
	, TIME_TAKEN NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_SUBMIS_FACT is 'Measures for the last submitted quiz';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.SCORE is 'Denotes the score for this submission. Its value would be NULL when they are in the ''preview'', ''untaken'' OR ''settings_only'' workflow states (since it is associated with quiz moderation events). Or its value should not be NULL when workflow state is either ''complete'' or ''pending_review''. It defaults to NULL.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.KEPT_SCORE is 'For quizzes that allow multiple attempts, this is the actual score that will be associated with the user for this quiz. This score depends on the scoring policy we have for the submission in the quiz submission dimension table, the workflow state being ''completed'' or ''pending_review'' and the allowed attempts to be greater than 1. Its value can be NULL when not all these required conditions are met.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.DATE_ is 'Contains the same value as ''finished_at''. Provided to support backward compatibility with the existing table in production.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.COURSE_ID is 'Foreign key to the course this submission belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term of the course this submission belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account of the course this submission belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.QUIZ_ID is 'ID of the quiz the quiz submission represents. Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.USR_ID is 'ID of the user (who is a student) who made the submission. Foreign key to the user dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.SUBMIS_ID is 'ID to the submission the quiz submission represents. Foreign key to the quiz submission dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.ENROLLMENT_ROLL_ID is 'Foreign key to the enrollment roll-up dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.QUIZ_SUBMIS_ID is 'Foreign key to the quiz submission dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.QUIZ_POINTS_POSSIBLE is 'Maximum points that can be scored in this quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.SCORE_BEFORE_REGRADE is 'Original score of the quiz submission prior to any re-grading. It''s NULL if the submission has never been regraded. Defaults to NULL.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.FUDGE_POINTS is 'Number of points the quiz submission''s score was fudged (changed) by. Values can be negative or positive. Defaults to 0.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.TOTAL_ATTEMPTS is 'Denotes the total number of attempts made by the student for the quiz. Is valid only if the quiz allows multiple attempts.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.EXTRA_ATTEMPTS is 'Number of times the student was allowed to re-take the quiz over the multiple-attempt limit.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.EXTRA_TIME is 'Amount of extra time allowed for the quiz submission, in minutes.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.TIME_TAKEN is 'Time taken, in seconds, to finish the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_SUBMIS_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_QUEST_GROUP_DIM');
END;
/

CREATE TABLE ACU.LMS_QUIZ_QUEST_GROUP_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, QUIZ_ID NUMBER
	, NAME_ NVARCHAR2(512)
	, POSITION NUMBER
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_QUEST_GROUP_DIM is 'Attributes for quiz group.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.ID is 'Unique surrogate ID for the quiz group.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.CANVAS_ID is 'Primary key for this quiz group in the ''quiz_question_groups'' table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.QUIZ_ID is 'Foreign key to quiz dimension.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.NAME_ is 'Name of the quiz group.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.POSITION is 'Order in which the questions from this group will be displayed in the quiz relative to other questions in the quiz from other groups.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.CREATED_AT is 'Time when the quiz question was created.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.UPDATED_AT is 'Time when the quiz question was last updated.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_QUEST_GROUP_FACT');
END;
/

CREATE TABLE ACU.LMS_QUIZ_QUEST_GROUP_FACT
(
	QUIZ_QUEST_GROUP_ID NUMBER
	, PICK_COUNT NUMBER
	, QUEST_POINTS NUMBER
	, QUIZ_ID NUMBER
	, COURSE_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_QUEST_GROUP_FACT is 'Measures related to quiz groups.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.QUIZ_QUEST_GROUP_ID is 'Foreign key to quiz group.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.PICK_COUNT is 'Number of questions picked from the group for the quiz the group is associated with.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.QUEST_POINTS is 'Number of points to assign per question in the group.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.QUIZ_ID is 'Foreign key to quiz dimension.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.COURSE_ID is 'Foreign key to the course this group''s quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account of the course this group belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term of the course this group belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_GROUP_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_QUEST_DIM');
END;
/

CREATE TABLE ACU.LMS_QUIZ_QUEST_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, QUIZ_ID NUMBER
	, QUIZ_QUEST_GROUP_ID NUMBER
	, POSITION NUMBER
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, ASSESSMENT_QUEST_ID NUMBER
	, ASSESSMENT_QUEST_VERSION NUMBER
	, NAME_ NVARCHAR2(512)
	, QUEST_TYPE NVARCHAR2(512)
	, QUEST_TEXT CLOB
	, REGRADE_OPTION NVARCHAR2(512)
	, CORRECT_COMMENTS CLOB
	, INCORRECT_COMMENTS CLOB
	, NEUTRAL_COMMENTS CLOB
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_QUEST_DIM is 'Attributes of a question associated with a quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.ID is 'Unique surrogate key for the quiz question.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.CANVAS_ID is 'Primary key for this quiz question in the ''quiz_questions'' table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.QUIZ_ID is 'Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.QUIZ_QUEST_GROUP_ID is 'Foreign key to the quiz group dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.POSITION is 'Order in which the question will be displayed in the quiz relative to other questions associated with the quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.WORKFLOW_STATE is 'Denotes where the quiz question is in the workflow. Possible values are ''unpublished'', ''published'' and ''deleted''. Defaults to ''unpublished''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.CREATED_AT is 'Time when the quiz question was created.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.UPDATED_AT is 'Time when the quiz question was last updated.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.ASSESSMENT_QUEST_ID is 'Foreign key to the assessment question dimension table (to be made available in later releases).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.ASSESSMENT_QUEST_VERSION is 'Version of the assessment question associated with the quiz question (to be made available in later releases).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.NAME_ is 'Name of the question.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.QUEST_TYPE is 'Denotes the type of the question. Possible values are ''calculated_question'', ''essay_question'', ''file_upload_question'', ''fill_in_multiple_blanks_question'', ''matching_question'', ''multiple_answers_question'', ''multiple_choice_question'', ''multiple_dropdowns_question'', ''numerical_question'', ''short_answer_question'', ''text_only_question'' and ''true_false_question''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.QUEST_TEXT is 'Text content of the question.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.REGRADE_OPTION is 'Denotes if regrading is available for the question. Possible values are ''available'' and ''unavailable'' for question types ''multiple_answers_question'', ''multiple_choice_question'', ''true_false_question'' and ''NULL'' for others. Defaults to ''available'' for the allowed question types and ''NULL'' for the rest.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.CORRECT_COMMENTS is 'Comments to be displayed if the student answers the question correctly.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.INCORRECT_COMMENTS is 'Comments to be displayed if the student answers the question incorrectly.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.NEUTRAL_COMMENTS is 'Comments to be displayed regardless of how the student answers the question.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_QUEST_FACT');
END;
/

CREATE TABLE ACU.LMS_QUIZ_QUEST_FACT
(
	QUIZ_QUEST_ID NUMBER
	, QUIZ_ID NUMBER
	, QUIZ_QUEST_GROUP_ID NUMBER
	, ASSESSMENT_QUEST_ID NUMBER
	, COURSE_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, POINTS_POSSIBLE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_QUEST_FACT is 'Measures of a question associated with a quiz.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.QUIZ_QUEST_ID is 'Foreign key to the quiz question dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.QUIZ_ID is 'Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.QUIZ_QUEST_GROUP_ID is 'Foreign key to the quiz group dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.ASSESSMENT_QUEST_ID is 'Foreign key to the assessment question dimension table (to be made available in later releases).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.COURSE_ID is 'Foreign key to the course this group''s quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account of the course this group belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term of the course this group belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.POINTS_POSSIBLE is 'Maximum number of points that can be awarded for answering the question correctly.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_QUEST_ANSWER_DIM');
END;
/

CREATE TABLE ACU.LMS_QUIZ_QUEST_ANSWER_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, QUIZ_QUEST_ID NUMBER
	, TEXT CLOB
	, HTML CLOB
	, COMMENTS CLOB
	, TEXT_AFTER_ANSWERS CLOB
	, ANSWER_MATCH_LEFT NVARCHAR2(512)
	, ANSWER_MATCH_RIGHT NVARCHAR2(512)
	, MATCHING_ANSWER_INCORRECT_MATC NVARCHAR2(512)
	, NUMERICAL_ANSWER_TYPE NVARCHAR2(512)
	, BLANK_ID NVARCHAR2(512)
	, EXACT NUMBER
	, MARGIN NUMBER
	, STARTING_RANGE NUMBER
	, ENDING_RANGE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_QUEST_ANSWER_DIM is 'Attributes of an answer related to a quiz question.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.ID is 'Unique surrogate key for the quiz question answer. As with all surrogate keys in Canvas Data, there is no guarantee of stability. That said, this key is particularly unstable and will likely change from dump to dump even if there are no data change.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.CANVAS_ID is 'Primary key for this quiz question answer. No table available in Canvas.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.QUIZ_QUEST_ID is 'Foreign key to the quiz question dimension column.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.TEXT is 'Text of the answer.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.HTML is 'HTML markup of the text.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.COMMENTS is 'Specific contextual comments for a particular answer.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.TEXT_AFTER_ANSWERS is '(Used in ''short_answer_question'', also known as ''fill_in_the_blank''. Set to ''NULL'' in others) Text following the missing word.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.ANSWER_MATCH_LEFT is '(Used in ''matching_question'', set to ''NULL'' in others) Static value of the answer that will be displayed on the left for students to match for.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.ANSWER_MATCH_RIGHT is '(Used in ''matching_question'', set to ''NULL'' in others) Correct match for the value given in ''answer_match_left'', displayed in a drop-down with other ''answer_match_right'' values.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.MATCHING_ANSWER_INCORRECT_MATC is '(Used in ''matching_question'', set to ''NULL'' in others) List of distractors (incorrect answers), delimited by new lines, that will be seeded with all the ''answer_match_right'' values.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.NUMERICAL_ANSWER_TYPE is '(Used in ''numerical_question'', set to ''NULL'' in others) Denotes the type of numerical answer that is expected. Possible values are ''exact_answer'' and ''range_answer''.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.BLANK_ID is '(Used in ''fill_in_multiple_blanks_question'' and ''multiple_dropdowns_question'', set to ''NULL'' otherwise) Refers to the ID of the blank(s) in the question text.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.EXACT is '(Used in ''numerical_question'' with answer type ''exact_answer'', set to ''NULL'' otherwise) Value the answer must be equal to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.MARGIN is '(Used in ''numerical_question'' with answer type ''exact_answer'', set to ''NULL'' otherwise) Margin of error allowed for a student''s answer.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.STARTING_RANGE is '(Used in ''numerical_question'' with answer type ''range_answer'', set to ''NULL'' otherwise) Start of the allowed range (inclusive).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.ENDING_RANGE is '(Used in ''numerical_question'' with answer type ''range_answer'', set to ''NULL'' otherwise) End of the allowed range (inclusive).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_QUIZ_QUEST_ANSWER_FACT');
END;
/

CREATE TABLE ACU.LMS_QUIZ_QUEST_ANSWER_FACT
(
	QUIZ_QUEST_ANSWER_ID NUMBER
	, QUIZ_QUEST_ID NUMBER
	, QUIZ_QUEST_GROUP_ID NUMBER
	, QUIZ_ID NUMBER
	, ASSESSMENT_QUEST_ID NUMBER
	, COURSE_ID NUMBER
	, ASSIGN_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, WEIGHT NUMBER
	, EXACT NUMBER
	, MARGIN NUMBER
	, STARTING_RANGE NUMBER
	, ENDING_RANGE NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_QUIZ_QUEST_ANSWER_FACT is 'Measures for answers related to a quiz question.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.QUIZ_QUEST_ANSWER_ID is 'Foreign key to the quiz question answer dimension table. As with all surrogate keys in Canvas Data, there is no guarantee of stability. That said, this key is particularly unstable and will likely change from dump to dump even if there are no data change.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.QUIZ_QUEST_ID is 'Foreign key to the quiz question dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.QUIZ_QUEST_GROUP_ID is 'Foreign key to the quiz group dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.QUIZ_ID is 'Foreign key to the quiz dimension table.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.ASSESSMENT_QUEST_ID is 'Foreign key to the assessment question dimension table (to be made available in later releases).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.COURSE_ID is 'Foreign key to the course this group''s quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.ASSIGN_ID is 'Foreign key to the assignment the quiz belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the account of the course this group belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term of the course this group belongs to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.WEIGHT is 'Integer value to determine correctness of the answer. Incorrect answers should be 0, correct answers should be non-negative.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.EXACT is '(Used in ''numerical_question'' with answer type ''exact_answer'', set to ''NULL'' otherwise) Value the answer must be equal to.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.MARGIN is '(Used in ''numerical_question'' with answer type ''exact_answer'', set to ''NULL'' otherwise) Margin of error allowed for a student''s answer.';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.STARTING_RANGE is '(Used in ''numerical_question'' with answer type ''range_answer'', set to ''NULL'' otherwise) Start of the allowed range (inclusive).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.ENDING_RANGE is '(Used in ''numerical_question'' with answer type ''range_answer'', set to ''NULL'' otherwise) End of the allowed range (inclusive).';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_QUIZ_QUEST_ANSWER_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_REQUESTS');
END;
/

CREATE TABLE ACU.LMS_REQUESTS
(
	ID NVARCHAR2(2000)
	, TIMESTAMP DATE
	, TIMESTAMP_YEAR NVARCHAR2(512)
	, TIMESTAMP_MONTH NVARCHAR2(512)
	, TIMESTAMP_DAY NVARCHAR2(512)
	, USR_ID NUMBER
	, COURSE_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, QUIZ_ID NUMBER
	, DISCUSSION_ID NUMBER
	, CONVERS_ID NUMBER
	, ASSIGN_ID NUMBER
	, URL CLOB
	, USR_AGENT CLOB
	, HTTP_METHOD NVARCHAR2(512)
	, REMOTE_IP NVARCHAR2(512)
	, INTERACTION_MICROS NUMBER
	, WEB_APPLICATION_CONTROLLER NVARCHAR2(512)
	, WEB_APPLICAITON_ACTION NVARCHAR2(512)
	, WEB_APPLICATION_CONTEXT_TYPE NVARCHAR2(512)
	, WEB_APPLICATION_CONTEXT_ID NVARCHAR2(512)
	, REAL_USR_ID NUMBER
	, SESSION_ID NVARCHAR2(512)
	, USR_AGENT_ID NUMBER
	, HTTP_STATUS NVARCHAR2(20)
	, HTTP_VERSION NVARCHAR2(512)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_REQUESTS is 'Pageview requests. Disclaimer:   The data in the requests table is a ''best effort'' attempt, and is not guaranteed to be complete or wholly accurate. This data is meant to be used for rollups and analysis in the aggregate, _not_ in isolation for auditing, or other high-stakes analysis involving examining single users or small samples.    As this data is generated from the Canvas logs files, not a transactional database, there are many places along the way data can be lost and/or duplicated (though uncommon).   Additionally, given the size of this data, our processes are often done on monthly cycles for many parts of the requests tables, so as errors occur they can only be rectified monthly.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.ID is 'Request ID assigned by the canvas system to the request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.TIMESTAMP is 'Timestamp when the request was made in UTC.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.TIMESTAMP_YEAR is 'Year when the request was made.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.TIMESTAMP_MONTH is 'Month when the request was made.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.TIMESTAMP_DAY is 'Day when the request was made.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.USR_ID is 'Foreign key in user_dim for the user that made the request. If the request was made by one user masquerading as another, then this column contains the ID of the user being masqueraded as.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.COURSE_ID is 'Foreign key in course_dim for the course that owned the page requested. Set to NULL if not applicable.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.ROOT_ACCOUNT_ID is 'Foreign key in account_dim for the root account on which this request was made.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.COURSE_ACCOUNT_ID is 'Foreign key in account_dim for the account the associated course is owned by.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.QUIZ_ID is 'Foreign key in quiz_dim if the page request is for a quiz, otherwise NULL.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.DISCUSSION_ID is 'Foreign key in discussion_dim if page request is for a discussion, otherwise NULL.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.CONVERS_ID is 'Foreign key in conversation_dim if page request is for a conversation, otherwise NULL.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.ASSIGN_ID is 'Assignment foreign key if page request is for an assignment, otherwise NULL.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.URL is 'URL which was requested.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.USR_AGENT is 'User agent header received from the users browser/client software.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.HTTP_METHOD is 'HTTP method/verb (GET, PUT, POST etc.) that was sent with the request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.REMOTE_IP is 'IP address that was recorded from the request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.INTERACTION_MICROS is 'Total time required to service the request in microseconds.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.WEB_APPLICATION_CONTROLLER is 'The controller the Canvas web application used to service this request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.WEB_APPLICAITON_ACTION is 'Controller the Canvas web application used to service this request. (There is a typo in the field name, in order to minimize impact, this will be changed in a future version of Canvas Data.)';
COMMENT ON COLUMN ACU.LMS_REQUESTS.WEB_APPLICATION_CONTEXT_TYPE is 'Containing object type the Canvas web application used to service this request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.WEB_APPLICATION_CONTEXT_ID is 'Containing object''s ID the Canvas web application used to service this request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.REAL_USR_ID is 'If the request was processed by one user masquerading as another, then this column contains the real user ID of the user.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.SESSION_ID is 'ID of the user''s session where this request was made.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.USR_AGENT_ID is '(Not implemented) Foreign key to the user agent dimension table.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.HTTP_STATUS is 'HTTP status of the request.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.HTTP_VERSION is 'HTTP protocol version.';
COMMENT ON COLUMN ACU.LMS_REQUESTS.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_REQUESTS.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_EXT_TOOL_ACTIV_DIM');
END;
/

CREATE TABLE ACU.LMS_EXT_TOOL_ACTIV_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, COURSE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ACTIV_TARGET_TYPE NVARCHAR2(512)
	, URL NVARCHAR2(2000)
	, NAME_ NVARCHAR2(512)
	, DESCRIPTION NVARCHAR2(512)
	, WORKFLOW_STATE NVARCHAR2(512)
	, PRIVACY_LEVEL NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, TOOL_ID NVARCHAR2(512)
	, SELECTABLE_ALL NCHAR(6)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_EXT_TOOL_ACTIV_DIM is 'Attributes for external tool (LTI) activations.
Note that activations can happen on courses or accounts.   If this activation is associated with a course then course_id, course_account_id and enrollment_term_id will be populated.  If this activation is associated with an account then only account_id will be populated.';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.ID is 'Unique surrogate id for tool activations';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.CANVAS_ID is 'Primary key for this record in the context_external_tools table in the Canvas database';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.COURSE_ID is 'Foreign key to the course if this tool was activated in a course';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.ACCOUNT_ID is 'Foreign key to the account this tool was activated in if it was activated in an account';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.ACTIV_TARGET_TYPE is 'The type of object the tool was activated in, (course or account)';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.URL is 'The URL to where the tool may launch to';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.NAME_ is 'The name of tool activation as entered by the user';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.DESCRIPTION is 'The description of the tool activation as entered by the user';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.WORKFLOW_STATE is 'Workflow state for activation (active, deleted)';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.PRIVACY_LEVEL is 'Privacy setting for activation (name_only, email_only, anonymous, public)';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.CREATED_AT is 'Timestamp when the activation was created';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.UPDATED_AT is 'Timestamp when the activation was last updated';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.TOOL_ID is 'The tool id received from the external tool. May be missing if the tool does not send an id.';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.SELECTABLE_ALL is 'true - tool is selectable in all scenarios. false - not selectable for assignment or module selection menu';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_EXT_TOOL_ACTIV_FACT');
END;
/

CREATE TABLE ACU.LMS_EXT_TOOL_ACTIV_FACT
(
	EXT_TOOL_ACTIV_ID NUMBER
	, COURSE_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, COURSE_ACCOUNT_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_EXT_TOOL_ACTIV_FACT is 'Facts and denormalized dimensions for external tool (LTI) activations.';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.EXT_TOOL_ACTIV_ID is 'Foreign key to the external_tool_activation_dim dimension with attribute for this activation';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.COURSE_ID is 'Foreign key to the course if this tool was activated in a course';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.ACCOUNT_ID is 'Foreign key to the account this tool was activated in if it was activated in an account';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.ROOT_ACCOUNT_ID is 'Foreign key to the root account for this data';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the course''s enrollment term if this tool was activated in a course';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.COURSE_ACCOUNT_ID is 'Foreign key to the course''s account if this tool was activated in a course';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_EXT_TOOL_ACTIV_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_WIKI_DIM');
END;
/

CREATE TABLE ACU.LMS_WIKI_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, PARENT_TYPE NVARCHAR2(512)
	, TITLE CLOB
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, FRONT_PAGE_URL CLOB
	, HAS_NO_FRONT_PAGE NCHAR(6)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_WIKI_DIM is 'Attributes for wiki in canvas.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.ID is 'Unique id for the wiki.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.CANVAS_ID is 'Primary key to the wikis table in canvas.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.PARENT_TYPE is 'Type of Parent the wiki belongs to. For example, Groups or Courses.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.TITLE is 'Title for the wiki.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.CREATED_AT is 'Timestamp when the wiki was first saved in the system.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.UPDATED_AT is 'Timestamp when the wiki was last updated in the system.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.FRONT_PAGE_URL is 'URL of the front page of the wiki.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.HAS_NO_FRONT_PAGE is 'True if the wiki does not have a front page or is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_WIKI_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_WIKI_FACT');
END;
/

CREATE TABLE ACU.LMS_WIKI_FACT
(
	WIKI_ID NUMBER
	, PARENT_COURSE_ID NUMBER
	, PARENT_GROUP_ID NUMBER
	, PARENT_COURSE_ACCOUNT_ID NUMBER
	, PARENT_GROUP_ACCOUNT_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_WIKI_FACT is 'Measures for wikis.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.WIKI_ID is 'Foreign key to the wiki dimension.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.PARENT_COURSE_ID is 'Foreign key to the courses table if the wiki is associated with a Course. Otherwise this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.PARENT_GROUP_ID is 'Foreign key to the groups table if the wiki is associated with a Group. Otherwise this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.PARENT_COURSE_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the wiki''s course. If the wiki is not associated to a Course, this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.PARENT_GROUP_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the wiki''s group. If the wiki is not associated to a Group, this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.ACCOUNT_ID is 'Foreign key to the accounts table that this wiki belongs to. Helpful for directly finding the account associated with the wiki, irrespective of whether it belongs to a Course or a Group.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.ROOT_ACCOUNT_ID is 'Root account Id of the account the wiki belongs to. Foreign key to the accounts table.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term table of the course this wiki is associated with. Otherwise this is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.GROUP_CATEGORY_ID is '(Not implemented) Foreign key to the group categories table of the group this wiki is associated with. Otherwise this is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_WIKI_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_WIKI_PAGE_DIM');
END;
/

CREATE TABLE ACU.LMS_WIKI_PAGE_DIM
(
	ID NUMBER
	, CANVAS_ID NUMBER
	, TITLE NVARCHAR2(512)
	, BODY CLOB
	, WORKFLOW_STATE NVARCHAR2(512)
	, CREATED_AT DATE
	, UPDATED_AT DATE
	, URL CLOB
	, PROTECTED_EDITING NCHAR(6)
	, EDITING_ROLES NVARCHAR2(512)
	, REVISED_AT DATE
	, COULD_BE_LOCKED NCHAR(6)
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_WIKI_PAGE_DIM is 'Attributes for wiki pages in canvas.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.ID is 'Unique id for the wiki pages.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.CANVAS_ID is 'Primary key for the wiki pages table.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.TITLE is 'Title of the wiki page.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.BODY is 'Body of the wiki page. Redshift will only load the first 256 bytes of the body.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.WORKFLOW_STATE is 'Current state the wiki is in. For Example, active, unpublished, deleted.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.CREATED_AT is 'Timestamp when the wiki page was created in the system.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.UPDATED_AT is 'Timestamp when the wiki page was last updated in the system.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.URL is 'URL for the wiki page.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.PROTECTED_EDITING is 'Editing protection for the wiki page. It is false by default.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.EDITING_ROLES is 'Users or roles who can edit a wiki page.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.REVISED_AT is 'Timestamp the wiki page was last revised in the system.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.COULD_BE_LOCKED is 'True if the wiki page can be locked. This prevents it from being visible to others until ready.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_DIM.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.LMS_WIKI_PAGE_FACT');
END;
/

CREATE TABLE ACU.LMS_WIKI_PAGE_FACT
(
	WIKI_PAGE_ID NUMBER
	, WIKI_ID NUMBER
	, PARENT_COURSE_ID NUMBER
	, PARENT_GROUP_ID NUMBER
	, PARENT_COURSE_ACCOUNT_ID NUMBER
	, PARENT_GROUP_ACCOUNT_ID NUMBER
	, USR_ID NUMBER
	, ACCOUNT_ID NUMBER
	, ROOT_ACCOUNT_ID NUMBER
	, ENROLLMENT_TERM_ID NUMBER
	, GROUP_CATEGORY_ID NUMBER
	, WIKI_PAGE_COMMENTS_COUNT NUMBER
	, VIEW_COUNT NUMBER
	, ACU_RESERVED VARCHAR2(255)
	, ROW_HASH VARCHAR2(32)
)
;
COMMENT ON TABLE ACU.LMS_WIKI_PAGE_FACT is 'Measures for wiki pages.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.WIKI_PAGE_ID is 'Foreign key to the wiki pages dimension.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.WIKI_ID is 'Foreign key to the wikis dimension.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.PARENT_COURSE_ID is 'Foreign key to the courses table if the wiki that owns the wiki page is associated with a Course. Otherwise this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.PARENT_GROUP_ID is 'Foreign key to the groups table if the wiki that owns the wiki page is associated with a Group. Otherwise this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.PARENT_COURSE_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the wiki page''s course. If the wiki page is not associated to a Course, this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.PARENT_GROUP_ACCOUNT_ID is 'Foreign key to the account dimension for the account associated with the wiki page''s group. If the wiki page is not associated to a Group, this field is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.USR_ID is 'Foreign key to the user table.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.ACCOUNT_ID is 'Foreign key to the accounts table that this wiki page belongs to. Helpful for directly finding the account associated with the wiki page, irrespective of whether it belongs to a Course or a Group.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.ROOT_ACCOUNT_ID is 'Root account Id of the account the wiki belongs to. Foreign key to the accounts table.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.ENROLLMENT_TERM_ID is 'Foreign key to the enrollment term table of the course this wiki page is associated with. Otherwise this is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.GROUP_CATEGORY_ID is '(Not implemented) Foreign key to the group categories table of the group this wiki page is associated with. Otherwise this is set to NULL.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.WIKI_PAGE_COMMENTS_COUNT is '(Deprecated) No longer used in Canvas. Will always be Null';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.VIEW_COUNT is 'Number of views per wiki page.';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.ACU_RESERVED is '';
COMMENT ON COLUMN ACU.LMS_WIKI_PAGE_FACT.ROW_HASH is '';
BEGIN
  DBMS_OUTPUT.put_line('create command for ACU.TLMS_COURSE_DIM');
END;
/

would you mind sharing the code for CanvasToOracle/main.py ? I couldn't find it in your repo but it is referred to in the sql