Add Last Access Date to CDM_LMS.PERSON_COURSE of Blackboard Data

Idea created by smachaje on Oct 20, 2019
    Under review
    Score0

    Because user activity for historical courses is limited in Blackboard Data, it would be very useful to have last access date in the person_course table in order to determine which courses were active.

     

    The course_users table has the last_access_date field, which allows us to determine historical activity in a course.  It is not part of the activity accumulator, which is limited in time.

     

    So this is the Blackboard Data table:

    Table: BLACKBOARD_DATA_2B8B1A43DA6044D69811495F9755A2D1.CDM_LMS.PERSON_COURSE
    I'm asking to add last_access date per user, per course.
    Thank you!
    Product Version (if applicable):1