Canvas Data Release Notes (2019-03-29)

Document created by Emily Allen Employee on Mar 15, 2019Last modified by Emily Allen Employee on Mar 18, 2019
Version 2Show Document
  • View in full screen mode

In this Canvas Data release, the schema version has been updated to 4.2.3. Several new tables with Canvas Catalog data have been added.

 

 

Canvas Data is a service that provides institutions with optimized access to all their data for reporting and queries. Learn more about Canvas Data.

 

 

Added Tables

< BACK TO TABLE OF CONTENTS

 

catalog_order_dim

Attributes for Catalog orders.

NameTypeDescription
idbigintUnique surrogate key for the catalog order
catalog_idbigintForeign key to the catalog dim
user_idbigintForeign key to the user dim. Refers to the user associated with this order
full_idvarcharThe id of the order prepended with the Catalog-specified order id, if provided by customers. If not prefixed, full_id will match the order id
purchased_attimestampWhen the catalog order was fulfilled
created_attimestampWhen the catalog order was created
updated_attimestampWhen the catalog order was last updated
currencyvarcharType of currency used in the catalog order

 

catalog_order_fact

Measure for Catalog orders.

NameTypeDescription
catalog_order_idbigintForeign key to the catalog order dim
catalog_idbigintForeign key to the catalog dim
parent_catalog_idbigintForeign key to the catalog dim. References the parent of the catalog that this order belongs to
user_idbigintForeign key to the user dim. Refers to the user associated with this order
totaldouble precisionCost of the catalog order. Units are found in catalog_order_dim.currency

 

catalog_order_item_dim

Attributes for Catalog order items.

NameTypeDescription
idbigintUnique surrogate key for the catalog order item
catalog_order_idbigintForeign key to the catalog order dim
catalog_product_idbigintForeign key to the catalog product dim. Refers to the course or program associated with this order item
catalog_promotion_idbigintForeign key to the catalog promotion dim
created_attimestampWhen the catalog order item was created
updated_attimestampWhen the catalog order item was last updated

 

catalog_order_item_fact

Measures for catalog order items.

NameTypeDescription
catalog_order_item_idbigintForeign key to the catalog order item dim
catalog_idbigintForeign key to the catalog dim. Refers to the catalog this order item belongs to
parent_catalog_idbigintForeign key to the catalog dim. References the parent of the catalog that this order item belongs to
catalog_order_idbigintForeign key to the catalog order dim
catalog_product_idbigintForeign key to the catalog product dim. Refers to the course or program associated with this order item
catalog_promotion_idbigintForeign key to the catalog promotion dim
amountdouble precisionCost of the catalog order. Units are found in catalog_order_dim.currency

 

catalog_application_dim

Attributes for catalog applicants.

NameTypeDescription
idbigintUnique surrogate key for the catalog applicant
catalog_idbigintForeign key to the catalog dim. Refers to the catalog this applicant belongs to
catalog_product_idbigintForeign key to the catalog product dim. Refers to the course or program associated with the applicant
user_idbigintForeign key to the user dim. Refers to the catalog applicant
notified_of_opening_attimestampIf present, indicates when the applicant was notified of an opening in the course or program
activatedbooleanIndicates whether the user's catalog account has been activated. If true, the user's account has been activated; otherwise, the user's account has not been activated
statusvarcharIndicates the applicant's enrollment status for the course or program. Possible values are "waitlist", "accepted", "declined", "expired", "error"
created_attimestampTime when the applicant was created
updated_attimestampTime when the applicant was last updated

 

catalog_payment_dim

Attributes for catalog payments.

NameTypeDescription
idbigintUnique surrogate key for the catalog payment
catalog_idbigintForeign key to the catalog dim. Refers to the catalog this payment belongs to
catalog_order_idbigintForeign key to the catalog order dim
statusvarcharThe payment status. Can be one of "success", "pending", or "error"
reference_idvarcharThe transaction reference ID from the payment merchant
created_attimestampTime when the payment was created
updated_attimestampTime when the payment was updated

 

catalog_payment_fact

Measures for catalog payments.

NameTypeDescription
catalog_payment_idbigintForeign key to the catalog payment dim
catalog_idbigintForeign key to the catalog dim. Refers to the catalog this payment belongs to
parent_catalog_idbigintForeign key to the catalog dim. References the parent of the catalog this payment belongs to
catalog_order_idbigintForeign key to the catalog order dim
amountdouble precisionThe payment amount

 

catalog_promotion_dim

Attributes for Catalog promotions.

NameTypeDescription
idbigintUnique surrogate key for the catalog promotion
catalog_idbigintForeign key to the catalog dim. Refers to the catalog this promotion belongs to
catalog_product_idbigintForeign key to the associated course or program from the catalog product dim. If null, this promotion is available for all courses or programs in the catalog
discount_typevarcharThe type of discount. Can be either "flat" or "percent"
codevarcharThe code used to redeem the promotion
namevarcharThe name of the promotion
usage_typevarcharIndicates whether the promotion is "unlimited" or "once-per-user"
start_datetimestampThe time the promotion begins
end_datetimestampThe time the promotion ends
activebooleanWhether or not the promotion is active
created_attimestampTime when the promotion was created
updated_attimestampTime when the payment was updated

 

catalog_promotion_fact

Measures for catalog promotions.

NameTypeDescription
catalog_promotion_ idbigintForeign key to the catalog promotion dim
catalog_idbigintForeign key to the catalog dim. Refers to the catalog this promotion belongs to
parent_catalog_idbigintForeign key to the catalog dim. References the parent of the catalog this promotion belongs to
catalog_product_idbigintForeign key to the associated course or program from the catalog product dim. If null, this promotion is available for all courses or programs in the catalog
amountdouble precisionThe amount of the promotion. If discount_type is "flat", this represents an amount in currency. If discount_type is "percent", this represents a percentage

 

catalog_tag_dim

Attributes for Catalog tags.

NameTypeDescription
idbigintUnique surrogate key for the catalog tag
catalog_idbigintForeign key to the catalog dim. Refers to the catalog that this tag belongs to
namevarcharThe catalog tag text
created_attimestampTime when the tag was created
updated_attimestampTime when the tag was updated

 

catalog_product_tag_dim

Attributes for Catalog product tags.

NameTypeDescription
idbigintUnique surrogate key for the catalog product tag
catalog_idbigintForeign key to the catalog dim. Refers to the catalog that this product tag belongs to
catalog_product_idbigintForeign key to the associated course or program from the catalog product dim
catalog_tag_idbigintForeign key to the associated tag from the catalog tag dim
created_attimestampTime when this product tag was created
updated_attimestampTime when this product tag was updated

Attachments

    Outcomes