Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Completion Per Manager And Organization Domain is a curated selection of LMS data that enables you to create Reports on who has or has not completed courses, sorted by manager or by organization. Relevant items in this Domain include the Organization, Manager, Position, Date Completed, and Date Enrolled.

The Completion Per Manager And Organization Domain is located in the Public folder in the Zoola™ Repository. To locate the Domain in either the Repository or the Data Chooser (when selecting a Domain to create an Ad Hoc View), navigate to Public > Totara > Domains.

This Domain contains LMS data organized to report on the completion information of your courses and users, through managers and organizations. “Completion” information consists of measures that track the milestones of a learner's path to completing a course, such as enrollment dates, start dates, and completion dates—all sortable through manager and organization groupings. Using  Using fields and  and measures from the  from the set included  included in this Domain, you can easily build out Reports and Views to track learner milestones through course completion by manager or organization.

The links along the right-hand side of this article will open the Course Completions By Manager Chart View and Course Completions By Organization Chart View, respectively. If you are logged in to Zoola™, these views will open in the Ad Hoc Editor. The left-hand View panel will display the contents of the Completion Per Manager And Organization Domain, organized into sets of items (as both fields and measures).

All included sets are comprised of selections from the tables listed in the Totara table, located at the end of the right-hand column.

Specifically, the Completion Per Manager And Organization Domain is comprised of the following sets:

  • completions_per_organization_and_manager: Items in the completions_per_organization_and_manager set provide completion information sortable through organization, manager, position, user, category, course, and related dates.

 

 

HTML
<style>
table.confluenceTable th.confluenceTh, table.confluenceTable td.highlight {
    background-color: #57575b !important;
    border-color: #57575b !important;
    border-width: 2px;
    vertical-align: top;
}
table.confluenceTable td.confluenceTd {
  border-color: #57575b !important;
  border-width: 2px;
  vertical-align: top;
}
.wiki-content .columnLayout .cell.aside {
    width: 34.9%;
}
</style>



Related Ad Hoc Views 

The following links will directly open the Ad Hoc Views in Zoola™: 
  

 

 

Included LMS Tables

The Completions Per Organization And Manager Domain is built from a Derived Table, which draws the following fields from the Totara database:

  • category
  • completed
  • course
  • date completed
  • date enrolled
  • manager
  • manager ID
  • organization
  • organization ID
  • position
  • user
  • user ID